Excel Hidden and Very Hidden Sheets – What’s the difference?

Hidden and Very Hidden Sheets in Excel – Skip to Video As most of us know, Excel, being such an amazing tool, gives us the ability to Hide sheets from view.  However, what many are not aware of is that Excel also offers the ability to set sheets as very hidden.  Hidden sheets are common […]

Easy steps to Convert Snowflake to a Star- DAX Modeling

If there is one piece of advice, I could give to DAX users, it would be to keep the structure of the model simple.  That includes flattening or converting from a snowflake to a star. Take a look at this. Its an image of a model I found online some time ago. Source How does it […]

How to use XMATCH in Excel

Learn how to use XMATCH in Excel, with practice activity, workbook to download and video solution to the Problem