Course Outline
1 - WORKING WITH MULTIPLE WORKSHEETS AND WORKBOOKS
- Topic A: Use Links and External References
- Topic B: Use 3-D References
- Topic C: Consolidate Data
2 - SHARING AND PROTECTING WORKBOOKS
- Topic A: Collaborate on a Workbook
- Topic B: Protect Worksheets and Workbooks
3 - AUTOMATING WORKBOOK FUNCTIONALITY
- Topic A: Apply Data Validation
- Topic B: Search for Invalid Data and Formulas with Errors
- Topic C: Work with Macros
4 - USING LOOKUP FUNCTIONS AND FORMULA AUDITING
- Topic A: Use Lookup Functions
- Topic B: Trace Cells
- Topic C: Watch and Evaluate Formulas
5 - FORECASTING DATA
- Topic A: Determine Potential Outcomes Using Data Tables
- Topic B: Determine Potential Outcomes Using Scenarios
- Topic C: Use the Goal Seek Feature
- Topic D: Forecast Data Trends
6 - CREATING SPARKLINES AND MAPPING DATA
- Topic A: Create Sparklines
- Topic B: Map Data
Requirements
To ensure success, students should have practical, real-world experience creating and analyzing datasets using Excel 2019. Specific tasks students should be able to perform include: creating formulas and using Excel functions; creating, sorting, and filtering datasets and tables; presenting data by using basic charts; creating and working with PivotTables, slicers, and PivotCharts; and customizing the Excel environment. To meet these prerequisites, students can take the following courses, or should possess the equivalent skill level:
Microsoft® Office Excel® 2019: Basic
Microsoft® Office Excel® 2019: Intermediate
Testimonials
Examples of improvements
Python for Excel Course
Access to efficient VMs, showing Flask in an accessible way
Python for Excel Course
This is probably the first training in which the trainer constantly showed potential problems when starting to write code and taught how to deal with them. These meaningless errors discouraged me from learning programming in Python on my own. Now I feel like I have a much stronger foundation for exploring new ideas :)
Python for Excel Course
many exercises
Julia - Angelika Czapka, LKQ Polska Sp. z o. o.
Analysing Financial Data in Excel Course
can use in the work
Sebastian, 弗马斯精密锻件(大连)有限公司
Excel Basics Course
some new functions i did knew before, such as power query; fomat cell -alignment-fill
Bella - Sebastian, 弗马斯精密锻件(大连)有限公司
Excel Basics Course
new facts
Angelika Czapka, LKQ Polska Sp. z o. o.
Excel Modelling Course
learned new things
Daria Pawlak - Angelika Czapka, LKQ Polska Sp. z o. o.
Excel Modelling Course
Practical tips
Angelika Czapka, LKQ Polska Sp. z o. o.
Excel Modelling Course
I learned new skills and information
fatma AlKetbi - Dubai Government Human Resources
Excel 2019 - Intermediate Course
The trainer was informative and has a smooth and easy way of teaching
Gihan El Shafei - Dubai Government Human Resources
Excel 2019 - Intermediate Course
Trainers are very knowledgeable and patient in ensuring students could follow the lecture.
Trudy Staples Girardin - Indigenous Services Canada
Excel to Power BI Course
I learned so much about Power BI, the trainers were patient and very knowledgeable.
Krystina Merkley - Indigenous Services Canada
Excel to Power BI Course
One hands-on exercise that is super relevant to work.
Fannie Mae
R Programming for Excel Course
The applicability of the content
EPFL HBP PCO
Analysing Financial Data in Excel Course
The tips for many of the functions that the trainer presented, which we can easily remember and implement in our future work
Emilija Stoilova - EPFL HBP PCO
Analysing Financial Data in Excel Course
Patience of Costas, adaptability to our various knowledge levels and work requirements. Possibility to ask questions.
Beatrice PLATEAU - Ameropa
Excel to Power BI Course
The guy was really helpful and knowledgeable and i really learned a lot in two days.
Francesca Maggiolo - Bettzeit GmbH
Excel Basics Course
Examples from different area of VBA programing.
UBS Business Solutions Poland Sp. z o.o.
Visual Basic for Applications (VBA) in Excel - Advanced Course
The instructors knowlege
US Bank
Visual Basic for Applications (VBA) in Excel - Advanced Course
Content and the way it was provided.
Marcin Samborski
Visual Basic for Applications (VBA) in Excel - Advanced Course
short excersises
Mateusz Podsiadlo
Visual Basic for Applications (VBA) in Excel - Introduction to programming Course
Training agenda was well thought out
Przemek Zalasinski
Visual Basic for Applications (VBA) in Excel - Introduction to programming Course
Kamil was exceptionally patient and very helpful in figuring out solutions to real needs. He was also very honest about if he didn't know something from the top of his head, which enabled us to quickly jump on in the training and we didn't lose time.
Christine Weiler
VBA For Access & Excel Course
The explanation way and including tips on the best practices in VBA/Access, encouraging via exercise to think more by ourselves on how to solve the problem rather than giving ready solutions
Daria Rudin
VBA For Access & Excel Course
examples and the way he explained