Microsoft® Excel® Basics Agenda
Seminar: ID# 1003786
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!