Microsoft Excel – Advanced Course

Course Summary

This half-day course is designed to assist those wishing to build further upon their knowledge of Microsoft Excel. Ideally delegates will have completed the ‘Intermediate’ module or have a good working knowledge of other Excel versions to begin with.

This course is the third of our Excel series, the others being Excel Beginners, Excel Intermediate and Excel An Introduction to Marcos and VBA

Topics

Complex IF Statements

• Using the IF Statement combined with AND, OR and nested IF arguments to solve various scenarios including situations where multiple criteria is involved.
• Combine the power of the IF function with the SUMIF & SUMIFS with the ability to calculate totals based on single or multiple criteria.

Protecting Data

• Protect important cells within your worksheet e.g. formulas static data, formatting etc to prevent them from being overwritten

Grouping and Subtotalling

• How to categorise your data as Groups thereby allowing calculations or printing of just certain groups of data.
• Using the Subtotal command to create a hierarchy of groups, known as an outline, to help organize your worksheet. It also will calculate common functions like SUM, COUNT, and AVERAGE to help summarize your data.

Pivot Tables and Charts

• Discover the full functionality of Pivot Tables and make them work for you.
• Compile comprehensive Pivot Charts.
• Compile a Pivot Table for an Excel novice to analyse your data using Slicers.
• Creating and enhancing Pivot charts

Tutor Profile

Jacqui Ward is the proprietor and trainer of JW Training, specialising in providing Microsoft application training and business consultancy.

Jacqui is a qualified PRINCE 2 Project Manager and freelance computer software trainer with over 25 years’ experience both in Guernsey and the UK. She has delivered packaged and bespoke training on a corporate, group or one-to-one basis for a variety of major financial companies, the States of Guernsey, Guernsey Electricity and quarterly Excel sessions for the GTA to name just a few.
In previous roles Jacqui has worked as both a marketing director for an international merchant bank and as an IT business solutions manager. Delegate feedback is consistently high, emphasising Jacqui’s ability to draw on her vast experience to deliver training which is targeted on user requirements in her relaxed, friendly and focused style.