Loading...

Course Description

Microsoft Excel is the most widely used spreadsheet tool in the world. Keep your Excel skills current with this class, as it change with the features of Excel over time. Learn how to construct an Excel worksheet, populate it with content, and edit it for delivery in a variety of business situations. Master the options that will take your Excel worksheet from a collection of plain, drab numbers to an engaging multimedia presentation.

About Your Instructor

 
 
Betsy Flanagan is a business architect, innovator and entrepreneur. With a passion for workforce engagement, she co-founded WorkStrengths where she advises individuals on career strategy and companies on best practices in workforce management including talent management, professional development, motivation and retention strategies. Flanagan’s professional history includes founding successful startups, top corporate executive strategic advisory work, line management responsibility in startups and large organizations, innovation and change management agent, and being Investor Relations company spokesperson for a Fortune 25 company.

Course Outline

Unit 1
Excel From The Ground Up
Why businesses use Excel for spreadsheet management
Technical requirements to use Excel (and all Office modules)
Launch Excel and create your first Excel worksheet
Discover how to protect and save your document
Set your document’s Properties and Attributes including Subject, Title and Author
 
Unit 2
Excel Document Creation
Explore the different parts of the Excel worksheet and document navigation
Understand cells and their makeup
Learn how to populate, format and merge cells
Create multiple worksheet “workbooks”
Learn how to insert comments and check spelling
 
Unit 3
Advanced Features and Functionality
Create and manage formulas and functions
Filter and sort tables and data
Create “live” connections between multiple worksheets
Create effective and informative table and charts
 
Unit 4
Excel Management and Sharing
Create meaningful file names and understand filing systems to manage Excel documents
Organize your documents on your hard drive and learn how to copy and move documents
Manage track changes when co-authoring documents
Printing and PDF file creation including setting print areas
Learn how to export Excel tables and charts to PowerPoint presentations and Word documents
Use Outlook to send Excel worksheets and workbooks to other users
 

Learner Outcomes

Upon completion of this course you will:
  • Understand how to use Excel to create effective spreadsheets for use in business
  • Know what the various parts of a Excel worksheet are and how to control them
  • Understand how to create a Excel worksheet from scratch
  • Learn how to add pictures, charts, graphs and labels to your work
  • Understand what is most effective in the presentation and delivery of your Excel worksheets and workbooks
  • Have created several Excel worksheets that you can use as templates for future work
 

Notes

Course Objectives
  • Learn how to operate Excel as a spreadsheet creation and management tool
  • Understand the various kinds of spreadsheets that Excel can read and create
  • Discover how various menu items, commands, settings and processes affects the look of your Excel worksheets and workbooks
  • Use Excel in practical applications for every day business use
  • Explore how Excel integrates with other Office modules, like Outlook, Word and PowerPoint
 

Applies Towards the Following Digital Badges

Loading...
Enroll Now - Select a section to enroll in
Section Title
MASTERING MICROSOFT EXCEL
Type
Online-Self Paced
Dates
Sep 07, 2021 to Oct 01, 2021
Contact Hours
16.0
Course Fee(s)
Tuition non-credit $195.00
Section Notes

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

Required fields are indicated by .