Excel Views and Layout
The eLearning course aims to enhance your proficiency in using various views and layout options 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 3 hours.
The primary objective of this course is to equip you with the necessary knowledge and skills to utilize Excel views, import and export files, insert hyperlinks, manage workbook properties, add headers, utilize Page Setup options, and utilize the Print Preview feature.
Learning Objectives
- Excel Views
- Custom Views
- Importing, Forms and Exporting
- Working with Hyperlinks
- Workbook Properties
- Headers, Previewing and Page Setup
- Print Place
Microsoft Excel Courses
Introduction and Basics
This course covers topics included in the Microsoft Office Specialist (MOS) exam 77-727. You will learn how to open workbooks, navigate directly to cells and between worksheets.
Cells and Worksheets
This course covers topics included in the Microsoft Office Specialist (MOS) exam 77-727. You will learn cell selection techniques, how to move and copy data, add and remove cells.
Views and Layout
This course covers topics included in the Microsoft Office Specialist (MOS) exam 77-727. You will learn how to use Excel views, and import and export files.
Formatting and Proofing
This course covers topics included in the Microsoft Office Specialist (MOS) exam 77-727. You will use AutoFill and Paste options, modify and group worksheets, insert rows and columns apply styles, and format worksheets.
Formulas and Functions
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.
Presenting Data Visually
This course covers topics included in the Microsoft Office Specialist (MOS) exam 77-727. You will create charts, move charts and add illustrations using Pictures, WordArt, SmartArt, and ClipArt.
Sharing and Validating Data
This course covers topics included in the Microsoft Office Specialist (MOS) exam 77-727. You will learn how to add comments and share workbooks.
Advanced Charting and Data Analysis
This course covers topics included in the MOS Expert exam 77-728. This includes using Advanced Chart features, PivotTables and PivotCharts.
Advanced Formulas, Macros and External Data
This course covers topics included in the MOS Expert exam 77-728. This includes custom templates, data formats and Internationalizing workbooks.
Advanced Functions, Consolidating and Auditing
This course covers topics included in the MOS Expert exam 77-728. This includes using Logical, Informational, Time, Mathematical and Lookup Functions.