Agenda

Take a Quick Tour of Excel Basics!

• Shortcut menus: the most efficient way to access commands for any task
• Help for Help! How to find what you need in Help without the endless searching and scrolling
• How to select cells or ranges of cells — 2 methods to choose from
• How to find a single file or a particular workbook in record time

Build a Worksheet From the Ground Up

• What to consider before you create a worksheet — expert advice on building a worksheet framework that will accomplish your objectives
• Tips for entering text and numbers, and a super-quick way to cancel or confirm your entry
• The view you need — how to zoom in and zoom out of your worksheet
• When titles and labels keep moving out of view: techniques to freeze them in place while you move around your worksheet

Harness the Real Power Behind the Numbers

• 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

Learn the Techniques That Produce Visually Exciting 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
• Fonts, shading, and borders that increase the readability and attractiveness of your worksheet

Get the Output You Want Without Trial-and-Error Printing

• 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

Add Impact and Visual Punch To Your 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

Gain Speed, Efficiency, and Ease At Every Session!

• Large worksheets with Split Windows — the best way to effortlessly view distant figures side by side
• For mouse-haters: a quick guide to shortcuts that keep your hands on the keyboard
• An end to macro mystery — how you can automate many tasks using macros

Our Excel training is just what you'll need to increase your productivity and take your current Excel skills to the next level!