Excel Formulas and Functions
Seat time: 3 hours
About the course: This course covers topics included in the Microsoft Office Specialist (MOS) exam 77-727. You will learn how to use formulas and functions in Excel including Informational, Logical, Financial, Text functions, data tables and using named ranges.
Learning Objectives
- Formulas and Referencing
- Working with Functions
- Logical and Informational Functions
- Named Ranges
- Financial Functions and Data Tables
- Text Functions
Microsoft Excel Courses
Excel Level 1 Introduction and Basics
Learning Objectives:
- Screen Components
- Navigating Workbooks
- Viewing Tools and Excel Options
- Creating Workbooks
- Opening, Saving and Closing
Excel Level 2 Cells and Worksheets
Learning Objectives:
- Cell Selection Techniques
- Moving and Copying Data
- Adding and Removing Cells
- Searching and Sorting Data
- Cell Formatting
- Using Multiple Worksheets
Excel Level 3 Views and Layout
Learning Objectives:
- Excel Views
- Custom Views
- Importing, Forms and Exporting
- Working with Hyperlinks
- Workbook Properties
- Headers, Previewing and Page Setup
- Print Place
Excel Level 4 Formatting and Proofing
Learning Objectives:
- AutoFill and Paste Options
- Modifying Worksheets
- Cell and Table Styles
- Formatting Worksheets
- Applying Themes
- Proofing Tools
- Flash Fill and Macros
Excel Level 5 Formulas and Functions
Learning Objectives:
- Formulas and Referencing
- Working with Functions
- Logical and Informational Functions
- More Logical Functions
- Named Ranges
- Financial Functions and Data Tables
- Text Functions
Excel Level 6 Presenting Data Visually
Learning Objectives:
- Creating and Modifying Charts
- Adding Illustrations
- Shapes, ClipArt and Sparklines
- Outlining Worksheets
Excel Level 7 Sharing and Validating Data
Learning Objectives:
- Using Comments
- Sharing Workbooks
- Sorting and Filtering Data
- Custom and Conditional Formats
- Validating Data
Excel Expert Advanced Charting and Data Analysis
Learning Objectives:
- Trendlines and Sparklines
- Dual Axes and Chart Templates
- PivotTables
- Working with PivotTables
- PivotCharts
- Slicers
- Data Analysis Tools
Excel Expert Advanced Formulas, Macros and External Data
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
Excel Expert Advanced Functions, Consolidating and Auditing
Learning Objectives:
- Logical and Informational Functions
- Time and Mathematical Functions
- Lookup Functions
- Consolidating Workbooks
- Auditing Tools
- Protecting Workbooks
- Sharing Workbooks