Sitemap

• Home
• Services
• • Services
  • Core Services
  • Modelling
  • • Modelling
    • Financial Modelling
    • Financial Model Auditing
    • Strategic and Probabilistic Modelling
    • Powerful Data Modelling
    • Model Development
  • Strategy
  • Planning
  • Training
  • • Training
    • In-house training
• Courses
• Subscriptions
  • Excel Tips and Tricks
  • Power Pivot, Power Query and Power BI
  • Pivot Tables
  • Financial Modelling
• Thought
  • A Debt to Repay
  • A Decided Lack of Style
  • A Modicum of MOD
  • A to Z of DAX Functions
  • A to Z of Excel Functions
  • Achieving the Impossible: Reversing Text
  • AGGREGATE
  • Aggregating Aggravating Time Periods
  • All Creatures MAX, MIN, LARGE and SMALL
  • Allocating Fees
  • Allocating Weeks to Months
  • ALTernative Excel in an Instance
  • Are You Absolutely Sure?
  • Array of Light
  • Asking for a Date
  • Auto Fill Becoming a Drag..?
  • Automated File Names
  • Automating a Table of Contents
  • Avoiding a Group Protection Racket
  • Avoiding Bad Hyperlinks
  • Avoiding Macros: Solve for X
  • Being Direct About INDIRECT
  • Broken Charts
  • Calculating Depreciation for Existing Capital Expenditure
  • Calculating Interest Rates Correctly
  • Calculating the Pre-Tax Cost of Equity
  • Chart Labels
  • Charts and Dashboards Blog Series
  • Coming to Terms with Dates
  • Comparing Lists Simply
  • Concatenation
  • Conditional Custom Number Formatting
  • Conditional Formatting
  • Consistent Formulae
  • Copying Formulae Across Rows
  • Counting Unique Items in a List
  • Creating a Calendar with Dynamic Arrays
  • Creating a Timestamp
  • Creating Similar Charts Side by Side
  • Data Tables
  • Data Tables Re-Revisited: Care with Inputs
  • Data Tables with Off-Sheet Inputs
  • Data Validation
  • DATEDIF
  • Debt Sculpting
  • Depending on Data Validation Lists
  • Depreciation Appreciation
  • Desperately Seeking Solver
  • Do You Choose to Use CHOOSE?
  • Dynamic Arrays: One Year On
  • Dynamic Data Validation
  • Dynamic Lookups
  • Dynamic Range Names
  • Entering the Import / Export Business
  • Erring on the Side of #CAUTION!
  • Evaluating EVALUATE
  • Excel 2016 Functions and Features
  • Excel 2019 Functions and Features
  • Excel 365 Functions and Features: February 2019
  • Extracting Pictures from Excel
  • Fee FIFO Fumbles
  • File Style
  • Filter Tips with No Health Warning
  • Finding an EXACT Match
  • Finding the Nth Item on a List
  • First and Last Lookups
  • Forecasting – Manual versus Automatic?
  • Forecasting Tips
  • Formulae Referencing Current Worksheet
  • Getting a Date if You’re a Modeller...
  • Getting Arrays: Spilling the Beans on Seven New Functions
  • Go Poisson
  • Goals Gone Wild
  • GROUPBY, PIVOTBY, PERCENTOF, ETA LAMBDAS ET AL
  • Hiding Formulae
  • Hiding Unhideable Objects
  • Historical vs. Actual vs. Forecast
  • How Much Do I Need
  • Hyperlinking Chart Sheets
  • INDEX MATCH
  • INDEX MATCH INDEX
  • Interest Received
  • Irreverent IRR
  • Keeping Up Appearances – Conditional Formatting
  • Keyboard Shortcuts
  • LAMBDA Formulaic Recursion: It’s All About ME!
  • LIFO Parole
  • Linking to PowerPoint
  • Locating Links
  • Locating Links #2
  • Locating Links #3
  • Looking Up to LOOKUP
  • Lookout for VLOOKUP and HLOOKUP
  • Managing Scenario Manager
  • Many Happy Returns: Modified Internal Rate of Return (MIRR)
  • Model Construction Tips
  • Modelling Actual versus Budget
  • Models with S-Curves
  • Modified Internal Rate of Return Revisited
  • Modifying Numbers Inappropriately
  • Multiple Criteria
  • Multiple Criteria with Errors
  • Multiple Criteria with OR
  • Multiple Multiple Criteria
  • Multiple Number Formatting
  • Names
  • Navigation Not Such a Pane
  • New Data Types and FIELDVALUE Function Now Generally Available (Sort Of)
  • New Views for Power Query
  • Not Just Mary Can Have a Little LAMBDA / Excel Hits 500
  • Number Formatting
  • Number of Days in the Month
  • Onset of OFFSET
  • Opting for Optimised Economic Life
  • Order of Operations
  • Pivotal PivotTables
  • Power BI Tips Blog Series
  • Power Pivot Principles Blog Series
  • Power Query Blog Series
  • Pro-Rating Over Time
  • Protect / Unprotect Multiple Worksheets
  • Reducing File Size
  • Referencing Every Nth Row
  • Referencing Multi-Page Data from a Web Site with a Single URL
  • Report at the Double
  • Revising Forecasts
  • Rolling Budgets
  • Rolling Charts
  • Running in a Field
  • Seasonal Forecasting
  • Section Numbering
  • Self Reviews
  • Simple Pro-Rating Over Time
  • Simulation Stimulation
  • Slicer of Good Fortune
  • Slicing One Element on a Chart Only
  • Smoothing Capex
  • Sorting Sorted (Sort of!)
  • Spotting Inconsistencies and Plugs
  • Spreadsheet Skills: Flagging IF
  • SUBTOTAL - Function and Functionality
  • Sum Every Nth Item
  • SUM Things to Consider
  • Summing a Dynamic Range
  • Sumproduct Squared..?
  • Tables
  • Take it to the Limit
  • Taking Stock of Inventory
  • Text Messages
  • The answer to everything – It Depends! Dependent Data Validation lists for many sets of input cells
  • The Check’s in the Post
  • Time for Payback
  • Time Series
  • Tornado Charts
  • Transpose, I Suppose
  • Unique RANK
  • Using OFFSET for Depreciation
  • Using OFFSET for Scenario Analysis
  • Variable (Dynamic) Hyperlinks
  • VBA Blog Series
  • Version Aversion
  • Volatile Functions: Talk Dirty to Me
  • Waterfall Charts
  • Weighted Averages Await
  • What about US? Converting Dates to and from US Format
  • When Modelling Dozen Work
  • Working Capital Adjustments
  • XLOOKUP and XMATCH: Two New X-Men for Excel
• News
  • SumProduct on Financial Modeler’s Corner
  • Australasian Reporting Awards 2025
  • Define New Measures in DAX Query View Quick Queries
  • November 2024 Updates for Power BI
  • New Features for Excel October 2024
  • October 2024 Updates for Power BI
  • New Features for Excel September 2024
  • September 2024 Updates for Power BI
  • Python in Excel – Now Generally Available for Windows users of Microsoft 365 Business and Enterprise
  • Copilot in Excel Now Generally Available
  • Keeping in TRIM
  • New Features for Excel August 2024
  • August 2024 Updates for Power BI
  • New Regex Modes for XLOOKUP and XMATCH
  • Kathryn Hits 400
  • New Features for Excel July 2024
  • Best Excel Tip Ever?
  • MVP Renewal 2024
  • July 2024 Updates for Power BI
  • Work smarter, not harder: ChatGPT free webinar
  • New Translation Functions in Excel
  • Checkboxes in Excel
  • New Features for Excel June 2024
  • June 2024 Updates for Power BI
  • New Features for Excel May 2024
  • Regex comes to Excel
  • May 2024 Updates for Power BI
  • Revision to PIVOTBY
  • New Features for Excel April 2024
  • April 2024 Updates for Power BI
  • March 2024 Updates for Power BI
  • New Features for Excel March 2024
  • Steve Kraynak MVP
  • New Features for Excel February 2024
  • February 2024 Updates for Power BI
  • Synchronise Forms Data to Excel
  • New Features for Excel January 2024
  • Copilot for All (sort of...)
  • PivotTables Now Available on iPad
  • Debugging Formulae with Excel Labs
  • December 2023 Updates for Power BI
  • New Features for Excel November 2023
  • Fabric and Copilot in Power BI
  • Loretta Ross, Head of Sales and Product Strategy
  • November 2023 Updates for Power BI
  • Datasets Renamed Semantic Models
  • New Functions Announced
  • New Features for Excel October 2023
  • Excel Virtually Global 2023 – In Case you Missed It…
  • October 2023 Updates for Power BI
  • Copilot Support for Python in Excel
  • New Features for Excel September 2023
  • Python Editor from Excel Labs
  • September 2023 Updates for Power BI
  • Python in Excel in Preview
  • SumProduct US and Steve Kraynak
  • New Features for Excel August 2023
  • Python in Excel
  • August 2023 Updates for Power BI
  • Australian Institute of Training and Development (AITD) Finalist 2023
  • Formula Bar Has a New Look
  • Stale Value Formatting
  • New Features for Excel July 2023
  • July 2023 Updates for Power BI
  • MVP Renewal 2023
  • Images and Data Types in PivotTables
  • Formula by Example
  • Formula Suggestions in Excel
  • New Features for Excel June 2023
  • 2023 End of Financial Year Sale
  • New Features for Excel May 2023
  • May 2023 Updates for Power BI
  • Announcing Microsoft Fabric
  • Global Excel Awards Lifetime Achievement Award Finalist
  • New Features for Excel April 2023
  • Introducing Excel Labs
  • Formula Argument Assistance
  • Check Performance
  • April 2023 Updates for Power BI
  • New Features for Excel March 2023
  • Need a Copilot?
  • March 2023 Updates for Power BI
  • Power Query Editor Updates for Excel for Mac
  • New Features for Excel February 2023
  • Import Data from Additional Data Sources using Power Query in Excel for Mac
  • February 2023 Updates for Power BI
  • New Excel Features for Excel January 2023
  • Value Preview ToolTips in Excel
  • New Features for Excel December 2022
  • Shortest Formula Challenge
  • December 2022 Updates for Power BI
  • Power BI Goes Green
  • Late November 2022 Updates for Power BI
  • New Features for Excel November 2022
  • New Features for Excel Late October 2022
  • Microsoft Excel World Championship on ESPN
  • New Features for Excel October 2022
  • October 2022 Updates for Power BI
  • Excel Virtually Global 2022
  • Conditional Formatting Returns to the Formatting Pane of Power BI Desktop
  • September 2022 Updates for Power BI
  • Power Query Editor in Excel for Mac
  • New Features for Excel September 2022
  • New IMAGE Function
  • August 2022 Updates for Power BI
  • New Features for Excel August 2022
  • Excel Live in Public Preview Soon
  • July 2022 Updates for Power BI
  • New Features for Excel - July 2022
  • MVP Renewal 2022
  • Recent Text and Array Functions: an Update
  • New Features for Excel – June 2022
  • June 2022 Updates for Power BI
  • May 2022 Updates for Power BI
  • Power BI Known Issues Page
  • Office Scripts Can Now Run on Windows via a Button
  • Power Query Refresh is Now Generally Available for Selected Data Sources in Excel for the Web
  • Shaping Data with the Power Query Editor in Excel for Mac
  • VBA Blocking
  • April 2022 Updates for Power BI
  • March 2022 Updates for Excel for the Web
  • March 2022 Updates for Power BI
  • 14 New Excel Functions
  • February 2022 Updates for Power BI
  • Announcing LAMBDAs to Production and Advanced Formula Environment
  • New Features for Charting in Excel for the Web
  • AutoComplete for Dropdown Data Validation Lists in Excel for Windows
  • New Conditional Formatting Experience in Excel for the Web
  • Excel 4.0 Macros Now Restricted by Default
  • New Features in Excel for the Web
  • December 2021 Updates for Power BI
  • Feature Updates for Sheet View
  • Improvements to Excel Add-ins and Data Types
  • New Microsoft Feedback Portal
  • November 2021 Updates for Power BI
  • October 2021 Updates for Power BI
  • Happy Spreadsheet Day 2021
  • Excel Virtually Global 2021 - Coming Soon!
  • Comments and Notes Upgraded in Excel for the Web
  • September 2021 Updates for Power BI
  • A Top Excel Blog?
  • August 2021 Updates for Power BI
  • Navigation Not Such a Pane
  • Not Just Mary Can Have a Little LAMBDA / Excel Hits 500
  • Restrict Usage of Excel 4.0 (XLM) Macros with New Macro Settings Control
  • July 2021 Updates for Power BI
  • MVP Renewal
  • Lifetime Achievement Award
  • New Features in Excel for the Web June 2021
  • June 2021 Updates for Power BI
  • Office Scripts now Generally Available in Excel for the web
  • Import Data from Local Files using Power Query in Excel for Mac
  • May 2021 Updates for Power BI
  • Recommended Files
  • Larger File Size Upload Limits
  • April 2021 Updates for Power BI
  • Understanding Recursion
  • Unhide Multiple Sheets
  • Convert Word Documents to PowerPoint Presentations
  • Show Changes Shows its Hand
  • Conditional Formatting Improvements in Excel
  • March 2021 Updates for Power BI
  • Power Fx
  • 100th Newsletter
  • February 2021 Updates for Power BI
  • Office 2021 Coming Soon
  • Office Scripts Ask Me Anything
  • Excel Roadmap Updates
  • SumProduct Melbourne on the Move
  • Continuing Financial Modelling - Paperback Release Imminent
  • LAMBDA Formulaic Recursion: It’s All About ME!
  • Apple iOS Announcement
  • Universal app support for Macs with M1 is here
  • December 2020 Updates for Power BI
  • LAMBDA Slaughter: Creating Custom Functions Using LAMBDA
  • LET Off the Leash
  • Power BI Anomaly Detection in Preview
  • November 2020 Updates for Power BI
  • Unhide Multiple Sheets November 2020
  • October 2020 Updates for Power BI
  • Happy Spreadsheet Day!
  • Auto-detecting Data Types
  • Power BI, Windows 7 and .NET Announcements
  • September 2020 Updates for Power BI
  • Smart Narratives (Preview) Comes to Power BI
  • Save As Picture
  • Continuing Financial Modelling - Out Now on Kindle
  • Situation Vacant – August 2020
  • Excel for the Web Workbook Link Support
  • Coming Soon: Continuing Financial Modelling
  • August 2020 Updates for Power BI Desktop
  • May and June 2020 Updates for Power BI Service and Mobile
  • July 2020 Updates for Power BI Desktop
  • MVP Renewal 2020
  • Have You Got What it Text? Introducing ARRAYTOTEXT and VALUETOTEXT
  • Windows Insider Channels
  • Gone Too Soon: Chris 'Smitty' Smith
  • Additional Language Support for Stocks and Geography Data Types
  • Brand New Excel Function: STOCKHISTORY
  • June 2020 Updates for Power BI Desktop
  • Announcing Excel Virtually Global
  • Office Insider / Beta Channel File Opening Issue Workaround
  • Get Data From PDF
  • Free Three Way Integrated Financial Model (Excel)
  • May 2020 Updates for Power BI Desktop
  • New Update Channels
  • COVID-19 Apps Available in Power BI
  • Coming Soon: Microsoft Information Protection (MIP)
  • Coming Soon: Power BI Datasets in Excel
  • April 2020 Updates for Power BI Desktop
  • Power BI Modern Filter Experience Upgrade Delayed
  • Power BI: Copy a Visual as an Image
  • Office Scripts Goes Local
  • Microsoft Visio Data Visualizer Add-in for Excel
  • Office 365 To Be Renamed
  • New Data Types and Smart Templates Coming to Excel
  • Free Excel Money
  • Introduction to Financial Modelling Now Available on Kindle
  • Excel Office 365 To LET
  • Modern Filter Experience for Power BI - Important Reminder
  • March 2020 Updates for Power BI Desktop
  • February 2020 Survey
  • February 2020 Updates for Power BI Desktop
  • Office Scripts Preview Rolling Out Now
  • Workbook Statistics Comes to Insider Fast
  • Excel Insights Book Out April 2020
  • Happy New Year 2020!
  • December 2019 Updates for Power BI Desktop
  • October and November 2019 Updates for Power BI Service and Mobile
  • Dynamic Arrays Gradually Rolling Out on Monthly Channel
  • November 2019 Updates for Power BI Desktop
  • Dynamic Arrays Becoming Generally Available
  • XLOOKUP Presents Moving Arguments
  • October 2019 Updates for Power BI Desktop
  • Financial Modelling Book Finally Available in US
  • Get & Transform (Power Query) in Excel for Mac: Phase 1
  • September 2019 Updates for Power BI Report Server
  • New Views for Power Query
  • Dynamic Arrays: One Year On
  • August 2019 Updates for Power BI Service and Mobile
  • September 2019 Updates for Power BI Desktop
  • XLOOKUP and XMATCH Now Across Office 365 Insider Fast
  • Power BI Mobile Apps Gets a New Look (Preview)
  • XLOOKUP and XMATCH: Two New X-Men for Excel
  • Power BI MVP Book - A Compendium
  • Countdown to 8 out of 10 Cats does SumProduct
  • August 2019 Updates for Power BI Desktop
  • July 2019 Updates for Power BI Service and Mobile
  • Excel Blog Return
  • Power BI Service Gets Fresh
  • July 2019 Updates for Power BI Desktop
  • June 2019 Updates for Power BI Service and Mobile
  • MVP Renewal 2019
  • Free Stuff from Microsoft Business Applications Summit 2019
  • Salesforce Buys Tableau
  • May 2019 Updates for Power BI Service and Mobile
  • Insert Data from Picture Generally Available on the iPhone Excel Application
  • Limited Refresh Now Available in Mac Excel Power Query
  • May 2019 Updates for Power BI Report Server
  • PivotCharts Now Available in Excel Online
  • May 2019 Updates for Power BI Desktop
  • April 2019 Updates for Power BI Service and Mobile
  • April 2019 Updates for Power BI Desktop
  • March 2019 Updates for Power BI Service and Mobile
  • March 2019 Updates for Power BI Desktop
  • Dynamic Arrays in Action
  • February 2019 Updates for Power BI Desktop
  • February 2019 Updates for Power BI Service and Mobile
  • Excel 365 – Latest Improvements: February 2019 Update
  • New Improved RANDARRAY Function Coming Soon to Office 365 Excel
  • January 2019 Updates for Power BI Service and Mobile
  • January 2019 Power BI Report Server Updates
  • Happy New Year 2019!
  • December 2018 Updates for Power BI Desktop
  • New Excel Icon
  • What’s New in Excel 2019
  • November 2018 Updates for Power BI Desktop
  • Power Query Blogs Hit 100 Not Out
  • Customise Your Keyboard Shortcuts in Excel for Mac
  • October 2018 Updates for Power BI Desktop
  • Getting Arrays: Spilling the Beans on Seven New Functions
  • Excel Office 365 Performance Improvements – Phase 2
  • New Ideas: Insights Re-Badged
  • Introducing Power BI Home & Global Search
  • Insert Data from Picture
  • New Data Types and FIELDVALUE Function Now Generally Available (Sort Of)
  • Office 2019 Commercially Available Now
  • September 2018 Updates for Power BI Desktop
  • September Updates for Power BI Service and Mobile
  • Amazin' Amazon Book
  • August 2018 Updates for Power BI Desktop
  • August 2018 Updates for Power BI Report Server
  • London Excel Developer Conference
  • Financial Modelling Book Out Now!!
  • July 2018 Updates for Power BI Desktop
  • July 2018 Updates for Get & Transform / Power Query
  • July 2018 Updates for Power BI Service and Mobile
  • Financial Modelling Book Out Soon
  • MVP 2018/19
  • New Office 365 Changes Coming Soon
  • New PivotTable Microsoft Tutorial for Excel 2016
  • June 2018 Updates for Power BI Service and Mobile
  • June 2018 Updates for Power BI Desktop
  • Power (Pivot) to the People
  • General Data Protection Regulation (GDPR)
  • May 2018 Updates for Power BI Desktop
  • May 2018 Updates for Power BI Service and Mobile
  • Excel Goes with the Flow
  • April 2018 Updates for Power BI Service and Mobile
  • New Features, Functions and Performance in Excel for Mac Version 16
  • The Excel Functions Translator
  • April 2018 Updates for Power BI Desktop
  • New Data Types and FIELDVALUE Function
  • Financial Modelling Brought to Book
  • Microsoft Translator
  • Office 2019 Shock Announcement
  • Coming Soon to Power BI: Common Data Service (CDS) for Analytics
  • March 2018 Updates for Power BI Service and Mobile
  • Power BI Report Server March 2018 Update
  • Sharing Power BI Content with Anyone by Email
  • March 2018 Updates for Power BI Desktop
  • Unlock Excel 2018 - Early Bird Pricing Expiring Very Soon!
  • Inserting PivotTables Now Possible in Excel Online
  • February 2018 Update for Get & Transform / Power Query
  • MVP Summit 2018
  • Amsterdam Excel Summit 2018
  • Unlock Excel 2018
  • Latest Updates for Power BI Service and Mobile
  • February 2018 Updates for Power BI Desktop
  • Deselect Cells from Selected Ranges in Excel 2016
  • January 2018 Updates for Power BI Desktop
  • January 2018 Updates for Get & Transform / Power Query
  • Are You Getting it Five Times a Week?
  • Year in Review 2017 Power BI Competition
  • Microsoft Tutorials for Excel 2016
  • Upcoming Insights in Excel
  • December 2017 Update for Power BI Desktop
  • Windows 10 Insider Program: Security Updates Ending for Early Editions
  • December 2017 Update for Power BI Service
  • Custom Functions in Excel using Developer Preview and JavaScript
  • And Then There Were Two...
  • Goodbye CIMA, Hello CGMA
  • Power BI for All?
  • Power BI Desktop November 2017 Update
  • Bulgaria Excel Days Not Confused
  • Mac Excel Version 16 - Now Available for Insider Fast Participants
  • Power BI Report Server November 2017 Update
  • Ask Me Anything October 2018
  • Excel Office 365 Performance Improvements
  • October 2017 Update for Power BI Desktop
  • Excel for Mac Gets a Makeover
  • What's in Store for Power BI?
  • October 2017 Update for Power BI Service
  • Excel Shows its Form
  • #N/A No Longer a Waste of Space
  • Mac Excel Gets PivotCharts
  • Excel (and Office) 2019
  • Out and About in October 2017
  • September 2017 Update for Power BI Desktop
  • Load Data from External Data Sources to the Common Data Service using Power Query
  • August 2017 Updates for Get & Transform / Power Query Add-In
  • August 2017 Update for Power BI Desktop
  • Mac Can Run and Now IDE
  • Get and Transform - Transformed July 2017
  • July 2017 Update for Power BI Desktop Out Now
  • Excel User Voice Finds its Voice: Half-Term Report
  • Bringing Free (Down)Loaders to Book
  • MVP Lucky Seven
  • June 2017 Updates for Get & Transform / Power Query Add-In
  • Power BI Announcements
  • Data Insights Summit: The Movie
  • June 2017 Update for Power BI Desktop
  • May 2017 Updates for Get & Transform / Power Query Add-In
  • AutoSave is Coming to Get YOU!! Action Required
  • Personalising PivotTables
  • CPA Unlock Excel Wraps Up
  • Are You Ready for Office 365 Pro Plus?
  • Key Changes Happening to Power BI Free from June 1
  • Unlock Excel Flash Sale
  • New Excel Add-In Script Lab Launched
  • April 2017 Updates for Get & Transform / Power Query Add-In
  • Unlock Excel Back InTheBlack
  • Power BI Desktop - April Updates Out Now
  • Phoney Excuse
  • Unlock Excel Earlybird Pricing Expiring Very Soon
  • Access Historical Versions of Your Office 365 Files
  • Amsterdam Summit: Best April Fool..?
  • Something to Share: Co-Authoring
  • March 2017 Updates for Get & Transform / Power Query
  • Microsoft Discusses Early Preview of Unified Get & Transform
  • Unified Get & Transform
  • 2017's First Updates for Get & Transform / Power Query
  • Unlock Excel 2017
  • Data Breach at Mr Excel
  • Office Insider Program for iPhone and iPad Announced
  • MVP 2017
  • Annual Quiz Update
  • Windows 10 Internet Issue
  • November Power BI Update
  • November Power Query / Get & Transform Updates
  • Excel Memory Checking Tool
  • Microsoft Press: Discount on Books
  • November Updates for Excel 2016
  • Excel Ask Me Anything: A Success!
  • Microsoft Lays Down the Gauntlet
  • Sending a PDF No Longer a Pane
  • Power BI Desktop - October 31 Update
  • Trick or Treat 2016
  • Office 365 Adoption Content Pack in Power BI Preview
  • Windows 10: September Update
  • Accessing dBASE
  • Excel World Champ
  • August Update for Get & Transform / Power Query
  • August Update for Power BI for Excel
  • Windows 10 Anniversary Update
  • Give the New Excel API a REST
  • ModelOff 2016
  • Power Query / Get and Transform - July Updates
  • July Power BI Updata
  • Faster PivotTables in Excel 2016
  • Microsoft Wins Data Privacy Appeal
  • Excel 2016 July Updates
  • Room Without a Power View
  • June Updates for Get & Transform in Excel 2016 / Power Query in Excel 2010 and 2013
  • SumProduct Blog Launch
  • Microsoft Survey Available
  • Bringing Windows 10 to a Close
  • More Updates for Get & Transform in Excel 2016 / Power Query in Excel 2010 and 2013
  • More Memory for 32-bit Click-To-Run Excel 2016
  • New Updates for Get & Transform in Excel 2016 / Power Query in Excel 2010 and 2013
  • Weather You Want To Or Not...
  • Microsoft Data Insights Summit - Free Online Sessions
  • Excel 2016 / Office 365: New Functions and Features
  • Excel Summit South - Limited Time Discount Offer
  • MVP 2016
  • Summit to Say?
  • CIMA Christmas Quiz
  • Excel Summit South - Registration Now Live
  • Power Pivot in Excel 2013 Updated
  • Trick or Treat 2015
  • MVP Summit 2015
  • Happy 30th Birthday Excel!!
  • Which Excel 2016?
  • Office 2016 Out Sep 22
  • New Website Coming Very Soon
  • Windows 10 Assistance for Developers
  • ModelOff Global Training Camp
  • Excel 2007 Security Patch Released
  • Power Pivot 2010: Microsoft Interim Fix for Windows 10
  • Power Pivot 10-4
  • 10-tative Power Pivot..?
  • Windows 10 Upgrade Released
  • Office for Mac 2016 Released
  • The Future’s Mapped Out..?
  • Sooner Rather Than Later
  • Best Tip Ever..?
  • Excel at Excel XL
  • Power Update Update
  • Free Financial Modelling Add-In
  • Archive for March, 2015 Increase Your Purview of Preview
  • Excel in the Nether Regions
  • Setting Windows 10 Free
  • Amsterdam Excel Summit – April 2015
  • MVP 2015
  • Xmas Quiz 2014 Now Live!
  • Advanced Warning
  • Trick or Treat
  • Resurfacing Surface
  • ModelOff 2014
  • Excel for iPad Upgrade
  • Tabling a Coffee Table Table Book..?
  • Out and About in August
  • The Excel Function Bible
  • Summit to Talk About
  • Office 2016 Public Preview Now Available
  • Excel Online Update
  • A New Dawn
  • Apple of Your Eye?
  • Change of Address
  • Go Fourth and Multiply
  • Shape Up to Ship Out
  • MVP 2014
  • I Siena Wanna App
  • Oops
  • New Services Offered
  • Office 2003 Terminated: Judgment Day Approaches
  • Windows 8.1 Out Now
  • Get Back in The Box
  • No Souped-Up Excel For You!
  • Power Maps: September Update
  • A Warm and Fuzzy Welcome
  • Excel Thinks Inside The Box
  • When They’re Cleaning Windows
  • Power Query: Adding Power to the Query
  • Wake Up Call for Excel..?
  • Fresh Start for Windows 8
  • Microsoft Discovers Australia
  • Geo with the Flow
  • Which version of Office 2013..?
• Blog
• • AI Blog: What is AI?
  • Excel for Mac: KeyTips now available on Mac!
  • Excel for Mac: Built-in Add-ins
  • Excel for Mac: Does it Support XML Data?
  • Excel for Mac: No ActiveX Support on Mac, Object Linking and Embedding (OLE) is Limited
  • Excel for Mac: Where to Find Stuff That’s on the File Tab in Excel for Windows (Part 2)
  • Excel for Mac: Where to Find Stuff That’s on the File Tab in Excel for Windows (Part 1)
  • Excel for Mac: Switching Languages
  • Excel for Mac: Conditional Formatting
  • Excel for Mac: Create a Forecast Sheet
  • Excel for Mac: Security Settings in Excel for Mac
  • Excel for Mac: Privacy for your Workbooks
  • Excel for Mac: Modifying Slicer styles
  • Excel for Mac: PivotCharts
  • Excel for Mac: PivotTable Sorting
  • Excel for Mac: no Fuzzy Merge in Power Query? How to Ignore Case when Merging Queries.
  • Excel for Mac: Filtering by Values in a PivotTable
  • Excel for Mac: Can’t Add Current Selection to Filter
  • Excel for Mac: Mac Only – Auto Apply for Filters
  • Excel for Mac: Missing Pop-Up Buttons
  • Excel for Mac: Combo Charts
  • Excel for Mac: Where Did I Save My File?
  • Excel for Mac: How to Use Flash Fill
  • Excel for Mac: Optimised AutoRecover (Only on Mac)
  • Excel for Mac: ‘Click To Add’ Mode (Only on Mac)
  • Excel for Mac: Mac Only – Pick Any Colour in Excel
  • Excel for Mac: Keyboard Shortcuts on a Small Keyboard
  • Excel for Mac: Mac Only - Customise Your Keyboard Shortcuts
  • Excel for Mac: Functions Unavailable on Mac
  • Excel for Mac: Power Query and PivotTables – Consolidate Ranges
  • Excel for Mac: Power Query – From Table/Range
  • Excel for Mac: Power Query features and limitations
  • ChatGPT Final Fiday Fix Explanation
  • Excel for Mac: Value Preview
  • Excel for Mac: Writing and Editing Formulae
  • Excel for Mac: Should You Buy a Mac?
  • Excel for Mac: PivotTable Field Layout
  • Excel for Mac: Basics You Need To Know
  • Excel for Mac: Introduction – A New Series
  • Excel Virtually Global 2020: A Personal Look Back
  • Working from Home
  • Monday Morning Mulling: November 2019 Challenge
  • Final Friday Fix: November 2019 Challenge
  • Monday Morning Mulling: September 2019 Challenge
  • Final Friday Fix: September 2019 Challenge
  • Season's Greetings and Happy New Year
  • Monday Morning Mulling: July 2018 Challenge
  • Final Friday Fix: July 2018 Challenge
  • Monday Morning Mulling: June 2018 Challenge
  • Final Friday Fix: June 2018 Challenge
  • Monday Morning Mulling: May 2018 Challenge
  • Final Friday Fix: May 2018 Challenge
  • Monday Morning Mulling: April 2018 Challenge
  • Final Friday Fix: April 2018 Challenge
  • Monday Morning Mulling: March 2018
  • Poisson D'Avril
  • Final Friday Fix: March Challenge 2018
  • Monday Morning Mulling: February 2018 Challenge
  • Final Friday Fix: February 2018 Challenge
  • Monday Morning Mulling: January 2018
  • Final Friday Fix: January 2018
  • Happy New Year 2018
  • Monday Morning Mulling: December Challenge
  • Final Friday Fix: December Challenge
  • Enjoy the Festive Season
  • Monday Morning Mulling: November 2017 Freaky Black Friday!
  • Final Friday Fix: November 2017 - Freaky Friday!
  • Same-Sex Marriage Results - A Data Driven Analysis
  • Monday Morning Mulling: October 2017 Challenge
  • Final Friday Fix: October Challenge
  • Monday Morning Mulling: September 2017
  • Final Friday Fix: September 2017 Challenge
  • ModelOff Sydney
  • Weird Little Traps: Excel Going Wrong from Day 1…
  • Monday Morning Mulling: August Challenge
  • Final Friday Fix: August Challenge
  • Monday Morning Mulling: July Challenge
  • Final Friday Fix: July Challenge
  • Monday Morning Mulling: June Challenge
  • Final Friday Fix: June Challenge
  • Seattle doesn't Settle...
  • Out and About in Seattle
  • Come on, Make My Spreadsheet, Come on!
  • Monday Morning Mulling: May Challenge
  • Final Friday Fix: May Challenge
  • Monday Morning Mulling: April Challenge
  • Final Friday Fix: April Challenge
  • How do I Install Power Query?
  • Monday Morning Mulling – March 2017
  • Final Friday Fix – March 2017
  • In the Black
  • Monday Morning Mulling: February Challenge
  • Final Friday Fix: February Challenge
  • Monday Morning Mulling: January 2017
  • Final Friday Fix: January 2017
  • Monday Morning Mulling: December 2016
  • Happy New Year 2017!!
  • Final Friday Fix: December 2016
  • Season's Greetings
  • A New Course, Of Course
  • London Trip Update
  • Newsletter Turns Four
  • Out and About in London
  • Monday Morning Mulling: November Challenge
  • Final Friday Fix: November Challenge
  • November MVP Summit Update
  • Power Training in December
  • Excel at Monopoly #6: House Rules
  • Momentous Day in the US
  • Out and About in Seattle, San Francisco, and Kuala Lumpur
  • Monday Morning Mulling: October Challenge
  • Final Friday Fix: October Challenge
  • Summit To Talk About
  • Out and About in Singapore
  • Excel at Monopoly #5: VBA simulation and review
  • Out and About with CPA: Auckland and Brisbane Next Week
  • Excel at Tetris..?
  • SumProduct Presenting at GTC New York!
  • Monday Morning Mulling: September Challenge
  • Final Friday Fix: September Challenge
  • Professor Aswath Damodaran
  • Excel at Monopoly #4: Payoff periods
  • SumProduct in Toronto
  • Gene Very Angry with Excel
  • On the Road - North East America
  • Excel UserVoice
  • Excel at Monopoly #3: Valuing property
  • Monday Morning Mulling: August Challenge
  • Final Friday Fix: August Challenge
  • Excel at Monopoly #2: MMULT sneak peek
  • Excel at Monopoly #1: Who Wants to Play a Game?
  • M&A Training in Sydney
  • Buggin' Out #8: AutoRecovery is a Real Pane in Excel 2016
  • Buggin' Out #7: Custom Sort Lists Issue in Excel 2016
  • Buggin' Out #6: Save or Export to PDF Crashes Excel
  • Version Aversion
  • Buggin' Out #5: Corrupted Data Validation Drop Down Lists
  • Buggin' Out #4: HTML Files with .xls
  • Buggin' Out #3: Excel File Extensions Not Recognised
  • How Not to Build a Financial Model – Part 2
  • Buggin' Out #2: Opening Excel Files After Upgrading to Excel 2016
  • Buggin' Out #1: Hyperlinks in Excel .xls Files
  • Monday Morning Mulling: July Challenge
  • Windows 10: Happy Anniversary!
  • Final Friday Fix: July Challenge
  • Happy Birthday Internet!
  • Excel 2010 Security Update May Be Causing Add-In Issues
  • Changing the Way We Look at Pokémon Go
  • July Power BI Updata
  • How Not to Build a Financial Model – Part 1
  • Out and About in Jakarta
  • Final Friday Fix
  • Possible Power Pivot Training in Brisbane
  • Online Training Update
  • New Sydney Office
  • Melbourne follow-up
  • SumProduct Referral Program
  • Out and About in Perth
  • A Night Out in Melbourne with Power Pivot
  • London Office
  • Power BI - Here to stay
  • New York Office
  • Power BI Development
  • SumProduct in Perth
  • Welcome to Our New Blog
  • A To Z of Excel Functions
    • The RIGHTB Function
    • The RIGHT Function
    • The REPT Function
    • The REPLACEB Function
    • The REPLACE Function
    • The REGISTER.ID Function
    • The REGISTER Function
    • The REGEXTEST Function
    • The REGEXREPLACE Function
    • The REGEXEXTRACT function
    • The REDUCE Function
    • The RECEIVED Function
    • The DETECTLANGUAGE Function
    • The RATE Function
    • The RANK.EQ Function
    • The RANK.AVG Function
    • The RANK Function
    • The RANDBETWEEN Function
    • The RANDARRAY function
    • The RAND Function
    • The RADIANS Function
    • The QUOTIENT Function
    • The QUARTILE.INC Function
    • The QUARTILE.EXC Function
    • The QUARTILE Function
    • The PY Function
    • The PV Function
    • The PROPER Function
    • The PRODUCT Function
    • The NUMBERSTRING Function
    • The ECMA.CEILING Function
    • The DATESTRING Function
    • The PROB Function
    • The PRICEMAT Function
    • The PRICEDISC Function
    • The PRICE Function
    • The PPMT Function
    • The PIVOTBY Function
    • The PERCENTOF Function
    • The GROUPBY Function
    • The POWER Function
    • The POISSON.DIST Function
    • The POISSON Function
    • The PMT Function
    • The PI Function
    • The PHONETIC Function
    • The PHI Function
    • The PERMUTATIONA Function
    • The PERMUT Function
    • The PERCENTRANK.INC Function
    • The PERCENTRANK.EXC Function
    • The PERCENTRANK Function
    • The PERCENTILE.INC Function
    • The PERCENTILE.EXC Function
    • The PERCENTILE Function
    • The PEARSON Function
    • The PDURATION Function
    • The OR Function
    • The OFFSET Function
    • The ODDLYIELD Function
    • The ODDLPRICE Function
    • The ODDFYIELD Function
    • The ODDFPRICE Function
    • The ODD Function
    • The OCT2HEX Function
    • The OCT2DEC Function
    • The OCT2BIN Function
    • The NUMBERVALUE Function
    • The NPV Function
    • The NPER Function
    • The NOW Function
    • The NOT Function
    • The NORMSINV Function
    • The NORMSDIST Function
    • The NORMINV Function
    • The NORMDIST Function
    • The NORM.S.INV Function
    • The NORM.S.DIST Function
    • The NORM.INV Function
    • The NORM.DIST Function
    • The NOMINAL Function
    • The NETWORKDAYS.INTL Function
    • The NETWORKDAYS Function
    • The NEGBINOMDIST Function
    • The NEGBINOM.DIST Function
    • The NA Function
    • The N Function
    • The MUNIT Function
    • The IMAGE Function
    • The MULTINOMIAL Function
    • The MROUND Function
    • The MONTH Function
    • The MODE.SNGL Function
    • The MODE.MULT Function
    • The MODE Function
    • The MOD Function
    • The MMULT Function
    • The MIRR Function
    • The MINVERSE Function
    • The MINUTE Function
    • The MINIFS Function
    • The MINA Function
    • The MIN Function
    • The HSTACK Function
    • The EXPAND Function
    • The DROP Function
    • The CHOOSEROWS Function
    • The CHOOSECOLS Function
    • The MIDB Function
    • The MID Function
    • The MEDIAN Function
    • The MDURATION Function
    • The MDETERM Function
    • The MAXIFS Function
    • The MAXA Function
    • The MAX Function
    • The MATCH Function
    • The MAP Function
    • The LAMBDA Function
    • The MAKEARRAY Function
    • The LOWER Function
    • The LOOKUP Function
    • The LOGINV Function
    • The LOGNORMDIST Function
    • The LOGNORM.INV Function
    • The LOGNORM.DIST Function
    • The LOGEST Function
    • The LOG10 Function
    • The LOG Function
    • The LN Function
    • The LINEST Function
    • The LET Function
    • The LENB Function
    • The LEN Function
    • The LEFTB Function
    • The LEFT Function
    • The LCM Function
    • The LARGE Function
    • The KURT Function
    • The JIS Function
    • The ISTEXT Function
    • The ISOMITTED Function
    • The BYROW Function
    • The BYCOL Function
    • The ISREF Function
    • The ISPMT Function
    • The ISOWEEKNUM Function
    • The ISODD Function
    • The ISO.CEILING Function
    • The ISNUMBER Function
    • The ISNONTEXT Function
    • The ISNA Function
    • The ISLOGICAL Function
    • The ISFORMULA Function
    • The ISEVEN Function
    • The ISERROR Function
    • The ISERR Function
    • The ISBLANK Function
    • The IRR Function
    • The IPMT Function
    • The INTRATE Function
    • The INTERCEPT Function
    • The INT Function
    • The INFO Function
    • The IMSUM Function
    • The IMSUB Function
    • The IMSQRT Function
    • The IMSINH Function
    • The IMSIN Function
    • The IMSECH Function
    • The IMSEC Function
    • The IMREAL Function
    • The IMPRODUCT Function
    • The IMPOWER Function
    • The IMLOG2 Function
    • The IMLOG10 Function
    • The IMLN Function
    • The IMEXP Function
    • The IMDIV Function
    • The IMCSCH Function
    • The IMCSC Function
    • The IMCOT Function
    • The IMCOSH Function
    • The IMCOS Function
    • The ARRAYTOTEXT Function
    • The IMCONJUGATE Function
    • The IMAGINARY Function
    • The IMARGUMENT Function
    • The IMABS Function
    • The IFS Function
    • The IFNA Function
    • The IFERROR Function
    • The HYPGEOMDIST Function
    • The HYPGEOM.DIST Function
    • The IF Function
    • The HYPERLINK Function
    • The HOUR Function
    • The HLOOKUP Function
    • The HEX2OCT Function
    • The HEX2DEC Function
    • The HEX2BIN Function
    • The HARMEAN Function
    • The GETPIVOTDATA Function
    • The GROWTH Function
    • The GESTEP Function
    • The INDIRECT Function
    • The INDEX Function
    • The GEOMEAN Function
    • The GCD Function
    • The IMTAN Function
    • The GAUSS Function
    • The GAMMALN Function
    • The GAMMALN.PRECISE Function
    • The GAMMAINV Function
    • The GAMMADIST Function
    • The GAMMA.INV Function
    • The GAMMA.DIST Function
    • The GAMMA Function
    • The FVSCHEDULE Function
    • The FV Function
    • The FTEST Function
    • The FREQUENCY Function
    • The FORMULATEXT Function
    • The FORECAST.LINEAR Function
    • The FORECAST.ETS.STAT Function
    • The FORECAST.ETS.SEASONALITY Function
    • The FORECAST.ETS.CONFINT Function
    • The FORECAST.ETS Function
    • The FORECAST Function
    • The FLOOR.MATH Function
    • The FLOOR.PRECISE Function
    • The FLOOR Function
    • The FIXED Function
    • The FISHERINV Function
    • The FISHER Function
    • The FINV Function
    • The FINDB Function
    • The FIND Function
    • The FILTERXML Function
    • The FILTER Function
    • The FIELDVALUE Function
    • The FDIST Function
    • The FALSE Function
    • The FACTDOUBLE Function
    • The FACT Function
    • The F.TEST Function
    • The F.INV.RT Function
    • The F.INV Function
    • The F.DIST.RT Function
    • The F.DIST Function
    • The EXPONDIST Function
    • The EXPON.DIST Function
    • The EXP Function
    • The EXACT Function
    • The EVEN Function
    • The EUROCONVERT Function
    • The ERROR.TYPE Function
    • The ERFC.PRECISE Function
    • The ERFC Function
    • The ERF.PRECISE Function
    • The ERF Function
    • The EOMONTH Function
    • The ENCODEURL Function
    • The EFFECT Function
    • The EDATE Function
    • The DVARP Function
    • The DVAR Function
    • The DURATION Function
    • The DSUM Function
    • The DSTDEVP Function
    • The DSTDEV Function
    • The DPRODUCT Function
    • The DOLLARFR Function
    • The DOLLARDE Function
    • The DOLLAR Function
    • The DMIN Function
    • The DMAX Function
    • The DISC Function
    • The DGET Function
    • The DEVSQ Function
    • The DELTA Function
    • The DEGREES Function
    • The DECIMAL Function
    • The DEC2OCT Function
    • The DEC2HEX Function
    • The DEC2BIN Function
    • The DDB Function
    • The DCOUNTA Function
    • The DCOUNT Function
    • The DBCS Function
    • The DB Function
    • The DAYS360 Function
    • The DAYS Function
    • The DAY Function
    • The DAVERAGE Function
    • The DATEVALUE Function
    • The DATEDIF Function
    • The DATE Function
    • The CUMPRINC Function
    • The CUBEVALUE Function
    • The CUBESETCOUNT Function
    • The CUBESET Function
    • The CUBERANKEDMEMBER Function
    • The CUBEMEMBERPROPERTY Function
    • The CUBEMEMBER Function
    • The CUBEKPIMEMBER Function
    • The CSCH Function
    • The CSC Function
    • The CRITBINOM Function
    • The CORVARIANCE.S Function
    • The CORVARIANCE.P Function
    • The COVAR Function
    • The COUPPCD Function
    • The COUPNUM Function
    • The COUPNCD Function
    • The COUPDAYSNC Function
    • The COUPDAYS Function
    • The COUPDAYBS Function
    • The COUNTIFS Function
    • The COUNTIF Function
    • The COUNTBLANK Function
    • The COUNTA Function
    • The COUNT Function
    • The COTH Function
    • The COT Function
    • The COSH Function
    • The COS Function
    • The CORREL Function
    • The CONVERT Function
    • The CONFIDENCE.T Function
    • The CONFIDENCE.NORM Function
    • The CONFIDENCE Function
    • The CONCATENATE Function
    • The CONCAT Function
    • The COMPLEX Function
    • The COMBINA Function
    • The COMBIN Function
    • The COLUMNS Function
    • The COLUMN Function
    • The CODE Function
    • The CLEAN Function
    • The CHOOSE Function
    • The CHITEST Function
    • The CHISQ.TEST Function
    • The CHISQ.INV.RT Function
    • The CHISQ.INV Function
    • The CHISQ.DIST.RT Function
    • The CHISQ.DIST Function
    • The CHIINV Function
    • The CHIDIST Function
    • The CHAR Function
    • The CELL Function
    • The CEILING.PRECISE Function
    • The CEILING.MATH Function
    • The CEILING Function
    • The CUMIPMT Function
    • The CALL Function
    • The BITXOR Function
    • The BITRSHIFT Function
    • The BITOR Function
    • The BITLSHIFT Function
    • The BITAND Function
    • The BINOM.INV Function
    • The BINOM.DIST.RANGE Function
    • The BINOMDIST Function
    • The BINOM.DIST Function
    • The BIN2OCT Function
    • The BIN2HEX Function
    • The BIN2DEC Function
    • The BETAINV Function
    • The BETA.INV Function
    • The BETADIST Function
    • The BETA.DIST Function
    • The BESSELY Function
    • The BESSELK Function
    • The BESSELJ Function
    • The BESSELI Function
    • The BASE Function
    • The BAHTTEXT Function
    • The AVERAGEIFS Function
    • The AVERAGEIF Function
    • The AVERAGEA Function
    • The AVERAGE Function
    • The AVEDEV Function
    • The ATANH Function
    • The ATAN2 Function
    • The ATAN Function
    • The ASINH Function
    • The ASIN Function
    • The ASC Function
    • The AREAS Function
    • The ARABIC Function
    • The AND Function
    • The AMORLINC Function
    • The AMORDEGRC Function
    • The AGGREGATE Function
    • The ADDRESS Function
    • The ACOTH Function
    • The ACOT Function
    • The ACOSH Function
    • The ACOS Function
    • The ACCRINTM Function
    • The ACCRINT Function
    • The ABS Function
  • Charts And Dashboards Blogs
    • The Horizontal Raincloud Chart – Part 4
    • The Horizontal Raincloud Chart – Part 3
    • The Horizontal Raincloud Chart – Part 2
    • The Horizontal Raincloud Chart – Part 1
    • The Marimekko Chart – Part 4
    • The Marimekko Chart – Part 3
    • The Marimekko Chart – Part 2
    • The Marimekko Chart – Part 1
    • The Triangular Distribution Chart
    • The Bubble Pie Chart - Part 3
    • The Bubble Pie Chart - Part 2
    • The Bubble Pie Chart - Part 1
    • The Point and Figure Chart – Part 4
    • The Point and Figure Chart – Part 3
    • The Point and Figure Chart – Part 2
    • The Point and Figure Chart – Part 1
    • Working Capital Adjustment Chart in Detail – Part 4
    • Working Capital Adjustment Chart in Detail – Part 3
    • Working Capital Adjustment Chart in Detail – Part 2
    • Working Capital Adjustment Chart in Detail – Part 1
    • Histogram Hiccoughs – Part 3
    • Histogram Hiccoughs – Part 2
    • Histogram Hiccoughs – Part 1
    • Gauging Success – Part 2
    • Gauging Success – Part 1
    • Letting Your Charts Take a Break
    • Learning our Lines – Part 3
    • Learning our Lines – Part 2
    • Learning our Lines – Part 1
    • The Waffle Chart
    • The Risk Bubble Chart – Part 4
    • The Risk Bubble Chart – Part 3
    • The Risk Bubble Chart – Part 2
    • The Risk Bubble Chart – Part 1
    • Vertical Raincloud Chart Part 4
    • Vertical Raincloud Chart Part 3
    • Vertical Raincloud Chart Part 2
    • Vertical Raincloud Chart Part 1
    • Custom Axes – Part 3
    • Custom Axes – Part 2
    • Custom Axes – Part 1
    • Dynamic Arrays in Charts
    • Charting Example – Extended Case Study Part 6
    • Charting Example – Extended Case Study Part 5
    • Charting Example – Extended Case Study Part 4
    • Charting Example - Extended Case Study Part 3
    • Charting Example – Extended Case Study Part 2
    • Charting Example – Extended Case Study Part 1
    • Chart Titles as a Text Box Revisited
    • Asking the Right Questions with Analyze Data
    • A Quick Look at Analysis
    • Recommended Charts
    • Graphing Missing Data
    • Braving the Elements
    • Surface Charts
    • Data Tables - Part 5
    • Data Tables - Part 4
    • Data Tables - Part 3
    • Data Tables - Part 2
    • Data Tables - Part 1
    • Tornado Charts - Part 3
    • Tornado Charts - Part 2
    • Tornado Charts - Part 1
    • Creating Comparable Charts - Part 2
    • Creating Comparable Charts - Part 1
    • Conditional Chart Labelling – Part 4
    • Conditional Chart Labelling – Part 3
    • Conditional Chart Labelling – Part 2
    • Conditional Chart Labelling – Part 1
    • Presentation Pitfalls Part 3
    • Presentation Pitfalls Part 2
    • Presentation Pitfalls Part 1
    • Time-Saving Template
    • Venn Diagrams Part 3
    • Venn Diagrams Part 2
    • Venn Diagrams Part 1
    • Sparkling Sparklines Part 2
    • Sparkling Sparklines Part 1
    • Thermometer Chart Part 2
    • Thermometer Chart Part 1
    • Step Chart
    • Sales Funnel Chart – Part 2
    • Sales Funnel Chart – Part 1
    • Pareto Power
    • Pareto Plus
    • Problem Solving with Pareto Charts
    • Great Gantt - Part 2
    • Great Gantt - Part 1
    • Marking Milestones - Part 2
    • Marking Milestones - Part 1
    • More Target Practice
    • Target Practice
    • A Bar Chart with Dynamic Ordering – Part 2
    • A Bar Chart with Dynamic Ordering – Part 1
    • Chart Titles as a Text Box
    • Moving Chart Labels – Part 2
    • Moving Chart Labels – Part 1
    • Dynamic Legend
    • Conditional Donut Chart – Part 3
    • Conditional Donut Chart – Part 2
    • Conditional Donut Chart – Part 1
    • Bullet Charts – Part 3
    • Bullet Charts – Part 2
    • Bullet Charts – Part 1
    • Dynamic Chart Labels for Stacked Column Charts
    • Customised Chart Shapes – Part 2
    • Customised Chart Shapes – Part 1
    • Working Capital Adjustment Chart
    • Dynamic Simulation Charts
    • Dynamic Chart Labels
    • Dynamic Chart Titles
    • Rolling Charts
    • Multiple Bullet Charts – Part 2
    • Multiple Bullet Charts – Part 1
    • Linking Excel Charts to Power Point
    • Symbol Charts – Part 2
    • Symbol Charts – Part 1
    • Sparklines
    • Dashboard Design – Using Tables and Conditional Formatting
    • Dashboard Workbook Layout – Part 3
    • Dashboard Workbook Layout – Part 2
    • Dashboard Workbook Layout – Part 1
    • Interactive Charts – Part 4: Introduction to ActiveX Controls
    • Interactive Charts – Part 3: Data Validation
    • Interactive Charts – Part 2: Form Controls (Continued)
    • Interactive Charts – Part 1: Form Controls
    • Dynamic Charts – Part 3
    • Dynamic Charts – Part 2
    • Dynamic Charts – Part 1
    • Hiding Data - Part 2
    • Hiding Data - Part 1
    • Highlighting Data
    • PivotChart – Part 2: Interactivity
    • PivotChart – Part 1: Creating a PivotChart
    • Introduction to Data Ranges and Data Tables
    • Waterfall Charts – Part 2
    • Waterfall Charts – Part 1
    • Funnel Charts
    • Introducing the Camera Tool for Dashboards
    • Box and Whisker Charts
    • Stock Charts
    • Treemap Charts
    • Sunburst Charts
    • Radar Charts
    • Scatter Charts
    • Pie of Pie Charts
    • Pie Charts
    • Bar Charts
    • Column Charts
    • Line Charts
    • Chart Tools – Contextual Tabs (Part 2)
    • Chart Tools – Contextual Tabs (Part 1)
    • Chart Design Best Practice – Part 3: Memorable Charts
    • Chart Design Best Practice – Part 2: Colours and Compositions
    • Chart Design Best Practice – Part 1: Which Chart When?
    • Understanding Chart Elements
    • How to Create a Chart
    • Getting to Know Charts in Excel
  • FFF MMM
    • Monday Morning Mulling: October 2024 Challenge
    • Final Friday Fix: October 2024 Challenge
    • Monday Morning Mulling: September 2024 Challenge
    • Final Friday Fix: September 2024 Challenge
    • Monday Morning Mulling: August 2024 Challenge
    • Final Friday Fix: August 2024 Challenge
    • Monday Morning Mulling: July 2024 Challenge
    • Final Friday Fix: July 2024 Challenge
    • Monday Morning Mulling: June 2024 Challenge
    • Final Friday Fix: June 2024 Challenge
    • Monday Morning Mulling: May 2024 Challenge
    • Final Friday Fix: May 2024 Challenge
    • Monday Morning Mulling: April 2024 Challenge
    • Final Friday Fix: April 2024 Challenge
    • Monday Morning Mulling: March 2024 Challenge
    • Final Friday Fix: March 2024 Challenge
    • Monday Morning Mulling: February 2024 Challenge
    • Final Friday Fix: February 2024 Challenge
    • Monday Morning Mulling: January 2024 Challenge
    • Final Friday Fix: January 2024 Challenge
    • Monday Morning Mulling: December 2023 Challenge
    • Final Friday Fix: December 2023 Challenge
    • Monday Morning Mulling: November 2023 Challenge
    • Final Friday Fix: November 2023 Challenge
    • Monday Morning Mulling: October 2023 Challenge
    • Final Friday Fix: October 2023 Challenge
    • Monday Morning Mulling: September 2023 Challenge
    • Final Friday Fix: September 2023 Challenge
    • Monday Morning Mulling: August 2023 Challenge
    • Final Friday Fix: August 2023 Challenge
    • Monday Morning Mulling: July 2023 Challenge
    • Final Friday Fix: July 2023 Challenge
    • Monday Morning Mulling: June 2023 Challenge
    • Final Friday Fix: June 2023 Challenge
    • Monday Morning Mulling: May 2023 Challenge
    • Final Friday Fix: May 2023 Challenge
    • Monday Morning Mulling: April 2023 Challenge
    • Final Friday Fix: April 2023 Challenge
    • Monday Morning Mulling: March 2023 Challenge
    • Final Friday Fix: March 2023 Challenge
    • Monday Morning Mulling: February 2023 Challenge
    • Final Friday Fix: February 2023 Challenge
    • Monday Morning Mulling: January 2023 Challenge
    • Final Friday Fix: January 2023 Challenge
    • Monday Morning Mulling: December 2022 Challenge
    • Final Friday Fix: December 2022 Challenge
    • Monday Morning Mulling: November 2022 Challenge
    • Final Friday Fix: November 2022 Challenge
    • Monday Morning Mulling: October 2022 Challenge
    • Final Friday Fix: October 2022 Challenge
    • Monday Morning Mulling: September 2022 Challenge
    • Final Friday Fix: September 2022 Challenge
    • Monday Morning Mulling: August 2022 Challenge
    • Final Friday Fix: August 2022 Challenge
    • Monday Morning Mulling: July 2022 Challenge
    • Final Friday Fix: July 2022 Challenge
    • Monday Morning Mulling: June 2022 Challenge
    • Final Friday Fix: June 2022 Challenge
    • Monday Morning Mulling: May 2022 Challenge
    • Final Friday Fix: May 2022 Challenge
    • Monday Morning Mulling: April 2022 Challenge
    • Final Friday Fix: April 2022 Challenge
    • Monday Morning Mulling: March 2022 Challenge
    • Final Friday Fix: March 2022 Challenge
    • Monday Morning Mulling: February 2022 Challenge
    • Final Friday Fix: February 2022 Challenge
    • Monday Morning Mulling: January 2022 Challenge
    • Final Friday Fix: January 2022 Challenge
    • Monday Morning Mulling: December 2021 Challenge
    • Final Friday Fix: December 2021 Challenge
    • Monday Morning Mulling: November 2021 Challenge
    • Final Friday Fix: November 2021 Challenge
    • Monday Morning Mulling: October 2021 Challenge
    • Final Friday Fix: October 2021 Challenge
    • Monday Morning Mulling: September 2021 Challenge
    • Final Friday Fix: September 2021 Challenge
    • Monday Morning Mulling: August 2021 Challenge
    • Final Friday Fix: August 2021 Challenge
    • Monday Morning Mulling: July 2021 Challenge
    • Final Friday Fix: July 2021 Challenge
    • Monday Morning Mulling – June 2021
    • Final Friday Fix – June 2021
    • Monday Morning Mulling: May 2021 Challenge
    • Final Friday Fix: May 2021 Challenge
    • Monday Morning Mulling: April 2021 Challenge
    • Final Friday Fix: April 2021 Challenge
    • Monday Morning Mulling: February 2021 Challenge
    • Final Friday Fix: February 2021 Challenge
    • Monday Morning Mulling: December 2020 Challenge
    • Final Friday Fix: December 2020 Challenge
    • Monday Morning Mulling: November 2020 Challenge
    • Final Friday Fix: November 2020 Challenge
    • Monday Morning Mulling: October 2020 Challenge
    • Final Friday Fix: October 2020 Challenge
    • Monday Morning Mulling: September 2020 Challenge
    • Final Friday Fix: September 2020 Challenge
    • Monday Morning Mulling: August 2020 Challenge
    • Final Friday Fix: August 2020 Challenge
    • Monday Morning Mulling: July 2020 Challenge
    • Final Friday Fix: July 2020 Challenge
    • Monday Morning Mulling: June 2020 Challenge
    • Final Friday Fix: June 2020 Challenge
    • Monday Morning Mulling: April 2020 Challenge
    • Final Friday Fix: April 2020 Challenge
    • Monday Morning Mulling: March 2019 Challenge
    • Final Friday Fix: March 2020 Challenge
    • Monday Morning Mulling: February 2020 Challenge
    • Final Friday Fix: February 2020 Challenge
    • Monday Morning Mulling: January 2020 Challenge
    • Final Friday Fix: January 2020 Challenge
    • Monday Morning Mulling: October Challenge
  • Power Bi Blog
    • Teams Activity Analytics Report To Be Retired
    • Introducing The New INFO.VIEW Data Analysis eXpressions (DAX) Functions
    • Visual Calculations Updated
    • Power BI in Teams Now Supporting Multi Factor Authentication
    • Menu Bar Updated in Power BI Service View Mode
    • Last Day of Month Subscriptions
    • Dark Mode in Power BI
    • Q&A in Power BI Desktop Revisited - Part 2
    • Q&A in Power BI Desktop Revisited – Part 1
    • Visual Level Format Strings
    • Dynamic Per Recipient Subscriptions
    • DAX Query View in the Web
    • Ask Copilot Questions Against Your Semantic Model
    • Multiple ToolTips in One Visual - Revisited
    • Considering Custom Shape Map
    • Funnel Chart – Part 2
    • Funnel Chart – Part 1
    • Power BI Enhanced Report Format (PBIR)
    • New INFO Functions
    • Power BI Home in Power BI Desktop
    • Power BI Blog: Customising a Threshold Column Chart
    • Power BI Blog: Building a Threshold Column Chart
    • Managing Relationships
    • DAX Queries Explained with Copilot
    • The Duo Chart – Part 2
    • The Duo Chart – Part 1
    • Refreshing Time on Power BI Service – Part 2
    • Refreshing Time on Power BI Service – Part 1
    • Writing DAX Queries in DAX Query View with Copilot
    • Selection Expressions for Calculation Groups
    • Editing Your Data Model in Power BI Service
    • Autocreating a Mobile Layout
    • More on Visual Calculations Part 2
    • More on Visual Calculations Part 1
    • Visual Calculations in Preview
    • Storytelling in PowerPoint
    • The Pane Switcher
    • Show Visuals as Tables
    • Reference Labels
    • Button Slicers
    • Suggested Synonyms from Copilot
    • Explore in Power BI Service
    • Highlight Event Periods – Part 2
    • Highlight Event Periods – Part 1
    • Narrative Visual with Copilot
    • Power BI Home in Desktop
    • Power BI Desktop – One Drive and SharePoint Integration
    • De-duplication Rules for Composite Models
    • More on DAX Query View
    • DAX Query View
    • Model Explorer in Preview Part 2
    • Model Explorer in Preview Part 1
    • New Features for Editing Relationships
    • Date Hierarchy Updates
    • Customised Deployment Pipelines
    • Labelling Growth on a Line Chart – Part 3
    • Labelling Growth on a Line Chart – Part 2
    • Labelling Growth on a Line Chart – Part 1
    • Combining Double Headers
    • Editing Linguistic Relationships in Q&A Setup
    • DAX Function Changes to MINX and MAXX
    • Multiple Tooltips in one Visual
    • The Magic of Dynamic Legends
    • Power BI Connected Tables
    • Choosing Start-Up Content on Power BI Mobile
    • Considering Mobile Layout
    • Better Custom Visuals
    • New DAX Function MATCHBY
    • Power BI Desktop with Files in OneDrive and SharePoint
    • Azure Maps
    • Optimizing the Ribbon
    • RANK and ROWNUMBER (New DAX Functions)
    • ORDERBY Revamped
    • Dynamic Format Strings for Measures
    • Composite Models on Power BI Datasets and Analysis Services Models
    • On-Object Interaction
    • New Styling for the Format Pane
    • Email Subscriptions
    • Visual Container Improvements
    • Apply all Slicers Button
    • Power BI Dataflows – Part 2
    • Power BI Dataflows – Part 1
    • EVALUATEANDLOG
    • New Get Data Experience in Power BI Service
    • LINEST and LINESTX Now Added to Power BI
    • Enhanced Row Level Security Editor
    • Themes in Power BI
    • Page Navigator Visual
    • Conditional Formatting Based upon String Fields
    • Connected Excel Tables
    • Unshared and Unsynchronised Axes for Small Multiples Charts
    • Subscribe to a Report with Filters Applied
    • Optimize Ribbon
    • New Way to Upload Power BI and Excel Files
    • Linked Metrics
    • Creating Dynamic Slicers using Field Parameters
    • Controlling and Customising Labels on Azure Maps
    • Datamarts – Part 8
    • Datamarts – Part 7
    • Datamarts – Part 6
    • Datamarts – Part 5
    • Datamarts – Part 4
    • Datamarts – Part 3
    • Datamarts – Part 2
    • Datamarts – Part 1
    • Row-Level Security (RLS) – Part 3
    • Row-Level Security (RLS) – Part 2
    • Row-Level Security (RLS) – Part 1
    • Quick Measure Suggestions (an Experimental Feature)
    • Hierarchical Axis (by default)
    • Display Names for Summarized Fields
    • Auto-Generate Reports on Existing Datasets in Power BI Service
    • Field Parameters – Part 4
    • Field Parameters – Part 3
    • Field Parameters – Part 2
    • Field Parameters – Part 1
    • More on Datamarts
    • Composite Models and Dynamic M Query Parameters Part 3
    • Composite Models and Dynamic M Query Parameters Part 2
    • Composite Models and Dynamic M Query Parameters Part 1
    • Metric Visuals Updated
    • New DAX Function - NETWORKDAYS
    • Recent Improvements to the Power BI Experience in Excel
    • Datamarts
    • Data Hub
    • Power BI Metrics
    • Exportable Formatted Data Tables in Power BI Service
    • Data Point Rectangle Select
    • Field Parameters
    • Canvas Zoom
    • Power BI Known Issues Page
    • Locating Links
    • Push Notifications on Mobile Applications
    • Bookmark Navigator
    • More Updates for the New Format Pane
    • Power BI Goals – Custom Statuses and Team Notifications
    • Error Bars in Preview
    • Dynamic Format Strings Now Supported for All Chart Elements
    • Not Imported
    • Refreshing to Change
    • Fully Imported
    • Power BI Goals Updated
    • Parameter Typo
    • New Format Pane, Still in Preview, Now on by Default
    • Roles with no Insight
    • Dating Part 6
    • Dating Part 5
    • Dating Part 4
    • Hybrid Tables in Power BI Premium
    • Improvements to Power BI Mobile
    • Sparklines in Preview
    • QR Codes with URL Parameters for Power BI Mobile
    • Scorecards and Power BI Goals
    • Pie and Donut Chart Rotation
    • New Page and Bookmark Navigators
    • New Format Pane
    • Dating Part 3
    • Dating Part 2
    • Dating Part 1
    • Conference Planning Part 2
    • Conference Planning Part 1
    • All in Order
    • Insights Now in Preview in Power BI
    • New Formatting Options for Buttons
    • “X” and “Non-X” functions in DAX
    • Data Formatting
    • Power BI REST API Support for DAX Queries
    • New Way of Expressing Date and DateTime Values
    • Sharing Q&A Synonyms
    • Power Automate Visual Preview
    • Power BI Desktop Installer Changes and WebView2
    • Access-ible Returns Part 3
    • Access-ible Returns Part 2
    • Access-ible Returns Part 1
    • Leave a Line
    • Draw a Line
    • Select All Operation Now Supported for Dynamic M Query Parameters
    • Q&A Improvements for Inferred Results
    • CALENDAR tables
    • Dynamic Headers
    • Monthly New Customers
    • Smart Narratives Now Generally Available
    • Share and Collaborate in Excel for the web Connected to Power BI
    • Calculating Monthly % Change Update
    • Calculating Monthly % Change
    • Gauge Visualisation – Presenting Percentages
    • Revisiting Built-In Gauge Charts
    • Maximum and Minimum Points on a Line Chart
    • Maximum and Minimum Levels on a Line Chart
    • Even More on the Decomposition Tree Visualisation
    • More on the Decomposition Tree Visualisation
    • Introducing the Decomposition Tree Visualisation
    • Ordered Legends
    • Dealing with an Excessive Number of Categories
    • Different Coloured Columns in a Stacked Column Chart
    • Different Coloured Columns in a Chart
    • Dynamic Headings for In-Between Variables
    • Easier Dynamic Heading Based on Time Slicer
    • Custom Field Formatting
    • Bulk Measure Format Reassignment
    • Power BI on Teams
    • Zoom Sliders
    • New Year, New Icons
    • Anomaly Detection
    • Canvas Watermarks
    • Using Display Folders
    • Setting Up Custom ToolTips
    • Managing Slicers
    • Extending Report Page Size
    • Analysing our Bins
    • Group Type – Bin (Grouping Numerical Values in Power BI)
    • Text Data Groups
    • Dynamically Calculating Cumulative Metrics with the ALLSELECTED Function
    • Revisiting Formatting Negative Numbers with Brackets
    • Introducing ISFILTERED
    • Dealing with Overflow on Cards
    • Ordering Slicer Selections on Cards
    • Calculating Cumulative Totals for Time Periods
    • Displaying Multiple Slicer Selections on Cards
    • Summarising the Top N Number of Cities in a Dataset
    • Creating Custom Hierarchies
    • Renaming Fields in a Custom Hierarchy
    • Summarising the Top Two Countries in a Dataset
    • Rampant Column Widths
    • Importing Fonts into Power BI
    • {Missing Field or Column Breaking Query}, No Problem!
    • Dynamic Page Selector Navigation
    • Custom Button Page Navigation
    • The COALESCE Function
    • Dual Axis Line Chart
    • Conditionally Formatting Brackets with Negatives
    • Conditionally Formatting from Text
    • Conditionally Formatting Negative Numbers
    • Custom Visualizations; Funnel/Pyramid Chart Formatting
    • Custom Visualizations – Funnel/Pyramid Chart
    • Hierarchical Filters
    • Personalize Visuals (Preview)
    • Gauge Charts
    • Dark Themes
    • Power BI Report Builder – Part 7 (Built-in Fields)
    • Power BI Report Builder – Part 6 (Using Parameters)
    • Power BI Report Builder – Part 5
    • Power BI Report Builder – Part 4 (Creating Charts)
    • Power BI Report Builder – Part 3 (Editing Print Layouts)
    • Power BI Report Builder – Part 2
    • Power BI Report Builder – Part 1 (Importing Data)
    • Impact Bubble Chart
    • Custom Visuals – the Hierarchy Tree Advanced Editor
    • Custom Visuals – the Hierarchy Tree Continued
    • Custom Visuals – the Hierarchy Tree
    • Creating Summary Tables in Power BI
    • Creating Tables in Power BI
    • Bullet Charts
    • Combo Charts
    • Dynamic Visualisation Titles
    • Presenting Several Measures on a Single Visualisation
    • Creating a Dynamic Calendar Table
    • Sydney’s Register of Food Penalty Notices – Part 6
    • New Web Table Inference (Black Friday Special)
    • Sydney’s Register of Food Penalty Notices – Part 5
    • Sydney’s Register of Food Penalty Notices – Part 4
    • Sydney’s Register of Food Penalty - Part 3
    • Sydney’s Register of Food Penalty Notices – Part 2
    • Sydney’s Register of Food Penalty Notices
    • Dynamic Images Based on Slicer Selection
    • Dynamic Headings Based on Slicer Selection
    • New Default Themes for Power BI Desktop
    • Colour Formatting Tips – Conditional Formatting for Tables
    • Colour Formatting Tips – Conditional Formatting for Column Charts
    • Colour Formatting Tips
    • Sankey Chart
    • Copy vs. Export Data from Power BI Desktop
    • Power KPI
    • Real-time Forms to Dashboard
    • New Transform - Split Column by Positions
    • New Filters Pane
    • Excel Summit South 2019
    • Floor Plan
    • Mekko Chart (cont'd)
    • Mekko Chart
    • Waffle Chart (cont'd)
    • Waffle Chart
    • June 2019 Update New Interface
    • Microsoft Business Applications Summit 2019
    • Key Influencers Binning
    • Performance Analyzer
    • Restaurant Selector
    • New Web Table from Inference
    • Waterfall Charts
    • Get Data from Exchange
    • Key Influencers - Continuous Variables
    • Data Profiling Generally Available
    • New Highlighting and Filtering Icons
    • New Model Tab
    • Custom Visuals – Infographic Designer
    • Custom Visuals – Summary Table
    • Custom Visuals - Histograms
    • Custom Visuals – Box and Whisker Chart
    • Practical Influences
    • Key Influencers Top Segments
    • Key Influencers
    • Publishing to Teams
    • Custom URLs in Table Visualisations
    • Excel Publish to Power BI
    • Microsoft Teams
    • Microsoft Ignite | The Tour Singapore
    • Keyboard Shortcuts
    • Row Level Security
    • New Course Development
    • Get Data from PDFs
    • Power BI Gateway
    • Using OneDrive and Setting up Automatic Updates - .xls Files
    • Data Profiling
    • Using OneDrive and Setting Up Automatic Updates – Part 2
    • Using OneDrive and Setting Up Automatic Updates
    • Visiting Ideas 4 – Dynamic date slicer
    • Visiting Ideas 3 – Custom Visuals template
    • Visiting Ideas 2 – DAX editor
    • Visting Ideas
    • M Intellisense
    • Q&A Row Level Security
    • Q&A Power BI Desktop
    • Tooltip Reports
    • URLs in Measures
    • Conditional Formatting Improvements
    • Quality of Life Improvements 2
    • Quality of Life Improvements
    • Upgraded Quick Insights
    • Access-ible Data - Part 3
    • SumProduct in Seattle!
    • Access-ible Data - Part 2
    • Access-ible Data - Part 1
    • Top 5 Things in Power Bi That You Probably Aren’t Using (and Really Want to Use!)
    • Just Speculate Over Numbers – Part 8
    • Just Speculate Over Numbers - Part 7
    • Just Speculate Over Numbers – Part 6
    • Just Speculate Over Numbers – Part 5
    • Just Speculate Over Numbers - Part 4
    • Just Speculate Over Numbers - Part 3
    • Just Speculate Over Numbers - Part 2
    • Just Speculate Over Numbers - Part 1
    • Xenagogue to Markup Lists - Part 3
    • Xenagogue to Markup Lists - Part 2
    • Xenagogue to Markup Lists - Part 1
    • Text isn't Limiting! - Part 5
    • Text isn't Limiting! - Part 4
    • Text isn't Limiting! - Part 3
    • Text isn't Limiting! - Part 2
    • Text isn't Limiting! - Part 1
    • Excel-sior Part 3
    • Excel-sior Part 2
    • Excel-sior - Part 1
    • Get Data – Connecting to Different Data Sources
    • Which Power BI should I use?
    • When should we use Power BI and when should we use Excel?
    • Excel vs. Power BI – when to use which?
    • Introduction to Power BI
  • Power Pivot Principles
    • The A to Z of DAX Functions – INFO.MEASURES
    • The A to Z of DAX Functions – INFO.LINGUISTICMETADATA
    • The A to Z of DAX Functions – INFO.LEVELS
    • The A to Z of DAX Functions – INFO.KPIS
    • The A to Z of DAX Functions – INFO.HIERARCHYSTORAGES
    • The A to Z of DAX Functions – INFO.HIERARCHIES
    • The A to Z of DAX Functions – INFO.GROUPBYCOLUMNS
    • The A to Z of DAX Functions – INFO.GENERALSEGMENTMAPSEGMENTMETADATASTORAGES
    • The A to Z of DAX Functions – INFO.FUNCTIONS
    • The A to Z of DAX Functions – INFO.FORMATSTRINGDEFINITIONS
    • The A to Z of DAX Functions – INFO.EXTENDEDPROPERTIES
    • The A to Z of DAX Functions – INFO.EXPRESSIONS
    • The A to Z of DAX Functions – INFO.CATALOGS
    • The A to Z of DAX Functions – INFO.DICTIONARYSTORAGES
    • The A to Z of DAX Functions – INFO.DETAILROWSDEFINITION
    • The A to Z of DAX Functions – INFO.DELTATABLEMETADATASTORAGES
    • The A to Z of DAX Functions – INFO.DATASOURCES
    • The A to Z of DAX Functions – INFO.CALCDEPENDENCY
    • The A to Z of DAX Functions – INFO.CULTURES
    • The A to Z of DAX Functions – INFO.COLUMNSTORAGES
    • The A to Z of DAX Functions – INFO.COLUMNS
    • The A to Z of DAX Functions – INFO.COLUMNPERMISSIONS
    • The A to Z of DAX Functions – INFO.COLUMNPARTITIONSTORAGES
    • The A to Z of DAX Functions – INFO.CHANGEDPROPERTIES
    • The A to Z of DAX Functions – INFO.CALCULATIONITEMS
    • The A to Z of DAX Functions – INFO.CALCULATIONGROUPS
    • The A to Z of DAX Functions – INFO.ATTRIBUTEHIERARCHYSTORAGES
    • The A to Z of DAX Functions – INFO.ATTRIBUTEHIERARCHIES
    • The A to Z of DAX Functions – INFO.ANNOTATIONS
    • The A to Z of DAX Functions – INFO.ALTERNATEOFDEFINITIONS
    • The A to Z of DAX Functions – INDEX
    • The A to Z of DAX Functions – IGNORE
    • The A to Z of DAX Functions – IFERROR
    • The A to Z of DAX Functions – IF.EAGER
    • The A to Z of DAX Functions – IF
    • The A to Z of DAX Functions – HOUR
    • The A to Z of DAX Functions – HASONEVALUE
    • The A to Z of DAX Functions – HASONEFILTER
    • The A to Z of DAX Functions – GROUPBY
    • The A to Z of DAX Functions – GEOMEANX
    • The A to Z of DAX Functions – GEOMEAN
    • The A to Z of DAX Functions – GENERATESERIES
    • The A to Z of DAX Functions – GENERATEALL
    • The A to Z of DAX Functions – GENERATE
    • The A to Z of DAX Functions – GCD
    • The A to Z of DAX Functions – FV
    • The A to Z of DAX Functions – FORMAT
    • The A to Z of DAX Functions – FLOOR
    • The A to Z of DAX Functions – FIXED
    • The A to Z of DAX Functions – FIRSTNONBLANKVALUE
    • The A to Z of DAX Functions – FIRSTNONBLANK
    • The A to Z of DAX Functions – FIRSTDATE
    • The A to Z of DAX Functions – FIND
    • The A to Z of DAX Functions – FILTERS
    • The A to Z of DAX Functions – FILTER
    • The A to Z of DAX Functions – FALSE
    • The A to Z of DAX Functions – FACT
    • The A to Z of DAX Functions – EXPON.DIST
    • The A to Z of DAX Functions – EXP
    • The A to Z of DAX Functions – EXCEPT
    • The A to Z of DAX Functions – EXACT
    • The A to Z of DAX Functions – EVEN
    • The A to Z of DAX Functions – EVALUATEANDLOG
    • The A to Z of DAX Functions – EVALUATE
    • The A to Z of DAX Functions – ERROR
    • The A to Z of DAX Functions – EOMONTH
    • The A to Z of DAX Functions – ENDOFYEAR
    • The A to Z of DAX Functions – ENDOFQUARTER
    • The A to Z of DAX Functions – ENDOFMONTH
    • The A to Z of DAX Functions – EFFECT
    • The A to Z of DAX Functions – EDATE
    • The A to Z of DAX Functions – EARLIEST
    • The A to Z of DAX Functions – EARLIER
    • The A to Z of DAX Functions – DURATION
    • The A to Z of DAX Functions – DOLLARFR
    • The A to Z of DAX Functions – DOLLARDE
    • The A to Z of DAX Functions – DIVIDE
    • The A to Z of DAX Functions – DISTINCTCOUNTNOBLANK
    • The A to Z of DAX Functions – DISTINCTCOUNT
    • The A to Z of DAX Functions – DISTINCT(table)
    • The A to Z of DAX Functions – DISTINCT(column)
    • The A to Z of DAX Functions – DISC
    • The A to Z of DAX Functions – DETAILROWS
    • The A to Z of DAX Functions – DEGREES
    • The A to Z of DAX Functions – DEFINE
    • The A to Z of DAX Functions – DDB
    • The A to Z of DAX Functions – DB
    • The A to Z of DAX Functions – DAY
    • The A to Z of DAX Functions – DATEVALUE
    • The A to Z of DAX Functions – DATESYTD
    • The A to Z of DAX Functions – DATESQTD
    • The A to Z of DAX Functions – DATESMTD
    • The A to Z of DAX Functions – DATESINPERIOD
    • The A to Z of DAX Functions – DATESBETWEEN
    • The A to Z of DAX Functions – DATEDIFF
    • The A to Z of DAX Functions – DATEADD
    • The A to Z of DAX Functions – DATE
    • The A to Z of DAX Functions – DATATABLE
    • The A to Z of DAX Functions – CUSTOMDATA
    • The A to Z of DAX Functions – CURRENTGROUP
    • The A to Z of DAX Functions – CURRENCY
    • The A to Z of DAX Functions – CUMPRINC
    • The A to Z of DAX Functions – CUMIPMT
    • The A to Z of DAX Functions – CROSSJOIN
    • The A to Z of DAX Functions – CROSSFILTER
    • The A to Z of DAX Functions – COUPPCD
    • The A to Z of DAX Functions – COUPNUM
    • The A to Z of DAX Functions – COUPNCD
    • The A to Z of DAX Functions – COUPDAYSNC
    • The A to Z of DAX Functions – COLUMNSTATISTICS
    • The A to Z of DAX Functions – COUPDAYS
    • The A to Z of DAX Functions – COUPDAYBS
    • The A to Z of DAX Functions – COUNTX
    • The A to Z of DAX Functions – COUNTROWS
    • The A to Z of DAX Functions – COUNTBLANK
    • The A to Z of DAX Functions – COUNTAX
    • The A to Z of DAX Functions – COUNTA
    • The A to Z of DAX Functions – COUNT
    • The A to Z of DAX Functions – COTH
    • The A to Z of DAX Functions – COT
    • The A to Z of DAX Functions – COSH
    • The A to Z of DAX Functions – COS
    • The A to Z of DAX Functions – CONVERT
    • The A to Z of DAX Functions – CONTAINSSTRINGEXACT
    • The A to Z of DAX Functions – CONTAINSSTRING
    • The A to Z of DAX Functions – CONTAINSROW
    • The A to Z of DAX Functions – CONTAINS
    • The A to Z of DAX Functions – CONFIDENCE.T
    • The A to Z of DAX Functions – CONFIDENCE.NORM
    • The A to Z of DAX Functions – CONCATENATEX
    • The A to Z of DAX Functions – CONCATENATE
    • The A to Z of DAX Functions – COMBINEVALUES
    • The A to Z of DAX Functions – COMBINA
    • The A to Z of DAX Functions – COMBIN
    • The A to Z of DAX Functions – COALESCE
    • The A to Z of DAX Functions – BITXOR
    • The A to Z of DAX Functions – BITRSHIFT
    • The A to Z of DAX Functions – BITOR
    • The A to Z of DAX Functions – BITLSHIFT
    • The A to Z of DAX Functions – BITAND
    • The A to Z of DAX Functions – APPROXIMATEDISTINCTCOUNT
    • The A to Z of DAX Functions – AMORLINC
    • The A to Z of DAX Functions – AMORDEGRC
    • The A to Z of DAX Functions – ALLCROSSFILTERED
    • The A to Z of DAX Functions – ACCRINTM
    • The A to Z of DAX Functions – ACCRINT
    • The A to Z of DAX Functions – CLOSINGBALANCEYEAR
    • The A to Z of DAX Functions – CLOSINGBALANCEQUARTER
    • The A to Z of DAX Functions – CLOSINGBALANCEMONTH
    • The A to Z of DAX Functions – CHISQ.INV.RT
    • The A to Z of DAX Functions – CHISQ.INV
    • The A to Z of DAX Functions – CHISQ.DIST.RT
    • The A to Z of DAX Functions – CHISQ.DIST
    • The A to Z of DAX Functions – CEILING
    • Generating a List of Measure Descriptions
    • The A to Z of DAX Functions – CALENDARAUTO
    • The A to Z of DAX Functions – CALENDAR
    • The A to Z of DAX Functions – CALCULATETABLE
    • The A to Z of DAX Functions – CALCULATE
    • The A to Z of DAX Functions – BLANK
    • The A to Z of DAX Functions – BETA.INV
    • The A to Z of DAX Functions – BETA.DIST
    • The A to Z of DAX Functions – AVERAGEX
    • The A to Z of DAX Functions – AVERAGEA
    • The A to Z of DAX Functions – AVERAGE
    • The A to Z of DAX Functions – ATANH
    • The A to Z of DAX Functions – ATAN
    • The A to Z of DAX Functions – ASINH
    • The A to Z of DAX Functions – ASIN
    • The A to Z of DAX Functions – AND
    • The A to Z of DAX Functions – ALLSELECTED
    • The A to Z of DAX Functions – ALLNOBLANKROW
    • The A to Z of DAX Functions – ALLEXCEPT
    • The A to Z of DAX Functions – ALL
    • The A to Z of DAX Functions – ADDMISSINGITEMS
    • The A to Z of DAX Functions – ACOTH
    • The A to Z of DAX Functions – ACOT
    • The A to Z of DAX Functions – ACOSH
    • The A to Z of DAX Functions – ACOS
    • The A to Z of DAX Functions – ABS
    • Calculated Field vs. Measure
    • Initial Measures – a Pro Tip
    • COGS and COGS Cash Payments
    • PREVIOUSQUARTER Comparison
    • PREVIOUSMONTH Comparison
    • PARALLELPERIOD Comparison
    • DATEADD Comparison
    • Annual / Monthly Comparisons
    • Slicing the Bridge
    • How Did I Bridge the Gaps?
    • Bridging the Gaps
    • Data Cleansing
    • Credit Transactions
    • Budget vs Actuals
    • Sensitivity Analysis
    • Creating a Disconnected Table for GST
    • Amendments Made Easily
    • Calculating Measures
    • Summarising a Budget
    • Hiding Subtotals
    • Slicers for Columns – Part 2
    • Slicers for Columns – Part 1
    • SWITCH the Slicer
    • More PivotCharts from the Power Pivot Data Model
    • Creating PivotCharts from the Power Pivot Data Model
    • Size Can Be Everything
    • Nothing to Draw a BLANK About – ISBLANK Zero?
    • Problems with 1 Month Ago – DATEADD vs. PREVIOUSMONTH
    • Getting the Measure of a Measure – Multiple Measure Management
    • Using Measures to Define Target Value in KPIs
    • Introduction to Key Performance Indicators (KPIs) in Power Pivot
    • Working with Averages – Part 2
    • Working with Averages – Part 1
    • Introducing the REMOVEFILTERS Function in DAX
    • Using the ALLNOBLANKROW Function to Calculate The Percentage of Total
    • Introducing the ALLNOBLANKROW Function
    • SWITCH with an Expression
    • Irregular Month-End Reporting Case – Part 6
    • Irregular Month-End Reporting Case – Part 5
    • Irregular Month-End Reporting Case – Part 4
    • Irregular Month-End Reporting Case – Part 3
    • Irregular Month-End Reporting Case – Part 2
    • Irregular Month-End Reporting Case – Part 1
    • HASONEFILTER vs. HASONEVALUE vs. ISFILTERED
    • Introducing the HASONEFILTER Function
    • ISCROSSFILTERED vs ISFILTERED Functions
    • Introducing the FILTERS Function
    • The A to Z of DAX Functions – ADDCOLUMNS
    • Introducing the FILTER Function
    • Introducing the PREVIOUSDAY / MONTH / QUARTER / YEAR Functions
    • DISTINCT vs. VALUES
    • Introducing the VALUES Function
    • DISTINCT vs. DISTINCTCOUNT
    • Introducing the DISTINCT function
    • Power Pivot Principle: Introducing the RELATEDTABLE function
    • RELATED vs LOOKUPVALUE
    • Is there anything RELATED?
    • Duplicate Column Names
    • Accurate Totals
    • Sorting Financial Year Months in Power Pivot
    • Finding the Top N Values in a Dataset
    • Using DAX Studio to Return a Table Expression
    • Introducing the Function FIRSTNONBLANK
    • Using USERELATIONSHIP to Activate an Inactive Relationship
    • Using SELECTCOLUMNS to Create Calendar Table
    • Using ADDCOLUMNS to Create a Calendar Table
    • Ambiguity of Bidirectional Relationships in Power BI
    • Introducing the Function CROSSFILTER
    • Parameter Table
    • Bidirectional Relationships in Power Pivot
    • Introducing the Function PARALLELPERIOD
    • Introducing the Function CROSSJOIN
    • Introducing the Function DISTINCTCOUNT
    • Introducing the Function INTERSECT
    • Counting Working Days
    • Introducing the DATESBETWEEN Function
    • Introducing the ADDCOLUMNS Function
    • Understanding Functions for Parent-Child Hierarchies in DAX – Part 4
    • Introducing the Function LOOKUPVALUE
    • Understanding Functions for Parent-Child Hierarchies in DAX – Part 3
    • Understanding Functions for Parent-Child Hierarchies in DAX – Part 2
    • Understanding functions for parent-child hierarchies in DAX – Part 1
    • Introducing the CROSSFILTER Function
    • Selecting from Multiple Lookup Values
    • Introducing the SAMEPERIODLASTYEAR Function
    • Power Pivot Principles : Creating a Calendar Table
    • Introducing the SUMMARIZE Function
    • Power Pivot Principles : Introducing the HASONEVALUE Function
    • Properly Calculating Weighted Totals with the ISFILTERED Function
    • Introducing the SUBSTITUTE Function
    • Introducing the REPLACE Function
    • Calculating Cumulative Totals with Variables
    • Cumulative Totals with the EARLIER Function
    • Introducing the EARLIER Function
    • Highlighting Absent Students
    • Dynamic Ranges and Periods for Rolling Averages
    • Dynamic Ranges for Rolling Averages
    • Introducing the LASTDATE Function
    • Introducing the DATESINPERIOD Function
    • Dynamic Ranking based on Selection Filters
    • Introducing the RANKX Function
    • Grouping Text Columns with New Categories Dynamically using an Input Table – Part 2
    • Grouping Text Columns with New Categories Dynamically using an Input Table
    • Introducing the LASTNONBLANK Function
    • Grouping Text Columns with New Categories
    • Introducing the SEARCH Function
    • Introducing the CONCATENATE Function
    • Introducing the NOT Function
    • Introducing the SWITCH Function
    • Introducing the MEDIANX Function
    • Introducing the MEDIAN Function
    • MAXX with Filter Criteria
    • MAXX
    • Conditional Custom Columns with Four Categories
    • Conditional Custom Columns Using IF, OR and ‘||’
    • Conditional Custom Columns Using IF, AND, and ‘&&’
    • How to Create the CAGR Measure, Part 3
    • How to Create the CAGR Measure, Part 2
    • How to Create the CAGR Measure, Part 1
    • Introducing the DIVIDE Function
    • Introducing the CALCULATETABLE Function
    • Introducing the SUMX function
    • Revisiting the SUM function
    • Variables and Disconnected Tables in Power Pivot
    • Variables and Disconnected Tables in Power BI
    • Variables in DAX
    • KEEPFILTERS to the Rescue
    • When the CALCULATE Function Misbehaves.
    • Lookups in Power Pivot
    • How to Combine Three or More Filter Criteria into One CALCULATE Measure
    • Concatenating Filters
    • Introducing the IN Function
    • Introducing the DATEADD Function
    • DAX Syntax Requirements – Naming Conventions
    • DAX Requirements – Fully Qualified Names
    • Resource Management with Calculated Columns
    • Perspectives
    • Tips on Calculated Columns
    • Importance of Contiguous Dates
    • Introducing the CLOSINGBALANCEMONTH Function
    • How to Refresh Data in Power Pivot
    • Introducing the TOTALYTD Function
    • Introducing the DATESYTD Function
    • Basic Use of Calendar Table
    • Calendar Table
    • Filters Revisited
    • Disconnected Tables and Exchange Rates
    • Calculating with Other Tables
    • Tidying Data
    • Introducing Slicers
    • Multiple Table Management
    • Filters
    • Power PivotTables with Multiple Tables
    • ALLSELECTED
    • ALLEXCEPT
    • Introducing ALL
    • Caution when Negating Formulae
    • Doing More with CALCULATE
    • Introducing CALCULATE
    • Power PivotTables
    • Drawing a BLANK on Error Traps
    • Measure Creation in Practice
    • Recognising Measures
    • Introducing Measures and Aggregations
    • Calculated Columns
    • Tables, Fields and Measures
    • Power Pivot Menu in Excel
    • Advancing the Series
    • A Design for Life
    • Menu Options
    • Creating Relationships
    • Importing from an Access Database (Continued) and Formatting Data
    • Importing from an Access Database
    • Filtered Imports
    • Importing Data from Excel
    • Importing Data
    • Excel Compatibility
    • Introduction
  • Power Query Blogs
    • Fuzzy Fixing Part 1
    • It’s Good to Share(Point) Part 8
    • It’s Good to Share(Point) Part 7
    • It’s Good to Share(Point) Part 6
    • It’s Good to Share(Point) Part 5
    • It’s Good to Share(Point) Part 4
    • It’s Good to Share(Point) Part 3
    • It’s Good to Share(Point) Part 2
    • It’s Good to Share(Point) Part 1
    • Filtering of Choice Part 4
    • Filtering of Choice Part 3
    • Filtering of Choice Part 2
    • Filtering of Choice Part 1
    • Month Mayhem – Part 8
    • Month Mayhem – Part 7
    • Month Mayhem – Part 6
    • Month Mayhem – Part 5
    • Month Mayhem – Part 4
    • Month Mayhem – Part 3
    • Month Mayhem – Part 2
    • Month Mayhem – Part 1
    • Revision Time – Part 12
    • Revision Time – Part 11
    • Revision Time – Part 10
    • Revision Time – Part 9
    • Revision Time – Part 8
    • Revision Time – Part 7
    • Revision Time – Part 6
    • Revision Time – Part 5
    • Revision Time – Part 4
    • Revision Time – Part 3
    • Revision Time – Part 2
    • Revision Time – Part 1
    • Heading Off – Part 8
    • Heading Off – Part 7
    • Heading Off – Part 6
    • Heading Off – Part 5
    • Heading Off – Part 4
    • Heading Off – Part 3
    • Heading Off – Part 2
    • Heading Off – Part 1
    • Equal Split Part 5
    • Equal Split Part 4
    • Equal Split Part 3
    • Equal Split Part 2
    • Equal Split
    • Blog List – Part 6
    • Blog List – Part 5
    • Blog List – Part 4
    • Blog List – Part 3
    • Blog List – Part 2
    • Blog List – Part 1
    • Excel Files from a Folder Fiddle – Part 3
    • Excel Files from a Folder Fiddle – Part 2
    • Excel Files from a Folder Fiddle – Part 1
    • Power Query Online – Part 13
    • Power Query Online – Part 12
    • Power Query Online – Part 11
    • Power Query Online – Part 10
    • Power Query Online – Part 9
    • Power Query Online – Part 8
    • Power Query Online – Part 7
    • Power Query Online – Part 6
    • Power Query Online – Part 5
    • Power Query Online – Part 4
    • Power Query Online – Part 3
    • Power Query Online – Part 2
    • Power Query Online – Part 1
    • Template Tease
    • Project Population – Part 14
    • Project Population – Part 13
    • Project Population – Part 12
    • Project Population – Part 11
    • Project Population – Part 10
    • Project Population – Part 9
    • Project Population – Part 8
    • Project Population – Part 7
    • Project Population – Part 6
    • Power Query Tables Don’t Have to be Green UPDATE
    • Project Population – Part 5
    • Project Population – Part 4
    • Project Population – Part 3
    • Project Population – Part 2
    • Project Population – Part 1
    • Total Refresh – Part 2
    • Total Refresh – Part 1
    • It Makes All Types
    • It Takes All Types
    • Power Query Tables Do Not Have to be Green
    • Handling Dynamic Arrays
    • Questioning Queries
    • Generating the A to Z of M Functions
    • Joining the dots
    • Web Grouping
    • Refreshing Challenges on the Web – Part 2
    • Refreshing Challenges on the Web – Part 1
    • Expendable Expand
    • Join or List - Part 7
    • Join or List - Part 6
    • Join or List - Part 5
    • Join or List - Part 4
    • Join or List – Part 3
    • Join or List – Part 2
    • Join or List – Part 1
    • Flexible Appending – Part 4
    • Flexible Appending – Part 3
    • Flexible Appending – Part 2
    • Flexible Appending – Part 1
    • Get Pasted – Part 2
    • Get Pasted – Part 1
    • For Instance, Edit Two Queries
    • Steps to Take – Part 4
    • Steps to Take – Part 3
    • Steps to Take – Part 2
    • Steps to Take – Part 1
    • Re-returning to the Folder
    • Check the Filters - Part 2
    • Check the Filters - Part 1
    • Double Access Savings – Part 4
    • Double Access Savings – Part 3
    • Double Access Savings – Part 2
    • Double Access Savings – Part 1
    • Keeping it Current – Part 3
    • Keeping it Current – Part 2
    • Keeping it Current – Part 1
    • See it, Save it, Sort it - Part 7
    • See it, Save it, Sort it - Part 6
    • See it, Save it, Sort it - Part 5
    • See it, Save it, Sort it - Part 4
    • See it, Save it, Sort it - Part 3
    • See it, Save it, Sort it - Part 2
    • See it, Save it, Sort it - Part 1
    • More Haste Less Steps Part 4
    • More Haste Less Steps Part 3
    • More Haste Less Steps Part 2
    • More Haste Less Steps Part 1
    • Sheets Ahead Part 2
    • Sheets Ahead Part 1
    • Hidden Talents
    • Returning to the Folder
    • Google it
    • Random Enough
    • Too Random
    • Totally Random
    • Riveting Results Part 10
    • Riveting Results Part 9
    • Riveting Results Part 8
    • Riveting Results Part 7
    • Riveting Results Part 6
    • Riveting Results Part 5
    • Riveting Results Part 4
    • Riveting Results Part 3
    • Riveting Results Part 2
    • Riveting Results Part 1
    • Selective Staffing Part 7
    • Selective Staffing Part 6
    • Selective Staffing Part 5
    • Selective Staffing Part 4
    • Selective Staffing Part 3
    • Selective Staffing Part 2
    • Selective Staffing Part 1
    • PDF Pandemonium – Part 6
    • PDF Pandemonium – Part 5
    • PDF Pandemonium – Part 4
    • PDF Pandemonium – Part 3
    • PDF Pandemonium – Part 2
    • PDF Pandemonium – Part 1
    • Obstructed View
    • Fruit Frustration – Part 2
    • Fruit Frustration – Part 1
    • Rental Wrangles Receipts - Part 2
    • Rental Wrangles Receipts - Part 1
    • Refined Rental Wrangles
    • Rental Wrangles
    • Tidier Totals by Type
    • Totals by Type
    • Faulty Filtering
    • A List of Distinct Possibilities
    • Evaluate the Environment
    • Fixed Expression
    • Three Sheets to the Table
    • Evasive Errors
    • Intelligent Folding
    • Folding Table
    • Find a Table
    • Group Text
    • Arranging a List
    • Dating Options
    • Key Facts
    • Flat with a View
    • Flat Out
    • More Merging Matters
    • Merging Matters
    • Self Merging
    • Emerging from a Muddle
    • Merging Muddles
    • Don’t Miss Out
    • All Over Running Totals
    • Keep on Running
    • Part Time
    • Binary Function
    • Pivot Problems
    • New Year Function
    • Timings
    • Options for Table Groups
    • Divided Groups
    • I Gather That’s Right
    • All Dates Must Change
    • Space for a CamelCase
    • Recent Dates
    • More Searching Questions
    • Searching Questions
    • Expand Your Calendar
    • Update Your Calendar
    • To Do List
    • Going for the Record
    • Almost There
    • Picky Pivoting
    • ToolTip
    • Mad Max Too
    • Mad Max
    • It Takes All Types
    • Simply Conditional
    • If Only
    • All Change for Values
    • Which Way to Flip
    • The Delete Dilemma
    • Fabulously Fiddly Fill Down
    • Faster Fiddly Fill Down
    • Fiddly Fill Down
    • Mind the Large Overlap
    • Mind the Overlap
    • Missing in Transformation
    • Previous Value
    • More Room for a View
    • Room for a View
    • Top Two
    • Dynamic Merging
    • Folders Only
    • Big Comparison
    • Ageing
    • Table of Tables
    • Row by Row
    • Unique and Distinct
    • Reorganising by Numbers
    • Empty
    • Dynamic Removals
    • Next (Row) Once Again Please
    • Next (Row) Again Please
    • Next (Row) Please
    • Overfill
    • Sort it Out
    • Reconcilable Differences
    • Group Functions
    • Solid Summary
    • Common Merging
    • Even More Fun with (Un)Pivot
    • More Fun with (Un)Pivot
    • Fun with (Un)PivotTable
    • The Wrong Type
    • Not Your Type
    • Time for a List
    • Emerging from Merging
    • Check the List
    • Learn by Example
    • Python Go
    • Python Set
    • Python Ready
    • Top Tied
    • Grouping to the Max
    • Portable Document Format
    • Rows of Columns
    • Example Grading
    • Unique Combination
    • Name or Number
    • That Makes (Intelli)sense
    • Step Back and See
    • Functioning Columns
    • Combining Forces
    • Inquiring Minds
    • Reliable References
    • Durable Duplicates
    • Are Any of Them on the Table?
    • Is it on the Table?
    • Finding Fuzzy
    • Fuzzy Matching
    • Check Today’s Calendar
    • Today’s Calendar
    • Fascinating Filters
    • Divide and Conquer
    • Absolutely Fabulous
    • Exceptional Cases
    • Files for Today
    • Interactive Query
    • Functional Query
    • Types of Value
    • Extra Value
    • Value Added
    • Find the Folder
    • Fold(er) Away
    • File Away
    • Zoned Out
    • In the Zone
    • Conditional Column Splitting
    • Select a Number
    • A Join I Made Earlier
    • Skipping Lists
    • Seeing JSON
    • Linking Up
    • Update with Caution
    • Skip to the Good Part
    • Trying to Extract Errors
    • Different Standards
    • Merge Columns vs Merge Columns
    • The Right Combination
    • Building Bridges
    • Appearing Cultured
    • Presenting Text
    • Mind the Gap
    • Group Dynamics
    • Let It Be
    • Erasing Errors
    • 10 Top Tips
    • Good Relations
    • Excellent Examples
    • Words are Key
    • Upgrades
    • Joining Grades
    • Upgrading Grades
    • Seating Plans
    • Technically Dating
    • Currently Dating?
    • End of Dates
    • Getting Something Out of a Date
    • Changing Dates
    • Sub Texting
    • Tidy Texting
    • True Texting
    • Candid Columns
    • Splendid Splitting
    • X Marks the Spot - Unleashed
    • X Marks the Spot
    • Thanks for the Memory
    • Hot Cross Joins
    • Join Me at the Table
    • Comparing Lists
    • Zipping Through a List
    • Seeded Accommodating Accumulating
    • Seedless Accommodating Accumulating
    • Moving Date
    • Sorry, Not on the List
    • Passing (Reference to) Excel Parameters
    • Returning to Referencing Ranges
    • Setting a Better Example
    • Cell Referencing
    • Evaluating Stored Queries
    • Abridged Appending
    • It’s Good to Share (a Query)
    • Querying Query Options
    • Rapidly Renaming Columns
    • Customising Custom Built Functions
    • Powerless Pivot
    • Cleanse, Tone and Upload
    • Pivot the Blanks
    • Blanking the Blanks
    • Powering Through Issues
    • Birthday Lists
    • Expanding on Aggregating
    • Get 2016 and Transform
    • Managing Many Queries
    • Initial Problems
    • If You Can’t Tell Them Apart, Join Them
    • Bring it to the Table
    • Setting an Example
    • In Your Face(book)
    • Custom Built Functions
    • a Function Function
    • Null and Not Void
    • Structured Columns Deconstructed
    • Pivotal Pivoting
    • Passing Through Parameters
    • in Terms of Conditional Columns.
    • How Long Do We Have?
    • Uniting Different Types
    • I Just Want a Trim
    • Splitting Up is Not so Hard to Do
    • Knowing Your Type is the Key
    • Viewing Query Dependencies
    • Start and End with Grouping
    • Replace to Relocate – Simpler than Brexit
    • Less Aggravating Aggregating
    • Group and Conquer
    • Aggregating Aggravating Worksheets in Other Workbooks
    • Aggregating Aggravating Worksheets
    • Calendar Creation – Going for Dates
    • Calendar Creation – Preparing for Dates
    • Excel(lent) functions
    • One Route to a Running Total
    • A Summary Taster
    • Taking (Away) Steps for Efficiency
    • M-Body Personified
    • Unlimited Importing of Non-Delimited Text Files
    • M-Powered
    • Time for Refreshments
    • a World (Wide Web) of Possibilities
    • Two (Queries) Become One
    • Models Have Relationship Issues Too
    • (Data) Model Building
    • Relationship Goals
    • What's in a Name?
    • Painless Unpivoting
    • One Folder, One Query
    • Appending Files
    • Getting Started
    • Installing and Updating
    • A Refreshing Approach to ETL (get it?)
  • VBA Blogs
    • No Filter
    • Copy Values from Discontinuous Ranges to Specific Ranges
    • Deleting Error Values
    • Dynamic Validation List
    • Deleting Specific Rows
    • Multiple Criteria Filter
    • Dynamically Highlight the Entire Row and Column by Using VBA Script
    • Dynamically highlight entire row and column
    • Dynamically Highlight the Row
    • Group Specific Rows
    • Create text file from Excel table
    • File Path Selector confined to CSV
    • File Path Selector
    • Shape References
    • Referring to Sheets
    • Common Traps 4
    • Common Traps 3
    • Common Traps 2
    • Common Traps 1
    • Charts and Macros 4
    • Charts and Macros 3
    • Charts and Macros 2
    • Charts and Macros
    • Selecting Case By Case
    • Select Case Flexibility
    • Selecting The Right Case
    • ActiveWorkbook.Saved = True vs AutoSave
    • Going Through the Visual Basics – Part 18
    • Going Through the Visual Basics – Part 17
    • Going Through the Visual Basics – Part 16
    • Going Through the Visual Basics – Part 15
    • Going Through the Visual Basics – Part 14
    • Going Through the Visual Basics – Part 13
    • Going Through the Visual Basics – Part 12
    • Going Through the Visual Basics – Part 11
    • Going Through the Visual Basics – Part 10
    • Going Through the Visual Basics – Part 9
    • Going Through the Visual Basics – Part 8
    • Going Through the Visual Basics – Part 7
    • Going Through the Visual Basics – Part 6
    • Going Through the Visual Basics – Part 5
    • Going Through the Visual Basics – Part 4
    • Going Through the Visual Basics – Part 3
    • Going Through the Visual Basics – Part 2
    • Going Through the Visual Basics – Part 1
    • Stop Reticulating Splines - Part 2
    • Stop Reticulating Splines! - Part 1
    • Op-TRIM-isation
    • Find The Right Format
    • Matching the Case
    • Finding the Part of a Whole
    • Digging Up
    • Looking Up and Down
    • After You
    • Lost and Found
    • 'Do' it 'Until' You Believe
    • At Least Once in Our Lives, Let’s 'Do' It!
    • 'Do' You Want To 'Exit'?
    • Wending down the hill Until you Do
    • Getting Loopy Each Time
    • Can't Row with a Column
    • Having a Row
    • Same Same But Different
    • ListColumn Swan Song
    • ListColumn
    • Total Eclipse of the Heart
    • Header-ache
    • DataBodyRange - New Frontier
    • DataBodyRange Part 1
    • Close Range
    • Turning Tables
    • Unforget-TABLE, That’s What You Are
    • Constants is Her Name
    • Scoping Variables
    • The Value of Declaring Variables
    • Range Modifiers
    • Referring to Ranges
    • DoEvents
    • Painting with Excel
    • Save the event!
    • An Eventful Month Coming up!
    • Hidden vs Very Hidden
    • Speeding up the Pace of Running Your Macros
    • Handling VBA Errors
    • Unhiding and Unprotecting Sheets
    • For Loops
    • Declaring Variables
    • If I use VBA Then I get better at it!
    • Updating your Status (Bar) in Excel
    • Using Message Boxes in Excel
    • Cleaning Up Recorded Macros
    • Adapting recorded macros – Range Names
    • Introduction to VBA – Reading Code
    • Introduction to VBA: Recording Macros
    • Introduction to VBA
• About
• • About
  • About SumProduct
  • Value Proposition
  • Our Key Concepts
  • Biographies
  • • Biographies
    • Dr. Liam Bastick
    • Tim Heng
    • Oscar Hagan
    • Steve Kraynak
    • Talia Cao
  • Published Books
• Contact