Loading...

Course Description

This course will help you learn how to organize, display and calculate your data into useful information. Find out how to 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. 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.

Note: This course is part of a Digital Badge for those who wish to earn a credential. You may register for this individual class, but if If you would like to earn the Digital Badge, register for LRN0091- Online Self-Paced Excel Digital Badge.

Course 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

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.

Applies Towards the Following Digital Badges

Loading...
Enroll Now - Select a section to enroll in
Section Title
Intermediate Excel
Type
Online-Self Paced
Dates
Jul 01, 2024 to Jul 26, 2024
Contact Hours
16.0
Course Fee(s)
Tuition non-credit $195.00 Click here to get more information
CEUs
1.6 CEUs
Section Notes

For further information on this course, please contact dlanpher@harpercollege.edu.

Required fields are indicated by .