A new session of each course opens each month, allowing you to enroll whenever your busy schedule permits!
How does it work? Once a session starts, two lessons will be released each week, for the six-week duration of your course. You will have access to all previously released lessons until the course ends.
Keep in mind that the interactive discussion area for each lesson automatically closes 2 weeks after each lesson is released, so you’re encouraged to complete each lesson within two weeks of its release.
The Final Exam will be released on the same day as the last lesson. Once the Final Exam has been released, you will have 2 weeks plus 10 days to complete the Final and finish any remaining lessons in your course. No further extensions can be provided beyond these 10 days.
Week One
Lesson 01 - Getting to Know Excel
Wednesday
This lesson introduces the fundamentals of Excel, including navigating its interface, understanding workbooks and worksheets, and mastering basic data entry. You'll learn how to input labels, numeric data, and fractions, move efficiently within a worksheet, and save your work in various formats, ensuring your files are well-organized and accessible.
Lesson 02 - Modifying a Worksheet's Structure
Friday
In this lesson, you'll explore how to modify the structure of a worksheet by selecting, moving, and copying data. Topics include inserting and deleting rows, columns, and cells, merging cells, and using shortcuts to streamline tasks. These skills will enable you to organize and manipulate data effectively.
Week Two
Lesson 03 - Using Formulas and Functions
Wednesday
This lesson focuses on creating and using formulas and functions to perform calculations in Excel. You'll learn about simple formulas, essential aggregate functions like SUM and AVERAGE, and time-saving tools like AutoFill and Flash Fill. These techniques will help you automate calculations and save time.
Lesson 04 - Formatting Cells and Their Content
Friday
Learn how to format cells, rows, and columns to enhance the readability and appearance of your data. This lesson covers text alignment, cell borders, fill colors, number formatting, and custom cell styles. These formatting techniques will give your spreadsheets a polished and professional look.
Week Three
Lesson 05 - Formatting and Printing a Worksheet
Wednesday
This lesson covers preparing your worksheet for presentation and printing. Topics include modifying page setup, applying headers and footers, using themes, and printing to PDF or other formats. You'll learn to optimize your worksheets for both digital and physical distribution.
Lesson 06 - Referring to Cells, Ranges, and Formulas
Friday
In this lesson, you'll explore cell references, including relative, absolute, and mixed references, and learn to name ranges for clarity and ease of use. You'll also practice resolving formula errors and using tools to display and troubleshoot formulas effectively.
Week Four
Lesson 07 - Using Multiple Sheets and Workbooks
Wednesday
This lesson focuses on managing and linking data across multiple sheets and workbooks. You'll learn to add, delete, and group sheets, reference data across worksheets, and link content to other applications, expanding your ability to manage complex projects.
Lesson 08 - Working with Tables
Friday
This lesson introduces Excel tables, showing you how to create, format, and manage table data. You'll explore sorting, filtering, adding totals, and using table styles to make your data more organized and interactive.
Week Five
Lesson 09 - Charting Data
Wednesday
This lesson teaches you to visualize data with charts. You'll create and modify various chart types, format chart elements, and apply styles to make your data presentations clear and impactful. Topics include pie charts, bar charts, and advanced chart customizations.
Lesson 10 - Using Aggregate, Statistical, and Financial Functions
Friday
This lesson explores several types of powerful functions. We start with a review of aggregate functions, and then turn our attention to statistical functions like AVERAGE and standard deviation, as well as financial functions such as PMT and PV to calculate loan values and payments.
Week Six
Lesson 11 - Creating Business Forms
Wednesday
This lesson explores using Excel to create professional business forms, including calendars, invoices, and purchase orders. You'll learn to design layouts, apply formatting, and incorporate formulas to create functional and visually appealing forms.
Lesson 12 - Working with Templates
Friday
In the final lesson, you'll learn to create and use templates to save time and ensure consistency across projects. Topics include using Excel's built-in templates, designing custom templates, and creating chart templates for reuse. This lesson helps streamline your workflow and maintain professional standards.