Have you ever wondered why Excel is one of the most powerful applications used today by many businesses? Excel is one of the most important applications that you can study now to take your skills to the next level!

This course will help you increase your efficiency by learning how to organize, display and calculate your data into useful information. Find out how you can consolidate your data proficiently into readable rows and columns using different table designs and styles. Create a unique style for yourself to improve your spreadsheet appearance to make the content easier to understand for your target audience. Learn from the trainer on how beneficial it is to become more productive in generating different everyday business functions. Discover how easily pivot tables can be created to quickly summarize large amounts of data. Through this course, these tasks will make your work outstanding and unique in what you do.

One month course, Amy Klous, instructor.

 outlineCourse Outline
 
 
Unit 1 - Organizing Worksheet and Table Data
·         Introduction to tables
·         Formatting tables using table styles
·         Using formulas in tables
·         Sorting and Filtering table data
 
Unit 2 - Understanding Popular Excel Functions
·         Understanding Named Ranges
·         Applying business functions
·         Creating functions that handle text
·         Performing basic lookup functions
·         Creating functions that work with dates and times
 
Unit 3 - Improving Worksheet Appearance
·         Formatting cells in worksheets
·         Correcting common function errors
·         Creating and using templates
·         Customizing Excel toolbar
 
Unit 4 - Analyzing Data Using Data Validation and Pivot Tables
·         Understanding how to convert text to columns
·         Understanding how to analyze spreadsheet data 
·         Understanding the basic pivot table layout and key terms
·         Creating and formatting simple pivot tables

Question MarkAbout 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. 

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

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

ChecklistWhat you will do

For each Unit, you will:

  • Access the online readings
  • Listen to the audio presentation for the Unit and view the slides
  • Take 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 day.

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.

DiscussionDiscussion

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 day to maximize your learning and enjoyment of the course.

It’s easy. It’s fun.

Next offering(s):

Advanced Excel
April 1 - 26
June 3 - 28
August 5 - 30
November 4 - 29

Intermediate Excel
May 6 - 31
July 1 - 26
October 7 - November 1

Mastering Microsoft Excel
April 1 - 26
June 3 - 28
September 3 - 28

Add Certificate To Cart
$495.0000 USD
$195 USD

Ave. hours 16, 1.6 CEUs/ILUs

About Your Instructor

Amy Klous completed a BA in Entrepreneurship and an MBA. She has nearly 20 years experience in marketing and the majority of that time was spent working for corporations using Excel to analyze sales and industry data.  Her Excel students appreciate the hands-on learning and Amy’s patient teaching style. Amy runs a marketing advising + training business where she helps overwhelmed small businesses feel comfortable and understand how to market their business effectively.

Completion Requirements