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 (10)
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
I learned new things so that is a good point
Daria - LKQ Polska Sp. z o. o.
Course - Analysing Financial Data in Excel
Lecturer's openness
Natalia - Noble Drilling Poland
Course - Microsoft Office Excel - poziom średnio zaawansowany
Machine Translated
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
I like the hands on training and seeing us solve for issues on the spot.
Jon Matrille - LocumTenens.com
Course - Visual Basic for Applications (VBA) in Excel - Advanced
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
Reliable preparation of the trainer for training. Interesting examples.
Sandra - LKQ Polska Sp. z o. o.
Course - Excel Data Analysis
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