|This is the perfect class for anyone
who knows nothing about Excel, or has used Excel for a little
while, but needs to learn how to do more. We will take you from
knowing nothing to building a full fledged spreadsheet with functions in about an
We will cover many topics including
Excel basics, the parts of the screen, entering and editing data,
formatting your sheet, working with math calculations, functions
such as SUM and AVERAGE, cut, copy, and paste, AutoFill
basics, saving and loading your sheets, and finally printing your sheet.
click to enlarge
First, we show you how to start Microsoft Excel, and go over the
different parts of the screen: the title bar, the tool bars, the menu
bar, the spreadsheet area, and so on. We'll also talk about the parts of
a spreadsheet, such as columns, rows, cells, ranges, sheet tabs, etc.
(Note that these are screen shots from the actual
course - and from the optional printable handbook that you can get to
follow along with!)
Then, we'll teach you how to
customize Excel to make it a little easier to use. We'll turn the task pane
off, and fix your toolbars so they're easy to work with.
In lesson three, we'll show you how to enter
data into a spreadsheet. This is covered in the demo
lesson that's available to watch free here on the web site. We'll
show you how to enter data into rows and columns.
Lesson four covers editing data with both the
keyboard and mouse. We'll teach you how to edit data in place right on
the spreadsheet and how to use the formula bar to edit data as
well. We'll go over some shortcut keyboard tricks that will help you
edit data in your sheets as well. We'll teach you how to delete
data from cells, and then we'll show you how to undo mistakes, to
get back that data!
In lesson five, we'll spend some time making our
spreadsheet look professional. We'll go over fonts, font sizes,
bold, italics, underlining, column alignment, foreground and background
colors, and so on. We'll also show you a cool trick for
making your columns automatically resize themselves to the exact width
they need to be to fit the data in them.
Before we can learn advanced features like
functions, we have to show you how to do basic math calculations.
So, we'll show you the proper way to perform addition, subtraction,
multiplication, division, and so on in your spreadsheets. We'll also go
over the order of operations. Remember that from high school
In lesson seven, we'll show you your first
function. We'll spend some time talking about exactly what
functions are, and how they work.
Then, we'll teach you how to use the
SUM function to add up whole columns of numbers in a snap. We'll
also cover the AVERAGE function in detail. We'll show you some
shortcut tricks for entering your functions without having to type in
cell ranges. We'll also cover the functions MAX, MIN, and
Our courses are very hands-on with real world
examples. We'll take what we've learned about functions and sum up
the sales for our sales rep sheet we started earlier.
We'll spend some time going over cut,
copy, and paste in Excel. We'll show you also how to copy
large amounts of data and automatically update your functions using a
great feature called AutoFill. AutoFill will save you hours of
time from copying and pasting similar data in your spreadsheets.
Next we'll show you how to properly save
your workbook to disk, and then how to load it back up again.
We'll also cover some options for printing your spreadsheets.
This is the perfect beginner lesson for
anyone who needs to learn the basics of Excel. We'll get you up to speed
with how Excel works, and you'll be creating your own spreadsheets,
complete with functions and profession-looking formats, in about