Description |
1 online resource (280 pages) : illustrations |
Bibliography |
Includes bibliographical references (page 274) and index. |
Summary |
Microsoft Excel is one of the most powerful tools a business owner, manager, or new employee has at their disposal, and this guide teaches how to harness business data and put it to use. Using real-world examples of a small business in operation, the book covers topics such as preparing financial statements, how to best display data for maximum impact with formatting tools, data tables, charts and pivot tables, using customer information to create customized letters with mail merge, importing data from programs such as QuickBooks, calculating the costs of doing business with financial formulas, and much more. Helpful screenshots are spread throughout the text, and the book explains how to find ready-made templates online for free.-- Publisher description. |
Note |
Print version record. |
Contents |
Foreword -- Lesson 1 what is excel anyway? -- Lesson 2 basic file operations & setting up excel the way you want it -- Lesson 3 the ribbon in-depth the home tab -- Lesson 4 the ribbon in-depth part II -- Lesson 5 entering and manipulating data (and the basic rules of good spreadsheet design) -- Lesson 6 using functions & formulas -- Lesson 7 formatting & printing -- Lesson 8 working with graphics -- Lesson 9 charts -- Lesson 10 Excel tables & sub-totals -- Lesson 11 pivot tables -- Lesson 12 external data sources & mail merge -- About the author. |
Note |
GMD: electronic resource. |
Subject |
Microsoft Excel (Computer file)
|
|
Business -- Computer programs.
|
|
Educational statistics -- Computer programs.
|
|
Electronic spreadsheets -- Computer programs.
|
|
Psychometrics -- Computer programs.
|
|
COMPUTERS -- Desktop Applications -- Spreadsheets.
|
|
Microsoft Excel (Computer file) (OCoLC)fst01366659
|
|
Business -- Computer programs.
(OCoLC)fst00842283
|
Added Title |
Excel 2010 business basics and beyond |
Other Form: |
Print version: Smith, Chris (Chris Blanton), 1966- Excel 2010 business basics and beyond. Uniontown, Ohio : Holy Macro! Books, ©2013 9781615470129 (OCoLC)785874314 |
ISBN |
9781615472109 (electronic bk.) |
|
161547210X (electronic bk.) |
|
9781615473304 (electronic bk.) |
|
1615473300 (electronic bk.) |
|