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 (9)
Trainer flexibility. Comprehensive answers to every question.
Krystyna Szpala - Sogecap SA Branch in Poland
Course - Visual Basic for Applications (VBA) for Analysts
Machine Translated
'Fun facts' - how to achieve the same the other way around.
Paulina - Noble Drilling Poland
Course - Microsoft Office Excel - poziom średnio zaawansowany
I liked the large number of tasks and the friendly atmosphere.
Paulina - LKQ Polska Sp. z o. o.
Course - Excel Data Analysis
Machine Translated
Trainer's knowledge and experience.
Paweł Dykowski - LKQ Polska Sp. z o. o.
Course - Excel Modelling
Great pace during the training. very knowledgeable and teaching style
James - Gilead Sciences Ireland
Course - Excel to Power BI
Working on and using our own data/spreadsheets, where we could see how it would benefit us most.
Julie - Environment, Marine and Fisheries
Course - Excel VBA Introduction
Knowledge, substantive content, contact with others, willingness to help even with trivial problems, ability to interest listeners.
Michał
Course - Python for Excel
Machine Translated
Presentation of loads of details and possibilities that the application offers and the ways they can be used for. A lot of examples. Great knowleedge of the trainer.
Ewa - GP Strategies Poland sp. z o.o.
Course - Microsoft Office Visio – Creating Charts and Diagrams
I liked that we were able to go off topic and work on specific features that were most fit in with what we are trying to accomplish. Even some things not directly related to the course material but can be built on utilizing course content.