MS Office

Microsoft Office Excel (Intermediate Level)

10 October 2024

Dusit D2 Kenz Hotel

2 days

The Microsoft Office Excel (Intermediate Level) course is a 2-day program designed for individuals who have a basic understanding of Microsoft Office Excel but want to improve their proficiency. Participants will learn about the intermediate features of Excel, including data analysis and visualization, functions, and formulas. Topics covered will include conditional formatting, charts, pivot tables, and working with large data sets. The course is ideal for professionals, business owners, and students who want to become more efficient and effective in using Microsoft Office Excel.

Enquire about this course

This 2-day Microsoft Office Excel (Intermediate Level) course is structured for individuals who are familiar with the basics of Microsoft Office Excel and are keen to enhance their skills. The course delves into the intermediate features of Excel, focusing on areas such as advanced data analysis, visualization techniques, and complex functions and formulas. Key topics include mastering conditional formatting, creating sophisticated charts, utilizing pivot tables, and efficiently handling large data sets. This program is especially beneficial for professionals, business owners, and students who aspire to elevate their Excel capabilities, thereby increasing their efficiency and effectiveness in various tasks requiring advanced Excel usage.

Key Points:
  • Harnessing advanced data analysis techniques for better decision-making.
  • Crafting dynamic reports and visualizations using pivot tables and charts.
  • Utilizing complex functions and formulas for in-depth data manipulation.
  • Employing conditional formatting to highlight critical data insights.

Download the course guide

We offer a comprehensive curriculum that covers all of the essential topics. Our experienced instructors will provide you with the support and guidance that you need to succeed.

Course Guide Thumbnail

Course Content

Advanced Data Analysis Techniques
  • Utilizing advanced filter options
  • Exploring data analysis tools
  • Performing what-if analysis
Conditional Formatting and Data Validation
  • Applying conditional formatting to data sets
  • Customizing rules for dynamic data displays
  • Using data validation for improved data integrity
Mastering Functions and Formulas
  • Exploring logical functions (IF, AND, OR)
  • Utilizing lookup functions (VLOOKUP, HLOOKUP)
  • Working with date and time functions
Pivot Tables and Pivot Charting
  • Creating and customizing pivot tables
  • Analyzing data with pivot charts
  • Advanced pivot table techniques, such as grouping and calculated fields
Effective Charting and Data Visualization
  • Designing advanced charts (e.g., Combo charts, Histogram)
  • Utilizing Sparklines for in-cell visualization
  • Best practices for effective data presentation


Managing Large Data Sets
  • Techniques for handling and analyzing large volumes of data
  • Introduction to data consolidation
  • Efficient data sorting and filtering strategies
Data Import and Export
  • Importing data from external sources
  • Exporting data to other formats
  • Linking and consolidating data across multiple workbooks
Advanced Excel Tips and Tricks
  • Keyboard shortcuts and productivity tips
  • Troubleshooting common Excel issues
  • Customizing the Excel environment for individual preferences
Course Instructor

Gerard Cannon

Gerard Cannon

Gerard is a skilled trainer with 25 years of experience and a passion for education and technology. He utilizes his knowledge of Microsoft Visual for Applications to craft tailored applications for schools and corporations, and his expertise as a Microsoft Excel expert to empower individuals and organizations in mastering this essential tool. Gerard's training sessions are designed to transform complex Excel functionalities into accessible skills, fostering productivity and efficiency.

plus icon

Interested in what else we can offer you?

10 October 2024

Dusit D2 Kenz Hotel

    Get in touch

    Advance your career and achieve your goals

    Enter your details below & we will be in touch to discuss how we can help