Is your reporting data a mass of records without any real meaning? Do you need to accurately summarise or extract records that meet certain criteria from your spreadsheet data? Do you need to professionally present your results or highlight only the records that matter the most?
- In an Intermediate Excel class we introduce Excel tools that extract, consolidate, sort and filter information to display only the relevant records . We focus on building understanding of reference and analysis formulas to summarise results. We help our students comprehend nested functions and relative vs absolute referencing to confidently create dynamic formulas that find and present only the desired results.
- Although we customise every class to cover the topics determined by the pre-training analysis, our Microsoft Office Expert will allow time to discuss with the class their daily Excel tasks, to ensure the session is relevant to their needs.
- Complex functions are simplified for increased understanding
- Learn directly from a Microsoft Certified Office Expert and fully qualified trainer
- Flexible course content, duration and location
- Completion of Excel Beginner or equivalent experience would be advantageous
- Learn in the comfort of your own office
- Although we design all classes to cover the content determined by the pre-training analysis, the topics we typically deliver in Intermediate Excel classes are:
- Formula Referencing (Relative vs Absolute)
- Structuring Formulas
- Conditional Formatting
- Reference & Analysis Formulas
- Simple & Compound Filters
- Included in the cost of our training, our trainer will provide follow-up support for one month, via phone or email to answer any queries that may arise with regard to the functions learnt.
The cost of a half day customised Excel training is $960.00 (+GST), which includes:
- Review of requirements and personally tailored courseware
- Half day session for up to 10 participants delivered by a Microsoft Certified Office Expert
- Step-by-step guide
- Certificate of Completion
- One month support from your trainer via phone or e-mail.