Hello, and welcome to Beginning Excel – Mastering the Basics. This online course is based on a hands-on Beginning Excel class I’ve been teaching since 1992. More than ten thousand students from all walks of life have successfully completed that course – and you can too! Only now, you can attend in the comfort and safety of your own home or office.
Section 1 - Welcome:
This course is designed for people with little or no experience with Excel, and for those looking for a quick refresher. It includes a series of video lessons that explain key concepts in a clear, step-by-step manner. You can watch as I explain and demonstrate each topic. Feel free to skip topics you already know.
Each lesson builds on skills learned covered in previous lessons, and each section includes at least one exercise so you can practice what you’ve learned. After completing this course, you’ll be able to create a wide variety of different spreadsheets and charts. And you’ll learn many useful tips, tricks, and shortcuts along the way.
As you may already know, Excel is used to store, organize, and analyze text and numeric data. You can use Excel to track sales, do payroll, create profit and loss reports, invoices, budgets, calendars, lists, and much more.
Section 2 - Getting Started:
We cover the Excel User Interface, so you are familiar with important terms and what each part of the Excel screen is for. Then, we learn how to create a custom Quick Access Toolbar, so all our favorite commands are just one click away.
Next, we explain what each mouse cursor represents and when it is used. We follow up with basic file operations and some handy keyboard shortcuts.
Section 3 - Creating Spreadsheets:
First, we discuss design tips and "best practices" for Excel spreadsheets. Then, we cover the basics of formatting titles, headings, text, and values. Next, we learn how to add graphics, notes, comments, and hyperlinks. We show you how to fill in word, value, and date patterns and how to enter the same data on multiple spreadsheets simultaneously.
We complete this section with project. We use Excel to create a twelve-month calendar using many of the skills we learned in this section. You can just watch - or follow along!
Section 4 - Editing Spreadsheets:
In this section we learn how edit an Excel spreadsheet: We'll insert and delete columns and rows, move and copy sheets, and rename and change the color of sheet tabs.
Section 5 - Formulas & Functions:
We'll learn how to use AutoSum to total columns and rows. Next, we'll cover writing formulas so we can add, subtract, multiply, divide, and calculate percentages. Then, we'll learn four simple functions: Sum, Average, Max, and Min. We'll also learn how to copy formulas and functions and fix common formula errors.
We complete this section with two projects that incorporate skills we just learned. You can watch or follow along.
Section 6 - Printing Spreadsheets:
In this section we learn how to improve the printed output of a spreadsheet and how to fix common printing errors. We'll add headers, footers, and page numbers to a spreadsheet and learn how to make headings appear on all printed pages.
Section 7 - Creating Charts:
We cover the five most common Excel charts. Learn how to create and edit Pie, Doughnut, Column, Bar, and Line Charts. We'll finish this section with a project based on column charts.
Section 8 - Working with Large Spreadsheets:
Working with large Excel spreadsheets can be challenging so we cover some handy keyboard shortcuts for navigating and selecting cells. We'll learn how to use Freeze Panes to make column and rows headings visible as we scroll through a spreadsheet. Then, we'll use the Split Window feature to view different parts of a large spreadsheet. Finally, we'll learn how to hide and unhide columns and rows for viewing and printing purposes. We close out the section with a project so we can practice what we've learned.
Section 9 - Conclusion:
We wrap up the course and look forward to using what we've learned.