ICAEW.com works better with JavaScript enabled.

Tech News articles

View all the articles published by Tech News.

Displaying 1-10 of 334 results
Exclusive Power Query – matching lists part 1
  • Article
  • 17 Aug 2023
In the first part of a two-part article, we start looking at how to use lists in Power Query to add a new filter to our archive portal to support a new Excel Community project.
Exclusive LOOKUP
  • Article
  • 04 May 2023
Regular readers will recall I took VLOOKUP and HLOOKUP to task recently, before moving on to the INDEX MATCH combination and then XLOOKUP. You don’t always need the latest and greatest though: LOOKUP may seem a less versatile function upon first glance, but it is quite useful for modelling. It’s an “oldie but goodie”.
Exclusive Excel fundamentals training – what should be included?
  • Article
  • 04 May 2023
Should basic Excel training stick to simple formulas and functions or should it extend the horizons of learners to consider the likes of Dynamic Arrays, PivotTables and Power Query?
Exclusive Excel Tips & Tricks #470 – Introducing Office Scripts in Excel
  • Article
  • 28 Apr 2023
Hello and welcome back to Excel Tips and Tricks! This week we have a Developer level post where provide a high-level overview of Office Scripts in Excel, a potential replacement for VBA to help automate tasks.
Exclusive Excel Tips & Tricks #469 – Exploring the ‘Info’ view in Excel
  • Article
  • 04 Apr 2023
Hello and welcome back to Excel Tips and Tricks! This week we have a General User post where we explore document properties and version history in the ‘Info’ view in Excel to help manage spreadsheets, and show why it’s really important to use it correctly.
Exclusive Excel Tips & Tricks #468 – Refreshing dealing with Objects
  • Article
  • 16 Mar 2023
Hello and welcome back to Excel Tips and Tricks! This week we have a General User post where we take a look at how to insert and deal with objects including images, charts, or files in Excel.
Exclusive Excel Tips & Tricks #467 - Excel functions that do not return arrays or ranges
  • Article
  • 23 Feb 2023
Hello and welcome back to Excel Tips and Tricks! This week have a Creator level post where we take a look at Excel functions that are harder to use with arrays or ranges.
Exclusive Excel Tips & Tricks #466 - Setting range permissions in Excel Online
  • Article
  • 13 Feb 2023
Hello and welcome back to Excel Tips and Tricks! This week we have a Basic User level post in which we look at how to set up range permissions in Excel Online to protect your spreadsheets.
Exclusive Excel Tips & Tricks #465 - Using #N/A in charts redux
  • Article
  • 02 Feb 2023
Hello all and welcome back to the Excel Tips & Tricks! This week we have a Creator level post in which we're taking a look at how to make use of the #N/A error to help customise charts. This was previously covered in Tip #297.
Exclusive Excel Tips & Tricks #464 - Refreshing Keyboard shortcuts
  • Article
  • 20 Jan 2023
Hello and welcome back to Excel Tips and Tricks! To start off the new year, we have a Basic User level post in which we’re taking a look at keyboard shortcuts that will improve your experience of using Excel. All of our posts are written with Excel for Windows in mind, but for this post especially so!
Displaying 1-10 of 334 results