TRAINING SERIES OVERVIEW
Duration: ~14:50 hours online training
In today's data driven world, Microsoft® Excel plays a crucial role in using and analyzing data in numerous ways. The concepts of slicing and dicing the data to come up with "What if" analysis can be done using Microsoft Excel in both basic and advanced ways. This series will introduce Microsoft® Excel in three parts both for personal productivity and professional benefit.As a bonus, we will also introduce Microsoft 2019 essentials covering Excel, Word, PowerPoint, Outlook, and Access.
COURSE OVERVIEW
Microsoft Office 2019 New Features
Duration: ~2:46 hours online training
This course will introduce students to the new features in Microsoft Office 2019, including updates to Word, Excel, PowerPoint, Outlook, and Access.
- Course 01 - Word
- Course 02 - Excel
- Course 03 - PowerPoint
- Course 04 - Outlook
- Course 05 - Access
Microsoft Excel 2019 - Part 1
Duration: ~4:22 hours online training
This course will introduce students to Microsoft Office Excel 2019, and teach students about performing calculations, modifying a worksheet, formatting a worksheet, printing workbooks, managing workbooks, adding borders and colors to worksheets, and basic Excel customization.
- Chapter 1 - Getting Started with Microsoft Office Excel 2019
- Chapter 2 - Performing Calculations
- Chapter 3 - Modifying a Worksheet
- Chapter 4 - Formatting a Worksheet
- Chapter 5 - Printing Workbooks
- Chapter 6 - Managing Workbooks
- Chapter 7 - Adding Borders and Colors to Worksheets
- Chapter 8 - Basic Excel Customization
Microsoft Excel 2019 - Part 2
Duration: ~4:22 hours online training
This course will teach students about working with functions, working with lists, analyzing data, visualizing data with charts, using PivotTables and PivotCharts, working with graphical objects, and using array formulas.
- Chapter 1 - Working with Functions
- Chapter 2 - Working with Lists
- Chapter 3 - Analyzing Data
- Chapter 4 - Visualizing Data with Charts
- Chapter 5 - Using PivotTables and PivotCharts
- Chapter 6 - Working with Graphical Objects
- Chapter 7 - Using Array Formulas
Microsoft Excel 2019 - Part 3
Duration: ~4:22 hours online training
This course will teach students about working with multiple worksheets and workbooks, sharing and protecting workbooks, automating workbook functionality, using Lookup functions and formula auditing, forecasting data, creating sparklines and mapping data, importing and exporting data, internationalizing workbooks, working with Power Pivot, advanced customization options, and working with forms and controls.
- Chapter 1 - Working with Multiple Worksheets and Workbooks
- Chapter 2 - Sharing and Protecting Workbooks
- Chapter 3 - Automating Workbook Functionality
- Chapter 4 - Using Lookup Functions and Formula Auditing
- Chapter 5 - Forecasting Data
- Chapter 6 - Creating Sparklines and Mapping Data
- Chapter 7 - Importing and Exporting Data
- Chapter 8 - Internationalizing Workbooks
- Chapter 9 - Working with Power Pivot
- Chapter 10 - Advanced Customization Options
- Chapter 11 - Working with Forms and Controls
COMPLETION CERTIFICATE
In order to receive the completion certificate, learners must have completed reviewing all the modules and have successfully passed the training mockup exam.
Microsoft® Excel 2019 PowerPack
All course contents are carefully created and presented by experienced professionals. These courses
- Are Self-Paced Learning modules
- Comprises of Computer-Based Training
- Includes 360-day Access from the day access is granted to you