1 Day | Class-based & Online

Enhance your productivity and data management skills with this practical, hands-on Microsoft Excel Intermediate course. Building on your existing knowledge, you will learn how to work smarter and more efficiently by leveraging Excel’s powerful tools and functions. Discover how to use logical formulas such as IF statements, sort and filter data for clearer analysis, and apply Conditional Formatting to highlight key information. You will also refine your charting skills to create more insightful and professional visual presentations. Through guided exercises and real-world examples, this course will give you the confidence and capability to use Excel more strategically in your daily work.

Content:

1. Reviewing Core Excel Skills
   Refresh essential Excel concepts and foundational techniques to ensure a confident transition into more advanced tools and features.
2. Developing Complex Formulas
   Build multi-step formulas to perform advanced calculations and streamline data analysis.
3. Applying Logical Functions
   Use logical operators such as IF, AND, OR, and NOT to create dynamic, decision-based formulas that add intelligence to your spreadsheets.
4. Controlling Formula Scope and References
   Understand how relative, absolute, and mixed references impact formulas and apply scoping techniques for accurate results across worksheets.
5. Enhancing Data Presentation with Formatting Tools
   Apply advanced number formatting, borders, and cell styles to improve clarity and professionalism in data presentation.
6. Using Conditional Formatting for Insights
   Highlight key trends and exceptions automatically with data bars, colour scales, and icon sets that make patterns easy to spot.
7. Managing and Organising Data
   Sort, filter, and refine large data sets to extract relevant information quickly and efficiently.
8. Creating and Customising Charts
   Explore chart elements, formatting options, and styles to produce clear, impactful visualisations that support better decision-making.
9. Introducing Sparklines for At-a-Glance Analysis
   Incorporate in-cell charts to display quick visual summaries of data trends and comparisons.
10. Optimising Page Layouts and Printing
    Use advanced page setup options, print titles, and scaling tools to produce professional, presentation-ready reports.

Learning objectives:

By the end of this Microsoft Excel Intermediate course, participants will be able to:

• Create and apply logical functions such as IF, AND, and OR to analyse and evaluate data effectively.
• Use Conditional Formatting techniques to automatically highlight key trends and values for clearer data insights.
• Organise and analyse information efficiently using Excel’s advanced sorting and filtering tools.
• Enhance the professional appearance of spreadsheets through consistent use of borders, formatting, and layout design.
• Design and customise advanced charts to present complex data clearly and support informed business decisions.

Prerequisite: Participants are expected to have an essentials level of Microsoft Excel experience before attending this course.