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 (11)
Tworzenie tabel i kalkulacja ich danych.
Katarzyna Ciunajcis
Course - Working with spreadsheet in Microsoft Excel
exhaustion of topics
Karol - VOLKSWAGEN POZNAŃ SP. Z O.O.
Course - Excel Advanced with VBA
Machine Translated
Showing examples, pictorial way of translating
Aneta - LKQ Polska Sp. z o. o.
Course - Visual Basic for Applications (VBA) in Excel (intermediate level)
Machine Translated
Very accurate translation, paying attention to what the students are doing. A wide range of issues related to the topic. Very useful training!
Magdalena - DataConsult S.A.
Course - Microsoft Office Excel - working effectively with the spreadsheet
Machine Translated
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 personally liked Roman's passion for excel, and explaining everything so everyone could understand especially since we all had different levels of excel knowledge.
Erica Naimit - Kneipp Corporation of America
Course - Excel in One Day
Interesting exercises
Kacper - LKQ Polska Sp. z o. o.
Course - Excel Advanced
I learned new things so that is a good point
Daria - LKQ Polska Sp. z o. o.
Course - Analysing Financial Data in Excel
perfect adaptation of materials to the group, detailed discussion of issues, very high competence, very good contact with the group, high ability to transfer knowledge,
Malgorzata - LKQ Polska Sp. z o. o.
Course - Excel Basics
Machine Translated
I liked the large number of tasks and the friendly atmosphere.
Paulina - LKQ Polska Sp. z o. o.
Course - Excel Data Analysis
Machine Translated