Microsoft Excel 2010 Just The Steps for DUMMIES - Diane Koers (Wiley, 2010).pdf

spine=.4562"
Easy steps for creating ™
spreadsheets, analyzing data, Open the book Making Everything Easier!
and building charts and find:
®
• How to enter data into a Excel ®
Microsoft Microsoft
spreadsheet
• Tips for creating formulas and
®
Simple steps... ...for great results functions
®
2010
• Instructions for formatting
Use Cell Styles and sprucing up your 2010
spreadsheets Excel
1. Select the cells you want to format.
• Steps for sorting and
2. Choose Home➩Cell Styles. In Figure 7-9, you analyzing data
see a gallery of predefined styles.
• Options for creating charts
Format Cells as a Table and PivotTables
• How to save time with macros
1. Select the data you want to format as a table.
• Directions for integrating
2. Choose Home➩Format as Table. A gallery of
Excel into PowerPoint®
Excel themed formats appears. (See Figure 7-10.)
Themes are predefined style sets that appear across the
entire Office suite, providing consistency in your work
appearance. Go to ®
for videos, step-by-step photos,
how-to articles, or to shop! Pick the task,
Find it fast,
Concise, step-by-step instructions Get it DONE!
ISBN 978-0-470-50164-1 “Get in, get out” information
Easy-to-recognize tasks and topics
$ US Quick solutions to get it done
$19.
A dash of humor and fun
£ UK
Computers/Spreadsheets Koers Diane Koers
spine=.4562"
Hundreds of tasks including: Use General Windows Shortcut Keys Use Data Entry Shortcut Keys Use Formatting Shortcut Keys
To Do This Press
What Do You Want to Do? Try This Task Find It Here To Do This Press To Do This Press
Open a menu Alt+underlined Display the Print Backstage view. Ctrl+P Display the Style dialog box. Alt+’(apostrophe)
letter Display the Format Cells dialog box. Ctrl+1
Put Excel to Work Create a new file 9 Insert a new worksheet. Shift+F11
Switch to the next program. Alt+Tab Apply the general number format. Ctrl+Shift+ ~
Display