Skip to Main Content

Microsoft Excel 2013: Level 2

Hours: 6.00 | Estimated Cost: $175.00

Use Microsoft® Excel® to create advanced formulas and organize your data into tables. Discover the power of PivotTables and PivotCharts and how slicers can make data filtering as easy as clicking a few buttons. Prerequisite: Microsoft® Office Excel® 2013 - Level 1 or equivalent knowledge/experience.

Additional Information

Learn About
  • Creating advanced formulas
  • Analyzing data with logical and lookup functions
  • Organizing worksheet data with tables
  • Presenting data using charts
  • Analyzing data using PivotTables and Pivot Charts
  • Inserting graphic objects
  • Customizing and enhancing workbooks and the Excel environment
Benefits & Outcomes
  • Improve productivity by allowing mundane tasks to be completed more efficiently
  • Learn valuable tips and tricks to improve efficiency and accuracy
  • Become proficient in Microsoft Excel
Training Outline

** Creating Advanced Formulas**

  • Apply Range Names
  • Use Specialized Functions

** Analyzing Data with Logical and Lookup Functions**

  • Leverage Questions and Testing to Write Formulas
  • Use Logical and Lookup Functions to Find Answers to Questions

** Organizing Worksheet Data with Tables**

  • Create and Modify Tables
  • Sort and Filter Data
  • Use Summary and Database Functions to Calculate Data

** Visualizing Data with Charts**

  • Create Charts
  • Modify and Format Charts
  • Create a Trendline
  • Create Advanced Charts

** Analyzing Data with PivotTables, Slicers, and PivotCharts**

  • Create a PivotTable
  • Filter Data by Using Slicers
  • Analyze Data by Using PivotCharts

** Inserting Graphics**

  • Insert and Modify Graphic Objects
  • Layer and Group Graphic Objects
  • Incorporate SmartArt

** Enhancing Workbooks**

  • Customize Workbooks
  • Manage Themes
  • Create and Use Templates
  • Protect Files
Business and Industry Services

Fox Valley Technical College
Business & Industry Services (BIS)
D. J. Bordini Center
1825 N. Bluemound Road
P.O. Box 2277
Appleton, WI 54912-2277
View BIS Calendar

P: 888-458-0449
P: 920-735-2525
F: 920-735-4771

Join us on LinkedIn