Excel 2010: Intermediate

Course ID

27090

Course Description

This course builds on the skills and concepts taught in Excel Basic. Students will learn how to use multiple worksheets and workbooks efficiently, and they will start working with more advanced formatting options including styles, themes, and backgrounds. They will also learn how to create outlines and subtotals, how to create and apply cell names, and how to work with tables. Students will save workbooks as Web pages, insert and edit hyperlinks, and learn to share workbooks by email. This course also covers advanced charting techniques, use of trendlines and sparklines, worksheet auditing and protection, file sharing and merging, and workbook templates. Finally, students will learn to work with PivotTables and PivotCharts.

Prerequisites

Microsoft Excel 2010: Basic

Audience

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

Course Content

    Using multiple worksheets and workbooks
  • Using multiple workbooks
  • Linking worksheets with 3-D formulas
  • Linking workbooks
  • Managing workbooks

    Advanced formatting
  • Using special number formats
  • Using functions to format text
  • Working with styles
  • 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

    Tables
  • Sorting and filtering data
  • Advanced filtering
  • Working with tables

    Web and sharing features
  • Saving workbooks as Web pages
  • Using hyperlinks
  • Sharing workbooks

    Advanced charting
  • Chart formatting options
  • Combination charts
  • Graphical elements

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

    Templates and settings
  • Changing application settings
  • Using built-in templates
  • Creating and managing templates

    PivotTables and PivotCharts
  • Working with PivotTables
  • Rearranging PivotTables
  • Formatting PivotTables
  • Using PivotCharts

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.