Excel 2010/2013
Excel 2007
Excel 2003
Tips & Tricks
Excel Forum
Course Index CIG Excel Book
 
Home   News   Tips   Glossary   Templates   Forums   Help   Logon   Order   Contact Us  
 
 
 
Courses - Microsoft Excel 102
Description: Using Microsoft Excel
Running Time: 79 minutes
Pre-Requisites: Excel 101 strongly recommended
Versions:
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 9/17/2019 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

 
 

You may want to read these articles from the 599CD News:

 

Learn
 
Accessindex
Excelindex
Wordindex
Windowsindex
PowerPointindex
Photoshopindex
Visual Basicindex
ASPindex
Seminars
More...
Customers
 
Account Login
Online Theater
Downloads
Lost Password
Free Upgrades
Insider Circle
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Articles
Search Our Site
Waiting List
Production Schedule
Collapse Menus
Help
 
Live Chat
Customer Support
WalkThru Tutorials
Troubleshooting
FAQs
TechHelp
Consulting Services
About Us
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Order
 
Video Tutorials
Handbooks
MYOLP Memberships
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Gift CDs
Contact
 
Live Chat
General Info
Support Policy
Contact Form
Email Us
Mailing Address
Phone Number
Fax Number
Course Survey
Facebook    Twitter

Google Plus    LinkedIn

Blog RSS Feed    YouTube Channel
Richard Rost Microsoft MVP