Excel 2013 - Part 2

Course ID: 234829

Students will build upon the foundational Microsoft® Office Excel® 2013 knowledge and skills already acquired and learn to create advanced workbooks and worksheets, including advanced formulas, tables, PivotTables, PivotCharts and data filtering.

  • Create advanced formulas
  • Analyze data with logical and lookup functions
  • Organize worksheet data with tables
  • Visualize data by using charts
  • Analyzing data with PivotTables, slicers, and PivotCharts
  • Insert graphic objects
  • Enhance workbooks


Lesson 1: Creating Advanced Formulas
  • Apply Range Names
  • Use Specialized Functions
Lesson 2: Analyzing Data with Logical and Lookup Functions
  • Leverage Questions and Testing to Write Formulas
  • Use Logical and Lookup Functions to Find Answers to Questions
Lesson 3: Organizing Worksheet Data with Tables
  • Create and Modify Tables
  • Sort and Filter Data
  • Use Summary and Database Functions to Calculate Data
Lesson 4: Visualizing Data with Charts
  • Create Charts
  • Modify and Format Charts
  • Create a Trendline
  • Create Advanced Charts
Lesson 5: Analyzing Data with PivotTables, Slicers, and PivotCharts
  • Create a PivotTable
  • Filter Data by Using Slicers
  • Analyze Data by Using PivotCharts
Lesson 6: Inserting Graphics
  • Insert and Modify Graphic Objects
  • Layer and Group Graphic Objects
  • Incorporate SmartArt
Lesson 7: Enhancing Workbooks
  • Customize Workbooks
  • Manage Themes
  • Create and Use Templates
  • Protect Files



Virtual Excel 2013 - Part 2 Online Live training option
Imagine an industry-leading classroom training experience from wherever you have access to the Internet. The Virtual Online Live events listed here gives you an effective and proven online virtual learning experience with the freedom to attend virtually from anywhere.

There is also an option of experiencing Online Live from one of the many national partner centers where a computer and headset will be provided for you.

This rich and engaging virtual classroom environment lets you conveniently interact with instructors and other students. You will hear and see your instructor as they teach the course and answer your questions via voice or text. Choose the online live virtual training option and you can access the recorded version even after the class has finished.

The onDemand labs give you access to the same client and server technologies covered in class so you can test, apply and hone your skills by accessing the labs before and even after the class.

Technical Requirements: a computer or laptop with a modern browser and high speed internet access along with one or two monitors.

To register choose a training date or item from below:

Filter by: Location
Date Range to
  • All Types
  • C Classroom
  • V Virtual
  • O Online
LocationDateTimeTypeDurationPriceMore Info
GA Atlanta9/1/2015 9:00:00 AM9/1/2015 9:00:00 AM<span class="course-type type-c">C</span>1 day295.004576748
Virtual Live9/1/2015 9:00:00 AM9/1/2015 9:00:00 AM<span class="course-type type-v">V</span>1 day295.004582627
Virtual Live9/4/2015 8:00:00 AM9/4/2015 8:00:00 AM<span class="course-type type-v">V</span>1 day295.004582583
TN Memphis9/8/2015 8:00:00 AM9/8/2015 8:00:00 AM<span class="course-type type-c">C</span>1 day295.004577085
MA Waltham9/9/2015 8:00:00 AM9/9/2015 8:00:00 AM<span class="course-type type-c">C</span>1 day295.004577328
IA Hiawatha9/10/2015 5:00:00 PM9/10/2015 5:00:00 PM<span class="course-type type-c">C</span>2 days275.004576805
DC Washington9/11/2015 9:00:00 AM9/11/2015 9:00:00 AM<span class="course-type type-c">C</span>1 day275.004577346
Virtual Live9/11/2015 8:00:00 AM9/11/2015 8:00:00 AM<span class="course-type type-v">V</span>1 day295.004582637
OR Beaverton9/11/2015 8:00:00 AM9/11/2015 8:00:00 AM<span class="course-type type-c">C</span>1 day295.004576789
IL Chicago9/14/2015 8:00:00 AM9/14/2015 8:00:00 AM<span class="course-type type-c">C</span>1 day295.004576869
Virtual Live9/15/2015 8:00:00 AM9/15/2015 8:00:00 AM<span class="course-type type-v">V</span>1 day295.004582414
NV Reno9/15/2015 8:00:00 AM9/15/2015 8:00:00 AM<span class="course-type type-c">C</span>1 day295.004577179
NH Nashua9/15/2015 9:00:00 AM9/15/2015 9:00:00 AM<span class="course-type type-c">C</span>1 day295.004577146
CA Sacramento9/15/2015 8:00:00 AM9/15/2015 8:00:00 AM<span class="course-type type-c">C</span>1 day295.004577272
NV Las Vegas9/15/2015 8:00:00 AM9/15/2015 8:00:00 AM<span class="course-type type-c">C</span>1 day295.004577049
FL Tampa9/15/2015 9:00:00 AM9/15/2015 9:00:00 AM<span class="course-type type-c">C</span>1 day275.004577229
FL Plantation9/15/2015 8:00:00 AM9/15/2015 8:00:00 AM<span class="course-type type-c">C</span>1 day300.004576985
AZ Tucson9/16/2015 9:00:00 AM9/16/2015 9:00:00 AM<span class="course-type type-c">C</span>1 day295.004577283
PA Wayne9/16/2015 9:00:00 AM9/16/2015 9:00:00 AM<span class="course-type type-c">C</span>1 day295.004576978
TN Nashville9/16/2015 8:00:00 AM9/16/2015 8:00:00 AM<span class="course-type type-c">C</span>1 day295.004577182
Virtual Live9/17/2015 8:00:00 AM9/17/2015 8:00:00 AM<span class="course-type type-v">V</span>1 day295.004582589
FL Orlando9/17/2015 9:00:00 AM9/17/2015 9:00:00 AM<span class="course-type type-c">C</span>1 day275.004577091
FL Jacksonville9/18/2015 9:00:00 AM9/18/2015 9:00:00 AM<span class="course-type type-c">C</span>1 day275.004576969
MI Troy9/18/2015 9:00:00 AM9/18/2015 9:00:00 AM<span class="course-type type-c">C</span>1 day295.004577247
IA Hiawatha9/18/2015 8:00:00 AM9/18/2015 8:00:00 AM<span class="course-type type-c">C</span>1 day275.004576813
NY Rochester9/18/2015 8:00:00 AM9/18/2015 8:00:00 AM<span class="course-type type-c">C</span>1 day275.004577219
NY New York9/21/2015 9:00:00 AM9/21/2015 9:00:00 AM<span class="course-type type-c">C</span>1 day295.004577199
OH Westerville9/22/2015 9:00:00 AM9/22/2015 9:00:00 AM<span class="course-type type-c">C</span>1 day295.004576909
Virtual Live9/23/2015 8:00:00 AM9/23/2015 8:00:00 AM<span class="course-type type-v">V</span>1 day295.004582642
GA Atlanta9/23/2015 9:00:00 AM9/23/2015 9:00:00 AM<span class="course-type type-c">C</span>1 day295.004576756
Virtual Live9/28/2015 9:00:00 AM9/28/2015 9:00:00 AM<span class="course-type type-v">V</span>1 day295.004582632
FL Miami9/28/2015 8:00:00 AM9/28/2015 8:00:00 AM<span class="course-type type-c">C</span>1 day300.004577113
Virtual Live9/30/2015 9:00:00 AM9/30/2015 9:00:00 AM<span class="course-type type-v">V</span>1 day275.004582386
NY East Syracuse9/30/2015 9:00:00 AM9/30/2015 9:00:00 AM<span class="course-type type-c">C</span>1 day275.004577344
Virtual Live10/7/2015 8:00:00 AM10/7/2015 8:00:00 AM<span class="course-type type-v">V</span>1 day295.004582564
CA Sacramento10/13/2015 8:00:00 AM10/13/2015 8:00:00 AM<span class="course-type type-c">C</span>1 day295.004577280
GA Atlanta10/13/2015 9:00:00 AM10/13/2015 9:00:00 AM<span class="course-type type-c">C</span>1 day295.004576763
NV Reno10/13/2015 8:00:00 AM10/13/2015 8:00:00 AM<span class="course-type type-c">C</span>1 day295.004577186
FL Plantation10/13/2015 8:00:00 AM10/13/2015 8:00:00 AM<span class="course-type type-c">C</span>1 day300.004576994
Virtual Live10/13/2015 8:00:00 AM10/13/2015 8:00:00 AM<span class="course-type type-v">V</span>1 day295.004582417
NV Las Vegas10/13/2015 8:00:00 AM10/13/2015 8:00:00 AM<span class="course-type type-c">C</span>1 day295.004577058
OH Westerville10/14/2015 9:00:00 AM10/14/2015 9:00:00 AM<span class="course-type type-c">C</span>1 day295.004576917
Virtual Live10/15/2015 8:00:00 AM10/15/2015 8:00:00 AM<span class="course-type type-v">V</span>1 day295.004582571
OH Garfield Heights10/16/2015 9:00:00 AM10/16/2015 9:00:00 AM<span class="course-type type-c">C</span>1 day295.004576893
CT Trumbull10/16/2015 8:00:00 AM10/16/2015 8:00:00 AM<span class="course-type type-c">C</span>1 day295.004577048
AZ Tucson10/20/2015 7:00:00 AM10/20/2015 7:00:00 AM<span class="course-type type-c">C</span>1 day295.004577292
MA Waltham10/21/2015 8:00:00 AM10/21/2015 8:00:00 AM<span class="course-type type-c">C</span>1 day295.004577337
MI Grand Rapids10/21/2015 9:00:00 AM10/21/2015 9:00:00 AM<span class="course-type type-c">C</span>1 day295.004577030
FL Orlando10/21/2015 9:00:00 AM10/21/2015 9:00:00 AM<span class="course-type type-c">C</span>1 day275.004577100
NJ Iselin10/22/2015 9:00:00 AM10/22/2015 9:00:00 AM<span class="course-type type-c">C</span>1 day295.004576952
seek-warrow-warrow-eseek-eitems per page1 - 50 of 104 items