The following fields are required:
Error has occurred. Please reload this page and try the operation again.
University of Milwaukee School of Continuing Education
Login Menu
Student Login Parent/Youth Login
  • Student Login
  • Parent/Youth Login
  • Home
  • Courses
  • Credentials
  • Program Areas
  • Request Information
  • Make a Payment
Search Results New Search

CMPP 0002 - Microsoft Excel Level II

1031647
Facebook Twitter Instagram YouTube LinkedIn
Loading...

Course Description

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.

We are now offering both in-person and live online sections. Check section details for format.

Live Online Requirements:
To participate remotely, you must have:

  • Microsoft Excel 2019, Excel 2021 or Excel for Microsoft 365 (Desktop version only)
  • Reliable internet connection
  • Microphone and speakers/headphones
  • Webcam (required for attendance and engagement)
  • Mouse (preferred over a touchpad for precision)
  • Tip: A second monitor or extended screen setup is highly recommended for ease of learning.

Course Outline/Topics

Lesson 1: Customizing the Excel Environment

  • Configure Excel Options
  • Customize the Ribbon and the Quick Access Toolbar
  • Enable Excel Add-Ins

Lesson 2: Creating Advanced Formulas

  • Use Range Names in Formulas
  • Use Specialized Functions
  • Use Array Formulas

Lesson 3: Analyzing Data with Functions and Conditional Formatting

  • Analyze Data by Using Text and Logical Functions
  • Apply Advanced Conditional Formatting

Lesson 4: Organizing and Analyzing Datasets and Tables

  • Create and Modify Tables
  • Sort Data
  • Filter Data
  • Use SUBTOTAL and Database Functions

Lesson 5: Visualizing Data with Basic Charts

  • Create Charts
  • Modify and Format Charts

Lesson 6: Analyzing Data with PivotTables, Slicers, and PivotCharts

  • Create a PivotTable
  • Analyze PivotTable Data
  • Present Data with PivotCharts
  • Filter Data by Using Slicers

Testimonials

"I was happy to learn the foundation of processes and the right way. I have learned how to create certain reports from hand-me-down behaviors, but this will help me to analyze new data."
- Heather Kutz, Sales Operations Manager, Sprint, 2019

Applies Towards the Following Credentials

  • Business Analysis Certificate : Elective
  • Excel Essentials Microcredential : Core
  • Excel for Business & Analytics Certificate : Core
Loading...
Thank you for your interest in this course. Unfortunately, the course you have selected is currently not open for enrollment. Please complete a Course Inquiry so that we may promptly notify you when enrollment opens.
Required fields are indicated by .
University of Wisconsin - Milwaukee, School of Continuing Education

Contact Us

161 W Wisconsin Ave., Suite 6000 Milwaukee, WI 53203
sceinfo@uwm.edu

Site

  • Courses
  • Credentials
  • Program Areas

Follow Us

Facebook Twitter Instagram YouTube LinkedIn
Powered by Lifelong Learning EE
The School of Continuing Education uses cookies to help give you the best experience with our registration system. By continuing without changing your cookie settings, we assume you agree to this. Please read our cookie policy. UWM collects information from website visitors. For information on what information is collected, how this information is used, and with whom the information is shared please review UWM’s website privacy statement.

Session Time-Out

For security reasons and the protection of your personal information, your session will time out due to a period of inactivity in minute(s) and second(s). Click Extend My Session to continue. For security reasons and the protection of your personal information, your session timed out after a period of inactivity. You will be redirected to the home page.

Confirm

Alert

Processing...

Privacy Policy

Cancellation Policy

To cancel, log into your student portal, go to "Enrollment History," and select "Request Drop" next to the course. Refund eligibility depends on notice, course type, and fee:

  • 30+ days prior to start of course: Full refund.
  • 15-29 days prior to start of course: Refund minus a 25% administrative fee.
  • Less than 15 days prior to start of course: No refund.

Exceptions (No Refunds):

  • Osher Educational Travel/Go Explore and College for Kids & Teens courses.
  • Courses with a fee of $35 or less.
  • On-demand online courses after the student has accessed the learning environment.
  • Conferences/Special Events (specific policy will be in registration terms).
  • Special requests and non-course fee items (e.g., memberships, textbooks) are non-refundable.

If the School of Continuing Education cancels a course, a full refund will be issued.

Invoicing Policy

  • If "invoice full amount" is selected, payment is due 14 days before the course start.
  • Failure to pay by the due date may result in cancellation of your registration.
  • For Agency payments (AmeriCorps, DVR, MyCAA, etc.), contact sceinfo@uwm.edu for next steps.
  • Automated payment reminders will be sent until the balance is paid.

Third Party Expenses

The School of Continuing Education does not provide refunds for any expenses (such as travel, accommodations, or materials) incurred by students due to a course cancellation or a student's self-cancellation. We strongly recommend booking refundable/transferable travel and accommodations, and purchasing materials with a return window extending beyond the course start date.

Collections Policy

Participants who fail to make timely payments agree to pay all collection costs incurred by UWM (agency fees, legal fees, etc.) and any late fees. UWM may also certify the past-due balance to the Wisconsin Department of Revenue and claim the total due against any refunds or payments owed to the participant.

Photography and Media Usage

The School of Continuing Education may take photographs, video, and other media during courses and events for educational, promotional, and advertising purposes. Virtual programs may be recorded for marketing and content sharing.

Conduct Information and Disciplinary Measures

No firearms or weapons are allowed on UWM property.

Participant conduct policies are based on the following UW System Administrative Codes, which may result in probation, suspension, or dismissal from all UWM functions:

  • UWS Chapter 14 – Student Academic Disciplinary Procedures
  • UWS Chapter 17 – Student Nonacademic Disciplinary Procedures
  • UWS Chapter 18 – Conduct on University Lands

Cookie Policy

Cookie policy

This statement explains how we use cookies on our website. For information about what types of personal information will be gathered when you visit the website, and how this information will be used, please see our privacy policy.

How we use cookies

All of our web pages use "cookies". A cookie is a small file of letters and numbers that we place on your computer or mobile device if you agree. These cookies allow us to distinguish you from other users of our website, which helps us to provide you with a good experience when you browse our website and enables us to improve our website.

Types of cookies we use

We use the following types of cookies:

  • Strictly necessary cookies- these are essential in to enable you to move around the websites and use their features. Without these cookies the services you have asked for, such as signing in to your account, cannot be provided.
  • Performance cookies- these cookies collect information about how visitors use a website, for instance which pages visitors go to most often. We use this information to improve our websites and to aid us in investigating problems raised by visitors. These cookies do not collect information that identifies a visitor.
  • Functionality cookies- these cookies allow the website to remember choices you make and provide more personal features. For instance, a functional cookie can be used to remember the items that you have placed in your shopping cart. The information these cookies collect may be anonymized and they cannot track your browsing activity on other websites.

Most web browsers allow some control of most cookies through the browser settings. To find out more about cookies, including how to see what cookies have been set and how to manage and delete them please visit http://www.allaboutcookies.org/.

Specific cookies we use

The list below identify the cookies we use and explain the purposes for which they are used. We may update the information contained in this section from time to time.

  • JSESSIONID: This cookie is used by the application server to identify a unique user's session.
  • registrarToken: This cookie is used to remember items that you have added to your shopping cart
  • locale: This cookie is used to remember your locale and language settings.
  • cookieconsent_status: This cookie is used to remember if you've already dismissed the cookie consent notice.
  • _ga_UA-########: These cookies are used to collect information about how visitors use our site. We use the information to compile reports and to help us improve the website. The cookies collect information in an anonymous form, including the number of visitors to the website, where visitors have come to the site from and the pages they visited. This anonymized visitor and browsing information is stored in Google Analytics.

Changes to our Cookie Statement

Any changes we may make to our Cookie Policy in the future will be posted on this page.