This program will teach students much more details of complicated calculation task such as the use of financial functions, statistic functions, data mining, advanced filter, pivot table etc.

Key contents include:

Unit 1: Using Logical Functions

  • Working with Names and Ranges
  • What Are Range Names?
  • Defining and Using Range Names
  • Using Logical Functions
  • Using the Function Library
  • Manually entering a function
  • The IF function
  • The AND Function
  • The OR Function
  • Working with Nested Functions
  • Nested IF functions 

Unit 2: Working with Lookup Functions

  • Using VLOOKUP to Find Data
  • How to Find an Exact Match with VLOOKUP 
  • Finding the Closest Match with VLOOKUP 

Unit 3: Advanced List Management

  • Validating Your Data 
  • Creating Data Validation Settings
  • Using Database Functions
  • Creating a Criteria Range
  • Entering the Database Function

Unit 4: PivotTables and PivotCharts

  • What is a PivotTable? 
  • Preparing Data to Create a PivotTable
  • Creating a PivotTable 
  • Adding Fields to the PivotTable 
  • Creating a PivotTable Frame (Classic PivotTable Layout) 
  • PivotTable areas
  • Rearranging PivotTable Data
  • Hiding and Showing Field Data
  • The PivotTable Tools Ribbon
  • Modifying Calculations and Data Area Display
  • Formatting a PivotTable
  • Refreshing a PivotTable
  • Using Slicers to Manipulate PivotTables
  • Slicers
  • Insert the Slicer
  • Creating a PivotChart

Unit 5: Using ‘What-If’ Analysis Tools

  • Using Scenarios in Excel
  • Creating a Scenario
  • Using Goal Seek
  • Using Solver
  • Checking Solver Installation
  • Setting Solver Parameters

Study Time: Contact us to arrange your class .