Microsoft Excel 2007/2010 Level 2
Class timetable | Course outline
Course DescriptionExcel Level 2 is the second of 3 levels of Excel training we offer. This is a hands-on class where participants will learn to enhance spreadsheets using templates, charts, graphics, and advanced formulas. You will also learn to sort and filter data & analyze data using PivotTables and PivotCharts. View past student's video testimonials.
Target Audience
This course is aimed at anyone who needs to enhance their existing Excel skills beyond that of a basic user. Participants are recommended to have completed Excel Level 1 or have the equivalent experience prior attending this course.
For added peace of mind, Training Connection’s Microsoft Excel training comes with a 100% Money Back Guarantee.
If by lunchtime you don't feel that the program is for you, then you can leave the course at this point and receive a full refund of your course fees.
Excel Level 2 Class Timetable
| Los Angeles | Feb 7 ! | Register |
| Chicago | Feb 7 ! | Register |
| Chicago | Mar 8 ! | Register |
| Los Angeles | Mar 13 ! | Register |
| Chicago | Apr 4 ! | Register |
| Los Angeles | Apr 10 | Register |
| Chicago | Apr 26 ! | Register |
| Los Angeles | May 10 | Register |
| Chicago | May 22 | Register |
| Los Angeles | Jun 12 | Register |
| Chicago | Jun 19 | Register |
* Class almost full ! Class guaranteed to run † Class is full
Calculating Data with Advanced Formulas
- Manage Cell and Range Names
- Calculate Data Across Worksheets
- Use Specialized Functions
- Function Categories
- Function Syntax
- Function Entry Dialog Boxes
- How to Use Specialized Functions
- Analyze Data with Logical and Lookup Functions
- Logical Functions (AND, FALSE, IF, NOT, OR and TRUE)
- VLOOKUP and HLOOKUP
Organizing Worksheet and Table Data
- Create and Modify Tables
- Format Tables
- Sort or Filter Worksheet or Table Data
- Use Functions to Calculate Data
- Database Functions
Presenting Data Using Charts
- Create a Chart
- Modify Charts
- Format Charts
Analyzing Data Using PivotTables, Slicers and PivotCharts
- Create a PivotTable Report
- PivotTable
- PivotTable Filed List Pane
- Value Field Settings Dialog Box
- PivotTable Functions
- PowerPivot
- Filtering Data Using Slicers (2010)
- Analyze Data Using PivotCharts
Inserting Graphic Objects
- Insert and Modify Pictures and ClipArt
- The Screen Capping Tool
- Picture Formatting Options
- Draw and Modify Shapes
- Illustrate Workflow Using SmartArt Graphics
- Layer and Group Graphic Objects
Customizing and Enhancing Workbooks and the Excel Environment
- Customize the Excel Environment
- General Options in Excel
- Color Schemes
- Customize Workbooks
- Comments
- Hyperlinks
- Watermarks
- Background Pictures
- Manage Themes
- Create and Use Templates
What's included
Microsoft Excel Training Manual
Certificate of Course Completion
6 Months FREE Repeat Policy
2 AMC Movie Vouchers
Related Courses
