• Virtual
  • July 28, 2022 - July 29, 2022
  • 10:00 AM to1:00 PM (Everyday)

Contact event manager

Tickets details

  • STANDARD 15 remaining
    $400
View cart
Thank you Kindly

Microsoft Excel – Advanced (Virtual)

VIRTUAL (AEST)

Thu, 28 July, 2022 to Fri, 29 July, 2022
July 28, 2022

000000

Microsoft Excel – Advanced (Virtual)

VIRTUAL (AEST)

Thu, 28 July, 2022 to Fri, 29 July, 2022
July 28, 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

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