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
Due to the close similarities, this course will be taught using 2010 materials with differences of 2007 explained.

"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

"Today's class was very informative and helpful! Greg did a great job of teaching the material and explaining things step by step. Very applicable and easy to translate to daily use."
Student, 2014

  Sessions  
Tue., Jan. 20, 2015
8:30am-4:30pm
Location: UWM School of Continuing Education (Click link for directions)
Instructor: Greg Patterson, Great Lakes Training & Consulting
$224
Enrollment Limit: 20
Program No. 5070-7368
Registration Deadline: Mon., Jan. 19, 2015
Register Now
 
Thu., May 21, 2015
8:30am-4:30pm
Location: UWM School of Continuing Education (Click link for directions)
Instructor: Greg Patterson, Great Lakes Training & Consulting
$224
Enrollment Limit: 20
Program No. 5070-7371
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

In Partnership with
American Marketing Association


Center for the Study of the Workplace
Learn about the real-world impact of workplace changes. Hear what leaders in both business and academia have to say and help propel yourself or your company into the future.
Learn more>>