Skip to Main Content
FVTC Logo

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
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
D. J. Bordini Center
5 N. Systems Drive
P.O. Box 2277
Appleton, WI 54912-2277

bi.services@fvtc.edu
www.fvtc.edu/bis
View BIS Calendar

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


Join us on LinkedIn