Course Excel 4 - Expert
The MS Excel - Expert course is intended for advanced MS Excel users who want to expand their knowledge with useful tricks and thus increase the effectiveness of their work.
Minimum input knowledge
Advanced work with MS Excel - nested functions, working with extensive tables, conditional formatting, pivot tables, etc.
Course dates Excel 4 - Expert
Daily courses (2 days): 09:00 - 15:00
Course price: 250.00 / 307.50 EUR
without VAT / incl. VAT
Training syllabus Excel 4 - Expert
Databases and Tables
- advanced filter options, when to use database functions options for setting data validation and suitable use of functions intended for searching in tables
Use of Logical Values and Operations with Them
- use of the find and select operation use of the text to columns operation
Grouping Rows and Columns
Useful Use of Conditional Formatting
Use of OFFSET, COLUMN, ROW, RANK Functions
Pivot Tables
- advanced settings of row, column and value fields options and limitations of calculated fields and items, pivot charts
Security
- options for workbook and sheet settings, use of the VeryHidden sheet property
Inserting and Working with Form Objects in a Sheet, Their Use
Useful Keyboard Shortcuts
Automated Work Using Macro Recording
- discussion
Recommended courses after completing Excel 4 - Expert
Show all courses from category Excel courses
Contact us
If you need a custom date, group training, or help choosing the right course, contact Macrosoft directly. We will help you with the next step.
Need more details?
Open the contact page for a full enquiry flow, company billing details, and directions to the training centre.
Course Reviews Excel 4 - Expert
Average rating