Data management

• 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 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

Cooperation with databases

• Microsoft Query
• Getting data from Oracle, SQLServer, MS Access

Macros

• Displaying the Developer tab
• Review and purpose of macros
• Where to save macros
• Absolute and relative record
• Running macros: assigning to quick access toolbar, shapes, pictures and keyboard shortcuts

Absolutely. An advanced Excel course is useful for professionals who want to save time, improve accuracy, and master data management.

You will learn how to:

• build smart spreadsheets,
• automate tasks with macros,
• create advanced pivot reports.

These skills are highly valued by employers.

Advanced Excel is challenging only if you try to learn it alone. This course was created by trainer with years of practical experience. It combines expert-led lectures and real business case exercises. 

⚠️ If you are unsure if the level is right for you, we have created free Excel skills assessment. Complete it and find the best starting point.

To register, simply fill out the short registration form.

Go to form

• Visual Basic for Applications in Microsoft Excel- basic level
• VBA in MS Excel - Intermediate Level
• Visual Basic for Applications in MS Excel - advanced level. Databases in Excel spreadsheet
• VBA in MS Excel - Data analysis