Excel Knowledge Sharing week ending Fri. 20 Dec
Have you an awesome Excel resource to share? Something you published, a video or blog. Or, maybe a resource you found online. Excel knowledge sharing time is here
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 in 2021
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!
Stop! Do Not Merge Cells in Excel – Heres why with fixes
Over the years I have seen many things in Excel that have made me go “wow, I won’t do that again in a hurry”. Thankfully as the years have progresses, so has Excel and many of these problem items have been resolved with updates. However, there are still a few things that you should avoid […]
Move over VLOOKUP, here comes XLOOKUP
XLOOKUP Excel 365 (insider edition) VLOOKUP is one of those functions’ users tend to use over and over. At the start it is hard to get your head around it but once you do, it provides great value. However, it also has its limitations. For example, on its own it cannot look up to the […]
XLOOKUP V’s VLOOKUP – 8 Limitations Removed
XLOOKUP V’s VLOOKUP XLOOKUP, soon to be available in Excel 365 is going to make you rethink how you carry out your lookups. VLOOKUP comes with many limitations. Some of these limitations we can work around with other functions or combination of functions. But that is a pain…and time-consuming. Who needs all that hassle when […]