Excel Advanced Functions, Consolidating and Auditing
The eLearning course is designed to enhance your skills in using Microsoft Excel for advanced functions, consolidating data from multiple workbooks, auditing formulas, and managing workbook sharing and protection. The course has an estimated seat time of 3 hours, meaning it is designed to be completed within this duration.
The primary objective of this course is to prepare you for the Microsoft Office Specialist (MOS) Expert exam 77-728, which focuses on advanced Excel features. By taking this course, you will gain proficiency in using logical, informational, time, mathematical, and lookup functions, consolidating data from different workbooks, sharing and protecting workbooks, and utilizing auditing tools.
Learning Objectives
- Logical and Informational Functions
- Time and Mathematical Functions
- Lookup Functions
- Consolidating Workbooks
- Auditing Tools
- Protecting Workbooks
- Sharing Workbooks
Microsoft Excel Courses
Learning Objectives:
- Screen Components
- Navigating Workbooks
- Viewing Tools and Excel Options
- Creating Workbooks
- Opening, Saving and Closing
This course is delivered via eLearning. Delegates can complete the training in their own time. At checkout, please provide the delegate's full name.
Learning Objectives:
- Cell Selection Techniques
- Moving and Copying Data
- Adding and Removing Cells
- Searching and Sorting Data
- Cell Formatting
- Using Multiple Worksheets
This course is delivered via eLearning. Delegates can complete the training in their own time. At checkout, please provide the delegate's full name.
Learning Objectives:
- Excel Views
- Custom Views
- Importing, Forms and Exporting
- Working with Hyperlinks
- Workbook Properties
- Headers, Previewing and Page Setup
- Print Place
This course is delivered via eLearning. Delegates can complete the training in their own time. At checkout, please provide the delegate's full name.
Learning Objectives:
- AutoFill and Paste Options
- Modifying Worksheets
- Cell and Table Styles
- Formatting Worksheets
- Applying Themes
- Proofing Tools
- Flash Fill and Macros
This course is delivered via eLearning. Delegates can complete the training in their own time. At checkout, please provide the delegate's full name.
Learning Objectives:
- Formulas and Referencing
- Working with Functions
- Logical and Informational Functions
- More Logical Functions
- Named Ranges
- Financial Functions and Data Tables
- Text Functions
This course is delivered via eLearning. Delegates can complete the training in their own time. At checkout, please provide the delegate's full name.
Learning Objectives:
- Creating and Modifying Charts
- Adding Illustrations
- Shapes, ClipArt and Sparklines
- Outlining Worksheets
This course is delivered via eLearning. Delegates can complete the training in their own time. At checkout, please provide the delegate's full name.
Learning Objectives:
- Using Comments
- Sharing Workbooks
- Sorting and Filtering Data
- Custom and Conditional Formats
- Validating Data
This course is delivered via eLearning. Delegates can complete the training in their own time. At checkout, please provide the delegate's full name.
Learning Objectives:
- Logical and Informational Functions
- Time and Mathematical Functions
- Lookup Functions
- Consolidating Workbooks
- Auditing Tools
- Protecting Workbooks
- Sharing Workbooks
This course is delivered via eLearning. Delegates can complete the training in their own time. At checkout, please provide the delegate's full name.
Learning Objectives:
- Trendlines and Sparklines
- Dual Axes and Chart Templates
- PivotTables
- Working with PivotTables
- PivotCharts
- Slicers
- Data Analysis Tools
This course is delivered via eLearning. Delegates can complete the training in their own time. At checkout, please provide the delegate's full name.
Learning Objectives:
- Languages and Accessibility
- AutoSave and Templates
- Custom Formatting
- External Data and Queries
- Macros and Form Controls
- Evaluating Formulas and Watch Window
- MATCH and INDEX Function
This course is delivered via eLearning. Delegates can complete the training in their own time. At checkout, please provide the delegate's full name.
Unlimited access to full suite of courses for 1 year
- Hosted on a custom branded company LMS on our cloud based system
- Access via any device with internet access including phone, tablet and PC
*Minimum order of 25 learner passes required. All passes do not need to be allocated at once. Credits will sit on your account with unlimited expiry and will be allocated to users as requested. At point of allocation, all users will be given access to the full suite of 10 courses.
10 courses:
Excel 2019
Level 1 - Introduction and basics
Level 2 - Cells and worksheets
Level 3 - Views and layout
Level 4 - Formatting and proofing
Level 5 - Formulas and functions
Level 6 - Presenting data visually
Level 7 - Sharing and validating data
Expert - Adv. charting and data analysis
Expert - Adv. formulas, macros and external data
Expert - Adv. functions, consolidating and auditing