Excel 2010-2019
Excel 2007
Excel 2003
Tips & Tricks
Excel Forum
Course Index CIG Excel Book
Home   Courses   Seminars   Templates   TechHelp   Fast Tips   Forums   Help   Contact   Join   Order   Logon  
Courses - Microsoft Excel 220
Description: Intermediate Microsoft Excel - Data Analysis 1
Running Time: 74 minutes
Pre-Requisites: Excel 202 strongly recommended
We use Excel XP in this course, but the lessons are valid for all versions of Excel from 95 to 2003. There are cosmetic changes in Excel 2007. Order before 3/25/2023 to get a FREE upgrade to our 2007 version when released!

 Click here for the Teacher's Outline
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 toolbars.


You will learn how to add button commands to your toolbars.


You'll learn how to create your own custom toolbars.


I will show you how to attach your custom toolbars into your workbook files - so you can share them with others.


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 buttons!


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.



 Click here for the Teacher's Outline

Try a FREE Demo Lesson


Check out these other pages that may be of interest to you:

1/27/2023Math in Fields
12/12/2022Tax Brackets
12/9/2022Double Lookup
10/24/2022Follow Hyperlink
9/17/2022Very Hidden
7/26/2022Lottery Numbers 2
7/22/2022Lottery Numbers


The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.

Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
My Account
My Courses
Lost Password
Student Databases
Change Email
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Customer Support
Web Site Tour
Consulting Services
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    Twitter

YouTube Channel    LinkedIn
Copyright 2023 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 3/22/2023 6:12:52 PM.