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

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)

OR

Start Your Free Trial

Training 5 or more people?

Give your team All Access to the
entire Global eTraining ‘GeT Everything’
course library.

Buy For My Team

This course includes:

  • Let Me Try Exercises
  • Dataset Files
  • Progress Quizzes and Exams
  • Help Desk Support

PLUS!

  • Full access to the entire Global eTraining ‘GeT Everything’ course library

'GeT Everything' For One Low Price!

All Courses for $14.99 per month or $180 annually

Start Your Free Trial Today!

Fill out the form below to access your free 7-Day trial of the ‘GeT Everything’ library.

  • Global eTraining uses the contact information you provide to us to contact you about our products and services. You may unsubscribe from these communications at anytime. For information on our privacy practices and commitment to protecting your privacy, check out our Privacy Policy