Microsoft Excel advanced

The course is aimed at intermediate users who will be expected to exploit the advanced features of Excel, from the use of more specialised functions, to database management, data analysis techniques and the use of plug-ins and macros.

Excel Intermediate Overview
Accessing data from other workbooks

• Link to data in other workbooks
• Creating and updating attachments
• Loading data using the PowerQuery tool

Database management basics

• Data tables in the worksheet
• Controlling data entry with data validation
• Editing data
• Sort records in ascending, descending order, and by special criteria
• Using the Filter
• Advanced filtering (complex filtering conditions, copying filtered data, filtering by calculated condition)

Display

• Creating, editing and formatting a statement
• Updating the statement
• Using the Slicer
• Using the Timeline
• Creating a data model, creating and editing table relationships
• Creating a statement from multiple tables: data model

Display diagram

• Relationship between the statement chart and the statement table
• Creating, editing and formatting a statement chart
• Creating a statement chart without a statement table
• Dashboard creation basics

Calculations with database data

• Using database management functions
• DATA EXPLANATION.DATA (GETPIVOTDATA) function
• three-dimensional functions

Data analysis

• Target value search (What-If Analysis)
• Using a Data table
• Analyses with the Case Examiner
• Making a Forecast

Excel data protection

• Protecting worksheet and cells
• Protecting the structure of the workbook
• Protecting Excel files
• Sharing workbooks
• Easy sharing (Share)

To participate in the course, you must have successfully completed our Microsoft Excel intermediate training or have equivalent practical experience.