Description
Excel on Steroids is a more than just an advanced Excel course, it focuses on Excel features that are key for business reporting
Who should attend?
- Finance professionals: Create and analyse powerful financial reports to keep your finger on the pulse of your business
- Sales professionals: Effectively track your sales against target and identify performance by sales rep, area or product
- Marketing professionals: Maximize your ROI by keeping track of your campaigns
- HR professionals: Utilize employee turnover reports, leave reports or training and development reports to cultivate the right environment for your people
EXCEL ON STEROIDS Course Overview
Data Analysis:
- Tell Me Text Box
- Smart Lookup
- Sorting, Subtotalling and Filtering Data
- Data Validation
- What-If Data Analysis
- Forecast Sheet
- Macros
Formulas & Functions:
- Data Consolidation
- Conditional Formatting Worksheet Protection
- Managing and Preparing Data
- Using Cell References
- Lookup, Text and Logical Functions
- Statistical and Mathematical Functions
- Date and Time Functions
PivotTables and PivotCharts:
- PivotTable Basics
- PivotTable Options
- Formatting a PivotTable
- Calculated Items and Fields
- Sort & Filter a PivotTable
- Consolidated PivotTable
- PivotCharts and Sparklines
- 3D Maps
Booking Procedure
• Step 1: Add desired training course to your basket
• Step 2: Click on the cart to check out
• Step 3: Continue to make your payment on the Secure Payment Gateway
Once payment has been made an e-mail with your order will be sent to our training department. One of our friendly consultants will then be in contact with you to arrange Classroom dates or if you opted for E-Learning they will guide you through the registration process.
Contact the training team on 011 304 3670 or e-mail us at [email protected] if you would like to find out about our other courses
