Event details
- Virtual
- April 2, 2025 - April 3, 2025
- 9:30 AM to 12:45 PM (Everyday)
Contact event manager
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 hours and 15 Minutes 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