Specialised Microsoft Excel training workshops for enhanced Business reporting and
Decision making.
Decision making.
The Excel on Steroids workshops provide in-depth coverage of key Excel functionality, specific to business reporting and offers enhanced performance and productivity in this area upon completion.
These workshop are available in:
Microsoft 2003
Microsoft 2007 
Why should anyone do the Excel on Steroids Course?
How much time do you spend on Excel each day? 3 hours?? That’s 15 hours a week, 60 hours a month?
Imagine if you created a 25% improvement by working smarter, using methods you didn’t know about?
That’s saving you 15 hours a month – 180 hours a year, through efficient Excel use. What is your time worth? At R100 per hour – modest – that’s R18000 per year saving, and I’m asking you to invest in R3825?
Imagine if you created a 25% improvement by working smarter, using methods you didn’t know about?
That’s saving you 15 hours a month – 180 hours a year, through efficient Excel use. What is your time worth? At R100 per hour – modest – that’s R18000 per year saving, and I’m asking you to invest in R3825?
Samples of Worksheet Content
Workshop 1: Business Reporting using Formulas and Functions
- By viewing multiple windows you can Copy and Move worksheets between workbooks
- Save time on data capturing in multiple worksheets by using Grouping
- Consolidating worksheets by using Paste Special Quickly identifying certain transactions and highlighting duplicates by using Conditional formatting (incl. applying Data Bars, Icons, etc in MS 2007)
- Ensuring certain cells cannot be selected and formulae protected by using worksheet Protection
- Simplify formulae by using Named Ranges
- Using powerful Functions to develop your Report such as Lookup Functions, Text Functions, Logical Functions, Information Functions, Statistical Functions and Mathematical Functions
Workshop 2: Managing Data lists and Macros
- Sorting your list in any specific order by using a Custom List
- Using Subtotals to analyse your list to view totals by category
- Identifying certain data based on a criteria by using Filtering
- Ensuring you have consistent data capturing by using Data Validation
- Summarising your rows and columns by using Group and Outline and create Custom Views
- Forecast outcomes by creating Scenarios
- Simplify repetitive tasks by recording, viewing, running, and editing Macros
Workshop 3: Data analysis using PivotTables and PivotCharts
- Understanding the definitions and layout of a PivotTable
- Summarising data by creating a PivotTable
- Improving the look and feel of the PivotTable by Modifying and Formatting an existing PivotTable
- Saving time creating a new PivotTable by moving or copying an existing PivotTable
- Using Pivot Tools to manage your PivotTable effectively
- Creating specific formulae within your PivotTable by using a Calculated field
- Summarising dates into Months, Quarters and Years by using Grouping
- Graphically representing your PivotTable by creating a PivotChart
This course can be done classroom based, or Online (the courses can be done at a time & place suitable to you). Classroom delegates will receive a manual and 3 month’s email support, and online delegates will have 3 months access to the academy with e-mail support and an option to print the manual off the academy. On completion of each course you will need to complete the assessment and on achieving a pass mark of 70% or above, you will receive a printable certificate.
Who will benefit from attending this course?
Directors, Managers, and anyone else who uses Excel extensively for report writing. Delegates will return to the office after the workshops with an advanced understanding of relevant Excel functionality and practical know-how that will result in significant time-savings each month.
This workshops will contribute 12 verifiable CPD hours.
Please Note: Intermediate Excel skills are required for delegates to take full advantage of this course. An excellent “Discovering Excel” course is available to bring skills up to the required level.
Course Duration
Classroom – 3 ½ day workshops (9:00 – 13:30) Online - Self Paced (3 ½ days classroom equivalent)
To Register for this Course E-Mail:info@autoexcelreporting.co.za
To Register for this Course E-Mail:info@autoexcelreporting.co.za
