As I mentioned, I like to start off a new year with a new release so I feel like I’ve accomplished something for the year.
This year’s new release is the Excel 365 Essentials series, which includes Excel 365 for Beginners, Intermediate Excel 365, and 102 Useful Excel 365 Functions.
You may see some symmetry in those titles compared to the original Excel Essentials series (Excel for Beginners, Intermediate Excel, 50 Useful Excel Functions, and 50 More Excel Functions) and that’s because these are the updated versions of those titles.
Now, to be clear, the original Excel Essentials series still very much has its place for any users of Excel up to Excel 2019 as well as any users who need to worry about backwards compatibility with an older version of Microsoft Excel.
So if you want to learn how to use Excel and be able to function in any version of Excel, then the original series is still your best choice.
But Microsoft has made enough improvements to Excel over the years that if that’s not a concern for you, then this new Excel 365 Essentials series is the best choice. Because it incorporates things like a faster way to apply borders, how to use pivot charts, as well as some of the newer functions that can completely replace older functions.
For example, XLOOKUP, which is available in Excel 365 can take the place of VLOOKUP, HLOOKUP, and perhaps a few others. And TEXTJOIN takes the place of CONCATENATE (at least how I used it). And IFS replaces the need to use nested IF functions.
All tremendous advances. (I may in fact have included a marriage proposal in 102 Functions for whoever developed XLOOKUP, it’s that amazing a function.)
So if you want the latest and greatest, Excel 365 Essentials is my take on that as of December 2022. If you need tried and true and won’t fail you no matter which version of Excel you use, stick to Excel Essentials. And, of course, if you have Excel 2019 then the Excel Essentials 2019 series is there for you. (All links can be found on this page.)
Now, I also mentioned a free book. I put together Excel Tips and Tricks, which is a short little book that includes my favorite shortcuts and ways to make life easier. Things like freeze panes and print titles are covered in there, for example.
In ebook it is free on all major retailers. Amazon may or may not price match on any given day, but if they aren’t it’ll be just 99 cents there. But all the other retailers who are sane enough to allow free pricing will always have it free. Or you can get it on Payhip direct from me if you want. There is also a print version available, but that is, sadly, not free.
So there you have it. Enjoy!