Get solid answers to these and all your Excel questions

• Are there easier ways to maneuver around in Excel than what I’ve been using?
• Is there a way I can easily link Excel worksheets so I don’t have to risk errors or waste time rekeying information?
• What is a Pivot Table? What is it used for and how do you create one?
• What tool does Excel offer that’ll help me analyze data more easily?
• Are there any rules of thumb that I can use to make sure my charts look good, without spending tons of time on them?
• What shortcuts would help improve my speed and productivity on a daily basis?
• What types of mathematical functions will Excel perform, and how do you do each?
• How can I make my spreadsheets look better, so they’re easy to read and the important facts jump out on the page?
• What’s the best way to manage enormous spreadsheets so they’re easy to work in?
• How can I take a list and turn it into a database in Excel?
• Does Excel have features that can help me with my budgets, invoices, and other routine computing needs?
• What kind of templates can I create with Excel that’ll make me more productive?
• How can I customize my toolbar and formula bar to help me work more quickly on the type of worksheets I create most often?

Using Excel’s New Ribbon command system to optimum effect

• Make the Quick Access Toolbar include any of the ribbon buttons you need
• Locate more command options with the dialog box launcher in Ribbon groups
• Control your screen view by hiding/revealing the ribbon instantly

Navigation Tips – quickly navigate between different worksheets and workbooks

• Jump to different open workbooks without lengthy command sequences
• Move through a worksheet with speed and confidence using a myriad of keystroke shortcuts and mouse tricks
• Freeze panes and split worksheets horizontally and vertically for optimum display of critical data

Formatting – acceleration tools for quick visual changes to clarify worksheets in a flash

• Numeric Formatting simplified – keystroke shortcuts for date, time, currency, and scientific data
• Alignment and border changes in a flash
• Center titles vertically and horizontally; indent data without needless typing
• Preview font differences before actual changes with Excel’s new live preview feature

Operational features

• Copy/Move/Paste data in a flash with dragging techniques – not multi-step command sequences
• Insert/Delete Columns, Rows, and Sheets – learn the best ways to use these frequently needed tools
• Hide and Unhide Columns, Rows, and Sheets – for printing or security reasons, use these features fluently
• Use the greatly expanded Undo/Redo feature to your advantage

Formulas and Functions – the core of Excel usage

• Formula essentials – understand the crucial role of the hierarchy of operations
• Absolute or Relative – learn the best way to make your formulas concise and accurate
• See all worksheet formulas with a keystroke shortcut
• Copy formulas and values effortlessly down columns without cumbersome selections
• Check a cell’s dependencies with just a few mouse clicks – formula auditing simplified
• Master the functions that everyone needs – SUM, AVERAGE, MIN, MAX, MEDIAN …
• Use the Insert Function button to learn and build unfamiliar functions effortlessly
• Achieve programming-like power with the multi-faceted IF function
• Look up data efficiently with VLOOKUP/HLOOKUP

Database Tools – Excel has great tools for database management – master these time-saving productive tools

• Sorting – sort massive amounts of data with the versatile Sort command
• Use Excel’s AZ and ZA buttons to accelerate sorting
• Sort data by font or cell background color
• Filter – see just the data you want to see – expanded with great new tools in Excel 2007
• Analyze list data with COUNTIF, SUMIF, and the new AVERAGEIF

Pivot Tables – Excel’s greatest analytical and summarizing tool – and not a formula in sight

• Learn the key steps to creating Pivot Tables in a flash
• Change pivot table layout with simple dragging
• Create a Pivot Chart that’s always in sync with your Pivot Table

Macros – open the door to unlimited power in automating repetitious tasks

• Learn the critical steps to building macros – the macro recording process
• Play back your macros with keystroke shortcuts or commands
• Create a Quick Access toolbar button for your frequently needed macros

Charts – Excel’s great visual tool – with 21st century graphics in its latest version

• Two different keystroke shortcuts to create charts instantly – on your worksheet or on a new sheet
• Learn how the Chart Layout command can turn your quickly created charts into final form
• Add Trendlines for quick statistical analysis of your data
• Explore the chart types that work best for the right occasion
• Change a chart's orientation for different and potentially better display of your data
• Convert charts into pictures and quickly add shadows, reflections, and other dazzling techniques

"The instructor was able to bring the ideas and 'how-to's' down to a friendly and easily understandable language."
P. Earp
MicroComputer Tech II
Texas A&M University-Kingsville

"Chuck is not only knowledgeable and aware of a user's practical needs, but a very effective instructor."
B. Goodman
Electronic Access Librarian VC/UHV Library

"The seminar was very useful and informative. I will definitely apply the information to make myself more productive."
A. Kite
Secretary
Christ's Haven for Children

"The workbook anticipated a lot of my questions as it went along. Good presentation of material. Thanks tons!"
S. Schmitz
System Analyst
King Ranch, Inc.

" ... I would highly recommend this program to anyone!"
Larry Owens
Director of Business Administration
Golden Van Lines

" ... Thank you — this has been a great help!"
Judith Steinacher
Secretary
St. Vrain Valley School District