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
Successful Self-Publishing: How to Self-Publish and Market Your BookJoanna Penn3h 23m4.4 (2.9K) Only with Ultra
Knowing What We KnowSimon Winchester14h 19m3.9 (2.5K)$33 · $0.00
The Weather MachineAndrew Blum4h 50m3.7 (2K)$20 · $0.00
From Raw Data to Real InsightVictor Fontaine7h 42m$5
Florence (Vol. 1&2)Grant Allen10h 3m3.9 (13)$1.99 · $0.00
The Knitting Enthusiast's Library: 17 Must-Have BooksEléonore Riego de la Branchardière, Bertha Thompson, Mary A. McCormack, H. P. Ryder, Miss Lambert, H. D. Buck, William M.A. Davis, Elvina Mary Corbould, American Thread Company, George Mrs. Cupples25h 55m4.3 (11)$1.99 · $0.00
The Modern Clock (Annotated)Ward L. Goodrich14h 58m4.2 (36)$1.99 · $0.00
Studies in Spermatogenesis (Vol.1&2) (Annotated)N. M. Stevens3h 30m$1.99 · $0.00
Semiconductor Devices from Physics to Chip DesignSoo-Yeon Baek13h 8m$95
ScaleBradley J Sugars3h 27m4.6 (52)Free
The Ultimate Textile Library: 23 Essential ReadsJohn T. Taylor, T. F. Bell, Kate Heintz Watson, William H. Dooley, Peter Kilgour, Thomas Woodhouse, Washington Matthews, William Henry Holmes, Candace Wheeler, Grace Rogers Cooper, Broadus Mitchell, Arnold Wolfensberger, H. D. Buck, Frederic Kenyon Brown, William M.A. Davis, Samuel Brown, Thomas Packer, Margaret Smith Furry, H. William Nelson, Lila M. O'Neale, A. C. Whitford, Clinton G. Gilroy96h 46m$1.99 · $0.00
The Ultimate Math Library: 23 Must-Have BooksD'Arcy Wentworth Thompson, Henry Ernest Dudeney, Bertrand Russell, Henry Pemberton, Robert T. Browne, Edwin Abbott Abbott, Greg Fee, David Slowinski, Charles Howard Hinton, John Scott, Pierre Simon marquis de Laplace, Henry Stevens, Bernhard Marks, James Clerk Maxwell, W. Stanley, Lewis Carroll, Jerry T. Bonnell, Robert J. Nemiroff, Florian Cajori, René Descartes156h4.1 (11)$1.99 · $0.00
DigitalBradley J Sugars5h 11m4.8 (10)Free
Python That Does Your ChoresGreta Farrell7h 50m$5
How to Make $10K/Month with Enablement & Automation (2025 Edition)Gus Gonzalez33m5.0 (12) Only with Ultra
Book Repair and Restoration (Annotated)Mitchell S. Buck1h 36m4.3 (15)$1.99 · $0.00
The AI Strategy Framework for Business LeadersDavid M. Patel9h 18m$24 · $0.00
RepluggedSatnam Bains13h 47m$14 · $0.00
The In-Car-Nation CodeDr. Engelbert Wimmer20h 15m$21 · $0.00
MRI MachinesHarold M.Stevens2h 43m$10.50 · $0.00