Content examples for an Excel training session - Adaptable to your needs

Refresh

You have learned Excel "on the job" and you think that you could well improve your daily use of Excel ...
So, why not refresh your skills (tips and hints) ?

Such a session will cover the following chapters :

• Hints and tips related to typing data (using the the autofill handle, editing, deleting, using flash fill ...)
• Formatting cells
• Page setup and Printing
• Managing files
• Hints and tips for large and more complex tables
• Introduction to formulas and simple functions
• And more ...

Calculations and functions

You master adding and subtracting but you must admit that you don't go any further ! You could well use some easy functions ...

Such a session will cover the following chapters :

• Hints and tips related to standard calculations
• Relatives and absolute references (the well-known $ signs you may add)
• COUNT, COUNTA, COUNTBLANK, COUNTIF, SUMIF, ROUND, IF ...

Managing data

Who has not a list of something, short or ling ? Clients, suppliers, various statistics ... You master sorting and filtering but would like to be more at ease with pivot tables.

Such a session will cover the followgin chapters :

• What is a "list" for Excel
• Going further than standard sorting or filtering
• Subtotals : various types and methods
• Pivot tabless : simple, powerful but they require a minimum of training

Charts

You master the creation of a standard chart. But what about less common charts or special charts ?

Such a session will cover the following chapters :

• Rules to create a standard chart
• Hints and tips to manage a standard chart
• Special charts : bars, area, scatter, radar, stock, bubble ...
• The new charts : pareto, waterfall, funnel ...