Excel Presenting Data Visually
The eLearning course focuses on enhancing your skills in presenting data effectively using visual elements in Microsoft Excel. The course covers topics that are included in the Microsoft Office Specialist (MOS) exam 77-727. The estimated seat time for this course is 2 hours.
The main objective of this course is to equip you with the necessary knowledge and skills to create charts, move and format charts, add illustrations such as pictures, WordArt, SmartArt, and ClipArt, utilize alternative text for accessibility, work with shapes and sparklines, and use outlining tools to organize and structure your data.
Learning Objectives
- Creating and Modifying Charts
- Adding Illustrations
- Shapes, ClipArt and Sparklines
- Outlining Worksheets
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