[email protected]

Excel Course for Intermediate

Enquire Now

Excel Course for Intermediate

Course Description:

This intermediate Excel course is designed to build on basic Excel skills and enhance your proficiency in using spreadsheets for data analysis, reporting, and decision-making. Participants will learn advanced functions, data management techniques, and effective formatting to create professional-looking spreadsheets.

Course Outlines:

  • Introduction to Advanced Functions
    – Review of basic functions (SUM, AVERAGE, COUNT, etc.)
    – Using logical functions (IF, AND, OR)
    – Advanced lookup functions (VLOOKUP, HLOOKUP, INDEX-MATCH)
  • Data Analysis Techniques
    – Sorting and filtering data
    – Using conditional formatting for data visualization
    – Grouping and outlining data
  • PivotTables and PivotCharts
    – Creating PivotTables to analyze data
    – Formatting and customizing PivotTables
    – Creating PivotCharts for visual representation
  • Advanced Data Management
    – Working with large datasets using Excel tables
    – Data validation techniques
    – Introduction to Power Query for data cleaning and transformation
  • Automation and Efficiency Tools
    – Introduction to macros and VBA (Visual Basic for Applications)
    – Creating and running simple macros
    – Using Excel’s built-in tools for automation (Solver, Goal Seek)
  • Advanced Charting Techniques
    – Creating advanced charts (combo charts, sparklines)
    – Customizing charts and graphs
    – Using chart templates for consistency

Learning Outcomes:

By the end of this course, you will learn the following:

  • Mastering advanced Excel functions such as VLOOKUP, IF statements, and PivotTables
  • Analyzing data using filtering, sorting, and conditional formatting
  • Enhancing data visualization with charts and graphs
  • Managing large datasets with tables and data validation
  • Streamlining workflow with macros and automation tools
  • Improving spreadsheet efficiency and accuracy


Participants should have a basic understanding of Excel including familiarity with creating formulas, basic functions, and formatting. This course is suitable for those who have already completed an introductory Excel course or have equivalent experience.

Target Audience: 

Professionals and individuals who use Excel for data analysis, reporting, or project management and want to advance their skills to the next level.

Course Duration: 1 day

Certification: A certificate of completion will be provided to participants who attend the full course.


Upcoming Schedules:

July 25th
August 29th
September 26th
  • Duaration of the Course
  • Participants
  • Certification
  • Google My Business Reviews
  • Enquire Now
Sarah Thomas
Training was well prepared and well presented. The course added value to my day to day. Thank you Samson Training and Kean specifically. I enjoyed your "funny but not funny" jokes :)
Bonnie Reidy
Excellent cCourse and well presented
Bonnie O'Connor
Even through a pandemic , samsung training met all our needs and requirements to get us over the finish line and qualify to first aid responders. A very interesting course that covered everything. would highly recommend
Elzbieta Filipowicz
I would like to say I found the course very interesting and really enjoyable. I want to commend Cheryl on how she presented the course. She went into great detail and I left the course very happy and I learned a lot.
Ciara Kenny
Excellent course and great communication throughout from team.
Conor McElvaney
Even through the Pandemic Chris and the team succeeded in delivering our manual handling instructors course - delighted !
Sarah Cummins
Positive: Quality
British Health
Modern, thorough and very well organised approach to training and certification. 5 Star service - thanks to Chris and his team
David Powell
Outstanding Training Company