Skip to content

Mastering Microsoft Excel


Adult Programs / Professional Development -
Adult Online Professional & Personal Development Spring/Summer 2024

Stay current with this class. 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. 

This course can be taken alone or as part of the 3 course Certificate in Mastering Excel. 

Class Details

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

For more information, visit our question and answer page - Click Here.

Betsy Flanagan

LERN 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.
 June 2024 
SuMTuWThFSa
 
 
 
 
 
 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
 
 
 
 
 
 
SLCERT20A2

  Learning Resources Network, Inc , Betsy Flanagan


Virtual Class
Sun-Sat, Jun 3 - Jun 28
12:01 AM - 11:59 PM

Su
M
Tu
W
Th
F
Sa

Min Age   16 yr.

$ 195.00
single course