Course Outline
1 - GETTING STARTED WITH EXCEL 2019
- Topic A: Navigate the Excel User Interface
- Topic B: Use Excel Commands
- Topic C: Create and Save a Basic Workbook
- Topic D: Enter Cell Data
- Topic E: Use Excel Help
2 - PERFORMING CALCULATIONS
- Topic A: Create Worksheet Formulas
- Topic B: Insert Functions
- Topic C: Reuse Formulas and Functions
3 - MODIFYING A WORKSHEET
- Topic A: Insert, Delete, and Adjust Cells, Columns, and Rows
- Topic B: Search for and Replace Data
- Topic C: Use Proofing and Research Tools
4 - FORMATTING A WORKSHEET
- Topic A: Apply Text Formats
- Topic B: Apply Number Formats
- Topic C: Align Cell Contents
- Topic D: Apply Styles and Themes
- Topic E: Apply Basic Conditional Formatting
- Topic F: Create and Use Templates
5 - PRINTING WORKBOOKS
- Topic A: Preview and Print a Workbook
- Topic B: Set Up the Page Layout
- Topic C: Configure Headers and Footers
6 - MANAGING WORKBOOKS
- Topic A: Manage Worksheets
- Topic B: Manage Workbook and Worksheet Views
- Topic C: Manage Workbook Properties
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