How It Works

Course outcomes

At the end of the course:
  • The student will learn different condition types and know to how to apply it to Excel functions.
  • The student will make accurate business conclusions derived from various financial functions and calculations.
  • The student will understand cause and effect circumstances by changing data and how it can influence business decisions.
  • The students will be able to apply different data scenarios to find optimal solutions for proper business decisions.
  • The student will learn a variety of Excel’s most powerful features to analyze data quickly and easily.

Course objectives

Upon successful completion of this course, students will be able to:
  • Understand and apply logical functions to their data in the worksheet.
  • Demonstrate the need to learn and apply financial functions to data.
  • Create data rules to determine types of data entered into a cell.
  • Demonstrate working knowledge on how entered data can effect formulas and influence business decisions.
  • Determine how to protect data in the workbook.
  • Make effective business decisions by using a variety of data analysis tools
  • Design a visual interface in spreadsheet to view relevant information.

About Online Learning

Online learning is a fun, enjoyable and very productive way to learn. Millions of people are learning online each year. You will engage with the instructor and other participants. You will get to know your instructor and other participants. You may make friends. It's easy. It's fun.
UGotClass Refund Policy:
We are happy to offer a full refund through the second week of a class or certificate. After the second week of class no refund will be provided. Please email with any questions. 

How the Course Works

It is easy to participate in your online course. After you register, you will be given a web address to go to get into your online classroom. You will have a password and use your email address and password to gain access. Once inside the online classroom, here's what you can expect.

What You Will Do

For each Unit, you will:

  • Read the print readings (about 20 pages a week)
  • Have the option of accessing the online readings
  • Listen to the audio presentation for the Unit and view the slides
  • Have the option of taking a self-quiz to see how much you have learned
  • Engage in written online discussion with your instructor and other participants

For best learning, you should make one or more comments at 2-3 different times each week.
The content (readings, audio lectures, slides) and self quizzes are accessible for the entire course, so you can work ahead, or go back and review again, at your convenience.

Participate When You Want

You can participate any time of day or evening. The online classroom is open 24 hours a day, 7 days a week. There are no live real-time requirements or meetings. You decide when you participate.

For the best learning, participants should log into the course on 2-3 different days of the week.


The Discussion for each Unit lasts one week. All comments are made in writing and can be made at any time of the day or night.

Your instructor will log into the Discussion area at least once a day and answer questions, make comments, and respond to comments by you and the other participants.

We encourage you to make 2-3 comments each week to maximize your learning and enjoyment of the course.

It’s easy. It’s fun.

Learn about the other courses which are part of the same certificate:

Next start date

Aug 5 – 30