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
Show all chaptersShow less
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
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
Improvised Munitions HandbookU.S. Department of Defense4h 49m4.3 (1.6K)$1.99 · $0.00
Escaping GravityLori Garver10h 54m4.2 (2.2K)$20 · $0.00
Wireless WarsJonathan Pelson8h 2m4.3 (418)$20 · $0.00
Let There Be WaterSeth M. Siegel8h 36m4.2 (2.3K)$20 · $0.00
You may also like
Rapid Spanish (Latin American), Vol. 3Earworms Learning1h 16m4.7 (61)$15
Step By StepElza Lima3h 58m$16 · $0.00
Antipasti and moreNaumann & Göbel Verlag3h 25m$5 · $0.00
Rapid Maltese Vol. 1Earworms Learning1h 14m$15
RaunchyBill Brown Jr.49m$5
Comptine D'un Autre ÉtéBill Brown Jr.34m$4
Waltz 2 - CarulliiBill Brown Jr.13m$1
Three Little WordsBill Brown Jr.36m$4
CaravanBill Brown Jr.1h$5
Singing in the RainBill Brown Jr.25m$2
Cotton FieldsBill Brown Jr.49m$5
Hi-Heeled SneakersBill Brown Jr.30m$4
Voodoo Child - SRVBill Brown Jr.1h 34m$10
Gavotte in GMBill Brown Jr.32m$4
I am learning PunjabiJM Gardner3h 55m4.4 (113)$18 · $0.00
Triple Your Personal ProductivitySteve Pavlina13m4.0 (158)$4 · $0.00
Piano by Ear: Classical Box Set 1Bill Brown Jr.25h 18m$40
I am learning CzechJM Gardner3h 56m$18 · $0.00
Travel words and phrases in VietnameseJM Gardner1h 11m$7 · $0.00
Technical SpanishTomas Dvoracek7h 18m$18 · $0.00