Excel 2019 – Business Basics & Beyond

Overview

Quickly learn the ins-and-outs of the program from a business perspective, without tedious academic tutorials or material that is irrelevant to day-to-day use

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.

Author Biography

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.