ICAEW.com works better with JavaScript enabled.

Excel and Tech news

View the latest community announcements and articles from Tech News and the Excel Community.

Contents
Back to top

Latest articles

Exclusive Excel Tips and Tricks #455 - Data Conversion
  • No content type
  • 26 Sep 2022
Hello all and welcome back to the Excel Tips and Tricks. This week, we have a General User post in which we are taking a closer look at how to convert data types in Excel.
Exclusive Excel Tips and Tricks #455 - Data Conversion
  • Article
  • 26 Sep 2022
Hello all and welcome back to the Excel Tips and Tricks. This week, we have a General User post in which we are taking a closer look at how to convert data types in Excel.
Exclusive TEXTBEFORE(), TEXTAFTER, TEXTSPLIT()
  • Article
  • 22 Sep 2022
Three new text functions have been introduced in Excel to help extract values from text containing some sort of delimiter. We take a detailed look at some of the arguments available as part of these new functions to help you to get the most from them and also highlight some significant changes between the preview and release versions of the functions.
Exclusive How to Review a Spreadsheet Part 4: Design Principles and Formula Errors
  • Article
  • 21 Sep 2022
The last three blogs in this series will now look at validating the details within the spreadsheet. The range of these items that should be applied will need to be proportionate to the context, scale and risk of the spreadsheet being reviewed.
Exclusive Excel Tips and Tricks #454 – Revisiting splitting workbooks with VBA
  • Article
  • 13 Sep 2022
A Developer level post in which we are going to work through the VBA code required to take a workbook and cut it into one file for each sheet, and save all the resulting files.
Exclusive Excel Tips and Tricks #453 – Revisiting Audit Sampling with Dynamic Arrays
  • Article
  • 31 Aug 2022
Hello all and welcome back to Excel Tips and Tricks. This week, we have a General User post in which we are revisiting how to build (and use) a template to assist with audit sampling using dynamic arrays, last covered in TOTW #353.
Exclusive Pro-rating hours in a month
  • Article
  • 22 Aug 2022
This month’s article offers a method for pro-rating hours in a month that works in all versions of Excel.
Exclusive Filter tips 2 – more fun with FILTER()
  • Article
  • 09 Aug 2022
Last time we saw how the SUM() function can be combined with the new FILTER() function to calculate conditional aggregate values. This time we look at how to construct an aggregate formula to include all the items that are matched against an entire list of criteria values.

Excel hints and tips

The Excel community has produced an extensive list of helpful tips and tutorials including its 'Excel tip of the week' series.  
Exclusive Excel Tips and Tricks #455 - Data Conversion
  • Article
  • 26 Sep 2022
Hello all and welcome back to the Excel Tips and Tricks. This week, we have a General User post in which we are taking a closer look at how to convert data types in Excel.
Exclusive Excel Tips and Tricks #454 – Revisiting splitting workbooks with VBA
  • Article
  • 13 Sep 2022
A Developer level post in which we are going to work through the VBA code required to take a workbook and cut it into one file for each sheet, and save all the resulting files.
Exclusive Excel Tips and Tricks #453 – Revisiting Audit Sampling with Dynamic Arrays
  • Article
  • 31 Aug 2022
Hello all and welcome back to Excel Tips and Tricks. This week, we have a General User post in which we are revisiting how to build (and use) a template to assist with audit sampling using dynamic arrays, last covered in TOTW #353.
Exclusive Excel Tips and Tricks #452 - Named Ranges Refreshed
  • Article
  • 22 Aug 2022
For this Creator post we have a refresher on Named Ranges in Excel, last covered way back in TOTW #188, and discuss their use and practical tips for working with them.
Exclusive Excel Tips and Tricks #451 – Sparklines Refreshed
  • Article
  • 05 Aug 2022
Hello all and welcome back to the Excel Tip of the Week. This week, we have a Creator post in which we are looking at another under-utilised piece of functionality within Excel – the Sparkline, last covered in TOTW #290.
Exclusive Excel Tips and Tricks #450 – Revisiting Custom Data Validation
  • Article
  • 26 Jul 2022
In this Creator post we revisit the topic of how to make custom data validation rules with functions.
Exclusive Excel Tips and Tricks #449 - Let LET simplify formulas
  • Article
  • 19 Jul 2022
Hello all and welcome back to Excel Tips and Tricks! For this tip we have a Creator post where we introduce the LET formula in Excel and how this can be used to simplify otherwise long and complicated Excel formulas.
Exclusive Excel Tips and Tricks #448 – A Distinct Count Conundrum
  • Article
  • 13 Jul 2022
Hello all and welcome back to Excel Tips and Tricks! For this tip, we have a Creator post looking at the challenges around generating distinct counts by category and correctly calculating these as a percentage of the total population. This tip is based on a genuine scenario encountered when trying to produce some MI in relation to audit clients.

Join the Excel community

Do you use Excel in your organisation? Are you using it to its maximum potential? Develop your skills and minimise spreadsheet risk with our Excel resources. Membership is open to everyone - non ICAEW members are also welcome to join. You also have the option to Join the Tech Faculty, where Excel Community membership is included.

Join the community Already a member? login here
Excel community