Loading Classes

« All Classes

Sage | Excel On Steriods

July 21 @ 8:00 am - July 22 @ 5:00 pm

R6,957.50
Excel On Steroids

Tickets

The numbers below include SELECT NUMBER OF ATTENDEES for this event already in your cart. Clicking "Get SELECT NUMBER OF ATTENDEES" will allow you to edit any existing attendee information as well as change ticket quantities.
Sage Excel On Steriods
 
  • 1. ADD +1
 
  • 2. CLICK REGISTER NOW
 
  • 3. ADD THIS CLASS TO THE CART
 
  • 4. COMPLETE YOUR PERSONAL DETAILS
 
  • 5. SELECT A PAYMENT METHOD
 
R 6,957.50
4 available

What you will cover – Lesson Outline Excel On Steroids

Lesson 01 – Workshop: Data Analysis

  • Tell Me Text Box
  • Smart Lookup
  • Data Validation
  • What-If Data Analysis
  • Forecast Sheet
  • Makros

Lesson 02 – Workshop: 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

Lesson 03 – Workshop: 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

Details

Start:
July 21 @ 8:00 am
End:
July 22 @ 5:00 pm
Cost:
R6,957.50
Class Category:

Company

Sage South Africa (Pty) Ltd – Virtual Classes
Microsoft Teams
Gauteng, South Africa
View Company Website