Microsoft Excel for Experts
This training is intended for experienced Microsoft Excel users who want to improve their knowledge by learning more in-depth data analysis tools, multiple argument, dynamic array functions, Power Query, and other tools from the wide range of Microsoft Excel functionality.
EU co-financing of 50-70% is available to companies.
The total cost of tuition may vary depending on the rules of the specific association.
Aleksandrs Vosekalns
Raitis Uščins
Plans
Contact us
Apply or ask a question!
If you want to apply for the course or ask a question about it, feel free to use this form. |
||||||||||||
|
||||||||||||
Course target
Develop an in-depth understanding of Microsoft Excel data processing and analysis tools with the aim of teaching you how to work in depth with more complex dynamic array functions, Power Query, the data model, as well as being up to date with other expert-level functionality.
Audience
Experienced Microsoft Excel users who want to improve their knowledge of working with more complex functions, data analysis, and visualization capabilities.
At Course Completion you will be able to
- Use multiple argument functions in data calculations and combine them with each other.
- Use dynamic array functions in data analysis and report creation.
- Obtain and process information from external data sources using the extensive capabilities of Power Query.
Prerequisites
- Computer skills.
- Proficient knowledge of Microsoft Excel.
- Microsoft Excel 365 application support.
Training materials
Training materials and practical examples prepared by BDA.
Certification Exam
Not intended.
Course outline
DYNAMIC ARRAYS
Dynamic Array Functions:
- FILTER;
- SORT/BY;
- UNIQUE;
- SEQUENCE;
- RANDARRAY;
- XLOOKUP.
Using Dynamic Arrays in Excel
- Data Validation Tool;
- Dependence of Data Validation on Other Data Validation;
- Data Visualization Using Conditional Formatting;
- Dynamic Charts with Defined Areas.
Practical Work
Data Extraction and Processing from External Data Sources Using Power Query: From Other Workbooks, Folders, and From a Website.
Data Processing with Power Pivot (Creating a Data Model and Using DAX Formulas).
If you want to get more information about this course, please contact us by phone +371 67505091 or send an e-mail at mrn@bda.lv.
