Microsoft Excel

Microsoft Excel The Complete Guide provides extensive, thorough training in Excel. This course covers introductory through advanced topics and is ideal for the computer user who wants to become well versed in using Excel. Topics introduced in Unit 1 include the Ribbon interface; entering and editing data; selecting cells and ranges; printing worksheets; creating formulas and functions; formatting cell contents; inserting and deleting columns, rows, and cells; charts; and more. Unit 2 covers such topics as large worksheets and workbooks; tables; outlines; inserting clip art, pictures and SmartArt; templates; digital signatures; and more. In Unit 3, students are introduced to PivotTables and macros, financial functions, data analysis, auditing, and additional functions, advanced formatting and analysis tools, collaboration, and more.

The Microsoft Office Complete Guide series has been designed from the ground up for Global eTraining’s world-leading, online, on-demand GeT Interactive eTraining platform. With text from internationally recognized content matter experts, professional narration, video demonstrations by leading instructors, and Let Me Try exercises for users to get practical experience with the software, using downloadable datasets aligned with the presentation content.

User’s prerequisites

You don’t need any previous experience with Microsoft Excel to take this course.

GeT Started Today

GeT Everything for $499 / Year
(Limited Time Pricing)

Book a Demo Meeting

And receive a custom quote

Course Outline

Exploring Excel
Exploring Excel
Exploring The Excel Program Window
Entering Data In Excel
Working With Numbers And Save Concepts

Editing Worksheets
Opening Workbooks and Editing Entries
Selecting Cells and Ranges. and Cut. Copy, and Paste
Undo and Redo, and Clearing Cell Contents and Formats
Using AutoFeatures
Using AutoCorrect

Appearances of Worksheets
Exploring the Many Views Of Excel
Editing Workbook Properties and Managing Worksheets
Copying/Hiding Worksheets, and Modifying Columns/Rows

Formulas and Functions
Working With Formulas and Functions

Formatting Cell Contents
Formatting Worksheets
Text Control Options and Formatting Numbers
Format Cells Dialog Box

Charting Worksheet Data
Creating Charts
Moving & Sizing Embedded Charts
Exploring and Modifying Charts
Applying Layouts
Trendlines, Sparklines & Printing

Formatting Cell Contents, Advanced Skills
Working with the Format Painter and Quick Styles
Formatting with Themes
Inserting Date Functions and Formatting
Creating Custom Formats and Working with Conditional Formatting
Naming Cells and Ranges

Managing Multiple-Sheet Workbooks
Sorting Worksheet Data
Using Flexible Worksheet Views
Printing Multipage Worksheets
Using Multiple Worksheets & Linking Cells and Formulas
Using 3-D Cell References in Formulas
Copying Worksheets
Printing Multiple-Sheet Workbooks

Applying Advanced Functions and Data Analysis
Creating Formulas Using Criteria IF Functions
Using Logical Functions in Formulas
Using Functions to Format Text
Creating Financial Functions
Using Data Analysis Tools

Creating Tables and Outlines
Creating a Table
Working with Tables
Structured References & Enhanced Sorting and Filtering
Using SUBTOTAL and Quick Analysis
Using the Outline Feature and Displaying Subtotals

Utilizing Graphics and Templates
Using Illustrations & Inserting Pictures and Clip Art
Getting Into Shapes
Illustrating with SmartArt and WordArt
Using and Customizing Templates

Using LOOKUP Functions, PivotTables, and Macros
Introducing Lookup Functions
Creating PivotTables
Creating PivotCharts and Macro Security
Recording, Running and Assigning Macros

Using Advanced Formatting and Analysis Tools
Working with Grouped Worksheets
Consolidating Worksheet Data
Working with Data Validation
Circling Invalid Data
Removing Duplicate Records
Tracing Formulas
Auditing Formula Errors
Using Data Tables

Collaborating in Excel
Creating Folders in Excel
Inserting, Viewing, Positioning and Sizing a Comment
Creating Hyperlinks
Protecting Workbooks and Worksheets
Creating Digital Signatures

Sharing Workbooks
Preparing Workbooks for Distribution
Sharing Workbooks Without a Network
Tracking Changes to Workbooks
Merging Multiple Workbooks
Emailing a Workbook
Importing Data via a Web Query
Collaborating with SkyDrive and Office Web Apps

Integrating Excel with Other Programs
Maintaining Compatibility
Converting Workbooks
Merging with other MS Programs
Importing External Data
Saving Workbook Elements as a Webpage