Here is all of August's new Excel content. Excel Community and Tech Faculty members can access all posts by logging in to their accounts: Other users can access posts described as "public".
Excel Tip of the Week
301 - Google Sheets: SORT (public)
The dynamic SORT function can organise a whole range of data with just one function.
302 - Linear regression functions
Excel has plenty of statistical analysis functions for you to check out - in this Tip, we take a look at those related to linear regression.
303 - Revisiting the Formula Wizard
The Formula Wizard can help you keep your complicated formulas straight - even when nesting formulas.
304 - Google Sheets: FILTER
Continuing the series on Google Sheets' dynamic arrays, here's a look at a powerful dynamic array function that can filter the data it returns.
Part 51 - ALTernative Excel in an instance
Modeller Liam Bastick covers how to make multiple instances of Excel work for you.
Part 52 - New Excel functions: XLOOKUP and XMATCH
Liam shows off two new functions coming to Excel for Office 365 soon - and explains why both VLOOKUP and INDEX MATCH fans should be excited to jump ship!
Book review: Supercharge Excel: When you learn to write DAX for Power Pivot
Simon Hurst reviews a recent Excel book on the powerful DAX language for Power BI and Power Pivot.
Modern Excel - Statistical & forecasting charts
David Benaim guides you through the latest charting and formula options for forecasting and for presenting statistical data.
Accountants' guide to Excel: Keeping your formula cells safe
Simon Hurst talks you through the essentials of cell and worksheet protection.
Excel tips for accountants - Working with CSV files
New blogger Tom Edmunds, fresh from his webinar last month, begins a series on working with accounting data with a deep dive into the common CSV file format.