Excel – Part Two is an intermediate Excel course that builds on foundational skills to cover the more powerful features used by proficient Excel users. Students learn to work with named ranges, create more complex formulas including logical and lookup functions, apply data validation, analyse data with PivotTables and PivotCharts, and use conditional formatting to highlight meaningful patterns in data.
What You Will Learn
- Use logical functions including IF, AND, OR, and nested IF statements for conditional calculations
- Apply lookup functions including VLOOKUP, HLOOKUP, and INDEX/MATCH to retrieve data
- Define and use named ranges to make formulas more readable and maintainable
- Apply data validation rules to control data entry and ensure data quality
- Create PivotTables and PivotCharts to summarize and analyse large datasets interactively
Who Should Attend
Excel users who are comfortable with the basics and want to advance to intermediate-level features for more productive data analysis.
Prerequisites
Completion of Excel – Part One or equivalent hands-on Excel experience covering formulas, formatting, and basic data management.
