Excel 2019 Business Basics & Beyond 2nd Edition
- 5h 59m
- Chris Smitty Smith
- Tickling Keys
- 2018
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.
About the Author
Chris "Smitty" Smith is a content developer on the Excel team at Microsoft. Before joining Microsoft, he was a trainer/lecturer for a wide variety of corporate clients, including the U.S. Department of Treasury, CalTrans, Apple, Verizon, General Electric, and many others.
Smitty has over 25 years of business experience using Excel. Prior to corporate life, he worked as a Ranch Manager in Texas, Colorado, Wyoming and Australia after graduating from the Ranch Management program at TCU. He fondly remembers convincing ranch owners to move from paper ledgers to spreadsheets. When he is not busy at work, he is an avid Rock & Ice climber and occasional mountaineer. He lives in Seattle Washington with his wife, daughter and their mediocre Pyrenees dog, Ellie.
In this Book
-
Excel Basics
-
Understanding File Operations and Setting Up Excel
-
The Home Tab in Depth
-
The Ribbon in Depth: The Main Tabs
-
Entering and Manipulating Data
-
Using Functions and Formulas
-
Formatting, Printing, and Sharing
-
Graphics
-
Charts
-
Excel Tables and Subtotals
-
PivotTables, Power Pivot, & the Data Model
-
External Data and Mail Merge
