Pick your Excel task, find it fast, and get it done with Just
the Steps!
If you want to see how to do a particular Excel task, this is
the perfect book. Each page includes step-by-step instruction
in one column and illustrations and screenshots in the other
column, so you have all the information you need in one
place–no flipping pages!
Improve your Excel skills with just the steps for entering
spreadsheet data, building formulas, protecting excel data,
formatting cells, designing spreadsheets with graphics, managing
workbooks, changing worksheet values, sorting and filtering data,
creating charts, creating Pivot Tables, building macros, integrating
Excel into other Office programs, and–whew!–still
more.
* Explains essentials tasks for Excel 2010, the spreadsheet
application that is part of the Microsoft Office 2010 suite
* Shows you just the steps for numerous Excel tasks using an
easy-to-follow, two-column page layout, with step-by-step
instruction on one side and illustrations and screenshots on the
other
* Covers entering spreadsheet data, building formulas, protecting
excel data, formatting cells, designing spreadsheets with graphics,
managing workbooks, changing worksheet values, sorting and
filtering data, creating charts, creating Pivot Tables, and building
macros
* Walks you step by step through collaborating in Excel and
integrating or using Excel with Word, Power Point, and Access
Make your tasks easier, improve your Excel skills, and get
better results with this step-by-step guide.
Table des matières
Introduction.
Part I: Putting Excel to Work.
Chapter 1: Working with Excel Files.
Chapter 2: Entering Spreadsheet Data.
Chapter 3: Building Formulas.
Chapter 4: Using Excel Functions.
Chapter 5: Protecting Excel Data.
Part II: Sprucing Up Your Spreadsheets.
Chapter 6: Formatting Cells.
Chapter 7: Applying Additional Formatting Options.
Chapter 8: Designing with Graphics.
Chapter 9: Managing Workbooks.
Part III: Viewing Data in Different Ways.
Chapter 10: Changing Worksheet Views.
Chapter 11: Sorting Data.
Chapter 12: Creating Charts.
Chapter 13: Printing Workbooks.
Chapter 14: Saving Time with Excel Tools.
Part IV: Analyzing Data with Excel.
Chapter 15: Working with Outlines.
Chapter 16: Filtering Data.
Chapter 17: Creating Pivot Tables.
Chapter 18: Building Simple Macros.
Part V: Utilizing Excel with Other People and
Applications.
Chapter 19: Collaborating in Excel.
Chapter 20: Integrating Excel into Word.
Chapter 21: Blending Excel and Power Point.
Chapter 22: Using Excel with Access.
Part VI: Practical Applications for Excel.
Chapter 23: Creating a Commission Calculator.
Chapter 24: Tracking Medical Expenses.
Index.
A propos de l’auteur
Diane Koers owns and operates All Business Service, a
software training and consulting business formed in 1988, that
services the central Indiana area. Her area of expertise has long
been in the word-processing, spreadsheet, and graphics areas of
computing. She also provides training and support for Peachtree
Accounting Software. Diane’s authoring experience includes over 40
books on topics, such as PC security, Microsoft Windows, Microsoft
Office, Microsoft Works, Word Perfect, Paint Shop Pro, Lotus
Smart Suite, Quicken, Microsoft Money, and Peachtree Accounting.
Many of these titles have been translated into other languages,
such as French, Dutch, Bulgarian, Spanish, and Greek. She has also
developed and written numerous training manuals for her
clients.
Diane and her husband enjoy spending their free time fishing,
traveling, and playing with their four grandsons and their
Yorkshire Terrier.
Plus d’ebooks du même auteur(s) / Éditeur
16 612 Ebooks dans cette catégorie
