Microsoft Excel Excel 2013 Level 2

Excel 2013 Level 2


Date of Class:


Last Day To Enroll:

295.00 295.00

  • Course Delivery: Virtual Classroom
  • Language: English

Chat Live | Contact Us | Toll Free: (888) 360-8764



Whether you need to crunch numbers for sales, inventory, IT, human resources, or another business unit, the ability to get the right information to the right people at the right time can create a powerful competitive advantage in a complex market environment. This course builds upon the foundational Microsoft Office Excel 2013 knowledge and skills you've already acquired and set you on the road to creating advanced workbooks and worksheets that will deepen your firm's business intelligence. You’ll learn a lot of things about Excel 2013, including how to create advanced formulas and organize your data into tables. You'll discover the power of PivotTables and PivotCharts and how slicers can make data filtering as easy as clicking a few buttons. At its heart, this course is about one simple idea: asking your data questions and using Excel 2013 to find the answers.


Course Objectives

In this course, you will:

  • 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.

Topics Covered

Lesson 1: Creating Advanced Formulas
  • Topic A: Apply Range Names
  • Topic B: Use Specialized Functions

Lesson 2: Analyzing Data with Logical and Lookup Functions
  • Topic A: Leverage Questions and Testing to Write Formulas
  • Topic B: Use Logical and Lookup Functions to Find Answers to Questions

Lesson 3: Organizing Worksheet Data with Tables
  • Topic A: Create and Modify Tables
  • Topic B: Sort and Filter Data
  • Topic C: Use Summary and Database Functions to Calculate Data

Lesson 4: Visualizing Data with Charts
  • Topic A: Create Charts
  • Topic B: Modify and Format Charts
  • Topic C: Create a Trendline
  • Topic D: Create Advanced Charts

Lesson 5: Analyzing Data with PivotTables, Slicers, and PivotCharts
  • Topic A: Create a PivotTable
  • Topic B: Filter Data by Using Slicers
  • Topic C: Analyze Data by Using PivotCharts

Lesson 6: Inserting Graphics
  • Topic A: Insert and Modify Graphic Objects
  • Topic B: Layer and Group Graphic Objects
  • Topic C: Incorporate SmartArt

Lesson 7: Enhancing Workbooks
  • Topic A: Customize Workbooks
  • Topic B: Manage Themes
  • Topic C: Create and Use Templates
  • Topic D: Protect Files


Prior to taking this course, you should either have taken Microsoft Office Excel 2013: Part 1 or have equivalent knowledge.


Subject Matter Expert

Productivity Point Global is led by a team of individuals with world-class experience in professional development skills and leading edge technologies. These established professionals collaborate to drive PPG's business forward through entrepreneurial innovation, strategic partnerships, brand management and sales growth. Productivity Point Global, previously ExecuTrain of Florida, began in 2003 and evolved out of a desire to increase our outreach both nationally and internationally. Utilizing the highest standard in customer service combined with our subject matter experts and high-end training venues, PPG has carved a niche by consistently expanding our corporate and government client base, originally hosted in the southeastern region of the US. By consistently setting quality as the benchmark of our value system, PPG combines strategic partnerships and cutting edge technology with our determined efforts to branch out into other regions. PPG's combination of technology and professional skills training, IT outsourcing, and event hosting enables us to place a focused emphasis on the diversified business needs of our clients. For more info please visit:

Got questions? Contact us below or call 877-881-2235

Why Choose

  • Fast and easy courses completion
  • Get an education faster than at traditional colleges!
  • 100% online - No classroom attendance required.
  • Unlimited 24x7 online customer support
  • Over 500,000+ certified nationwide.