Category Archives: Other

#Excel Super Links #30 – shared by David Hager

Sort Warning in Excel

Build a stock chart with two series in Excel

Web Scraping In Power BI And Excel Power Query – Part 2 – Extracting links

An Alternative Design of Excel Bullet Graphs

#Excel Short and Sweep Tip #10 (Add Custom AutoCorrect with VBA Function) by David Hager


#Excel Super Links #19 – shared by David Hager

Excel Tips & Tricks by Rob Bovey

Show and hide a picture (VBA)

Dynamic Segmentation in DAX

Fix: Excel Formulas don’t update in Power Query tables

#Excel: Combining and Refining a Static Filter List & Filter Criteria UDF by David Hager

#Excel Super Links #18 – shared by David Hager

The Excel Rollover Mini FAQ

Collating with Excel Formulas from Multiple Sheets based on Conditions

Use any Map with Power BI

The Magic of IF(VALUES()) in Power Pivot

#Excel Shift Calendar by David Hager


Excel Short & Sweet Tip #7(Highlighting External Links) by David Hager

Using conditional formatting to highlight external links has been used before

but it required a VBA solution. Now, with Excel’s new FORMULATEXT function, it can be accomplished using only Excel formulas. So, using the following formula defined as IsExternalLink


Conditional formatting will highlight the cells containing “[“, which is associated with external link formulas. But, a more robust formula can also be used, as shown below.




#Excel Super Links #17 – shared by David Hager

Excel Shapes Information

Modelling Inventory Run Rate & Cash Flows using Excel

Budget Patterns in DAX

Presidential Word Cloud in Power BI

#Excel: Modifying Shapes From An UDF in a Worksheet Cell by David Hager

#Excel Super Links #16 – shared by David Hager

Find cells containing Excel formulas with literal (hard coded) values

New Power BI Reports from a Golden Dataset

Learn Excel – “Show Mean on Bell Curve – 5 Ways”: Podcast #1825B

VLOOKUP: How to calculate 500x faster

Returning the First Temperature in PowerPivot


#Excel Super Links #15 – shared by David Hager

Issue #15 is here!

Which numbers add up to total? Using Only Excel Formulas

Modifying Your List of Recently Viewed Excel Files

Daylight Saving Time And Time Zones In M (Power Query)

Use DAX and Slicers to Define Thresholds for Sentiment Analysis

Creating a Unique Delimited String from an Excel Filtered List by Using the TEXTJOIN Function