ABN 76 104 620 484
 
 
 
 
Microsoft Office Courses | Soft Skills | Pricing
Contact Us | Home | Trainer Profiles
   

VALIDATING, AUDITING AND TEMPLATES

Using Data Validation
  • How To Validate Data Input
  • How To Compose Data Input Message
  • How To Create Error Alert Message

Creating A New Workbook Using Templates
  • How To Create A New Workbook Using Built-In Template On Your Computer
  • How To Create A New Workbook Using Template On Office Online
  • How To Create A New Template
  • How To Create New Workbook From Own Template
  • How To Edit The Template

Auditing Worksheets And Tracing Cell References
  • How To Select Cells That Contain Formula
  • How To Watch Formulas
  • How To Find Cells That Provide Data To An Active Cell (Precedents)
  • How To Find Cells That Referred By An Active Cell (Dependents)
  • How To Hide All The Auditing Arrows

Tracing Errors
  • How To Circle And Remove Circle For Invalid Data
  • How To Correct Calculation Errors
  • How To Set Error Checking Options
  • How To Scan And Correct All Errors

Using Range Names
  • How To Define A Range Name
  • How To Define A 3-D Range Name Using The Menu
  • How To Redefine The Cell References In Range Name
  • How To Delete A Range Name
  • How To Use Range Name In Formula

Combining Worksheets And Data From Different Workbooks
  • How To Consolidate Data
  • How To Move Or Copy Worksheets to Another Workbook

USING ADVANCED FUNCTIONS

Using Financial Functions
  • How To Use PMT Function
  • How To Use ABS Function

Using Logical Functions
  • How To Use Logical Test
  • How To Use IF Function To Return A Text
  • How To Use IF Function To Return A Value
  • How To Use Nested IF Function
  • How To Use OR Function
  • How To Use AND Function
  • How To Use COUNTIF Function

Using The VLOOKUP Functions
  • How To Use VLOOKUP To Find Data
  • How To Limit The Lookup Value For Exact Match
  • How To Use The Closest Match For The Lookup Value

Using Simple Database Functions
  • How To Find The Sum Of Specific Records Using Paste Function
  • How To Find The Average Of Specific Records
  • How To Find The Maximum / Minimum Value Of Specific Records
  • How To Find The Number Of Records

CREATING A PIVOTTABLE AND ANALYSING DATA

Creating A Pivot Table
  • How To Create A PivotTable
  • How To Create A PivotTable From An Access Database

Updating Pivot Table
  • How To Update Information In Pivot Table
  • How To Add Information In Pivot Table
  • How To Arrange Information In Pivot Table
  • How To Remove Information In Pivot Table
  • How To Create Page In Pivot Table
  • How To Display Pages On Separate Sheets

Modifying A Calculated Field in Pivot Table
  • How To Use Other Functions In Calculated Fields
  • How To Insert Calculated Fields
  • How To Hide Calculated Fields
  • How To Delete Calculated Fields

Creating A Chart From A Pivot Table
  • How To Create Chart From A Pivot Table

WHAT IF TOOLS

Exploring Data Tables
  • How To Create One Variable Data Table
  • How To Create Two Variable Data Table

Using Scenarios
  • How To Create Scenarios
  • How To Apply Scenario
  • How To Edit Scenario
  • How To Delete Scenario

Using Goal Seek
  • How To Use Goal Seek

AUTOMATING ROUTINE TASKS WITH MACROS

Understanding Macros
  • How To Record A New Macro
  • How To Run Macro With Menu
  • How To Create A Run Macro Button On Toolbar
  • How To Create Macro Command Button On Worksheet
  • How To Edit Command Button

Editing A Macro
  • How To Edit Macro Coding
  • How To Rename A Macro
  • How To Delete A Macro

Using Relative Reference Macros
  • How To Record A Relative Reference Macro
  • How To Run Relative Reference Macro
RtB-logo-small