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

Share

Microsoft Excel Level I

Microsoft Excel is used in many jobs and at home to organize data and perform reliable, repeat calculations. This course focuses on navigating Excel, entering data, performing calculations, modifying worksheets, formatting cells, and applying styles and themes.

Most sessions are taught using Zoom. Small classes provide ample opportunity for interaction and individual attention.

To participate in the live online sessions, you must have

  • a computer
  • reliable internet connectivity
  • Microsoft Excel version 2016 or later (preferably)
  • computer audio with microphone or headphones with microphone
  • webcam, built-in or added – strongly recommended for interaction with the instructor and class participants

One or more sessions will return to our in-person labs in downtown Milwaukee for fall 2021. Please check session details for information.

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 United States and internationally. ... read more

Course Outline/Topics

Lesson 1: Getting Started With Excel

 Topic A: Navigate the Excel User Interface

 Topic B: Use Excel Commands

 Topic C: Create and Save a Basic Workbook

 Topic D: Enter Cell Data

 Topic E: Use Excel Help

 

Lesson 2: Performing Calculations

 Topic A: Create Worksheet Formulas

 Topic B: Insert Functions

 Topic C: Reuse Formulas and Functions

 

Lesson 3: Modifying a Worksheet

 Topic A: Insert, Delete and Adjust Cells, Columns and Rows

 Topic B: Search for and Replace Data

 Topic C: Use Proofing and Research Tools

 

Lesson 4: Formatting a Worksheet

 Topic A: Apply Text Formats

 Topic B: Apply Number Formats

 Topic C: Align Cell Contents

 Topic D: Apply Styles and Themes

 Topic E: Apply Basic Conditional Formatting

 Topic F: Create and Use Templates

 

Lesson 5: Printing Workbooks

 Topic A: Preview and Print a Workbook

 Topic B: Set Up the Page Layout

 Topic C: Configure Headers and Footers

 

Lesson 6: Managing Workbooks

 Topic A: Manage Worksheets

 Topic B: Manage Workbook and Worksheet Views

 Topic C: Manage Workbook Properties

Prerequisites

Experience using Windows

Notes

Contact Christine Sigrist at sigristc@uwm.edu or 414-227-3336 to learn more about delivering this course to your business or organization.

Testimonials

"Greg did a tremendous job. He knows his way around this software. Covered just enough material that it didn’t get overwhelming for the first session."  —  Gary Oldenburg, Danfoss LLC, May 2021

"Beginners level but still covered a lot. Greg is obviously very knowledgeable but made you feel welcome to ask all questions and explained them well. If I had teachers like him in school, I may have been valedictorian."  —  Alberto A Aranda, Milwaukee Public Schools Division of Facilities and Maintenance, April 2021

"Greg Patterson was very patient with the class. He knows his stuff. Great instructor and Rebecca from UWM was awesome as well."  —  Daniel M. Swiatkowski, Crew Leader for T.A.B. and the Metal Shop, Milwaukee Public Schools, April 2021

"Greg is knowledgeable, thorough and patient – qualities that transcend the diverse experience within the class [sic]."  —  Giles Patterson, Milwaukee Public Schools Department of Facilities and Maintenance, April 2021

"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

"Greg Patterson is an excellent instructor! Personable. Made me feel as though we’d been in class together before. Very patient. Welcomed any and all questions, even if they were “help, I’m lost” or “help, don’t know what I did wrong.” Looking forward to Levels II & III with Greg."  —  Ruth Alpizar, Acelero Learning Wisconsin

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

"This course was very good for a beginner level; [it] went over many of the various features of Excel. Plus [it] taught me new skills that I can use at my job. Greg was well informed; [he] kept the class on track and interactive. It was not boring but was still informative and inclusive."  —  Jennifer Held, Job Cost Accountant

"I learn a lot of new skills in Excel. It will really make my data entries more pleasant and accurate. Hopefully, I can be part of Level II."  —  Jerry Northern II, MPS Plumbing Shop, April 2021

Date: Tue-Wed, Sept 28-29

Delivery Method: Live Online

Time: 8am-Noon CT

Platform: Zoom

Instructor: Greg Patterson

Fee: $274

CEUs: 0.7

Enrollment Limit: 10

Program Number: 5070-13890

Registration Deadline: Sept 28

Register Now

Date: Fri, Nov 12

Delivery Method: In-person

Time: 8:30am-4:30pm CT

Location: UWM School of Continuing Education

Instructor: Greg Patterson

Fee:

$249 by Oct 27
$274 after Oct 27

CEUs: 0.7

Enrollment Limit: 10

Program Number: 5070-13901

Note: Participants who register for this in-person session prior to the early registration deadline of October 27, will receive a free hard copy of the reference book.  All others will receive a digital copy.

Registration Deadline: Nov 11

Register Now

Share

Join Our Email List

Get the latest on courses and certificates in your areas of interest.

Working...