How to create Stock Charts in Excel
Learn how to create your favourite stock charts in Excel to visualise the price movement of your favourite stock, commodity, or cryptocurrency
How to create a Household budget in Excel
Learn, step by step how to set up, manage and edit the monthly household budget template in Excel as start keeping on top of your expenses today
Women in Excel You Need to be following
Awesome Women in Excel you need to be following
Date tables for DAX users – Power BI and Power Pivot
Everyone should use a date table in Power BI, but creating one with DAX is not the most optimal solution. We have a lot to cover in this article on date tables,
9 Tips for PowerBI Users
are you a PowerBI user? here are 9 tips so you can make the most of PowerBI
Why and how to Keep Dimensions & Facts tables separate – DAX modeling
Modeling for DAX Power Pivot and Power BI – Learn why and how you should keep dimensions and facts tables separate.
DAX AND OR IN or syntax(&& ||) – Which one?
Learn how to create conditional statement in DAX using AND, OR, IN and the syntax && and ||
6 DAX tips for Excel and Power BI users
If you are learning DAX for Power Pivot or Power BI then here are 6 DAX tips you should be following
Dynamic Positioning of Totals using Dynamic Arrays
Learn to create spreadsheet with Dynamic positioning of totals in Excel. Great example of the use of SEQUENCE
Excel Knowledge Sharing week ending Fri. 3rd Jan
Its Excel knowledge sharing time peeps 🙂 Have you published an Excel resource this week? Or maybe you found a resource online that really helped you solve a spreadsheet problem you had? Well now is the time to share it (with a few simple rules) Rules The resource and knowledge you share must be related […]