Excel on Steroids

These workshops are available in Excel 2003 and Excel 2007.

Why should anyone do the Excel on Steroids course?

Who will benefit by attending this course?

These workshops will contribute 12 verifiable CPD hours.

Course Duration

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

Click here to view training dates.

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

Click here to view training dates.

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

Click here to view training dates.

Download registration form

Terms and Conditions Unless otherwise specified, all prices include VAT All course manuals are included in the class-room course fee Learners may be required to bring their own consumable items such as a writing pad, pens, etc. Payment for training is strictly to be paid at least a week before commencement date No Cancellations will be accepted, the full course fee will be charged – although substitutions may be made Lemay’s Training Centre reserves the right to cancel any course should there be an insufficient number of delegates booked for a course. Courses will only be run if there are sufficient learner numbers Additional Modules can be arranged should there be enough of a demand or arrangements can be made for 1 on 1 training Additional Modules - Manufacturing, Point of Sale, Multi Currency, Receipting, Serial Number Tracking, Time and Billing, General Ledger Manager, Multi Stores available on request Assessments & Certification Assessments are based on information taught in the classroom and not necessary based on the training material Marking of the exams will take between 2 to 4 weeks Accreditation Refresher & Bridging Assessments will be based on the previous and current versions Should it be required that you need to write an assessment after a course, you will need to do so within 30 days after the end of the course. No extensions will be granted Students are required to purchase and book assessments The pass mark is 75% A student needs to write an assessment in order to obtain certification for attending a course