Excel 2019 Business Basics & Beyond

September 2019

Excel 2019 Business Basics & Beyond

Use Excel In Your Small to Medium Sized Business!

Written by a member of Microsoft's Excel team! A comprehensive guide to Excel for small to medium sized business owners.

Bill Jelen, MrExcel

category: Spreadsheets
covers: Office 365, Excel 2019

Product Details
  • 279 Pages
  • Publisher: Holy Macro! Books (USA)
  • ISBN: 978-1-61547-061-7
  • PDF ISBN: 978-1-61547-144-7

Are you tired of tracking financial elements of your business manually, do you have to prepare staffing schedules by hand, or do you simply want to know how to get more information from your business data? Learn how to harness your business data and put it to use for you.

Learn the basics of Excel, including a comprehensive review of every tab of the Excel Ribbon. See how to best display your data for maximum impact with formatting tools, Data Tables, Charts & Pivot Tables. Use customer information to create customized letters with Mail Merge. Import data using Power Query. Calculate the costs of doing business with financial formulas, learn where to find pre-packaged business templates, and much more. This book uses real-world business examples in operation with all these elements.

  • Introduction
    • Features of the Book
    • Structure of the Book
    • Excel Version Notes
    • About the Author
  • Chapter 1: Excel Basics
    • Understanding Spreadsheets and Spreadsheet Terminology
    • What Can You Do with Excel?
    • The Excel Environment: Understanding the Ribbon Interface
    • Ribbon Tabs
    • Additional Ribbon Options
    • Worksheet Tabs, the Status Bar, and View Buttons
    • Navigating the Excel Environment
    • Chapter Summary
  • Chapter 2: Understanding File Operations and Setting Up Excel
    • The File Tab
    • Changing Excel’s Default Settings So They’re Right for You
    • Chapter Summary
  • Chapter 3: The Home Tab in Depth
    • The Clipboard Group
    • The Font Group
    • The Alignment Group
    • The Number Group
    • The Styles Group
    • The Cells Group
    • The Editing Group
    • Ideas
    • Chapter Summary
  • Chapter 4: The Ribbon in Depth: The Main Tabs
    • The Insert Tab
    • The Page Layout Tab
    • The Formulas Tab
    • The Data Tab
    • The Review Tab
    • The View Tab
    • Chapter Summary
  • Chapter 5: Entering and Manipulating Data
    • Answering Important Questions
    • Planning
    • Understanding Design Rules
    • Designing and Building Spreadsheets
    • Entering and Editing Data
    • Data Validation
    • Inserting and Deleting Ranges, Rows and Columns, and Worksheets
    • Chapter Summary
  • Chapter 6: Using Functions and Formulas
    • Basic Terminology
    • The Function Library Group
    • Order of Operations
    • Entering Functions
    • Excel Function/Formula Errors
    • Commonly Used Business Functions
    • Chapter Summary
  • Chapter 7: Formatting, Printing, and Sharing
    • Themes
    • Text, Cell, Row, and Column Formatting
    • Conditional Formatting
    • Printing and Page Setup Options
    • Sharing Your Workbook
    • Comments and Notes
    • Chapter Summary
  • Chapter 8: Graphics
    • Pictures and Online Pictures
    • Shapes
    • Icons
    • 3D Models
    • SmartArt
    • WordArt
    • Screenshot
    • Chapter Summary
  • Chapter 9: Charts
    • Planning to Use Charts
    • Chart Terminology and Components
    • Getting Started with Charts
    • Column and Bar Charts
    • Line Charts
    • Area Charts
    • Pie Charts
    • Hierarchy Charts
    • Statistic Charts
    • Scatter and Bubble Charts
    • Waterfall, Funnel, Stock, Surface, and Radar Charts
    • Combo Charts
    • Map Charts
    • Using Default Charts and Templates
    • Sparklines
    • Dealing with Charting Problems
    • Interactive Charts
    • Chapter Summary
  • Chapter 10: Excel Tables and Subtotals
    • Excel Table Basics
    • The Table Design Tab
    • Conditional Formatting with Tables
    • Structured References
    • Deleting Table Rows and Columns
    • Subtotals
    • Chapter Summary
  • Chapter 11: PivotTables, Power Pivot, & the Data Model
    • What PivotTables Can Do
    • Getting Started with PivotTables
    • The PivotTable Analyze Tab
    • The PivotTable Design Tab
    • Setting PivotTable Default Options
    • Power Pivot and the Data Model
    • Chapter Summary
  • Chapter 12: External Data and Mail Merge
    • The Get & Transform Group
    • The Queries & Connections Group
    • Unpivoting Data
    • Putting Data to Work
    • Mail Merges
    • Chapter Summary

Download Sample Files

The associated files that go along with the book can be downloaded by using the following link.

Download Sample Files »

Where to Buy

MrExcel Bookstore

eBook from MrExcel.

Add to Cart »

MrExcel Bookstore

Print book from MrExcel.

Buy Now »

Hear the Figures

If you are using assistive reading technology (for low-vision, dyslexia, mobility impairments, attention issues, or if you need to read hands free), this e-book is "born accessible", with a complete description attached to each screenshot so you can follow along with the text.

Other Editions

Excel 2010 Business Basics and Beyond

December 2012

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.