IT Services: Microsoft Excel Training

Microsoft Excel: 2013 Basics

Location: IT Services Training Lab, Kettler Hall, Room 205B
Instructors: Todd Raines, Kathie Surface
No Prerequisites

Topics include:

• Part 1
  • Interface and spreadsheet terminology
  • Entering data
  • Work with formulas and functions
  • Create simple chart
• Part 2
  • Import text-delimited data into Excel
  • Create named ranges and use them in formulas
  • Formatting and customizing
  • Printing
  • Templates

Microsoft Excel: 2013 Charts and Graphics

Location: IT Services Training Lab, Kettler Hall, Room 205B
Instructors: Todd Raines, Kathie Surface
Prerequisite: Excel Basics or equivalent skills

Topics include:

• Understand charting terminology
• Select appropriate chart types for a specific set of data
• Create basic chart types, including column, pie, line, XY Scatter, and bar charts
• Add a trendline and equation to the XY Scatter chart
• Apply custom formats to charts and chart elements
• Save and apply a chart template
• Add shapes and SmartArt graphics to charts
• Apply themes to charts
• Insert Excel charts into a PowerPoint presentation

Microsoft Excel: 2013 Data Management

Location: IT Services Training Lab, Kettler Hall, Room 205B
Instructors: Todd Raines
Prerequisite: Excel Basics, Excel Charts, or equivalent skills

• Work with built-in and custom lists
• Specify data validation criteria
• Protect a worksheet
• Work with text functions to separate and concatenate text
• Convert data to a table and work with table features
• Sort and filter data
• Create, replace, and remove subtotals
• Record and use a macro
• Create and format a pivot table
• Link data between worksheets
• Create a pivot chart

Microsoft Excel: 2013 Analyzing Data with Pivot Tables

Location: IT Services Training Lab, Kettler Hall, Room 205B
Instructors: Todd Raines, Kathie Surface
Prerequisites: Excel 2013 Basics

Topics include:

• Create, modify, and format pivot tables
• Use summary functions and customized calculations
• Group numbers and dates
• Create filters and slicers
• Link and update pivot tables
• Create pivot charts