
- 279 pages
- English
- ePUB (mobile friendly)
- Available on iOS & Android
Excel 2010 β Business Basics & Beyond
About this book
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.
Tools to learn more effectively

Saving Books

Keyword Search

Annotating Text

Listen to it instead
Information
Table of 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
- Resources
Frequently asked questions
- Essential is ideal for learners and professionals who enjoy exploring a wide range of subjects. Access the Essential Library with 800,000+ trusted titles and best-sellers across business, personal growth, and the humanities. Includes unlimited reading time and Standard Read Aloud voice.
- Complete: Perfect for advanced learners and researchers needing full, unrestricted access. Unlock 1.4M+ books across hundreds of subjects, including academic and specialized titles. The Complete Plan also includes advanced features like Premium Read Aloud and Research Assistant.
Please note we cannot support devices running on iOS 13 and Android 7 or earlier. Learn more about using the app