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

When & Where


ThinkData Lab
1500 1st Ave N
Ste L142
Birmingham, AL 35203

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


  Add to my calendar

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.