Microsoft Excel – Advanced

Duration:9:00am - 2:00pm
Cost (pp):$197
Location:3/610 Lorimer Street, Port Melbourne VIC 3101
Entry Requirements:

Participants should have attended or have the knowledge of our Microsoft Excel Intermediate course.

Description:

Click here to download the Microsoft Excel Advanced course outline

File Protection
• Worksheet protection
• Workbook protection
• Adding/changing passwords

Cell Protection
• Protecting cells

Functions
• Function overview
• AND function
• OR function
• Logical functions
• Nesting functions
• VLook up functions
• Function wizard

Goal Seek
• Goal seek overview
• Using goal seek

Solver/Scenarios
• Saving a scenario
• Adding scenarios
• Showing scenarios
• Showing scenarios

Linking
• Worksheet linking
• Workbook linking

Data Consolidation
• Data Validation
• Error alerts
• Drop down lists

Exporting Data
• Choosing specific format
• Exporting to Word
• Pasting data with a link
• Copying a graph with a link

PivotTable Reports
• PivotTable layout
• Rearranging data
• Filtering reports
• Adding fields
• Field settings
• Refreshing data
• Formatting a PivotTable
• Showing detail

PivotChart Reports
• Create a PivotChart
• Adding fields
• Creating reports

Macros
• Recording a macro
• Editing a macro
• Stepping through a macro
• Macro buttons
• Deleting a macro

Developer
• Adding developer tab
• Using fields
• Formatting fields

Units of Competency:
Assessment Type:No Assessment
Course Expires After:Certificate of Completion never expires
Delivery Method:Face to face
What to Bring and Wear:
  • Closed in shoes
  • Sleeved shirt
  • Photo ID
Upcoming Course Dates
Upcoming Course Dates
Course NameLocationCourse Date
AdvancedPort Melbourne13-09-2017Book Now
AdvancedPort Melbourne27-09-2017Book Now

SOME OF THE ORGANISATIONS THAT WE’VE WORKED WITH

“Working with Training Ahead Australia has been phenomenal. What they have delivered to my organisation has been nothing short of exceptional. We have seen a direct correlation between recent growth and success in sales, productivity and in culture from the training and influence of TAA.”- Bernard Fernandez, Agero Group
Book online
Training Ahead Australia