Visit uwm.edu/sce/coronavirus for information about spring 2021.

Share

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. The UWM computer lab provides a hands-on learning environment that includes training from an instructor with real-world experience.

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

Instructor

Greg Patterson

Greg Patterson

Greg Patterson is president and CEO of Great Lakes Training and Consulting. As president, Greg has conducted training for many companies, including several Fortune 500 companies. Mr. Patterson has trained small and large companies within the Unites States and internationally. ... read more

Course Outline/Topics

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

Testimonials

"I liked that Greg was able to handle all levels of learning with this course. Great information in a next level course. Pace was good to learn areas. I really enjoyed the continuing education course and would come back."  —  Lisa Lumani, Store Manager, H&M, 2019

"I was happy to learn the foundation of processes and the right way. I have learned how to create certain reports from hand-me-down behaviors, but this will help me to analyze new data."  —  Heather Kutz, Sales Operations Manager, Sprint, 2019

Date: Wed-Thu, Feb 17-18, 2021

Delivery Method: Live Online

Time: 8am-Noon CT

Platform: Zoom

Instructor: Greg Patterson

Fee:

$249 by Feb 3, 2021
$274 after Feb 3, 2021

CEUs: 0.7

Enrollment Limit: 20

Program Number: 5070-12887

Registration Deadline: Feb 17, 2021

Register Now

Date: Wed-Thu, May 19-20, 2021

Delivery Method: Live Online

Time: 8am-Noon CT

Platform: Zoom

Instructor: Greg Patterson

Fee:

$249 by May 5, 2021
$274 after May 5, 2021

CEUs: 0.7

Enrollment Limit: 20

Program Number: 5070-12932

Registration Deadline: May 19, 2021

Register Now

Share