Course Outline
1 - GETTING STARTED WITH MICROSOFT OFFICE EXCEL 2016
- Learn Your Way Around the Excel Menu
- Understand and Apply Excel Formulas
- Create and Save a Basic Workbook
- Enter Data Into Cells
- Access Excel Help
2 - PERFORMING CALCULATIONS
- Build Custom Worksheet Formulas
- Insert Built-In Functions to Your Data
- Save and Reuse Formulas
3 - MODIFYING A WORKSHEET
- Insert, Delete and Resize Cells, Columns and Rows
- Search for and Replace Data
- Use Proofing and Research Tools
4 - FORMATTING A WORKSHEET
- Format Text and Numbers
- Align Cell Data
- Apply Styles, Themes and Basic and Conditional Formatting
- Create and Select Worksheet Templates
5 - PRINTING WORKBOOKS
- Preview and Print a Workbook
- Set Up the Page Layout
- Configure Headers and Footers
6 - MANAGING WORKBOOKS
- Manage Worksheets and Workbook Properties
- Create, Apply or Delete Workbook and Worksheet Views
Testimonials (5)
I was recently struggling with some pivot table issues and the course gave me the knowledge to work with pivot tables quicker, smarter and more efficiently.
Arina Moayed-Dzenisa - Universal-Investment-Gesellschaft mbH Branch Poland Sp. z o. o.
Course - Microsoft Office Excel - poziom średnio zaawansowany
examples and looking for solutions
Monika Leśniewska - Takenaka Europe GmbH Sp. z o.o. Oddział w Polsce
Course - Excel Data Analysis
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
Course - Analysing Financial Data in Excel
The guy was really helpful and knowledgeable and i really learned a lot in two days.
Francesca Maggiolo - Bettzeit GmbH
Course - Excel Basics
There was a good amount of information for the time of training. Also the trainer was very engaged with the group, especially when people were having troubles or asking questions. It was very nice of him to offer help in case of future ideas.