Microsoft Excel Formulas and Functions

Course Overview

Upon completion of this program, candidates should be able to:

  1. Create formulas and use built in functions in MS Excel.
  2. Use “What if Analysis” tool to automate tasks in spreadsheet.
  3. Build report and charts using Pivot Table tool.

Who Should Attend?

This course takes users to a high level of knowledge using functions available in Excel.

Pre-requisite

Delegates should have an understanding of the Windows operating system. Delegates should have a good understanding of Microsoft Excel or alternatively should have attended our Essentials course.

Course Outlines

  • Creating and Using Functions
  • Using Built-in Functions
    • Using PMT and FV
    • Using IF, AND, and OR
    • Using VLOOKUP and HLOOKUP
  • Performing “What If” Analyses
  • Working with Scenarios
  • Goal Seek
  • Data Table
  • Sparklines
    • Types of Sparklines
    • Create a Sparklines
    • Customize Sparklines
    • Control which Value Points are Shown
    • Change the Style of or Format Sparklines
  • Working with Pivot Tables and Pivot Charts
  • Identifying the Parts of a Basic Pivot Tables
    • Pivot Table Reports
    • Create a PivotTable from Worksheet Data
    • Create a PivotChart Report from an Existing PivotTable Report
  • Delete a Pivot Table or PivotChart Report
  • Slicers
    • Using Slicers
    • Formatting Slicers for a Consistent Look
    • Sharing Slicers between PivotTables
Course Details
Course Title:

Microsoft Excel Formulas and Functions

Schedule:
Time:

9.00am-5.00pm

Course Fee:

TBA