WordPress.com



#Excel Super Links #1 – shared by David HagerThis is the first issue of a new series on all things Excel. In each edition, I will share with you some Excel articles of interest that you might not be aware of. I hope that this will be a valuable resource to you. It will (eventually) cover all aspects of Excel, ranging from old to modern Excel topics.HTH!How to sort an Excel slicer without a custom list, DAX, or?VBA Patterns: Related Distinct Count of Molecular Weight using an Excel Formula using Excel formulas the Sample Binary file path Dynamic (Power Query) Super Links #2 – shared by David HagerI am happy that the response to the first issue of ESL was so good. I used to publish the EEE newsletter many years ago, and I am thinking that this will be an appropriate substitute. Enjoy!Becoming One with CALCULATE() DAX Unichar() Function And How To Use It In Measures For Data?Visualisation to Set Up Cascading List Boxes for Filtered Excel Reports Power Query to Compare Database Records stock chart (Yahoo UDF) Super Links #3 – shared by David HagerI know where the vast majority of Excel link gems reside, but if you have any of your favorites that you would like to share with me (us), feel free to contact me.List Of Zip Files On The Chip Pearson Excel Web Site Excel – “UDF Rollover Jordan Goldmeier”: Podcast #1813 common mistakes you do in #PowerBI #PowerQuery – And how to avoid pitfalls #1 LOT of Great Links from Mike Girvin Formulas Super Links #4 – shared by David HagerIf you like the information you find in the links provided, then I am satisfied. If you have any comments or suggestions, feel free to contact me. HTH!Figuring out Employee Churn with Power Query [HR Analytics] Table Tutorials Index and Manipulations (David McRitchie) Function (DAX) Best Excel Resources And Websites Super Links #5 – shared by David HagerI hpe that you are enjoying these issues of ESL. Tell your Excel-savvy colleagues to check these out as well. Enjoy ESL #5!Use Power Query to Get a List of Hidden and System Directories: Returning an array of values Popular & Unpopular Outliers by Region, Demographic, etc (DAX) Formula Names Translated into Other Languages Charts: Connect Two XY Series with Arrows Super Links #6 – shared by David HagerShare these Excel gems with your colleagues.How To Really Publish Excel Data To Power BI of Free Excel Stuff at Ozgrid to Exams Used For 1st Excel World Champs Competition Goodies From John Walkenbach’s Excel Site Excel Examples Super Links #7 – shared by David HagerIf you like these links, please let me know. Propagate filters using TREATAS in DAX Excel Formula Examples Summary of Excel Tables formula to change the value of another cell? a Custom Calendar in Power Query Super Links #8 – shared by David HagerI am pleased that most seem to be enjoying this series. Let me know if you have links for me to ics in Excel – Tom Urtis numbers to written text with Excel Worksheet formulas RSS Feeds in Excel Your Queries’ M Code From Power Query And Power BI Using Copy/Paste Slicer to Control Them All… Super Links #9 – shared by David HagerExcel Magic Trick 1403: DAX Formulas: Explicit or Implicit Measures? Why Explicit is Better Business Problems – Power Query Does That Art & Science of Creating An Excel Dashboard (With Examples & Templates) Users Ctrl Break (ing) Your VBA Code During Execution a List Alphabetically (Without Filters) with Excel Formulas Super Links #10 – shared by David HagerHere is the 10th issue of ESL. One of the links in each Excel Super Links will be to articles on my web site from now on.How to Solve an Equation in Excel Matrix Multiplication – Replacing MMULT with Power Query Hierarchies in DAX Excel Chart Tooltips! An #Excel Game – Random Numbers W/O Repetition Using Worksheet Formulas Super Links #11 – shared by David HagerI am happy to see that y’all are finding these links useful.In Cell Charting Start and End Dates in Power Query Helpful Power BI Features You Might Not be Using Forensics 042: Reverse Text – A Formulaic Solution Using TEXTJOIN Irregular Banding on a Filtered List Super Links #12 – shared by David HagerAnd, the Super Links just keep on coming!Automation AddIns As Functions Libraries For Excel And VBA Part 1: Movement and Collision Detection Tables in Power?Query First Custom Ribbon Using Excel-DNA And Visual Studio DAX ENDSWITHX Function Equivalent Super Links #13 – shared by David HagerThanks for visiting my site to see the latest super links. Adding a Description and Category to your User Defined Functions in Excel Dive into Power Query Formula Language’s Tutorials For Excel: Conditionally Formatting Locked and Unlocked Cells’s CUBE functions Explained the Excel TEXTJOIN Function To Return Unique Items In A One-Cell Delimited String From A 2D and 3D Range Super Links #14 – shared by David HagerI will likely end this daily series of Super Links at issue #20, but will continue to add issues as available.Calculating Pearson Correlation Coefficient using DAX equivalent periods in DAX udf: Fuzzy lookups Data from a Mixed Column with Power Query in-cell charts with an Excel formula Super Links #15 – shared by David HagerIssue #15 is here!Which numbers add up to total? Using Only Excel Formulas Your List of Recently Viewed Excel Files Saving Time And Time Zones In M (Power Query) DAX and Slicers to Define Thresholds for Sentiment Analysis a Unique Delimited String from an Excel Filtered List by Using the TEXTJOIN Function Super Links #16 – shared by David HagerFind cells containing Excel formulas with literal (hard coded) values Power BI Reports from a Golden Dataset Excel – “Show Mean on Bell Curve – 5 Ways”: Podcast #1825B: How to calculate 500x faster the First Temperature in PowerPivot Super Links #17 – shared by David HagerExcel Shapes Information Inventory Run Rate & Cash Flows using Excel Patterns in DAX Word Cloud in Power BI: Modifying Shapes From An UDF in a Worksheet Cell by David Hager Super Links #18 – shared by David HagerThe Excel Rollover Mini FAQ with Excel Formulas from Multiple Sheets based on Conditions any Map with Power BI Magic of IF(VALUES()) in Power Pivot Shift Calendar by David Hager Super Links #19 – shared by David HagerExcel Tips & Tricks by Rob Bovey and hide a picture (VBA) Segmentation in DAX: Excel Formulas don’t update in Power Query tables: Combining and Refining a Static Filter List & Filter Criteria UDF by David Hager Super Links #20 – shared by David HagerAn Excel Scrabble Game on Excel trend line equations on line charts Obfuscation in Power BI and Power Query in Excel to Find Overlapping Pivot Tables: Using Conditional Formatting to Highlight 3D Formulas with Defined Names by David Hager Super Links #21 – shared by David HagerArchive of Microsoft Excel Newsgroups Discussion Threads (2004-2014) Query is awesome – dynamic table of dates Engwirda’s Excel Tips Total in DAX 3D – Easy as 1-2-3 and A-B-C and Others Super Links #22 – shared by David HagerVLOOKUP Between VBA function Words in Excel Having 5 Consecutive Vowels Pattern in DAX and Where to Get Help for Power BI Identifying if a String is the Anagram of Another String Using the TEXTJOIN Function by David Hager Super Links #23 – shared by David HagerExcel and Micro:Bit - Hacking for fun and creativity! and JavaScript Solver Tutorial Tricks for Data Wizards - FRE??E copy of Power Query eBook of Excel Experts E-Letter (by David Hager) Super Links #24– shared by David HagerWhat makes up a Power BI Desktop PBIX File to JavaScript Translator Monte Carlo Simulation of a Stock Portfolio in Excel values from ThingSpeak using VBA the Excel TEXTJOIN Function To Return Unique Items In A One-Cell Delimited String From A 2D and 3D Range By David Hager Super Links #25 – shared by David HagerGet calendar with working days for any country in Power BI (Dynamic) Hyperlinks Yahtzee Game the United States Debt Using PowerPivot: Using Conditional Formatting to Highlight 3D Formulas with Defined Names by David Hager Super Links #26 – shared by David HagerPower BI - ESRI ArcGIS Maps A Spectrum Graph in Excel hack to speed up data entry Tables in DAX Aggregation for Internal Numbers From Strings in a Range by David Hager (Very Complex!) Super Links #27 – shared by David HagerHow to create Cartograms in Microsoft Excel damaged or corrupt Excel files and restore all worksheet data Binary data using Power Query formulas in DAX BI Help for Excel Super Links #28 – shared by David HagerExcel VBA - FileSystemObject SSRS Data Directly into Excel with PowerPivot, Ordered List in Excel of Most Frequent Numbers in a Two-Dimensional Range CSV File and Chart CSV Data in Excel A Unique Delimited String From a Delimited String – Excel Formula Method (by David Hager) Super Links #29 – shared by David HagerSolving non-linear equations with two or more unknowns –Part 1 (4 parts) Excel Keyboard Shortcuts for Windows and Mac Clouds with Microsoft Excel and Returning Customers in DAX: Using Conditional Formatting to Highlight Cells That Contain Array Formulas Using the FORMULATEXT Function by David Hager Super Links #30 – shared by David HagerSort Warning in Excel a stock chart with two series in Excel Scraping In Power BI And Excel Power Query – Part 2 – Extracting links Alternative Design of Excel Bullet Graphs Short and Sweep Tip #10 (Add Custom AutoCorrect with VBA Function) by David Hager Super Links #31 – shared by David HagerExcel 2016 Map Chart Functions, DirectQuery And Unrestricted?Measures can I Stop an Excel formula from Calculating after it Reaches a Certain Date and A Word Frequency List with Excel VBA Short & Sweet Tip #9 (Get IP Address) by David Hager Super Links #32 – shared by David HagerBill of Materials (BOM) Power Query solution in Excel and PowerBI Level of Effort (LOE) in Excel a VLOOKUP Function in Power Query Variables within DAX: Generating a Random Sampling From a List Using VBA and the TEXTJOIN Function by David Hager Super Links #33 – shared by David HagerHow to Use Microsoft Excel Fuzzy Lookup VBA to automate Power Query in Excel 2016 Japanese Man Creates Amazing Art Using Excel (Wait, Excel?)() – The 5-point Palm, Exploding fxn Technique: Multiple Lookup Values in a Single Cell (With/Without Duplicates) Using Only #Excel Formulas by David Hager Super Links #34 – shared by David HagerSUMIFS Formula With Empty Criteria Cells – Create several AutoSum Measures in with one click #Excel Power Pivot – #powerbi values using the FORECAST function Magic Trick 1415: Power Query Lookup and Return Multiple Items And Join Them In Single Cell 2013: Power Query OmniQueries. Dynamic And Refreshable Connections To The Data Model Super Links #35 – shared by David HagerExcel Code Cracker Game VBA convert column of sentences to column of single words Magic Trick 1419: RANKX DAX Function & More: Ranking Profit for Products within Manufacturer(‘???’!C3) Is it a valid formula?? No. It is magical indeed! of Scientific Results in Excel Super Links #36 – shared by David HagerInteractive Bullet Graphs in Excel Ultimate Guide to Slopegraphs in Excel Index of Excel Tips difference between Excel and PowerBI with M is huge!: Finding and Visualizing the Last Record in a Table Based on Criteria by David Hager Super Links #37 – shared by David HagerPivotTables Just Got Personal distances in Power BI a BI report with a URL query string parameter XML – Dynamic Periodic Table Short and Sweet Tip #12 (Documenting Formulas and Highlighting Those Formulas With Conditional Formatting) by David Hager Super Links #38 – shared by David Hager100 Excel Tips & Resources to Celebrate 2000 RSS Subscribers BI Desktop/DAX – Using Unicode (Arrows) as Measures in a Table two-way Lookup in a Cross Reference Table Excel VBA Code Cleaner For You Blog Posts Containing Downloadable Workbook Files by David Hager Super Links #39 – shared by David HagerVLOOKUP: List all the Matching Items Across Several Worksheets (2) – Multiple Search Criteria vs INDEX-MATCH. Which is better? Parameter Table in DAX: Modifying Control Chart Data to Remove Outliers with Excel Formulas by David Hager Super Links #40 – shared by David HagerI decided that for my 40th issue of ESL, I would share 5 of my own posts that are very powerful techniques but have been underviewed IMO.#Excel: Generating a Random Sampling From a List Using VBA and the TEXTJOIN Function by David Hager: Using Conditional Formatting to Highlight 3D Formulas with Defined Names by David Hager: Using Advanced Filter with a Custom List By David Hager VBA: Create a Table of File Locations and URLs for Your Favorites by David Hager Shift Calendar by David Hager Super Links #41 – shared by David HagerExcel High Precision Engineering Chart #1 Query (M)agic Part 1: Always Have Good References System Secrets with VBA and WMI API The Drive Type From Excel a Unique Delimited String from an Excel Filtered List by Using the TEXTJOIN Function By David Hager Super Links #43 – shared by David HagerDynamic format using DAX CAGR Calculation in DAX Asynchronous Electric Mmotor Model in Excel Monthly Report Tutorial #Excel Chart as an Enhanced Metafile Picture by David Hager Super Links #44 – shared by David HagerExcel Formulas Can Make a Graph non-linear FEA with Excel Permutations in Excel Magic Trick 1427: DAX GEOMEANX function: Average Compounding Rate per Period for FV Calc #Excel Chart as a Enhanced Metafile Picture by David Hager Super Links #45 – shared by David HagerHow To Transform Data by Example in Excel UDF in Excel VBA get data from PDF file into Sheet(s) or Text file(s) VBA Trivial Pursuit Short and Sweet Tip #15 (Using TEXTJOIN With Non-Contiguous Ranges) by David Hager Super Links #42 – shared by David HagerCreating Infographics with Excel, Part 1 Scraping Power BI Custom Visuals from Office Store of Random Integers in Excel to edit M-function Documentation Metadata: Four Super Filter Techniques by David Hager Super Links #46 – shared by David HagerExcel Google Translate Function Rules for a Dashboard Color Palette VBA Interview Questions and Answers with Examples QR code with google chart API using UDF in Excel UDF Using Google API to Return the Elevation of an Address by David Hager Super Links #48 – shared by David HagerExcel To EXE Converter – XLtoEXE and Solstice in Excel Magic Trick 1430: DAX Functions XNPV & XIRR for Irregular Cash Flow Net Present Value & IRR to Send an Instant Message from Excel using Communicator Native 3D Ranges with the TEXTJOIN Function Plus Bonus by David Hager Super Links #49 – shared by David HagerPower Query: A Summary Taster the Excel FORECAST Function with Seasonality Used Items in Excel Drop Down List Matching Strings using Regular Expressions: Project Tracking Workbook by David Hager Super Links #50 – shared by David HagerDynamic TOPN Reports From PowerPivotPro Seeking and XIRR in PowerBI and PowerQuery again - useful! 3D Octal Planetary Model in Excel: Building a Frequency Summary Table Based on an Excel List by David Hager Super Links #51 – shared by David HagerExcel Magic Trick #1430 Materialize DAX Table Functions Functions James Bible in Excel UDF Using Google API to Return the Elevation of an Address by David Hager Super Links #47 – shared by David HagerExcel Chess Game Viewer Solver for Systems of linLear Equations in Excel Useful Excel Macro Examples for VBA Beginners Skills Tests Short and Sweet Tip #17 (Returning a Letter Grade Based on a Normal Grading Scale Without Lookup Table) by David Hager Super Links #52 – shared by David HagerFunctions For VBA Arrays An Alphabetical Sort To Your VBA Array List Magic Trick 1435: DAX Query to Export Data from Data Model to Excel Sheet & Much More! with repetition using Excel Short and Sweet Tip #19 (Invaluable Excel Speller) by David Hager Super Links #53 – shared by David HagerDecoding M – Exploring the YouTube Data API with Power BI Dates Displayed in Different Languages VLOOKUP to Calculate Discount Percentages Tip: Partition your Tables at Crossjoins where possible – PowerQuery PowerBI Using the Excel TEXTJOIN Function To Return Unique Items From A 3D Range by David Hager Super Links #54 – shared by David HagerUse the Power BI Quick Calcs with your own Date Table to Compute Index Numbers at Top Speed in DAX in Power Query (Rolling 12 Months) To Text UDF #Excel to Make A Round Robin Tournament Schedule by David Hager Super Links #55 – shared by David HagerSimple 3D to 1D Array Transformation in Excel Conditional Formatting for Statistical Significance Doughnut Chart with Conditional Formatting in Excel Tooltips on Excel Charts Short & Sweet Tip #16 (Multiple Delimiters with TEXTJOIN for Custom Formatting) by David Hager Super Links #56 – shared by David HagerFinding Nearby Zipcodes using Excel Formulas Array Formulas in Excel The Area Of A Simple Polygon Using The Shoelace Algorithm in Excel Privacy Settings In Power BI/Power Query, Part 2: Preventing Query Execution an Excel Translator by David Hager Super Links #57 – shared by David : All Articles with 'Hyperlink()' Tag Searching in Slicers Definitive Guide to Custom Number Formats in Excel Axes in Excel Charts Excel UDF to Translate a Phrase From One Language to Another by David?Hager Super Links #58 – shared by David Hager The Ultimate VLOOKUP Trick – Multi-Condition Lookup Magic Trick 1440: OR Logical Test on 2 Columns using DAX IN Operator & DAX OR Function BI Usage Metrics – What is it good for – Absolutely Everything! Patterns for DAX Short and Sweet Tip #20 (Create VBA Procedure List) by David Hager Super Links #59– shared by David Hager Pivot Your Table-Relationships in Power BI and Power Pivot Day in Excel Your Gmail Contacts In Excel Voice Fixes Pivot Table Default Settings the Excel TEXTJOIN function to Extract an Internal Numeric String From a String by David Hager Super Links #60 – shared by David Hager Excel Project Management How to Use VBA Worksheet Functions in Excel Find Excel Ribbon Commands VBA Dates and Bad Excel Dates: Using Conditional Formatting to Highlight Cells That Contain Array Formulas Using the FORMULATEXT Function by David Hager Super Links #61 – shared by David Hager My Top 5 Power BI Visual Design Practices: Transforming Good to GREAT Flow Chart in Excel References Libraries Lab – Explore the Office JavaScript API & Learn to Build Add-Ins Short and Sweet Tip #21 (Remove Unused Custom Formats) by David Hager # Excel Super Links #62 – shared by David Hager Chandoo: The Excel Vault Excel Skills for Specialists Power BI Reports with Power BI Report Server your Memory Consumption in PowerBI Exchange Rate UDF With Symbol Lookup by David Hager # Excel Super Links #63 – shared by David Hager Excel Cell Ranges: Basic Things 99% of Users Don’t Know Symbols in Excel Useful Excel Date Calculations Animated Chart #2 Plus a Lot of Illusion Links Short & Sweet Tip #9 (Get IP Address) by David Hager # Excel Super Links #64 – shared by David HagerConverting Excel Date to Julian Day of Year Number Maps Distance Function for Excel ONE with CALCULATE() Learning DAX for Free Conditional Formatting to Highlight Unique Items in an Excel Filtered List By David Hager # Excel Super Links #65 – shared by David HagerData Cleansing with R in Power BI + 1 Reasons You Should Use Excel’s Quick Analysis Option, LDAP and Active Directory Clouds with Microsoft Excel an Excel Table of Components By Product From a List Using the TEXTJOIN Function By David Hager # Excel Super Links #66 – shared by David HagerFormulas in Microsoft Excel Embedding Power BI Reports into Your Applications Users to Save Excel File As XLSM Slicer to Control Them All…PowerPivotPro Excel Super Links #67 – shared by David HagerMusical Excel Dive into the M Language with Web Services in Power Query/Excel and Power BI 404 URL Checker For Power Query: Exciting New Features – Using a Worksheet UDF to Modify Shapes on a Worksheet by David Hager # Excel Super Links #68 – shared by David HagerPower BI – Processing Data from PDF MDIS Presentations –Matt Allington Ten Pitfalls of the Data Wrangler using Power BI Things Modern Data Tools Can Do For You: Using Advanced Filter with a Custom List By David Hager # Excel Super Links #69 – shared by David HagerChange Number Format Based on a Cells Value Actions in Microsoft Excel of Material (BOM) Explosion Part2: Costing in Excel and PowerBI Of Subs & Functions in Excel Excel Super Links #70 – shared by David HagerSUMPRODUCT Vs. Power Query on Mt. KauKau Using Excel VBA to control other Office applications the AutoFilter of Excel (tables) to exclude items using VBA code Adjust Secondary Y Axis Scale Through VBA the Nth Best Performance (unique individuals) with Excel and PowerPivot # Excel Super Links #71 – shared by David HagerReverse Partial Match Lookup to Filter for a List in Excel and Reapplying Pivot Chart Formatting a StopWatch in Excel“CONTAINSX” – Finding if a value in table 1 has a matching value in table 2 DAX ENDSWITHX Function Equivalent # Excel Super Links #72 – shared by David HagerTom’s Tutorials For Excel: Updating a Comment to List Unique Items Better Way to Copy Filtered Rows Using VBA Power Query to Compare Database Records Formula Calculation Speed – Part 10: Summary Short & Sweet Tip #9 (Get IP Address) by David Hager # Excel Super Links #73 – shared by David HagerChanging Excel Icon & Creating Workbook Shortcut With A Custom Icon list of all the xlConstants found in Microsoft Excel Sequence of Events in DAX to Date in Previous/Prior Year in DAX: Multiple Lookup Values in a Single Cell (With/Without Duplicates) Using Only #Excel Formulas by David Hager # Excel Super Links #74 – shared by David HagerInteractive Decision Tree Visualization in Excel [Trump vs. Hillary in Swing States] Running a Native Query Within an M project Tips for Working with Complex Excel Formulas VBA Monopoly Short and Sweet Tip #17 (Returning a Letter Grade Based on a Normal Grading Scale Without Lookup Table) by David Hager # Excel Super Links #75 – shared by David HagerGetting A Handle On Userforms [VBA] VBE Options Solution: Who Should Sit Where? Analysis in DAX Short & Sweet Tip #6 (Shuffling a String) by David Hager # Excel Super Links #76 – shared by David HagerUnpivot by number of columns and rows in PowerBI and PowerQuery in Excel Charts using Excel Filters specific bars in an Excel bar chart you need to know about Power BI now Sparklines: Display Last N Values by David Hager #Excel Super Links #77 – shared by David HagerWhite Paper On “Planning A Power BI Enterprise Deployment” Tableau vs. Power BI Choropleth Excel Map by County per State Variables in DAX Queries Short and Sweet Tip #23 (Open Windows File Explorer with Worksheet UDF) by David Hager #Excel Super Links #78 – shared by David HagerMy Top 10 Tips for Mastering VBA & Excel Macros [Part 5 of 5 – VBA Crash Course] US Choropleth Map by County per State – a 4th Option Combo Box Number Problem SUMX or DAX Query? Dependent Lists from a Column Lookup in an #Excel List by David Hager #Excel Super Links #79 – shared by David HagerTop 10 things we struggle to do in Excel & awesome remedies for them Freeze-Thaw Data in Excel Skunkworks! Excel VBA Chess Challenge multiple values in DAX Information from #Excel About the August 2017 Total Eclipse by David Hager #Excel Super Links #80 – shared by David HagerUsing the ODDFPRICE Function in Excel Excel UserForms For Data Entry In 6 Easy Steps: Tutorial And Practical Example is Break-Even Point (BEP)? to Use Excel Wildcard Characters in Formulas New and Exciting Excel Content at: #Excel Super Links #81 – shared by David HagerExcel Magic Trick 1443: DAX Formula for Sales Per Working Day: Power Pivot or Power BI Desktop the Closest Number in an Excel Range Clock with Excel – no code to Add and Use an Excel Pivot Table Calculated Field: Conditional Format Rows in One List that are in Another List by David Hager #Excel Super Links #82 – shared by David HagerMicrosoft Excel Site Catchment Analysis (Part 1) and G.D.P. in Excel Data from a Mixed Column with Power Query to edit M-function Documentation Metadata Filter Magic by David Hager #Excel Super Links #83 – shared by David HagerRounding time to nearest minute or quarter hour etc. [Excel formulas] Understanding Power Query Combine you have to use Dim to Declare Variables? Comparison of Peltier Tech and Excel Box Plots: Get Audio Result For Any Excel Formula or Cell with Worksheet UDF by David Hager #Excel Super Links #84 – shared by David HagerSave Your Excel Ribbon Customizations Powerpoint from Excel using VBA Tables in Excel & Power BI multiple files from Dropbox folder into PowerBI and Excel (via PowerQuery) at once All Excel Articles by David Hager #Excel Super Links #85 – shared by David HagerExcel Magic Trick 1444: Logical Formulas: Count & Extract Customer Names for 8 Sales Coupon Groups Chart Highlighting Has My Workbook Open? [VBA] Power BI Card Visuals Word and PowerPoint from #Excel with a Worksheet UDF by David Hager #Excel Super Links #86 – shared by David HagerExcel VBA Connect Four Game Excel Function To Use - Part 1 vs. ISFILTERED vs. HASONEFILTER Integration In Excel Using The Trapezoidal Rule: Audio-Documenting Excel Formulas by David Hager BWT, A REALLY GREAT TECHNIQUE #Excel Super Links #87 – shared by David HagerPush Excel Named Range Values to Bookmarks in Word ALL() Function in DAX Magic Trick 1445: Single Cell Array Formula: Count Customer Names for 8 Sales Coupon Groups increments in prestressed concrete beams in Excel a Bible Verse Using #Excel (w/o VBA) by David Hager #Excel Super Links #88 – shared by David HagerExcel It In a Minute #8: Reverse Lookups with VLOOKUP Data Dictionary in VBA - Complete Syntax Documentation VBA to control Custom Lists Privacy Settings In Power BI/Power Query, Part 4: Disabling Data Privacy Checks New and Exciting Content Here #Excel Super Links #89 – shared by David HagerImport Tabular Data from PDF using Power Query Records Via Joins in Power Query a Table or DAX query from Power Pivot to CSV using VBA Patterns in DAX the Nth Best Performance (unique individuals) with Excel and PowerPivot #Excel Super Links #90 (Special Edition) – shared by David HagerMy Top 10 All-Time Viewed Posts Measuring Distance in Power BI Desktop #Excel: Creating A List Made Up Of Formulas From A Filtered List by David Hager Excel 2013: Power Query OmniQueries. Dynamic And Refreshable Connections To The Data Model Dynamic Write-Back to Sync PowerPivot Tables with Date Tables created by Power Query Excel Short & Sweet Tip #9 (Get IP Address) by David Hager The DAX ENDSWITHX Function Equivalent Using TEXTJOIN: Generating a Sorted Unique Array in #Excel using Only Formulas by David Hager #Excel: Modifying Shapes From An UDF in a Worksheet Cell by David Hager TEXTJOIN: Multiple Lookup Values in a Single Cell (With/Without Duplicates) Using Only #Excel Formulas by David Hager #Excel Short and Sweet Tip #18 (Toggle Formatting on Worksheet) by David Hager #Excel Super Links #91 – shared by David HagerCopy a Data Table from PDF into Excel PivotTables with VBA? Deselect Slicers First! Multiple Connections Between Power BI Tables Functions in Excel Formatting Gem in #Excel: Highlight the N Closest Values to the Mean of a Range in a Filtered List by David Hager Super Links #92 – shared by David HagerJuly 4th Trivia Game in Excel Progress in Excel All VBA Code Programmatically Chart Secondary Axis Alternatives #Excel Super Links #93 – shared by David HagerDAX SelectedValue Function Search Formula in Excel A Guided Tour Through The VBA IDE’s Options XL – How I became speed champion with Excel Keyboard Shortcuts #Excel Short and Sweet Tip #25 (Playing a Random Sound With a Worksheet UDF) by David Hager #Excel Super Links #94 – shared by David HagerSaving and Reapplying Pivot Chart Formatting Excel Spreadsheet Formulas For Beginners Counting Rows in Excel Where Condition Is Met In At Least One Column Create a 445 Calendar using Power Query – PowerPivotPro See All Content at Excel For You #Excel Super Links #95 – shared by David HagerAn Interesting Technique For Error Handling And Enumeration Validation In VBA Automatically Open Workbooks when Excel Starts Look Ma…No PowerPivot! Excel Magic Trick 1447: DAX DISTINCTCOUNT & CONCATENATEX to Count & List Stores Visited Getting the Sunrise and Sunrise Times From an Address by David Hager #Excel Super Links #96 – shared by David HagerUsing the SELECTEDVALUE function in DAX Lookup the Second, the Third, or the Nth Value in Excel Non-linear Break-Even Analysis in PowerBI Everything you need to know about the VLOOKUP function My Site Feed #Excel Super Links #97 – shared by David HagerPower Query - I Just Want a Trim How to Build a Simple Weather App in Excel VBA Tom’s Tutorials For Excel: Making Your Hyperlinks User-Friendly Joyplot in Excel #Excel Short and Sweet Tip #26 (Showing an UserForm With a Worksheet UDF) by David Hager #Excel Super Links #98 – shared by David HagerPower Query - Adding null to values returns null Power BI - When is the Best Day to See Your Favorite Baseball Team? The Calendar Table (Date Dimension) Explained for Power Pivot & Power BI Always Use Stored Procedures Lookup a Bible Verse In Any Language Using #Excel by David Hager #Excel Super Links #99 – shared by David HagerCalculate the Sum of Varying Ranges Based on a Condition and Across Multiple Sheets Specify a dis-contiguous range for an Excel function argument Transparent UserForm Background with VBA Handling Different Granularities In DAX Excel Short & Sweet Tip #7(Highlighting External Links) by David Hager #Excel Super Links #100 (Special Edition) – shared by David HagerMy Top 10 Most Underviewed Viewed Posts (IMO)Please check out these posts on my website. There are some powerful techniques to be found here.#Excel: Getting the Sunrise and Sunrise Times From an Address by David Hager #Excel: Removing Outliers with Excel Formulas to Modify Control Limits by David Hager #Excel: Using Conditional Formatting to Highlight 3D Formulas with Defined Names by David Hager Getting the Latest Earthquake Alert Using the WEBSERVICE and FILTERXML Functions in #Excel by David Hager Creating a Unique Delimited String from an Excel Filtered List by Using the TEXTJOIN Function By David Hager Excel: Conditional Format Rows in List 1 that are Not in List 2 by David Hager #Excel Short and Sweet Tip #17 (Returning a Letter Grade Based on a Normal Grading Scale Without Lookup Table) by David Hager The DAX ENDSWITHX Function Equivalent Returning the First Temperature in PowerPivot #Excel Short and Sweet Tip #25 (Random Sound - Worksheet UDF) by David Hager #Excel Super Links #101 – shared by David HagerWhy does the calculation mode keep changing? Variations of Alternative Bullet Graphs in Excel Row Context and Filter Context in DAX Browser automation in Excel VBA using Selenium #Excel Short and Sweet Tip #27 (Use Worksheet UDF to Add Background to #Excel Worksheet) by David Hager #Excel Super Links #102 – shared by David HagerUsing Power BI to Extract Data from Office 365 Reporting Web Services Stick a Drop Pin in It: Visualize Data With Maps (DAX Reanimator Series: Part 2) Built In and Custom Lists in Excel How To Customize The Order Of Your Excel Slicer Buttons Bible Verse In Any Language Using #Excel by David Hager #Excel Super Links #103 – shared by David HagerDAX KEEPFILTERS Plus Bonus Complaining! When to Use SUM() vs SUMX() SQL-query folding bug still alive and sucking in PowerBI and PowerQuery in Excel Related Distinct Count in DAX Storing and Running M Code from #Excel Worksheet Cells by David Hager #Excel Super Links #104 – shared by David HagerGet the File Name of the Current Excel Workbook Power BI for Accountants: Complete Introduction to Power BI Desktop to Build Reports & Dashboards Excel Pop Up Selector Tool With Slicer Use Webservice functions to Automatically Update Excel 2013 Spreadsheets with Online Data #Excel Short and Sweet Tip #27 (Use Worksheet UDF to Add Background to #Excel Worksheet) by David Hager #Excel Super Links #105 – shared by David HagerDrop Buttons on VBA UserForm Controls Power Query Unpivot Scenarios Reduce Development Lag in Power Query Automatic Default Number Formatting in Excel Pivot Tables #Excel Short and Sweet Tip #27 (Use Worksheet UDF to Add Background to #Excel Worksheet) by David Hager #Excel Super Links #106 – shared by David HagerExcel SUM Function in Detail Analyze Public Facebook Groups in #PowerBI Translate RGB codes to HEX #rrggbb Excel Custom Number Format Guide Storing and Running M Code from #Excel Worksheet Cells by David Hager #Excel Super Links #107 – shared by David HagerIP Address Mapping in Power BI Table.TransformColumns – alternative in PowerBI and PowerQuery in Excel Painting with Excel Storing and Running M Code from #Excel Worksheet Cells by David Hager #Excel Short and Sweet Tip #27 (Use Worksheet UDF to Add Background to #Excel Worksheet) by David Hager (Try it, you’ll like it!) #Excel Super Links #108 – shared by David HagerCalculating Travel Distance/Time in Power BI using Bing Map API Creating custom Map Charts using shapes and VBA WEBSERVICE and FILTERXML functions explained Storing and Running M Code from #Excel Worksheet Cells by David Hager Getting the Latest Earthquake Alert Using the WEBSERVICE and FILTERXML Functions in #Excel by David Hager #Excel Super Links #109 – shared by David HagerImport Json to excel and export excel to Json Excel Magic Trick 1449: DAX Measure % Change MOM & YOY Formulas For Incomplete Years Website Log-In Automation With VBA Enable #Excel Formulas to Give an Audio Result by David Hager #Excel Short and Sweet Tip #25 (Random Sound – Worksheet UDF) by David Hager #Excel Super Links #110 – shared by David Hager Using GENERATE and ROW instead of ADDCOLUMNS in DAX How to expand a column that cannot be expanded in Power BI and Power Query in Excel A migration sample to help moving from Power BI Azure Embedded to Power BI Service Embedded Ranking Values with Measures in Power BI Run Your Power Query M Code Procedures in #Excel Worksheet Cells by David Hager #Excel Super Links #111 – shared by David Hager Creating Animated Reports In Power BI With The Drilldown Player Custom Visual Extract currency amounts from text – Power Query Tutorial Power Query (M)agic Part 2: Organizing Your Queries Excel Convert Dates to Fiscal Quarters and Years Run Your Power Query M Code Procedures in #Excel Worksheet Cells by David Hager #Excel Super Links #112 – shared by David Hager Obtaining the save status of a file using VBA Inconsistent ListRow Copy in Excel JSON Master : In-depth JSON tutorial for Beginners #Excel Short and Sweet Tip #23 (Open Windows File Explorer with Worksheet UDF) by David Hager Using Excel UDF to Translate a Phrase From One Language to Another by David Hager #Excel Super Links #113 – shared by David HagerPDF Search Through VBA The Great Bottle Deposit Financial Model Users to Enable Macros in a Workbook #Excel: Creating A List Made Up Of Formulas From A Filtered List by David Hager Using Conditional Formatting to Highlight Unique Items in an Excel Filtered List By David Hager #Excel Super Links #114 – shared by David HagerMotion Induced Blindness Values Become Text After UnPivoting Other Columns Cloning Class Instances Dynamic List With Blank Cells A Valuable Collection of Excel and Power BI Links to Great Excel and Modern Excel Techniques #Excel Super Links #115 – shared by David HagerUse File > Info to quickly unprotect multiple worksheets DMV to Extract Measures from Power Pivot Self-Service BI: Improving Data Quality using Power BI, Flow & PowerApps Using DAX to Normalize Data in Power BI Using the Excel TEXTJOIN Function To Return Unique Items In A One-Cell Delimited String From A 2D and 3D Range #Excel Super Links #116 – shared by David Hager Engineering Drawings using Excel AnimShape UDF in Excel Cell Worksheet Functions Challenge of The Month – Perfect Shuffle BINGO! An #Excel Game by David Hager Super Links #117 – shared by David HagerAnalyzing a Blockchain Database with Power BI – Introducing SteemitSQL Save Space With Excel On Demand Slicers Excel Magic Trick 1451: Hack Data Model, Date Table & DAX Measures WITHOUT buying Power Pivot Reanimator Series – Part 3: Compare Product Performance After Launch Creating a Set of Custom Instructions Using the #Excel TEXTJOIN Function by David Hager #Excel Super Links #118 – shared by David HagerTom’s Tutorials For Excel: Importing an Access database table into Excel — a Quick Shortcut 50 Things You Can Do With Excel Pivot Tables Combination Line & Pie Chart Power Query: Passing Through Parameters List of Priority Items from Another List Using #Excel TEXTJOIN Function by David Hager #Excel Super Links #119 – shared by David HagerHandling Multiple Currencies in Power BI w/DAX Beautiful VBA Progress Bar with Step by Step Instructions How to Create a Project Schedule with “Click-and-Drag” in Excel VBA Blog series: DoEvents Creating a Priority List With #Excel by David Hager #Excel Super Links #120 – shared by David HagerObscure MDX Month: Recreating The Star Ratings Measure In MDX Using Excel Functions Getting A Handle On Userforms [VBA] The For Next and For Each Loops Explained for VBA & Excel Excel Workbook Metrics Filter Magic by David Hager #Excel Super Links #121 – shared by David HagerMeasure Dependencies in Power BI Numerical Integration In Excel Using The Trapezoidal Rule #Excel Super Links #122 – shared by David HagerThe Difference Between Forecasting & Predictive Analytics Excel Magic Trick 1453 Array Formula Count Customer Totals Between Upper Lower Limits, Each Month Dynamic data comparisons using disconnected slicers, TreatAs and inactive relationships Excel Data Validation Guide Bible Verse In Any Language Using #Excel by David Hager #Excel Super Links #123 – shared by David HagerFinding Nearby Zipcodes using Excel Formulas Create Multiple Pie Charts in Excel using Worksheet Data and VBA VBA Code Library, Attachment includes 75 code examples Fractions rounded to 1/4, 1/8, 1/16, 1/32, 1/64, 1/128 Creating a Set of Custom Instructions Using the #Excel TEXTJOIN Function by David Hager #Excel Super Links #124 – shared by David Hager Compare Tables in Excel & Power BI – Part 2 Employee Performance Panel Charts – Excel vs. R [video] The Excel DATEDIF Worksheet Function AutoExist, Cross Table Filtering, and You Excel Short and Sweet Tip #28: Jazzing Up a Star Rating by Using the TEXTJOIN by David Hager #Excel Super Links #125 – shared by David HagerNew M-function: Table.TransformColumnTypesToFirstRowsTypes for PowerBI and PowerQuery Employee Performance Panel Charts in Power BI with R Excel Magic Trick 1454 DAX Measure Count Customer Totals Between Upper Lower Limits, Each Month You Can Now Put Values On Rows In Power BI My Collection of Excel Tips by David Hager #Excel Super Links #126 – shared by David HagerUse VLOOKUP and return multiple values sorted from A to Z Excel to Alglib via xlwings How to Auto Adjust Combo Box or List based on Dynamic Data Ranges in Excel The 7 most dangerous Excel features 150 Articles with Valuable Excel Content #Excel Super Links #127 – shared by David HagerBest Practices for Sharing Power BI Reports xlRelease () AutoRecover Excel File Build your own usage report with Power BI Using #Excel VBA to Create a Filter Criteria User Defined Function by David Hager #Excel Super Links #128 – shared by David HagerUnique distinct list sorted alphabetically and based on a condition What is DAX? How to Easily Manage Your Inventory in Excel Feed the dragons in Game of Thrones with Excel 365 TextJoin Using the #Excel Advanced Filter with a List Having Internal Numbers in a String By David Hager #Excel Super Links #129 – shared by David HagerExcel Magic Trick 1455: Convert Text Month Criteria to Upper & Lower Dates for SUMIFS Function Excel Find and Remove Duplicates Find last value in a column UnicodeBox () Extracting Ingredients from an #Excel List by Cost Category by David Hager #Excel Super Links #130 – shared by David HagerTom’s Tutorials For Excel: Counting All Data Types in a Range What is Solver in Excel? Working With Range.FormulaArray In VBA 15 Quick & Powerful ways to analyze Business Data Extracting Ingredients from an #Excel List by Cost Category by David Hager #Excel Super Links #131 – shared by David HagerExcel Formulas Based Sudoku Solver Awesome chart to visualize Salary Increases for 3,500+ people [Tutorial] Converting a Formula to Values Changing the culture of a Power BI Desktop file Documenting Formulas in an #Excel Range Using the FORMULATEXT, ISFORMULA and TEXTJOIN Functions by David Hager #Excel Super Links #132 – shared by David HagerExcel CONVERT Function With Drop Down Lists How to import from Excel with cell coordinates in Power Query and Power BI Excel Range Modifiers How to refer to the next row in Power Query Using the SUBTOTAL Function in #Excel To Aggregate Values From Multiple Filtered Lists #Excel Super Links #133 – shared by David HagerExtract duplicate values with exceptions Top Excel Formulas & Function Examples To Get Better At Microsoft Excel Tom’s Tutorials For Excel: Returning a Formula’s Arguments Generating a series of numbers in DAX #Excel Impossibly Easy #1: Return a 1D Array from Non-Contiguous Native 3D Ranges #Excel Super Links #134 – shared by David HagerExcel Magic Trick 1456: PivotTable & Slicer to Create 8 Year Sales Report by Product & Month New Functions – GENERATESERIES, SELECTEDVALUE New Customers per Day – DAX Technique Dynamic Conditional Formatting CREATING AN Nth OCCURRENCE DAX FORMULA #Excel Super Links #135 – shared by David HagerPower BI – Using Change tables to compare data Extracting images and themes from Power BI Desktop files Calculating the Number of Unique Items in a Delimited String Excel Games Creating A Unique Delimited String From a Delimited String – Excel Formula Method With TEXTJOIN #Excel Super Links #136 – shared by David HagerDocumenting Formulas in an #Excel Range Using the FORMULATEXT, ISFORMULA and TEXTJOIN Functions #Excel Short and Sweet Tip #28: Jazzing Up a Star Rating by Using the TEXTJOIN Function List of Priority Items from Another List Using #Excel TEXTJOIN Function Creating a Set of Custom Instructions Using the #Excel TEXTJOIN Function #Excel Impossibly Easy #1: Return a 1D Array from Non-Contiguous Native 3D Ranges #Excel Super Links #137 – shared by David HagerPearson correlation coefficient in DAX Creating the DAX Measure to Display the Country Names Formatting and VBA Codes for Headers and Footers 5 pivot tables you probably haven't seen before Using the CHOOSE and AGGREGATE Functions To Apply Conditional Formatting to a Filtered List in Excel #Excel Super Links #138 – shared by David Hager Power Query: Structured Columns Deconstructed Excel Magic Trick 1457: Text or Number Date / Times in Functions & Direct Operations (10 Examples) we pipe M? Conditional Formatting Gem in #Excel: Highlight the N Closest Values to the Mean of a Range in a Filtered List Excel: Conditional Format Rows in List 1 that are Not in List 2 #Excel Super Links #139 – shared by David HagerExtract a list of alphabetically sorted duplicates based on a condition Copy & paste visible cells only [Excel Trick] Excel: Using Conditional Formatting to Highlight Cells That Contain Array Formulas Using the FORMULATEXT Function #Excel: Using Conditional Formatting to Highlight 3D Formulas with Defined Names #Excel: Using Conditional Formatting to Highlight Cells Containing Native 3D Formulas #Excel Super Links #140 – shared by David HagerUsing a Card as a Slicer in Power BI SSAS Multidimensional and Super DAX Create Forecasting Models using Excel and Machine Learning How to create and use an R-function-library in Power BI Excel Extract a Unique List #Excel Super Links #141 – shared by David HagerMBS Math Formula. Servicing, CPR, Payment Delay, Default Rate & Loss Severity Count unique distinct values based on a condition Application Settings in Excel Power BI What-if Analysis Multi Threaded Dynamic Visuals in Power BI - Advanced Power BI & DAX Techniques #Excel Super Links #142 – shared by David HagerExploring Top Chess Openings in Power BI Build your own Add-in: Calculation Timer Excel Magic Trick 1458: Lookup Price in Multiple Tables: VLOOKUP, INDIRECT & Defined Names Excel: Finding and Visualizing the Last Record in a Table Based on Criteria Excel Short & Sweet Tip #7(Highlighting External Links #Excel Super Links #143 – shared by David HagerExcel Magic Trick 1459: Adding Food or Accessory Costs For Each Dog with SUMIFS & SUMPRODUCT Convert unevenly spaced list to table [Data from Hell] DAX Reanimator Series: Moving Averages Controlled by Slicer (Part 1) Excel: Conditional Format Rows in One List that are in Another List Excel Short and Sweet Tip #18 (Toggle Formatting on Worksheet) #Excel Super Links #144 – shared by David HagerExcel Magic Trick 1460: List All Relative Positions in a Single Cell using TEXTJOIN Array Formula Color Grids for Power BI Scatterplots with the Help of Excel Applications Settings v2 Use calculated tables to show only used rows in dimensions #Excel Impossibly Easy #2: Change Sheet Tab Color with a User-Defined Worksheet Formula #Excel Super Links #145 – shared by David HagerGuide and Resources for Web Data Extraction with Power BI & Power Query Power BI Custom Data Connector For Language Detection, Key Phrase Extraction And Sentiment Analysis How to extract a case sensitive unique list from a column #Excel Exchange Rate UDF With Symbol Lookup TEXTJOIN: Multiple Lookup Values in a Single Cell (With/Without Duplicates) Using Only #Excel Formulas #Excel Super Links #146 – shared by David HagerHow To Solve a Complex DAX Problem Dax Gamechangers – Some useful features and functions from early projects Power BI Drill Through Calling Power BI API using Power BI Desktop to document Power BI Service #Excel Short and Sweet Tip #19 (Invaluable Excel Speller #Excel Super Links #147 – Shared by David HagerIntroducing the Timeline Storyteller custom visual for Microsoft Power BI CALCULATE and FILTER: A Love Story? Filter data based on a comma separated list using CALCULATE and PATHCONTAINS Why I STILL Teach DAX in Excel: My Lament to Microsoft Getting the Latest Earthquake Alert Using the WEBSERVICE and FILTERXML Functions in #Excel #Excel Super Links #148 – Shared by David HagerUsing Custom Lists in Excel Power Query: a Function Function Excel Pivot Chart Drill Down Buttons Adding Multiple Measures to Non-PowerPivot Versions of #Excel using an User-Defined VBA Function Advanced Filter Magic #Excel Super Links #149 – Shared by David HagerInteractive Formatting of a Chart Series with a Cell’s Color Flat Rate Loans Select First Item in a List Box Automatically with VBA How Power Query can return clickable hyperlinks with friendly names to Excel Using #Excel to Find How Far the Storm is from Your Location #Excel Super Links #150 – Special EditionTo celebrate the 150th issue of Excel Super Links, here are the links to all of my content at dhExcel1..Enjoy! ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download