Global eTraining Logo

Global eTraining – GeT Everything Library
including Microsoft Excel

Microsoft Excel Complete Guide provides extensive, thorough training of Excel, covering introductory through advanced topics.

Contact Us Buy Online

Microsoft Excel: The Complete Guide

Sign up for Global eTraining’s “Get Everything” library and get access to all their courses including Microsoft Excel.

Microsoft Excel Complete Guide provides extensive, thorough training of 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 Pivot Tables 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.

To get the most out of this course, we strongly recommend you review every topic .within the course and take advantage of the different tools and activities to help to ensure you retain the important information within. We also encourage you to take all the progress tests to ensure you have retained the knowledge, and most importantly practice with the hundreds of real-world, Let Me Try examples.

Course Outline:

  1. Exploring Excel
    • Exploring Excel
    • Exploring The Excel Program Window
    • Entering Data In Excel
    • Working With Numbers And Save Concepts
  2. 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
  3. Appearances of Worksheets
    • Exploring the Many Views Of Excel
    • Editing Workbook Properties and Managing Worksheets
    • Copying/Hiding Worksheets, and Modifying Columns/Rows
  4. Formulas and Functions
    • Working With Formulas and Functions
  5. Formatting Cell Contents
    • Formatting Worksheets
    • Text Control Options and Formatting Numbers
    • Format Cells Dialog Box
  6. 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
  7. 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
  8. 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
  9. 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
  10. Utilizing Graphics and Templates
    • Using Illustrations & Inserting Pictures and Clip Art
    • Getting Into Shapes
    • Illustrating with SmartArt and WordArt
    • Using and Customizing Templates
  11. Using LOOKUP Functions, PivotTables, and Macros
    • Introducing Lookup Functions
    • Creating PivotTables
    • Creating PivotCharts and Macro Security
    • Recording, Running and Assigning Macros
  12. 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
  13. Collaborating in Excel
    • Creating Folders in Excel
    • Inserting, Viewing, Positioning and Sizing a Comment
    • Creating Hyperlinks
    • Protecting Workbooks and Worksheets
    • Creating Digital Signatures
  14. 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
  15. Integrating Excel with Other Programs
    • Maintaining Compatibility
    • Converting Workbooks
    • Merging with other MS Programs
    • Importing External Data
    • Saving Workbook Elements as a Webpage
Global eTraining Logo

Next Steps

If you have any questions about this course or any other Global eTraining offering please contact us.