Excel 2010-2019
Excel 2007
Excel 2003
Tips & Tricks
Excel Forum
Course Index CIG Excel Book
Home   Courses   Index   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon  
Courses - Microsoft Excel 102
Description: Using Microsoft Excel
Running Time: 79 minutes
Pre-Requisites: Excel 101 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 7/28/2024 to get a FREE upgrade to our 2007 version when released!

 Click here for the Teacher's Outline
This class picks up where Excel 101 leaves off and covers many more features of this powerful spreadsheet program including AutoFill, creating a calendar, sorting data, and the big one: creating professional-quality charts and graphs!

click to enlarge

We begin by learning more about AutoFill, a very powerful feature of Excel. We'll see how you can use AutoFill to create lists of the days of the week, months of the year, number series, date sequences, and more.

We'll create a calendar using AutoFill that you can print out and use to plan your day. In doing so, we'll teach you about zoom ratios, neat tricks with resizing columns, and the Format Painter.

We will also spend time learning how to make cool borders to give your spreadsheets that professional touch.

You will learn how to use the Format Cells feature to gain even more control over the look and feel of your data.

Next, we'll build a sheet to track commissions for sales reps. We'll learn a lot of techniques such as how to use the currency style, increase and decrease decimal points, and more.

We'll learn about the quick-and-dirty AutoSum feature.

We'll then show you several ways to sort data in your spreadsheets. You will learn the proper way to sort data so as not to scramble your information.

We'll teach you how to sort your data by any column in a range of cells.

You will also learn how to sort based on multiple columns (last name, then first name, for example).

After sorting, we'll spend a great deal of time building charts. We'll build a simple 2D column chart, teach you how to manipulate it, change colors, axes labels, and other features.

We'll then make a more complex 3D column chart. We'll go through more of the charting options, such as gridlines, axes labels, data labels, and so on.

We'll teach you how to create fill effects, gradients, textures, and patterns in your charts.

We'll show you how to rotate your 3D charts, and adjust elevation and perspective.

We spend a lot of time learning how to build quality charts!

click to enlarge

After building a 3D column chart, we'll take you through creating a 3D pie chart. We'll show you how to add data labels, leader lines, and other features. You'll learn how to rotate your pie chart, separate the pie slices, and make other advanced adjustments.

This is a great course for someone who knows a little Excel, but wants to learn more... AutoFill is a very powerful timesaver. Knowing how to sort data properly is essential. Every business user should know how to create effective charts.


 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 2024 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 7/25/2024 1:08:58 PM. PLT: 0s