TLG Learning Bellevue / Seattle 425-460-2200 or 800-460-2298
TLG Learning
  

Course Outline

 

Excel - Level 2

Overview:

Learn how to use multiple worksheets and workbooks efficiently. Work with more advanced formatting options including styles, themes, and backgrounds. Learn to use advanced formulas, including lookup functions. Create and apply cell names, work with tables, learn basic and advanced charting techniques, including the use of trendlines and sparklines. Finally, learn to work with PivotTables and PivotCharts.

Pre-requisite(s):

Excel Level 1

Length/Cost:

1 Day, $265

Outline:

Lesson 1 : Using multiple worksheets and workbooks

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

Lesson 2 : Text and number formatting

Using special number formats
Using functions to format text
Other advanced formatting

Lesson 3 : Cell and range names

Creating and using names
Managing names

Lesson 4 : Lookups

Using lookup functions
Using MATCH and INDEX

Lesson 5 : Tables

Sorting and filtering data
Advanced filtering
Working with tables

Lesson 6 : Charts

Chart basics
Formatting charts

Lesson 7 : Advanced charting

Chart formatting options
Combination charts

Lesson 8 : PivotTables and PivotCharts

Working with PivotTables
Rearranging PivotTables
Formatting PivotTables
Using PivotCharts

Lesson 9 : Appendix - Additional Features

--note: Appendix content is not covered in the one day course
Working with styles
Working with themes
Creating data tables
Graphical elements

Schedule:

= "Guaranteed to Run"
ILT - Instructor-Led Training | MLT - Mentor-Led Training | Anywhere LIVE OLT - Live Online Training | Bellevue LIVE OLT - Live Online Training
Location RegisterTime
Anywhere
(Live-OLT)
Sep 05 8:00AM-4:00PM Pacific Time
Seattle, WA
(ILT)
Sep 05 8:00AM-4:00PM
Anywhere
(Live-OLT)
Oct 14 8:00AM-4:00PM Pacific Time
Bellevue, WA
(ILT)
Oct 14 8:00AM-4:00PM
Anywhere
(Live-OLT)
Nov 18 8:00AM-4:00PM Pacific Time
Seattle, WA
(ILT)
Nov 18 8:00AM-4:00PM


Find Courses
Search Courses
 
  

 
Course Topics
Course Schedules