Excel Intermediate Training Course
Key information
Upcoming sessions
Would you like to schedule this training on a specific date? Contact us by email or via the contact form.
Description of the training: Excel Intermediate Training Course
This Excel Intermediate training course is aimed at users who have mastered the basic operations of the spreadsheet and wish to gain confidence and independence. Over two hands-on days, you will consolidate calculation formulas, references, conditional formatting and the creation of clear charts. You will also discover the functions that are most useful day to day, along with a first approach to PivotTables to analyse your data more effectively. By the end, you will be able to build reliable, readable tables and save valuable time on your recurring tasks.
Complementary courses: to go further, also discover Excel Advanced Skills Training Course, Excel Advanced Level Training Course and Excel PivotTables Training Course.
Good to know
The sessions are guaranteed from the first registration (except in cases of force majeure).
A preliminary interview takes place between the participant and/or a company contact in order to fully take into account the participant’s profile (level, needs, professional context, challenges, etc.).
Assessment: during the course, the trainer assesses participants’ learning progress through quizzes, role-play and practical exercises. Participants receive a certificate of completion at the end of the course.
This training course is part of our Power Platform Training Courses catalogue. Explore all our Power Platform courses to automate, analyse and build your business applications without code.
Objectives of the training: Excel Intermediate Training Course
By the end of the course, participants will be able to:
- master relative, absolute and mixed references;
- use common functions (IF, AND/OR, SUMIF, COUNTIF, VLOOKUP);
- format and present clear tables (conditional formatting, styles);
- create and customise charts suited to the data;
- sort, filter and organise data lists;
- discover PivotTables to summarise information.
Prerequisites of the training: Excel Intermediate Training Course
To follow this course under the best conditions, it is recommended to have completed the Excel Introduction training course or to have equivalent knowledge: entering and formatting data, simple formulas (SUM, AVERAGE), creating basic tables. Because every participant is unique, a personalised interview is held beforehand in order to adapt the pace and practical cases to your context.
Detailed programme of the training: Excel Intermediate Training Course
Reminders and working environment
- Reminders on the interface, workbooks and sheets. Quick data entry and selection techniques. Relative, absolute and mixed references. Naming cell ranges for more readable formulas.
Common formulas and functions
- Essential functions: SUM, AVERAGE, MIN, MAX, COUNT. Logical and conditional functions: IF, AND, OR, SUMIF, COUNTIF. VLOOKUP lookup function. Understanding and correcting formula errors.
Formatting and presentation
- Conditional formatting to highlight information. Custom number formats. Styles and formatting as a table. Page layout and printing (print areas, headers and footers).
Create and customise charts
- Create a chart and choose the right type (column, line, pie). Customise the elements (titles, legends, labels, axes). Combined charts and trend lines. Introduction to sparklines.
Managing data lists
- Sort data according to one or more criteria. Filter and use advanced filters. Freeze panes to navigate large tables. Format data as a structured table and take a first approach to PivotTables.
The highlights of this training course
- This course: focuses on practice with around 60% of hands-on exercises in Excel; lets you work on your own files; takes place in a small group of 1 to 3 participants; is led by an expert trainer; leads to a certificate of completion.
FAQ
What is Excel?
Microsoft Excel is the spreadsheet application in the Office suite: it lets you enter, organise, calculate and analyse data in worksheets. MFE-IT’s Excel Intermediate training course helps users who are already familiar with the basics to gain independence with formulas, formatting, charts and data lists.
Who is the Excel Intermediate training course for?
It is aimed at people who already know the basics of Excel (data entry, simple formulas, formatting) and want to progress towards a more efficient use: common functions, conditional formatting, charts, sorting and filtering, and a first approach to PivotTables.
What is the difference between the Intermediate and Advanced Skills levels?
The Intermediate level consolidates the fundamentals and introduces the functions and charts useful day to day. The Advanced Skills level goes further: advanced functions, in-depth PivotTables, data consolidation and automation. Intermediate is the ideal step before Advanced Skills.
How long does the Excel Intermediate training course last?
The course lasts 2 days, i.e. 14 hours. Sessions are guaranteed from the first registration and take place in a small group of 1 to 3 participants. The programme can be customised and organised at your premises.
Is this Excel Intermediate training course eligible for CPF or OPCO funding?
This course is funded directly by the company and is not eligible for CPF. Depending on your situation, funding by your OPCO may be considered: contact us to explore the funding options suited to your project.
.elementor-accordion .elementor-tab-title .elementor-accordion-icon{margin-right:10px}.elementor-accordion .elementor-tab-title .elementor-accordion-icon + a,.elementor-accordion .elementor-tab-title .elementor-accordion-title{padding-left:4px}