Microsoft Excel: Super User

Microsoft Excel: Super User (Expert)

Overview and objectives

This one-day course is designed to introduce the advanced user to more of Microsoft Excel’s specialised functions.

Course Outline

This course consists of 7 modules
Module 1Add-ins
Description of the Add-in’s
Paste Special
The Operation Commands
Module 2Text Functions:
The CONCATENATE Function
The CHAR Function
The EXACT Function
Extracting Characters from a Text String
The LEFT Function
The RIGHT Function
The MID Function
Module 3Date & Time Options:
DATEDIF Function
Calculating Working Days between Two Dates
The DAY Function
The MONTH Function
Calculate the Number of Months between Two Dates
The YEAR Function
Calculating Ages
The LEFT Function
The ROUNDDOWN Function
The ROUNDUP Function
Module 4Logical Functions:
The AND Function
The OR Function
Nesting the OR/AND Function With an IF Function
The SUMIF Function
The COUNTIF Function
Nesting the SUM & IF Functions
The SUMIFS Function
The COUNTIFS Function
The IFERROR Function
The SUMPRODUCT
INDEX and MATCH Functions
MATCH Function
Nesting the INDEX & MATCH Functions
Troubleshoot the MATCH Formula
The CHOOSE Function
Module 5Using the Advanced Filter:
Filtering List “In-Place”
Copy Filter Results to a New Location
Extracting a Range to another Workbook
Creating a Macro to Extract Information
Module 6The Lookup Function:
Using the CEILING Function
Using the FLOOR Function
Module 7Using Form Controls:
Using Forms Controls in Excel
Activex vs Forms Controls?
Forcing User to Choose From a List
Creating a Combo Box
Controlling Multiple Charts with List Box
Create a List Box
Group Box and Option Buttons
Spin Button
Checkbox
Rename the Checkbox Button
Creating a Macro to Filter the Chart by Region
Assigning Macros to Buttons

Microsoft Excel Super User

Who should attend?

Any delegate wanting to further develop their skills in designing specialised spreadsheet solutions.

Course Prerequisite

Successfully completed Microsoft Excel: Advanced Course and be fully competent with all the concepts covered.

Duration

1 Day

Cost

R1 270,00 (excl. VAT)

Includes

  • Comprehensive Manual
  • Lunch & Refreshments (not applicable to on-site training)
  • Electronic Certificate (on successful completion of the course)
  • Electronic Trainer Feedback Report
  • Electronic Delegate Feedback Questionnaire
Download Course Information

Microsoft Excel: Super User

Course Schedule

View the available course dates