×

Microsoft Excel Level I

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.

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.

The instructor, Greg Patterson, was a very enthusiastic trainer! He was able to keep the interest of the class and allow enough time for questions and participation. The material that was covered was very good for a level one course. The class curriculum was well organized. I would recommend it to anyone getting acclimated to using MS Excel.

— Student, 2014

Greg is a fabulous instructor! He provides the class with real world scenarios that can be applied instantly in the workforce.

— Student, 2015

Thu., Sept. 24

8:30am-4:30pm

Location: UWM School of Continuing Education

Instructor: Greg Patterson

Fee: $249

CEUs: 0.7

Enrollment Limit: 20

Program Number: 5070-8499

Registration Deadline: Wed., Sept. 23

Register Now

Wed., Jan. 27, 2016

8:30am-4:30pm

Location: UWM School of Continuing Education

Instructor: Greg Patterson

Fee: $249

CEUs: 0.7

Enrollment Limit: 20

Program Number: 5070-8502

Registration Deadline: Tue., Jan. 26, 2016

Register Now

Thu., May 12, 2016

8:30am-4:30pm

Location: UWM School of Continuing Education

Instructor: Greg Patterson

Fee: $249

CEUs: 0.7

Enrollment Limit: 20

Program Number: 5070-8547

Registration Deadline: Wed., May 11, 2016

Register Now

FacebookTwitterGoogle+Share