Geert asks: “in my experience the datasets are non-uniform in the sense that only a subpart of the data needs subtotals. (categories of data are sequentially listed and only 1 category has a further breakdown that needs subtotals – the Continue reading “Excel Add Subtotals To Only One Category – 2432”
Month: October 2021
How To Speed Up Power BI Analytical Development Using These DAX Patterns
For this video, I’d like to give an overview on how you can speed up your Power BI development. I always think about ways on how we at the Enterprise DNA community can empower ourselves and also the Power BI Continue reading “How To Speed Up Power BI Analytical Development Using These DAX Patterns”
VLOOKUP or XLOOKUP for Currency Conversion in Excel Formula? Excel Magic Trick 1758
Download Excel File: https://excelisfun.net/files/EMT1758.xlsx
Learn how to create a formula to convert a source currency amount into a target currency amount using a two-way lookup conversion lookup table. Learn five different formulas:
(00:00) Currency Conversion Introduction
1. (00:26) Do Continue reading “VLOOKUP or XLOOKUP for Currency Conversion in Excel Formula? Excel Magic Trick 1758”
Excel Removing Subtotals – 2431
A co-worker sent you a file with subtotals. How do you get rid of them?
Why are there 3 numbered buttons to the left of column A in Excel?
Why are there minus buttons and vertical lines to the left of column Continue reading “Excel Removing Subtotals – 2431”
Excel Subtotals Are Awesome – 2428
Accountants love the subtotals feature in Excel. We love to see details but add a little summary information. I have a lot of friends who think Subtotals should be deprecated and that anytime you use subtotals, you should be using Continue reading “Excel Subtotals Are Awesome – 2428”
Easy Frequency Distribution For Bingo Numbers in Excel – 2430
Candace is using a third-party Bingo app to generate numbers for a bingo game. Some people are complaining that the app is not fair and that it is calling some numbers too frequently. Candace manually keyed the numbers into Excel Continue reading “Easy Frequency Distribution For Bingo Numbers in Excel – 2430”
Advanced Analytics Techniques For Power BI
RESOURCE DOWNLOAD – https://portal.enterprisedna.co/p/webinar-series-resources-free/
When is it?
September 30th, 4pm New York (EDT), 1pm Los Angeles (PDT) , 9pm London (BST)
October 1st, 6am Sydney (AEST), 9am Auckland (NZDT)
How long is it?
Session will run for approximately 1 hour
Where is it?
Join Continue reading “Advanced Analytics Techniques For Power BI”