Course Locations
Anaheim, CA
Atlanta, GA
Austin, TX
Baltimore, MD
Burbank, CA
Calgary, AB
Charleston, SC
Charlotte, NC
Chicago, IL
Columbia, MD
Columbus, OH
Dallas-Ft Worth, TX
Denver, CO
Detroit, MI
Edison, NJ
El Paso, TX
Framingham, MA
Houston, TX
Kansas City, MO
Los Angeles, CA
Minneapolis, MN
New York, NY
Oakbrook, IL
Ottawa, ON
Pittsburgh, PA
Toronto, ON
Virtual Classroom
Popular Courses
Project Management, IT Service Management, .NET, SAS, Rexx, ASP, JavaScript, HTML, XML, ColdFusion, Visual Basic, COBOL, Assembler, Java, J2EE, Java Wireless, WebSphere, WebLogic, UNIX, LINUX, AIX, Solaris, z/OS, OS/390, CICS, IMS, VSAM, Easytrieve, AS/400, Oracle, BusinessObjects, SQL, DB2, Crystal Reports
Browse Courses
 |
 |
 |
 |
 |
Microsoft Office Excel 2010: Level 2
Summary:
In this course, students will use advanced formulas and work with various tools to analyze data in spreadsheets. Students will also organize table data, present data as charts, and enhance the look and appeal of workbooks by adding graphical objects.
Duration:
1 day/Lecture & Lab
Audience:
This course is meant for those desiring to gain advanced skill sets necessary for calculating data using functions and formulas, sorting and filtering data, using PivotTables and PivotCharts for analyzing data, and customizing workbooks.
Topics:
- Calculating Data with Advanced Formulas
- Organizing Worksheet and Table Data
- Presenting Data Using Charts
- Analyzing Data Using PivotTables, Slicers, and PivotCharts
- Inserting Graphic Objects
- Customizing and Enhancing the Excel Environment
Prerequisites:
Before starting this course, students are recommended to take the following course or have equivalent knowledge: Microsoft Office Excel 2010: Level 1.
Last Update: May 19, 2013
