Course Description
Microsoft Excel is one of the major workhorses in the Microsoft Office suite of applications and arguably the most widely-used Office product. A solid understanding of how to use this program is vital to nearly everyone in most industries today. This course is designed specifically to teach you the fundamentals of Excel and give you the skills you need to begin to create and manipulate worksheets. Specifically, you will understand how to create, save, enter data, and print spreadsheets in addition to learning how to create formulas and use functions to calculate in Excel. You will learn how to enter data, format spreadsheets, manipulate columns and rows, add headers and footers, and use page setup options to prepare them for printing. You will also learn how to handle large worksheets or multiple workbooks, use styles and themes, insert various graphic objects, and options for proofing your workbooks.
Instructor: Ed McCrae
Student data files are available under Downloads in the course dashboard.
What am I going to get from this course?
- Learn to create simple worksheets
- Understand calculation hierarchy and the Order of Operations
- Add columns and rows
- Format and align worksheet data
- Use cell styles and themes
- Proof and print a workbook
- Manage Worksheets
Prerequisites and Target Audience
What will students need to know or do before starting this course?
Who should take this course? Who should not?
Anyone who needs to create or maintain worksheets
Curriculum
Module 1: Introduction
01:03
Resource 1
Student Data Files
Module 2: Getting Started with Excel
23:36
Lecture 2
What is Excel?
02:01
Lecture 3
Opening Excel
04:25
Lecture 4
Navigating the Excel User Interface
07:48
Lecture 5
Using the Excel Ribbon
02:55
Lecture 6
Understanding Excel Worksheet Components
03:55
Lecture 7
Using the Backstage View
02:32
Module 3: Creating Workbooks and Using Templates
14:04
Lecture 8
Creating a New Workbook
03:01
Lecture 9
Creating Workbooks Using Templates
03:24
Lecture 10
Saving an Excel Workbook
05:20
Lecture 11
Using Convert and Checking Compatibility
02:19
Module 4: Entering Data
25:18
Lecture 12
Navigating a Worksheet by Mouse or Keyboard
04:52
Lecture 13
Understanding Excel Data Types
02:50
Lecture 14
Working with Cell and Range Addressing
02:20
Lecture 15
Using Various Data Selection Techniques
05:14
Lecture 16
Working with Common Excel Commands
07:25
Lecture 17
Using the Autofill Handle
02:37
Module 5: Excel Formula Basics
27:07
Lecture 18
What are Formulas and Functions?
02:02
Lecture 19
Understanding the Components of a Formula
05:39
Lecture 20
Understanding Calculation Hierarchy and the Order of Operations
02:26
Lecture 21
Creating Basic Formulas
08:09
Lecture 22
Working with Basic Functions and AutoSum
03:59
Lecture 23
Using Cell References
03:37
Lecture 24
Using the Quick Analysis Tool
01:15
Module 6: Adjusting a Worksheet
09:14
Lecture 25
Modifying Columns and Rows
06:08
Lecture 26
Hiding and Unhiding Columns and Rows
03:06
Module 7: Formatting and Aligning Worksheet Data
19:56
Lecture 27
Formatting and Aligning Data
05:47
Lecture 28
Merging Data
03:52
Lecture 29
Wrapping Text and Adjusting Orientation
01:45
Lecture 30
Formatting Numbers
03:10
Lecture 31
Using Borders and Shading
02:37
Lecture 32
Using the Format Painter
01:21
Lecture 33
Removing Formatting Quickly
01:24
Module 8: Using Cell Styles and Themes
09:14
Lecture 34
Understanding Cell Styles
01:38
Lecture 35
Applying Cell Styles
04:23
Lecture 36
Applying Themes
03:13
Module 9: Inserting Objects and Graphics
30:37
Lecture 37
Inserting and Formatting Images
02:46
Lecture 38
Inserting and Formatting Shapes
04:27
Lecture 39
Inserting and Formatting SmartArt
03:47
Lecture 40
Inserting Screenshots
02:17
Lecture 41
Inserting Hyperlinks
02:37
Lecture 42
Inserting Symbols and Equations
03:13
Lecture 43
Inserting WordArt and Text Boxes
03:50
Lecture 44
Inserting Other Excel Objects
03:53
Lecture 45
Arranging Objects
03:47
Module 10: Proofing a Workbook
13:03
Lecture 46
Using Find and Replace
03:43
Lecture 47
Finding and Replacing Formatting
01:19
Lecture 48
Using Go To and Go To Special
02:23
Lecture 49
Using the Spell Checker
02:34
Lecture 50
Using the Thesaurus and Translation Features
03:04
Module 11: Printing an Excel File
20:11
Lecture 51
Printing and Previewing Excel Files
02:57
Lecture 52
Creating Custom Margins and Scaling
04:53
Lecture 53
Adding Headers and Footers
03:40
Lecture 54
Formatting a Page with the Page Layout Tab
02:34
Lecture 55
Printing Titles and Specific Worksheet Areas
04:31
Lecture 56
Exporting to PDF and XPS
01:36
Module 12: Managing Worksheets
11:58
Lecture 57
Renaming and Coloring Worksheet Tabs
02:34
Lecture 58
Adding, Deleting, and Navigating Worksheets
03:29
Lecture 59
Moving and Copying Worksheets
03:44
Lecture 60
Hiding and Unhiding Worksheets
02:11
Module 13: Navigating and Viewing Excel Files
18:25
Lecture 61
Viewing Workbooks
02:44
Lecture 62
Using Zoom Tools
02:13
Lecture 63
Configuring Sheet Options
02:16
Lecture 64
Using the Freeze Panes and Split Commands
04:49
Lecture 65
Working with Window Commands
03:41
Lecture 66
Adjusting Workbook Properties
02:42
Module 14: Conclusion
01:42
Lecture 67
Course Recap
01:42
