School of Continuing EducationRegistration InformationContact UsUWM HomeShopping Cart
UWM logo

SCE HomepageDean's WelcomeCourses & ProgramsCertificate ProgramsDistance EducationCalendarSpecial EventsDepartments & CentersCommunity ResearchInternationalCenter for the Study of the WorkplaceFaculty & StaffCustomized TrainingKeep Me Posted
 

Connect With Us

 
HomeCourses & ProgramsCertificate ProgramsFaculty & Staff
 

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.

For specific topics covered in Excel Level I, click on Course Outline/Topics below:

Course Outline/Topics

Course Content Microsoft Excel level I

Lesson 1: Getting Started with Excel

Identify the Elements of the Excel Interface

Navigate and Select Cells in Worksheets

Customize the Excel Interface

Create a Basic Worksheet

Lesson 2: Performing Calculations in an Excel Worksheet

Create Formulas in a Worksheet

Insert Functions in a Worksheet

Reuse Formulas

Lesson 3: Modifying a Worksheet

Edit Worksheet Data

Find and Replace Data

Manipulate Worksheet Elements

Lesson 4: Modifying the Appearance of a Worksheet

Apply Font Properties

Add Borders and Colors to Cells

Align Content in a Cell

Apply Number Formatting

Lesson 5: Managing an Excel Workbook

Manage Worksheets

View Worksheets and Workbooks

Lesson 6: Printing Excel Workbooks

Define the Page Layout

Print a Workbook

Close ▲

Prerequisites
Experience using Windows
Notes
This course is taught using Microsoft Office 2010. If you are interested in training using Microsoft Office 2013, please contact us for more information.

"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

"Learning Excel can be very dry but Greg keeps things light and actually entertaining. I think I learned a great deal from Greg today. Thanks Greg!"
Student, 2015

  Sessions  
Thu., Sept. 24
8:30am-4:30pm
Location: UWM School of Continuing Education (Click link for directions)
Instructor: Greg Patterson, Great Lakes Training & Consulting
$249
CEUs: 0.7
Enrollment Limit: 20
Program No. 5070-8499
Register Now
 
Wed., Jan. 27, 2016
8:30am-4:30pm
Location: UWM School of Continuing Education (Click link for directions)
Instructor: Greg Patterson, Great Lakes Training & Consulting
$249
CEUs: 0.7
Enrollment Limit: 20
Program No. 5070-8502
Register Now
 
Thu., May 12, 2016
8:30am-4:30pm
Location: UWM School of Continuing Education (Click link for directions)
Instructor: Greg Patterson, Great Lakes Training & Consulting
$249
CEUs: 0.7
Enrollment Limit: 20
Program No. 5070-8547
Register Now
 
  Related Courses  
Microsoft Excel Level II
Microsoft Excel Level III
 
For more information, contact:
Pam Nellen, Program Manager, Business and Technology Programs, nellenp@uwm.edu, 414-227-3208
 

Features

Marketing & Technology Spring 2015 Brochure

Marketing & Technology Fall 2014 Brochure

Or download the pdf