Training Course:Excel 2003 AdvancedSchool/Trainer:Raising the Bar
Sydney, NSW, Australia
Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced
Course Description:
'' 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
...''
Please go to the school's official website for training price and schedule:
http://www.rtb.com.au/
Phone:(02) 9929-8845
School Address:
Suite 501, Level 5
65 Walker St
North Sydney NSW 2060
Jobs & Resumes: Sydney
Houses & Roommates: Sydney
Travel Agencies: Sydney
Search other schools for Excel 2003 Advanced training resources.
Other training courses offered by Raising the Bar:
Access 2003 VBA Basic
Access 2003 Basic
Access 2003 Intermediate
Access 2003 Advanced
Excel 2003 VBA Basic
Excel 2003 Intermediate
Excel 2003 Basic
Outlook 2003 Basic
Outlook 2003 Advanced
Powerpoint 2003 Advanced
Powerpoint 2003 Basic
Project 2003 Advanced
Project 2003 Basic
Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
Tips:
Want to find a place to stay close to the school? Or homestay in a different country? Try the house rental message board where you can search for roommates and post shared rooms or apartments for rent. |
|
| 
