Course Excel Professional
The Excel Professional course is intended for all interested participants who want to learn to use Microsoft Excel at a professional level. The promotional package consists of the following courses: Excel 2 - intermediate, Excel 3 - advanced, Excel PowerPivot and PowerQuery.
Minimum input knowledge
Basics of working with a computer and basics of Microsoft Excel.
Course dates Excel Professional
Daily courses (6 days): 09:00 - 15:00
Course price: 616.00 / 757.68 EUR
without VAT / incl. VAT
This course can be completed free of charge within the support program for ZoZ employed applicants.
If you are interested in attending the course free of charge, you can find more information at the following link:
The manual is included in the training price.
Training syllabus Excel Professional
Review and Summary of Excel Basics
Excel User Interface
- moving around a worksheet and working with sheets, selecting a continuous and non-contiguous cell range, selecting a table cell formatting format settings, creating a custom format conditional formatting combining multiple conditions
Writing Formulas in MS Excel
- inserting formulas into cells, copying formulas AutoComplete function structured references difference between relative and absolute cell reference
Basics of Working with Functions, Function Syntax, Nesting Functions in MS Excel
- automatic functions: sum, average, minimum, maximum, count function categories, different ways of inserting a function - their advantages and disadvantages overview and examples of the most frequently used mathematical, statistical, time, logical and lookup functions
Sorting, Filtering and Summaries in Microsoft Excel
- tool for sorting data in a table automatic filter: custom automatic filter, use of wildcard characters in text criteria simple summaries (subtotals) and their use in practice
Conditional Calculations and Logical Functions
- IF, nesting IF, AND, OR, SUMIF, COUNTIF
Lookup Functions
- HLOOKUP and VLOOKUP
Array Formulas
- their use, one-dimensional and two-dimensional arrays Excel lookup functions LOOKUP, VLOOKUP, HLOOKUP, CHOOSE, MATCH, INDEX Logical functions IF, nesting IF, AND, OR Text functions CONCATENATE, FIND, SEARCH, LEFT, RIGHT, MID, SUBSTITUTE Working with automatic and advanced filter limitations of automatic filter entering complicated filtering conditions use of wildcard characters in text criteria
Summaries, Subtotals
- creating simple and nested summaries tool for merging multiple ranges
Working with Pivot Tables
- working with row, column, page fields and data area setting properties of a table field and also properties of the whole table multiple consolidation ranges calculated field, grouping
Goal Seek Function and Its Use
- working with the SOLVER add-in: optimization tasks entering conditions
POWERPIVOT
- Getting familiar with the editor for data modeling Data model Loading data into the Model Processing and editing database data import from various file types Linking tables and creating relationships Alternatives of outputs to Microsoft Excel from the Data Model Measures and creating calculated fields Key performance indicators Hierarchy and groups Slicers
POWERQUERY
- Basic structure and philosophy of the Power Query tool versus Power Pivot Working with the Power Query editor Import and loading of various types of data files Editing and transformation of data Queries Column management and reduction of records in loaded databases Database cleaning Data transformation and working with fields of type: Text, Number, Date Merging and appending queries Rules for working with the M language Export of data to Microsoft Excel Loading data directly Loading data into the Data Model Creating links DAX LANGUAGE Language syntax Basic functions (SUM vs SUMX) CALCULATE RELATED and RELATEDTABLE DISTINCTCOUNT Practical use of other DAX functions INDEX and MATCH INDIRECT and ADDRESS
Date Functions
- TODAY, NOW, DATE, YEAR, MONTH DAY, DATEDIF, NETWORKDAYS
Text Functions
- CODE, CHAR, TEXT, FIND, LEN LEFT, RIGHT, MID, SEARCH REPLACE, SUBSTITUTE, REPT, CONCATENATE
Financial Functions
- FV, PV, PMT, RATE, NPER
Information Functions
- INFO, ISNUMBER, ISERROR etc.
Goal Seek Function and Its Use
- working with the SOLVER add-in optimization tasks entering conditions
Creating Charts in MS Excel
- use of the wizard, chart types correct setting of source data chart options, setting and changing chart location setting the format of different chart areas pivot chart
Printing
- page layout page setup, margins creating document header and footer selecting print area saving data to PDF and XPS format
Templates in Microsoft Excel
- working with a template - creating and using it discussion conclusion
Output knowledge
Mastering the use of Excel as a comprehensive tool for independent planning, decision-making and evaluation. Creating professional applications intended for automatic data processing, including control mechanisms.
Recommended courses after completing Excel Professional
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 Professional
Average rating