Excel 2010-2019
Excel 2007
Excel 2003
Tips & Tricks
Excel Forum
Course Index CIG Excel Book
Home   Courses   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon  
Courses - Microsoft Excel 221
Description: Intermediate Microsoft Excel - Data Analysis 2
Running Time: 75 minutes
Pre-Requisites: Excel 220 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 12/8/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. This course is the second in the series. This course covers AutoFilter, Custom AutoFilter, Advanced Filtering, Calculated Filters, Custom Views, and Subtotals.

We'll work with Filters a lot in this course. Filters allow you to weed out data you don't want and show just a specific set of data. For example, if you have a bunch stores in different cities, and you want to see sales from just your Toronto stores.


You can also use filters to show you the Top 10 items (or top 10%, or top 20 items, and so on).


You can use Custom Filters to show you, for example, all stores that have sales between $100 and $900.


You can create Advanced Filters to specify your own criteria row. This will let you create query-like structures in your Excel spreadsheets and really get the data you want!


We've got a great side project in this class where we take a long list of customers (some of whom are missing data), filter that data correctly, sort and filter by ZIP code...


...and then create mailing labels using Microsoft Word and a Mail Merge.


You will learn all about Filter Wildcard characters.


You will learn about Calculated Filters.


You will learn how to create Custom Views with your filter. This will allow you to set up special filters, such as "show me all Buffalo stores with at least $500 in sales," and "show me all Toronto stores with at least $300 in sales." You can then quickly switch between them using the toolbar.


Next we'll learn about the SUBTOTAL function, and how it's much better than SUM or AVERAGE when working with Filters. Why do you need it? What's the benefit? You'll find out!


You'll also learn how to create automatic Subtotals (not to be confused with the SUBTOTAL function). These are automatic subtotals for groups of records - like "show me the sales totals for each group of stores by month."


We'll talk a little bit about Grouping and Outlining. We'll discuss it in great detail in the next class (Excel 222).


Learning how to use Filters properly is the cornerstone for good, solid data analysis. Whether you've got a few records to filter, or several thousand, the lessons in this course will teach you how to manage that data.



 Click here for the Teacher's Outline

Try a FREE Demo Lesson



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    YouTube Channel

Copyright 2023 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 12/5/2023 3:32:49 AM.