These formulas are the extensions past the basics, such as:

• IF, IFS, COUNTIF, SUMIF
• VLOOKUP, INDEX, MATCH
• TEXT, LEFT, RIGHT, MID
• DATE, TIME, NOW

These functions are often combined in nested formulas to tackle real-world spreadsheet problems.

You can achieve the intermediate level by mastering the following skills:

• efficient data entry and formatting
• logical and lookup functions
• pivot tables and advanced filters
• tools such as Goal Seek and Solver

With practical training and excercises from our Intermediate Excel course, you'll boost your confidence and speed in no time!

Not sure how good you are with Excel? Take our free Excel skills assessment. It will help you figure out your current level and discover which course would be the best fir for you!

In the intermediate level, we cover the basics of data operations, including logical formulas, filters, and pivot tables. As you progress to the advanced level, you will explore automation with macros (VBA), advanced modeling techniques, and custom functions.

Check out our Excel Advanced level course to dig deeper!

Data management

• Sheets management (naming, copying, colour change)
• Efficient data entering
• Efficient selecting
• Go To and Go To Special tools
• Sorting data
• Custom lists
• Autofilter and Advanced filter
• Advanced operations on copying and pasting data

 Adjustment of the working environment

• Hotkeys, facilities
• Create and modify toolbars
• Excel Options (autosave, input, calculations, etc.)

Formatting

• Cell styles
• Format painter
• Number formats

 Functions

• Subtotals function and subtotal tool
• Statistical functions (average, maximum, minimum and quantity)
• Text conversion functions
• Date and time functions
• Sheet inspection

 Tables and list management

• Using names of cells and ranges
• Format as Table

Conditional functions

• IF
• Logical functions
• Informational functions
• Avoiding errors
• Other conditional functions (countif, sumif  and others)
• Creation of complex / multiple nested formulas

 Data consolidation

• Getting external data (CSV, TXT, Access)
• Data consolidation functions and tools
• Search functions (lookup, vlookup, hlookup, index, match)

Review

• Collaboration
• Tracking changes
• Comments

Protection

• Protect worksheet and workbook
• Secure and encrypt files

Pivot Tables and Pivot Charts

• How to effectively create a pivot table
• Changing style, layout, totals, subtotals
• Formatting pivot table fields
• Sorting and filtering data
• Grouping the data
• Using calculated fields and calculated items
• Getting data from Pivot Table
• Advanced Pivot Table options
• Pivot Charts

General Analysis Tools

• Scenarios
• Custom Views
• Goal Seek
• Solver
• Data Tables
• One Input
• Two Input

Development Path explore other courses in the MS Excel training path:

• MS Excel – advanced level
• Visual Basic for Applications in Microsoft Excel – Basic level
• Visual Basic for Applications in Microsoft Excel – Intermediate level
• Visual Basic for Applications in Microsoft Excel - advanced level. Databases in Excel spreadsheet.
• VBA in MS Excel – Advanced Level - Data analysis
• Free MS Excel e-learning demo

To sign up, simply fill out the short registration form.

Go to form