Excel Data Validation – Control and Restrict user inputs
What is Data validation in Excel? Where is data validation in Excel? What about data validation with Excel tables or with Dynamic arrays. Learn all about Data validation in this blog post.
DAX LOOKUPVALUE – Power BI and Excel Power Pivot
Learn how to lookup a value from a different table in DAX for Power Pivot and PowerBI, with no relationship using LOOKUPVALUE
Avoid Transformation steps in DAX (Excel and PowerBI)
Avoid Transformation steps in DAX (Excel and PowerBI) and learn to carry out data transformation in Power Query
The Sort Functions in Excel (SORT, and SORTBY)
learn to use the SORT functions in Excel, SORT and SORT by
Data Profiling views in Power Query (Excel and Power BI)
By identifying problems before they become errors Data profiling views in power query helps to ensure your data is clean & ready to be loaded into a model
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