This event has ended

Excel 2010 Intermediate

ThinkData Solutions, Inc

Thursday, May 31, 2012 from 9:00 AM to 12:00 PM (CDT)

Birmingham, AL

Excel 2010 Intermediate

Ticket Information

Ticket Type Sales End Price Fee Quantity
MICROSOFT OFFICE EXCEL 2010 - Intermediate Ended $175.00 $0.00

Share Excel 2010 Intermediate

Event Details

 

Microsoft Excel 2010 - Intermediate


Course Description

This course is designed for any person with a basic understanding of Microsoft Windows who needs to learn more advanced features and uses of Microsoft Excel 2010.

Course Objectives:

 Upon completion of this course, the student will be able to:

  •  Calculate data with advanced formulas
  •  Organize worksheet and table data
  •  Present data using charts
  •  Present data using pivot tables

Lesson 1 – Calculating Data with Advanced Formulas

  • Absolute/Relative Referencing (HP10081865)
  • Manage Cell and Range Names
  • Name a Cell/Range
  • Change or Manage the Named Cells/Ranges
  • Create Names Automatically from Selection
  • Vlookup (HP10069835)
  • IF Function (HP10069829)
  • ISNA Function (HP10069827)
  • 3D Referencing
  • Edit Links

Lesson 2 – Organizing Worksheet and Table Data

  •  Modify Table
  • Format the Table
  • Sort and filter data
  • Sort Data
  • Filter Data
  • Clear Filters

Lesson 3 – Presenting Data Using Charts

  • Create a basic chart
  • Modify a Chart

Lesson 4 – Pivot Tables

  • Create a Pivot Table
  • Format Pivots
  • Drill Down on Pivot Data
  • Create a Pivot Chart
  • Notes

 

 

 

 

 

Have questions about Excel 2010 Intermediate? Contact ThinkData Solutions, Inc

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.