Microsoft Excel 2013 Level 2

This course covers more complex skills than those presented our Level 1 course, but with the same proven instructional design.

Intermediate
English
Course Length: 14 Hours

What you'll learn

  • Formatting Cell Contents, Advanced Skills
  • Managing Multiple-Sheet Workbooks
  • Applying Advanced Functions and Data Analysis
  • Creating Tables and Outlines
  • Utilizing Graphics and Templates

Course Description

Microsoft Excel 2013 Level 2 course provides thorough intermediate training of Excel 2013. This course covers more complex skills than those presented our Level 1 course, but with the same proven instructional design. Topics introduced include large worksheets and workbooks; tables; outlines; inserting clip art, pictures and SmartArt; templates; digital signatures; 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.

Course Outline

Excel 2013 Level 2 Course Outline

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

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