Microsoft Excel Basics: A One-Day Seminar

Starting with the basics and moving to more advanced features, this Excel training seminar will teach you how to turn Microsoft Excel into your most powerful productivity tool. If you're only tapping into a few of the features of this powerful and versatile software, get set for a productivity explosion! You'll learn hundreds of ways to work faster, smarter, and savvier with Excel!

You don't have to waste hours wading through thick manuals ... sitting in classes for days, even weeks ... fruitlessly punching keys in "trial and error" learning efforts — forget all that! Fred Pryor Seminars' guaranteed one-day basic Excel seminar gives you the most information possible in the least amount of time. Most of us don't have time in our busy workdays for extended training or "on-the-job" learning. Enroll in Microsoft Excel Basics today, and you'll master the basics and move on to the tough stuff — away from deadlines, demands, and office pressures.

Who will benefit ...

Our Microsoft Excel Basics seminar is perfect for both beginners and users with some experience. We recommend that attendees have some knowledge of Excel basics. The course is especially effective for beginners who want to learn more, as well as intermediate users who want to sharpen their skills and tap into Excel's more powerful functions.

How we present this material ...

This is not hands-on Excel training, and for good reason. Everyone works on computers at different speeds. Some people like to experiment, while others get lost and need help. In the long run, a hands-on class slows everyone down. Besides, you don't need practice moving your mouse. You do need to know how Excel's features work, how to use them, and where to activate them.

Our Excel training is just what you'll need to increase your productivity and take your current Excel skills to the next level! Save over 25% when you attend both Microsoft Excel Basics and Microsoft Excel: Beyond the Basics.

Microsoft Excel Basics — Seminar Overview

Excel Basics — A Quick Tour!
Building an Excel Worksheet from the "ground up"
Excel Formulas and Functions
Formatting Your Excel Worksheets
Excel Printing Options
Charting and Graphing your Excel Data

Excel Basics — A Quick Tour!

How to use the Toolbar buttons to perform tasks quickly.
Drop-down menus and Shortcut menus: the most efficient ways to access commands for any task.
Help for Help! How to find what you need in Help without endless searching and scrolling.
How to select cells and ranges of cells — 2 methods to choose from!
Excel Workbooks: the backbone to efficient file management.
How to find a single file or a particular workbook in record time.

Building an Excel Worksheet from the "ground up"

Tips for entering text and numbers, and a super-quick way to cancel or confirm your entry!
How to "backtrack" with Excel's Undo feature.
Use routines to replace data, correct errors, or see "what if" scenarios.
Ways to copy and move data without anxiety.
How to change the organization of your worksheet by inserting and deleting rows and columns.
The quick, fail-safe procedure to erase a cell or range of cells.

Back to Seminar Overview

Excel Formulas and Functions

Formula and Function basics — on-the-mark advice that will end confusion once and for all.
Mathematical formulas made easy: how to subtract, multiply, or divide data.
Basic Excel functions that let you calculate averages, percentages, and much more using "built-in" predefined formulas.
How to save time by copying formulas to appropriate cells in the worksheet.

Formatting your Excel Worksheets

The secrets to attractive, readable worksheets: 5 formatting guidelines that apply to any worksheet you produce.
How to control alignment, decimals, dollar signs, and more — in one easy operation.
How to format dates to be more readable and understandable.
Fonts, shading, and borders that increase the readability and attractiveness of your worksheet.

Back to Seminar Overview

Excel Printing Options

Print Options: the many choices Excel gives you to customize your printing. Plus, how to add headers, footers, and page numbers to a worksheet.
No more strange page breaks — how to set manual page breaks and ensure that your titles and labels print on every page.

Charting and Graphing your Excel Data

An easy-to-understand glossary of the terms used in charting and graphing data.
The Chart Wizard — how to easily produce vivid, exciting charts to accompany your data, even if you're a total novice!
Where to actually put your chart: all about embedded charts, separate charts, and chart sheets within a workbook.

Back to Seminar Overview