A must-have skill to succeed in business, whether an entrepreneur or a valued employee, is the ability to create, edit and manage spreadsheets. Microsoft Excel is the most used spreadsheet tool in the world. Stay current with this class, as it is always up-to-date and will change as the features of Excel change over time. Examine the life of an Excel worksheet and workbook, from creation to presentation. Learn how an Excel worksheet is constructed, populated with content, and edited for delivery. Master the options that can take your Excel worksheet from plain, drab numbers to exciting and engaging multimedia. You will leave class with a set of skills that are in high demand and will be a deciding factor in your future success.
 
One month course; Betsy Flanagan, instructor

Agenda
 
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
 
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:

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

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


It’s easy. It’s fun.

Next offering(s):

Advanced Excel
August 7 - September 1
November 6 - December 1

Intermediate Excel
July 3 - 28
October 2 - 27

Mastering Microsoft Excel
September 5 - 29

Add Certificate To Cart
$495.00 USD
$195 USD
 
Ave. hours 16; 1.6 CEUs/ILUs



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.
 
Directional ArrowsCourse 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
Puzzle PiecesCourse 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
Completion Requirements