Effective Work with Microsoft Excel
This is a training for experienced Microsoft Excel users
You will get to know the new Microsoft Excel functions and learn about their application
You will learn about the best work practices with large amounts of data, dynamic arrays
You will discuss data visualization tools that are built into Microsoft Excel
Training Program:
Duration - 4 academic hours
Functions
- New built-in functions
Datasets
- Dynamic arrays
Data sources
- Data connection - scenarios
- Power Query Overview
The best practices of working with Pivot Tables
- Preparing data
- Pivot Tables in Excel and Power Pivot
- Images in Pivot Tables
Formatting and visualization
- Conditional formatting
- Custom formats - the best practices
- Visualization tools - sparklines, diagrams, diagrams in PowerPivot
- Dashboards in Excel
Overview of the newest tools
- Authorization tools
- AI in Excel
- Creating formulas with Excel Copilot
What will you get after completing this training?
We want you to be able to apply the knowledge from this training in practice right away
An official training course
completion certificate
completion certificate
All the reference materials in a PDF,
sent through an email
sent through an email
10% discount on any of our trainings
Tatyana Iostman
The author of the course, certified Microsoft trainer
The leading lecturer with over 20 years of experience, having educated over 10,000 participants. I specialize in business productivity, project management, programs, and portfolio management using traditional, hybrid, and Agile approaches. During my 10-year tenure at Microsoft, I focused on "Corporate Project Management" and "Modern Workplace" directions.
I have successfully executed projects in major manufacturing, financial, telecommunications, oil and gas companies, as well as in the public sector of Central and Eastern Europe and Central Asia.
I have successfully executed projects in major manufacturing, financial, telecommunications, oil and gas companies, as well as in the public sector of Central and Eastern Europe and Central Asia.
Share with your friends!
If you find this training useful, tell your friends about it!
Link to the training - http://planetaproject.com/excel_advanced_training_eng
Link to the training - http://planetaproject.com/excel_advanced_training_eng
Apply for this course and we will contact you to discuss the details
Please fill out the form fields
You agree to have your contact information registered so that we can contact you.
