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
Category: Excel Tips and Tricks
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.
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
DAX AND OR IN or syntax(&& ||) – Which one?
Learn how to create conditional statement in DAX using AND, OR, IN and the syntax && and ||
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 […]