Microsoft Excel 2013: Intermediate

Pre-Requisites: Basic Microsoft Excel ® 2013 skills.

5-stars

Key Features

  • Online live classroom available
  • Quality learning materials
  • Small Class Sizes
  • State of the Art Facility
  • Free Retakes
  • Instructor Led Classroom training
  • Certified Industry Experienced Teachers
  • 100% Job Placement assistance

This intermediate course teaches spreadsheet users about additional features available in Microsoft® Office Excel® 2010. Key topics include naming ranges, protecting worksheets, linking between worksheets, and charting.

This course is intended for students learning Microsoft Excel® 2013 Intermediate skills.

Managing workbooks and worksheets

  • Viewing large worksheets
  • Printing large worksheets
  • Working with multiple worksheets
  • Linking worksheets with 3-D formulas
  • Using multiple workbooks
  • Linking workbooks

Advanced formatting

  • Using special number formats
  • Working with themes
  • Other advanced formatting

Outlining and subtotals

  • Outlining and consolidating data
  • Creating subtotals

Cell and range names

  • Creating and using names
  • Managing names

Data structure and tables

  • Sorting and filtering data
  • Working with tables

Web and sharing features

  • Saving workbooks as Web pages
  • Using hyperlinks

Documenting and auditing

  • Auditing features
  • Comments in cells and workbooks
  • Protection
  • Workgroup collaboration

Application settings and templates

  • Application settings
  • Working with templates

Course Number : MOUS-8-0201

Duration : 8 hours

[]
1 Step 1

Request Information!

Who you are?
First Nameyour first name
Last Nameyour last name
Address
City
ZipZip
Phone Number
Commentsmore details
0 /

By submitting this form, you are giving your express written consent for Global Information Technology to contact you regarding our programs and services using email, telephone or text.  This consent is not required to purchase goods/services, and you may always call us directly at 1-866-464-4846.

Previous
Next