Excel 2019 - Business Basics & Beyond

by Chris Smitty Smith

Overview

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.

Product Details

ISBN-13:	9781615473663
Publisher:	Holy Macro! Books
Publication date:	12/01/2018
Sold by:	Barnes & Noble
Format:	eBook
Pages:	279
File size:	43 MB
Note:	This product may take a few minutes to download.

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.

Table of Contents

 Introduction to Excel - Getting Started  Basic File Operations & Setting up Excel the Way You Want It  The Ribbon In Depth – The Home Tab  The Ribbon – Part II  Entering and Manipulating Data (and the basic rules of good spreadsheet design)  Using Functions & Formulas  Formatting & Printing  Working with Graphics  Charts  Excel Tables  Pivot Tables  Get & Transform (Power Query)  Real-Time Collaboration