WordPress.com



#Excel 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 ................
................

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

Google Online Preview   Download