Excel On Steroids

TydeCo™U is pleased to offer their new advanced Microsoft Excel training by our qualified and experienced Excel trainers. Our advanced Excel training courses can be done virtually, or in our Cape Town-based classroom or at your premises and is suitable for anyone wanting to build on their current Microsoft Excel skills. Enrol with us today.

Virtual: R6 141,00 VAT Incl.

Classroom: R8 199,50 VAT Incl.

Training Course Overview:

Excel on Steroids is more than just an advanced Excel course. It focuses on Excel features that are key for business reporting in Accounting, Sales, Marketing and all kinds of industries. The course works through practical examples using the software and takes the student through scenarios and setups of reports in Excel. Training is presented in a virtual, instructor-led environment or classroom facilities in Cape Town or on-site.

 

Training Course Content:

1. Data analysis:

• Smart Lookup
• Sorting, subtotalling
• Filtering
• Data validation
• Macros

2. PivotTables & PivotCharts:

• New options
• Formatting
• Calculated items and fields
• Sort and filter
• Consolidate
• Sparklines
• 3DMaps

3. Formulas and functions:

• Data Consolidation
• Conditional formatting
• Cell references
• Lookup functions including vlookup and match.
• Statistical & mathematical functions
• Date and time functions

Training Duration: 2 Full Days (9:00 – 16:00)

Pre-Requisite:

Excel Intermediate or passing of pre-assessment.

 

To arrange training at your office email training@tydeco.com for a quotation.