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.
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 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
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
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 Workbook and Worksheet Views
Manage Workbook Properties
Experience using Windows
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 firstname.lastname@example.org or 414-227-3208.
"I have to tell you that Greg Patterson is an excellent instructor. Many of us from the Wauwatosa Fire Department have taken an Excel class, even more than one, in the past. We learned more in the first hour of this class than all the combined classes at a different facility. I will highly recommend this course and UW-Milwaukee to others. When anyone did have a question or needed a minute to catch up, he was kind enough to halt so that could happen. Of course he offered to help when needed." — Lori Murphy, Fire Education Coordinator, Wauwatosa Fire Department, 2019
"Fun instructor. Easy to follow along. I would recommend the class for beginners to Excel." — Imaging Data Specialist, Medical College of Wisconsin, 2019
All sessions are Face-to-Face unless otherwise noted.
Date: Wed, Jan 22, 2020
Location: UWM School of Continuing Education
Instructor: Greg Patterson
$249 by Wed., Jan. 8, 2020.
$274 after Wed., Jan. 8, 2020.
Enrollment Limit: 20
Program Number: 5070-12514
Registration Deadline: Wed., Jan. 22, 2020