Course Excel 3 - Advanced
The Excel for Advanced Users course is intended for all interested participants who have experience with the Excel spreadsheet processor and want to supplement or enrich themselves with new possibilities.
Minimum input knowledge
Experience with Excel: setting cell format, copying content and format, absolute and relative references, working with functions, filtering and sorting in a table, creating charts, print output settings. Experience with Excel is also sufficient.
Course dates Excel 3 - Advanced
Daily courses (2 days): 09:00 - 15:00
Evening courses (3 days): 16:30 - 19:00
Weekend courses (2 days): 09:00 - 15:00
Course price: 200.00 / 246.00 EUR
without VAT / incl. VAT
The manual is included in the training price.
Training syllabus Excel 3 - Advanced
New Features in MS Excel and Main Differences Compared with a Lower Version of Excel
- Review of working with formulas and functions in Excel, function syntax, nesting functions
- Creating forms, controls and their connection with a cell
- Options for protecting cells, a sheet and locking a file with a password
- Naming a range, use in formulas and functions
- Referencing cells in other sheets and files
Freezing Panes
Logical Functions
IF, IFS, AND, OR
Lookup Functions
XLOOKUP, CHOOSE, XMATCH, INDEX
Mathematical and Statistical Functions
SUMIF, COUNTIF
Text Functions
- CONCAT, FIND, SEARCH, LEFT, RIGHT, MID, SUBSTITUTE, TEXTBEFORE, TEXTAFTER
Array Formulas
- Arrays and their use in formulas and functions
Dynamic Arrays - RANDARRAY, UNIQUE, SORT, FILTER Functions
Working with the Advanced Filter
- Limitations of the automatic filter, entering complicated filtering conditions, use of wildcard characters in text criteria
Summaries, Subtotals
Creating Simple and Nested Subtotals
Working with Pivot Tables
- Pivot table options, calculated field, grouping, sorting
- Slicer, timeline
Referencing Pivot Table Cells
Working with the Solver Add-In
Activating the Add-In, Optimization Tasks, Entering Constraints
Discussion
Output knowledge
Mastering the use of Excel as a comprehensive tool. After completing the course, graduates will be able to create and process complex projects at a professional level, including control mechanisms. The course will also help them automate routine tasks.
Recommended courses after completing Excel 3 - Advanced
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 3 - Advanced
Average rating