×

Microsoft Excel Level II

Microsoft Excel allows users to create and manage spreadsheets to manipulate data used in personal finance, budget preparation, financial and investment analysis, business modeling, sales forecasting and other calculating and analytical applications.

This class is taught in Microsoft Office 2013.

For specific topics covered in Excel Level II, click on Course Outline/Topics below:

Course Outline/Topics

Course Content Microsoft Excel Level II

Lesson 1: Customizing the Excel Environment

  • Configure Excel Options
  • Customize the Ribbon and the Quick Access Toolbar
  • Enable Excel Add-Ins

Lesson 2: Creating Advanced Formulas

  • Use Range Names in Formulas
  • Use Specialized Functions
  • Use Array Formulas

Lesson 3: Analyzing Data with Functions and Conditional Formatting

  • Analyze Data by Using Text and Logical Functions
  • Apply Advanced Conditional Formatting

Lesson 4: Organizing and Analyzing Datasets and Tables

  • Create and Modify Tables
  • Sort Data
  • Filter Data
  • Use SUBTOTAL and Database Functions

Lesson 5: Visualizing Data with Basic Charts

  • Create Charts
  • Modify and Format Charts

Lesson 6: Analyzing Data with PivotTables, Slicers, and PivotCharts

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

Prerequisites

Excel 2010/2013 – Level I (or equivalent experience)

Notes

Public courses on Microsoft Excel and Access are taught in Office 2013. If you are using Office 2010 – the functions and features you will learn are similar to 2013 and can be applied in the 2010 environment. If you would like group training on any MS Office 2010 programs, please contact Pam Nellen at nellenp@uwm.edu or 414-227-3208.

This course is very useful for the type of data analysis I do on a daily basis. I learned many new tips to help me create, sort, slice and dice data to create useful reports, which will help make better business decisions.

— Student, 2015

Greg is a great instructor! The program was well taught and easy to follow. The workbook will prove to be a valuable resource going forward to reinforce the lessons from class.

— student, 2014

All sessions are Face-to-Face unless otherwise noted.

Wed., Oct. 21

8:30am-4:30pm

Location: UWM School of Continuing Education

Instructor: Greg Patterson

Fee: $249

CEUs: 0.7

Enrollment Limit: 20

Program Number: 5070-8500

Registration Deadline: Tue., Oct. 20

Register Now

Thu., Feb. 25, 2016

8:30am-4:30pm

Location: UWM School of Continuing Education

Instructor: Greg Patterson

Fee: $249

CEUs: 0.7

Enrollment Limit: 20

Program Number: 5070-8501

Registration Deadline: Wed., Feb. 24, 2016

Register Now

Wed., June 22, 2016

8:30am-4:30pm

Location: UWM School of Continuing Education

Instructor: Greg Patterson

Fee: $249

CEUs: 0.7

Enrollment Limit: 20

Program Number: 5070-8549

Registration Deadline: Tue., June 21, 2016

Register Now

FacebookTwitterGoogle+Share