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

Share

Microsoft Excel Level I

At home or work, Excel can help you create and manage spreadsheets to make life more efficient and organized. This course focuses on Excel basics, navigating the interface, performing calculations, modifying a worksheet, formatting cells, and applying styles and themes.

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.

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

Course Content Microsoft Excel level I

Lesson 1: Getting Started with Microsoft Office Excel 2013

Navigate the Excel User Interface
Use Excel Commands
Create and Save a Basic Workbook
Enter Cell Data
Use Excel Help

Lesson 2: Performing Calculations

Create Worksheet Formulas
Insert Functions
Reuse Formulas

Lesson 3: Modifying a Worksheet

Insert, Delete, and Adjust Cells, Columns, and Rows
Search for and Replace Data
Use Proofing and Research Tools

Lesson 4: Formatting a Worksheet

Modify Fonts
Add Borders and Colors to Worksheets
Apply Number Formats
Align Cell Contents
Apply Styles and Themes
Apply Basic Conditional Formatting
Create and Use Templates

Lesson 5: Printing Workbooks

Preview and Print a Workbook
Define the Page Layout

Lesson 6: Managing Workbooks

Manage Worksheets
Manage Workbook and Worksheet Views
Manage Workbook Properties

Prerequisites

Experience using Windows

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

"Such a great class! Greg is such a fun, smart, witty and engaging teacher. I would take so many classes with him. He challenges you, keeps you interested, which is hard for a big group of random people, and I learned so much. I thought I knew Excel well, but I already learned a lot from just class 1. Planning on coming back for Excel 2 and 3. I really hope that Greg is my teacher again. Could not recommend more highly as an instructor!"  —  Erin TerBeek (Olson), Prospect Researcher, Greater Milwaukee Foundation, 2019

"Great teacher, incredibly helpful, funny and engaging."  —  Tammy Tellock, BelAir Cantina, Operations and Training Manager, 2019

Date: Wed-Thu, Jan 20-21, 2021

Delivery Method: Live Online

Time: 8am-Noon CT

Platform: Zoom

Instructor: Greg Patterson

Fee:

$249 by Jan 6, 2021
$274 after Jan 6, 2021

CEUs: 0.7

Enrollment Limit: 20

Program Number: 5070-12886

Registration Deadline: Jan 20, 2021

Register Now

Date: Wed-Thu, Apr 21-22, 2021

Delivery Method: Live Online

Time: 8am-Noon CT

Platform: Zoom

Instructor: Greg Patterson

Fee:

$249 by Apr 7, 2021
$274 after Apr 7, 2021

CEUs: 0.7

Enrollment Limit: 20

Program Number: 5070-12931

Registration Deadline: Apr 21, 2021

Register Now

Share