Confident Excel at Work
Build a Professional Sales Dashboard with Power Query and Power BIBy Curtis Brandt
Length7h 27m
About this audiobook
Excel at work, master spreadsheets, learn Excel fast. Go from nervous beginner to capable user with practical workbooks covering formulas, formatting, charts, and analysis, all built around the tasks you face daily. This hands-on guide transforms confusion into confidence, step by step. Whether you're creating budgets, tracking sales, or visualizing data, each chapter focuses on real-world scenarios you encounter in the office. Start with the basics: navigate the ribbon, enter data, and format cells like a pro. Then level up to essential formulas—SUM, IF, VLOOKUP—and learn how to troubleshoot errors without panic. Next, build dynamic charts and pivot tables to summarize insights at a glance. Finally, tackle advanced analysis with conditional formatting, data validation, and what-if scenarios. No fluff, no jargon—just clear instructions and downloadable practice files. By the end, you'll automate repetitive tasks, impress your boss, and solve problems independently. Perfect for administrative assistants, project managers, small business owners, and anyone who feels overwhelmed by Excel. Includes cheat sheets, keyboard shortcuts, and a troubleshooting guide. Stop struggling and start succeeding. [placeholder] and [placeholder] cover similar ground, but this workbook delivers more hands-on exercises tailored to daily work.
This hands-on Excel/BI guide is written to be used at the keyboard: every concept is paired with something you can run, adapt, and keep. You move from first principles to real, working results, with the common errors and fixes called out along the way so you are never stuck for long.
Audiobook details
GenreTechnology
Length7 hrs 27 mins
Narrated byListen with 1,000+ voices
FormateBook with Audio
LanguageEnglish
Table of contents
1Confident Excel at Work
2Preface
3Chapter 1 — Laying the Groundwork: Importing and Structuring Raw Sales Data
4Chapter 2 — Power Query: Clean, Transform, and Combine Data
5Chapter 3 — Core Formulas for Business Metrics: SUM, AVERAGE, and More
Mostrar todos os capítulosVer menos
6Chapter 4 — Looking Up the Details: VLOOKUP, INDEX-MATCH, and XLOOKUP
7Chapter 5 — Logical Functions for Data Classification
8Chapter 6 — Data Modeling with Excel Tables and Relationships
9Chapter 7 — PivotTables: Summarize Millions of Rows in Seconds
10Chapter 8 — Charts That Tell a Story: Visualizing Trends and Comparisons
11Chapter 9 — Conditional Formatting and Dashboard Eye-Candy
12Chapter 10 — Advanced Summaries: SUMIFS, COUNTIFS, and AGGREGATE
13Chapter 11 — What-If Analysis: Scenarios, Goal Seek, and Data Tables
14Chapter 12 — Introducing DAX: Calculated Columns and Measures in Power Pivot
15Chapter 13 — Building a Professional Dashboard in Excel
16Chapter 14 — From Excel to Power BI: Connecting and Preparing Data
17Chapter 15 — Power BI Data Modeling and DAX Revisited
18Chapter 16 — Interactive Visualizations in Power BI
19Chapter 17 — Designing the Final Dashboard Layout
20Chapter 18 — Publishing, Sharing, and Next Steps
21About the Author
LiftoffEric Berger9h 4m4.6 (9.5K)$29 · $0.00
The Honey BusMeredith May9h 31m4.4 (16.6K)$25 · $0.00
Collected Writings of Nikola TeslaThomas Commerford Martin, Nikola Tesla19h 42m4.4 (2.8K)$1.99 · $0.00
Operation PedestalMax Hastings12h 29m4.4 (5.2K)$29 · $0.00
When the Heavens Went on SaleAshlee Vance18h 20m4.4 (3K)$40 · $0.00
Everybody Has a Podcast (Except You)Justin McElroy, Travis McElroy, Griffin McElroy5h 9m4.3 (2.3K)$24 · $0.00
Hands of TimeRebecca Struthers8h 8m4.4 (1.3K)$26 · $0.00
Never Lost AgainBill Kilday10h 1m4.4 (805)$29 · $0.00
How the Internet HappenedBrian McCullough13h 28m4.3 (2.7K)$23 · $0.00
Collected Writings of Nikola TeslaNikola Tesla, Thomas Commerford Martin21h 50m4.3 (1.7K)$1 · $0.00
Just AspireAjai Chowdhry9h 13m4.4 (260)$29 · $0.00
The Little Book of AliensAdam Frank8h 20m4.3 (1.3K)$26 · $0.00
The inventions, researches and writings of Nikola Tesla (Annotated)Thomas Commerford Martin16h 59m4.3 (1.3K)$2 · $0.00
KargilV.P. Malik15h 18m4.3 (2K)$24 · $0.00
Experiments with Alternating CurrentsNikola Tesla9h 16m4.3 (874)$1.99 · $0.00
Fire on the HorizonTom Shroder, John Konrad8h 23m4.3 (858)$26 · $0.00
The Smell of Kerosene (Annotated)National Aeronautics and Space Administration, Donald L. Mallick, Peter W. Merlin11h 32m4.3 (523)$2 · $0.00
The Boy Who Harnessed the WindWilliam Kamkwamba, Bryan Mealer10h 5m4.2 (78.9K)$29 · $0.00
Across the Airless WildsEarl Swift10h 8m4.3 (1.3K)$29 · $0.00
Console WarsBlake J. Harris20h 41m4.2 (13.7K)$46 · $0.00
You may also like
Semiconductor Devices from Physics to Chip DesignSoo-Yeon Baek13h 8m$95
Rapid Spanish (Latin American), Vol. 3Earworms Learning1h 16m4.7 (61)$15
Step By StepElza Lima3h 58m$16 · $0.00
Rapid Maltese Vol. 1Earworms Learning1h 14m$15
I am learning PunjabiJM Gardner3h 55m4.4 (113)$18 · $0.00
Triple Your Personal ProductivitySteve Pavlina13m4.0 (158)$4 · $0.00
Identifying Business OpportunitiesAnthony Ekanem23m$4 · $0.00
An Introduction to Machine Drawing and DesignDavid Allan Low3h 13m$2 · $0.00
Gas Burners Old and NewOwen Merriman3h 1m$2 · $0.00
Early Printed BooksE. Gordon Duff5h 1m3.6 (19)$2 · $0.00
Tower's Little Primer, for the youngest class in primary schoolAnna E. Tower9m$2 · $0.00
English DemystifiedChris Fitzgerald51m$10 · $0.00
Omnibuses and cabsHenry Charles Moore5h 45m$1 · $0.00
Master Portuguese For Everyday Conversations!Mohamed Elshenawy4h 39m$26 · $0.00
Ultimate Guide To Cupcakes 175 Selected Simply Delicious Recipes With Decorating IdeasJideon F Marques5h 58m$10 · $0.00
Chats on Old MiniaturesJ. J. Foster4h 44m$2 · $0.00
The Kitchen From A To Z (and The Z For Zing! So Delicious!)Betty Crocker2h 24m$7 · $0.00
A Manual of Photographic Chemistry, Including the Practice of the Collodion ProcessT. Frederick Hardwich10h 28m$1 · $0.00
Making Money Online: Lets Get StartedDaniele Moreira34m$6 · $0.00
Manual of Library CataloguingJohn Henry Quinn5h 3m$1 · $0.00