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-SCE 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:
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 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
Excel 2010/2013 – Level I (or equivalent experience)
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 email@example.com or 414-227-3208.
"I think Greg did a great job at interacting with the students and made everyone feel comfortable when asking questions. I really enjoyed the class and his extensive knowledge and would definitely take another one of Greg’s classes!" — Edith Rivas, The Mark Travel Corporation
All sessions are Face-to-Face unless otherwise noted.
Date: Wed., Feb 28
Location: UWM School of Continuing Education
Instructor: Greg Patterson
$249 by Wed., Feb. 14.
$274 after Wed., Feb. 14.
Enrollment Limit: 20
Program Number: 5070-10670
Registration Deadline: Wed., Feb. 28