• Virtual
  • November 24, 2022 - November 25, 2022
  • 10:00 AMto1:00 PM (Everyday)

Contact event manager

Tickets details

  • Sorry, Event passed
View cart
Thank you Kindly

Microsoft Excel – Advanced (Virtual)Passed

VIRTUAL (AEST)

Thu, 24 November, 2022 to Fri, 25 November, 2022
November 24, 2022

000000

Microsoft Excel – Advanced (Virtual)Passed

VIRTUAL (AEST)

Thu, 24 November, 2022 to Fri, 25 November, 2022
November 24, 2022

PRINT

Excel Advanced is for people who need to create sophisticated user-friendly spreadsheets, solve more complex problems, perform data analysis, work with different scenarios or create more automated solutions in Excel. In this course we will look at how we can ensure accuracy using data validation and protection functionality, we will automate procedures using a range of lookup functions and macros, model different scenarios using what-if analysis tools and analyse and visualise data using PivotTables and Pivot Charts.

DATA VALIDATION
• Add simple validation
• Add validation that uses calculations
• Create automated drop-down lists

LOOKUP FUNCTIONS
• VLOOKUP
• INDEX
• MATCH
• XLOOKUP (version permitting)

PROTECTING DATA
• Protecting access to a spreadsheet
• Protecting the structure of a workbook

CHARTS
• Create Pivot table reports
• Modify calculations within pivots
• Change the formatting of PivotTables
• Sort and Filter PivotTables
• Add Pivot Charts
• Create interactive dashboards with Pivot
• Charts and Slicers

ADDING DIFFERENT TYPES OF PROTECTION TO SPECIFIC CELLS MACROS
• Understand macros and macro security
• Record and run macros
• Edit macros
• Create buttons for running macros

PIVOT TABLES
• VLOOKUP range lookup
• VLOOKUP exact match

WHAT IF SCENARIOS
• Goal Seek
• Scenario Manager
• Solver

Ideal for individual delegates who have specific requirements from the software, or where previous knowledge makes group training inappropriate. The pace and content can be adjusted to the individuals exact needs.

PREQUALIFICATIONS
Advanced Excel training is for people who can already create moderately complex spreadsheets and want to add more sophistication and automation. Candidates should have completed the Intermediate level, or feel competent they have an intermediate knowledge of Excel.

• 1-day Face to Face instructor-led program
• 2 x 3-hour web-based virtual sessions

 
This workshop is not suitable for Mac Users.  Should you have a Microsoft Office for Mac training requirement, please contact us for assistance.

  • Extensive Learning & Reference Guides provided on USB
  • Participation in the full day workshop
  • Access to a Microsoft technical expert throughout and post the workshop