DAX AND OR IN or syntax(&& ||) – Which one?
Learn how to create conditional statement in DAX using AND, OR, IN and the syntax && and ||
Category: Excel Tips and Tricks
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 […]
Excel Dynamic Conditional Formatting Tricks
Learn how to use Excels Dynamic Conditional Formatting to add those professional finishing touches to any spreadsheet or model.
Excel Superstars you need to be following
Excel Superstars – Excel Bloggers and Excel Youtubers you really need to follow.
10+ Excel Learn and Earn Activities YOU can do Today
Earn your self some cryptocurrency rewards by completing these Microsoft Excel Learn and Earn Activities
5 Reasons Spreadsheet Users should be using Excel 365
5 Awesome reasons you should upgrade to Excel 365
Share Collaborate and Co-Author in Excel
Share Collaborate and Co-Author in Excel With improvements in Cloud Computing it is now easier than ever to collaborate and Co Author in an Excel workbook. People can work together, see each other changes and keep the file saved an up to date. Collaboration is the ability to work with other people and through out […]
Excel Dynamic Arrays – A new way to model your Excel Spreadsheets
An Introduction to the New Excel Dynamic Arrays – 4 Examples. Soon you will have a new way to model your Excel Spreadsheets!