When you attend this power-packed Excel 2007 training, you'll get ...
- On-the-mark advice about Formula and Function basics to end
confusion once and for all
- Excel 2007 tips for creating a worksheet framework that will acccomplish
your objectives: worksheets that work for you!
- Number-crunching capabilities with Basic Excel functions: how to calculate
averages, percentages, and much more using "built-in" predefined formulas
- An overview of the Ribbon — Excel 2007's revolutionary new command
center that makes most menus and toolbars obsolete!
- The secret to attractive, readable worksheets: 5 formatting guidelines
that apply to any worksheet you produce
- Tips and tricks for error-free printing every time to make your
printing woes a thing of the past!
- Pizzazz for every document as you instantly transform complex information and
statistics into easy-to-understand, colorful tables, charts, and graphs
- Techniques for streamlining many of your repetitive tasks when you bring the
muscle of macros into play
- And much, much more!
Introducing Excel 2007 — more powerful, more streamlined, and more
user-friendly than ever before!
Whether you are just beginning to use Excel, looking to upgrade your skills, or
working toward a comprehensive understanding of the exciting new features and
functions, this Excel 2007 tutorial will provide the training you need to quickly and confidently
build spreadsheets ... track and analyze data ... create sophisticated reports, charts,
and graphs ... perform complex calculations with just a mouse click ... and much, much
more. Data entry, keyboard shortcuts, printing tips, cell maneuvering, hyperlinks,
embedding, macros — we'll cover it all, utilizing the latest in adult learning
techniques and instructional methods.
A host of brand-new features puts incredible power, flexibility, and control
at your fingertips!
Excel 2007 is truly revolutionary because, for the first time, you don't have to
deal with all those pull-down menus, toolbars, and task panes. Instead, a simplified
command control structure — the Ribbon — stretches across your worksheet
so that the commands you use most frequently are within easy reach at all times. Many of
the Excel 2007 new features and functions have been streamlined and simplified,
making it easier than ever before to crunch numbers ... track, organize, and analyze
data ... produce colorful, professional-looking charts ... perform complex calculations ...
and create and maintain sophisticated, reliable spreadsheets.
Other outstanding Excel 2007 new features include the Live Preview, which allows you to preview
all of your formatting choices before you select them; the Page Layout View; a host
of exciting new pop-up style galleries, including Table Quick Styles and Cell Styles; the
Quick Access Toolbar; and a new, enhanced version of the Conditional Formatting function.
Boost your productivity, enhance your capabilities, and excel with Excel —
all in just one day of concentrated training!
Excel is one of today's most powerful and versatile business tools, but if you're
not familiar with its basic functions, formulas, commands, and keystrokes, you're
setting yourself up for frustration and disappointment. This Excel 2007 training gives you strong
fundamentals to build on, leads you through more advanced concepts, reveals the most
important new features of Excel 2007, and sends you home with a concise, information-packed
workbook that summarizes everything you've learned.
Excel 2007 Training — Seminar Overview
Start with a quick overview of Excel basics
- 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
- 2 methods for selecting cells or ranges of cells
- How to find a single file or a particular workbook in record time
Move on to Worksheets 101
- What to consider before you create a worksheet
- Guidelines for building a worksheet framework that will accomplish your objectives
- The view you need — how to "zoom in" and "zoom out" of your worksheet
- A "freezing" solution to the annoying problem of titles and labels that move
out of view when you move around your worksheet
Speed through calculations and formulas
- Helpful hints that take the mystery out of Formula and Function basics
- Mathematical formulas made easy: how to subtract, multiply, or divide data
- Expert tips on Basic Excel functions for calculating averages, percentages, and much
more using "built-in" predefined formulas
Build visual power into your worksheets
- 5 formatting secrets that make any worksheet more attractive and readable
- How to control alignment, decimals, dollar signs, and more — in one easy operation
- Fonts, shading, and borders for more effective, eye-pleasing worksheets
Produce good-looking, hard-working documents
- Print Options: a look at the many ways Excel lets you customize your printing
- Tips for adding headers, footers, and page numbers to a worksheet
- How to end strange page breaks and ensure that your titles and labels print on every page
Add eye-catching interest to charts and spreadsheets
- An easy-to-understand glossary of the terms used in charting and graphing data
- The ChartWizard — even if you're a total novice, how to easily produce vivid,
exciting charts to accompany your data
- Where to put your chart: all about embedded charts, separate charts, and chart sheets
within a workbook
- How you can add text boxes and arrows to your charts
- The Shapes gallery, WordArt, SmartArt, and other design tools you can use to dress
up your documents to be sure they capture attention
Gain speed, efficiency, and ease at every session
- Large worksheets with Split Windows — how to effortlessly view distant figures side by side
- For the mouse-hater: shortcuts that keep your hands on the keyboard
- How to automate many tasks using macros
Discover the new and enhanced features of Excel 2007!
- An introduction to the Ribbon — Excel 2007's revolutionary new command center
that makes most menus and toolbars obsolete
- How to use Formula AutoComplete to make it even easier to create formulas
- Total Row Options: a simpler approach to utilizing total rows
- An overview of the Cell Styles gallery and its assortment of ready-made cell styles
- Excel's new gallery of table styles
- Conditional Formatting — a feature that lets you apply different Data Bars,
Color Scales, and Icon Sets to your cell selections with just a click
- How to customize the QuickAccess Toolbar to streamline your most common tasks
- A look into the future with Live Preview, a way to preview changes to your worksheet
before applying them
|
