×
  • This field is for validation purposes and should be left unchanged.

Microsoft Excel Level I

Use Microsoft Excel to create and manage spreadsheets that 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.

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

"Greg is a great trainer and presenter. He took, what is dry material for me, and made it fun, interesting and useful! I would recommend his class, especially his approach, to anyone."  —  Student, 2016

"Greg is a fabulous instructor! He provides the class with real-world scenarios that can be applied instantly in the workforce."  —  Student, 2015

All sessions are Face-to-Face unless otherwise noted.

Tue., Sept. 13

8:30am-4:30pm

Location: UWM School of Continuing Education

Instructor: Greg Patterson

Fee: $249

CEUs: 0.7

Enrollment Limit: 20

Program Number: 5070-9267

Registration Deadline: Tue., Sept. 13

Register Now

Tue., Jan. 31, 2017

8:30am-4:30pm

Location: UWM School of Continuing Education

Instructor: Greg Patterson

Fee: $249

CEUs: 0.7

Enrollment Limit: 20

Program Number: 5070-9266

Registration Deadline: Tue., Jan. 31, 2017

Register Now

FacebookTwitterGoogle+Share