In this self-paced beginner Excel workshop, you’ll learn the essentials of Microsoft Excel, including calculations, basic functions, charts, formatting, and printing. Designed for those with limited experience, the course helps you build confidence using Excel through practical, hands-on exercises. You’ll follow along with examples and then complete activities on your own, and by the end of the course, you’ll have a training guide you can reference whenever you work in Excel.
After completing Excel Level I, you’ll gain access to a comprehensive video suite with beginner-level lessons that can be viewed on desktop, mobile, or tablet. These videos break down common Excel tasks into clear, easy-to-follow steps while reinforcing key skills such as navigating the Excel interface, entering and managing data, using essential formulas and functions, formatting and printing worksheets, creating charts, managing workbooks efficiently, and completing a final project to solidify your learning.
Course Outline
Introduction
Interface
-
Provides a brief description of the user interface for Microsoft Excel
Worksheets
-
Manage elements of worksheets
Data Entry
-
Examines and describes multiple means of entering data
Rows & Columns
-
Insert, delete, hide, and group rows and columns
Formulas
Autofill
-
Explores Excel's amazing ability to predict and extrapolate patterns
Calculations
-
Perform mathematical expressions and review the Order of Operations rule
AutoSum Functions
-
Review the five key functions: Sum, Average, Max, Min, and Count Numbers
Absolute Reference
-
Changing a cell reference into a constant, which is necessary for certain calculations
True or False
-
Tests to see whether criteria are true/false
Text Functions
-
Introduces functions used to modify text in Excel
Multi-Input Functions
-
More advanced functions that require more than one input
Formatting
Formatting
-
The addition of effects to an Excel document to provide visual instruction
Cell Styles
-
Apply consistent formatting to specific types of cells or values
Conditional Formatting
-
Apply a predetermined format based on specified rules
Charts & Tables
Tables
-
Explore the special functionality created when data is converted to a Table
Column Chart
-
Create a Column chart to visually examine data
Line Chart
-
Create a Line chart and Sparklines to visually examine data
Pie Chart
-
Create a Pie chart to visually examine data
Workbook Management
Freeze Panes
-
Enable a portion of the screen to stay visible at all times
Printing
-
Rules and strategies to make printing easy
Windows
-
Change how your worksheet displays data
Templates
-
Use prefabricated templates to build a spreadsheet
Excel Tricks
-
Fundamental keyboard shortcuts and other Excel tricks
End of Class Projects
Projects
-
End of class projects to review key concepts from the class
This course is available for 30 days. You can choose when to start your access period. Once you activate, you will have 30 days to complete it (access the course materials, quizzes, projects and videos). You may request one extension of seven (7) days. Other extension requests will be evaluated on a case-by-case basis. Videos are not downloadable.
