Microsoft Excel for Experts
The training is intended for those who are familiar with the basic functionality of Microsoft Excel 365 and want to expand their knowledge of data processing, analysis, and visualization capabilities in the modern Excel 365 environment.
The course, its program, and materials have been developed by BDA.
EU co-financing of 50-100% 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. |
||||||||||||||||
|
||||||||||||||||
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
Improve knowledge and skills in working with MS Excel 365 data analysis tools, using filtering, selecting by specific criteria, and creating PivotTables.
Audience
Experienced Microsoft Excel 365 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:
- Give a name to a cell range and use it in formulas and functions.
- Work with functions and perform calculations independently.
- Audit formulas – examine the values associated with them, correct them if necessary.
- Design a workbook, visualize various data.
- Select data using filters.
- Combine data from multiple worksheets into one worksheet.
- Organize data by calculating subtotals.
- Create and edit pivot tables.
- Create charts and use their properties for more accurate data display.
- Protect a workbook, worksheet, or range with a password.
Prerequisites
- Computer skills.
- Proficient knowledge of Microsoft Excel 365.
- 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.
