Training

Home Contact Resources Services Training Software About

 


Microsoft® Excel Training
by Krause Practice Management
 
This introductory course is designed for users new to Excel or those users who want to learn a little more about the basic functions of the program.

Introductory Excel Training Outline

Getting Around in Excel

Worksheets and Workbooks

Renaming a Worksheet

Spreadsheet Basics

Cells, Columns and Rows

Absolute vs. Relative References
Relative References
Absolute References

Entering Data

Entering Labels
Entering Data

Inserting a Row or Column into a Worksheet

Manipulating Data

Changing Column Width or Row Height

Copying Cell Contents using Copy and Paste

Using the AutoSum Button

Using AutoFormat

Moving a Range Using the Mouse

Hidden Data

Grouped Data

Formulas and Advanced Calculations

Entering Formulas

Copying a Formula using the Fill Handle

Common Functions
Building Formulas by Pointing

Charts and Graphics

Using Excel to create Graphs and Charts

Printing and Reports

Displaying and Printing Worksheet Formulas

Page Setup Options
Adding Headers and Footers

Stay current, Sign Up for our Monthly Newsletter

LexisNexis is a registered trademark of Reed Elsevier Properties, Inc., used under license. Time Matters, Billing Matters and HotDocs are registered trademarks and PCLaw is a trademark of LexisNexis, a division of Reed Elsevier, Inc. All Rights Reserved.