Excel 2013: Intermediate

Course ID

27120

Course Description

This course will teach students how to work with large worksheets in Microsoft Excel 2013, and use multiple worksheets and workbooks efficiently. It will introduce them to more advanced formatting techniques, such as applying special number formats, using workbook styles and themes, adding backgrounds, and mimicking watermarks. In addition, students will learn how to create outlines and subtotals, and how to create and apply cell names. They will sort and filter data, and create and format tables. They will learn how to save workbooks as Web pages, how to insert and edit hyperlinks, and how to share workbooks via email. Students will learn how to audit worksheets for errors, how to protect worksheets, how to share and merge workbooks, and track changes in a workbook. Finally, students will customize the Excel environment, and create and modify custom templates.

Prerequisites

Microsoft Excel 2013: Basic

Audience

This course is designed for students who wish to learn the intermediate operations of the Excel 2013 program to perform their day-to-day responsibilities.

Course Content

    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

For More Information

For training inquiries, call 850-308-1376

or email us at eramos@gbsi.com

Course Details

Duration - 1 day
Price - $250.00 USD


(Discounts may apply. Call for more information.)

Course Actions

Schedule

Acceletrain Collaborative Learning Environment (formerly know as VILT) places industry certified and expert instructors, peers, learners and multi-media components into a "borderless classroom", and interactive learning environment that can span multiple physical locations. VILT combines the benefits of the traditional brick-and-mortar classroom with innovative learning techniques and the cost savings of internet-based training.