Microsoft Excel 2013 Level 3

This course provides more complex skills than those presented in our Level 1 and Level 2 courses, but with the same proven instructional design.

Advanced

English

Course Length: 19 Hours

Back to Course List

What you'll learn

Using LOOKUP Functions, PivotTables, and Macros
Using Advanced Formatting and Analysis Tools
Collaborating in Excel

Sharing Workbooks
Integrating Excel with Other Programs

Course Description

Microsoft Excel 2013 Level 3 course provides thorough advanced training in Excel 2013. This course provides more complex skills than those presented in our Level 1 and Level 2 courses, but with the same proven instructional design.

This is an advanced course that will challenge students. 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.

Course Outline

Excel 2013 Level 3 Course Outline

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

Recommended Supported Browsers: Internet Explorer 10, Internet Explorer 9, Firefox, Chrome, Maxthon, iOS (iPad 2 and 3), Opera and Safari.

We recommend that you use the most current version of these browsers. Other browsers and some earlier versions of these browsers may be supported – but you may experience some limitations on certain Learning Management System or course functions.

Ready to
GeT Started Today!

$14.99 / month or $180 / year

Includes all access to the Global eTraining
‘GeT Everything’ course library.
(see all courses)

Subscribe Now