|In this series of Excel courses
(220-224) we will study Data Analysis. We will begin in this
class by learning about Data Lists. We will learn how to create
them, edit them, and format them. We will also work with Data Entry
Forms. We will learn advanced sorting techniques for data
lists. We will also learn how to customize our toolbars.
We will start out with an introduction to Data
Lists. We will learn about fields and records.
We will learn how to use the Pick From List
feature when entering items in a data list.
In one of our example side projects, you'll learn
one of the most-requested topics: how to calculate the difference in
time (in hours) between two times.
You will learn how to create and work with Data
Entry Forms to add or edit data in your worksheets. You might be
comfortable working just in the spreadsheet, but Data Entry Forms are
great for giving the sheet to someone else - say a secretary who isn't
that familiar with Excel.
We will learn some advanced sorting techniques,
such as how to get a list of month names to sort by month order - and
not alphabetically! You try that one at home.
We'll also take some time to study the rules of
alphanumeric sorts - and exactly what goes where and how.
Finally, we'll learn how to customize our
toolbars and create our own custom toolbars. Yes, this isn't exactly
a data analysis feature, but a lot of the features we will be working
with in the next couple of classes are buried deep in menus - and being
able to make our own custom toolbars will save us lots of time.
We'll see how to customize the existing built-in
You will learn how to add button commands
to your toolbars.
You'll learn how to create your own custom
I will show you how to attach your custom
toolbars into your workbook files - so you can share them with
You'll learn how to use the Button Editor
to modify or create your own custom button images - and I'll show you
how to take an image out of any drawing application and put it on your
Some buttons play dual roles - like if you hold
down the SHIFT key and click on the Sort Ascending button, you
actually get a Descending sort. I'll teach you with other buttons
to that - to save you time and space on your toolbars.
Finally, I'll show you where your custom toolbars
are all saved on your hard drive - so you can back them up or copy them
to another computer.
If you are planning to learn about data
analysis using Excel, this is the first course in our data analysis
series. You don't want to miss this course. All of the rest of the
courses in this series will build on this one - with data lists and the
techniques we learn in this class.
Future classes in the data analysis series will
include Pivot Tables, Database Functions, AutoFiltering,
Custom Views, Subtotaling, Styles, Grouping & Outlining, Pivot Charts,
Scenarios, Solver, Importing and Scrubbing Data, Consolidating,
Validating Data, Auditing, and more.
Don't miss Excel 220.