Creating tables in Excel allows for easier formatting and reporting, but the new syntax that it i...

PowerPivot Alchemy

Excel Simulations

Array Formulas have been around since the beginning of Excel. The author wrote a whole book about...

Excel tips to skyrocket white-collar productivity. Originally designed for Bill Jelen's live Powe...

College teaching assistant Ruth Tyack is excitedly planning for a new job in Rome when she falls ...

Real-world examples abound in this resource that provides a basic context for understanding how a...

'Master pivot tables, subtotals, VLOOKUP, power query, dynamic arrays & data analysis.'

Person-centered instead of theory-centered, this resource provides a basic context for understand...

Providing the tools and techniques necessary for finding errors and fraud in audits, this guide f...

Written by a member of Microsoft's Power BI team, this resource provides a practical step by step...

Drawn from actual excel conundrums posted on the author's website, mrexcel.com, this high-lev...

Designed with Excel gurus in mind, this handbook outlines how to create formulas that can be used...

You have just been promoted into a job that requires more Excel skills than ever. You are flounde...

A follow-up to Excel Outside the Box , More Excel Outside the Box is designed with the Excel guru...

This enthusiastic introduction provides support for Excel beginners and focuses on using the prog...

Vintage and modern examples of charms are interwoven throughout the pages of this exploration of ...

This book is aimed at those who wish to advance their knowledge and expertise in financial modell...

'Reader level: Intermediate'--Page 4 of back cover.

Master Excel and Thrive in Today's Data-Driven WorldAre you ready to take control of Excel and tr...

Created for heavy-duty users who prefer a visual learning experience, this DVD-ROM is an all-enco...

Master your data and transform your workflow with Power Query! This book provides a comprehensive...

Microsoft PowerPivot es un complemento gratuito para Excel de Microsoft que permite a los usuario...

Are you tired of tracking financial elements of your business manually, do you have to prepare st...

A simple walk-through of the common perils and pitfalls of financial modelling, this book examine...

Covering a variety of Excel simulations, from gambling to genetics, this introduction is for peop...

Data analysis expressions (DAX) is the formula language of Power BI. Learning the DAX language is...

The Fresh Voices series was inspired by a contest of the same name that identified high school wr...

Neither an exposé of the dark underbelly of wrestling nor a justification of its existence, Red H...

Microsoft's revolutionary Power Pivot is a tool that allows users to create and transform data in...

For scientists and engineers tired of trying to learn Excel with examples from accounting, this s...

This book includes step-by-step examples and case studies that teach users the many power tricks ...

This is a book about Microsoft 365 Excel, or Excel 365. With a new formula calculations engine an...

Excel Insights

Fifty Excel tricks that no one has ever seen before.

Just like a shovel, this book is genuinely ground-breaking. It hits you over the head with the pr...

Bill Jelen, MrExcel and Oz du Soleil of Excel on Fire, two of the leading Excel channels on YouTu...

Microsoft PowerPivot is a free add-on to Excel from Microsoft that allows users to produce new ki...

The essential guide for getting started with Power BI.

Excel tips to skyrocket white-collar productivity.

This book is about Power Query and M Code. Power Query and the functional language M Code (M) are...

RAISING ARRAYS FOR MODELLING This book tries hard to raze a laugh (yes, that's what was meant... ...

PROJECTING PROJECT FINANCE MODELLING. If you have a beginner's grasp in accounting, finance and E...

Excel tips to skyrocket white-collar productivity. Originally designed for Bill Jelen's live Powe...

This guide assists all levels of Microsoft Outlook users in furthering their understanding of the...

Written specifically for finance managers, Excel for the CFO explains the best features of Excel ...

With examples from the world of science, this reference teaches scientists how to create graphs, ...

Inspiring Excel tips designed to save 100 hours per year.