School of Continuing EducationRegistrationContact UsUniversity Of Wisconsin Milwuakee Homepage
UWM logo

School of Continuing Education

About Us

Courses and Programs

Certificate Programs

Distance Education

Calendar of Events

Special Events

Departments Centers and Institutes

Community Research

International Partnerships

Center for the Study of the Workplace

Faculty and Staff

Customized Professional Development Solutions

Join our Mailing List

 

Connect with us

 
HomeCourses & ProgramsCertificate ProgramsFaculty & Staff
 

Excel 2007/2010 - 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 1, click on arrow next to 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 course was very helpful in giving me tips that I can use immediately. I gained a broader understanding of the purpose and varied uses that are available with Excel. I would love to take the intermediate and advanced courses."

"It was very well organized, and I learned a lot. I wouldn't change anything. I particularly liked how knowledgeable and passionate the instructor was about Excel."
-- students, Excel-I, 2012

 
  Sessions  
Tue., May 28
8:30am-4:30pm
Location: UWM School of Continuing Education (Click link for directions)
Instructor: Greg Patterson, Great Lakes Training & Consulting
Fee: $224
Program No. 5070-0003
Add To Registration Form   Check Registration Form
 
Tue., Oct. 8
8:30am-4:30pm
Location: UWM School of Continuing Education (Click link for directions)
Instructor: Greg Patterson, Great Lakes Training & Consulting
Fee: $224
CEUs: 0.7
Program No. 5070-6217
Add To Registration Form   Check Registration Form
 
Thu., Jan. 16, 2014
8:30am-4:30pm
Location: UWM School of Continuing Education (Click link for directions)
Instructor: Greg Patterson, Great Lakes Training & Consulting
Fee: $224
CEUs: 0.7
Program No. 5070-6272
Add To Registration Form   Check Registration Form
 
Fri., May 16, 2014
8:30am-4:30pm
Location: UWM School of Continuing Education (Click link for directions)
Instructor: Greg Patterson, Great Lakes Training & Consulting
Fee: $224
CEUs: 0.7
Program No. 5070-6275
Add To Registration Form   Check Registration Form
 
  Related Courses  
Excel 2007/2010 - Level II
Excel 2007/2010 - Level III
 
For more information, contact:
  Pam Nellen, Program Manager, Business and Technology Programs, nellenp@uwm.edu, 414-227-3208
 

Features

IT Certificate Programs Brochure

Wired


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