ICAEW.com works better with JavaScript enabled.
Exclusive

Excel Community articles

Read the latest support and guidance from the Excel Community, including our very popular Tip of the Week series.
Displaying 1-10 of 917 results
Exclusive Excel Tip of the Week #404 - Mail merges
  • Article
  • 27 Jul 2021
Hello all and welcome back to the Excel Tip of the Week! This week we have a General User post in which we’re dipping our toes into Word-y waters, as we look at a classic Word/Excel double act – the mail merge.
Intro to Financial Modelling - Part 18: Sensitivities and Scenarios
  • Article
  • 23 Jul 2021
As the penultimate blog in this ICAEW modelling good practice blog series I will be moving away from the guidelines in the code and discussing how using sensitivity and scenario analysis is a key part of any financial model.
Exclusive Excel Tip of the Week #403 - Power Query - merge kinds
  • Article
  • 20 Jul 2021
This week, we have a Creator level post in which we are looking at the various options with Power Query’s Merge option.
Exclusive Community Power BI project – rescuing the lost archive – they think it's all over
  • Article
  • 15 Jul 2021
For details of what this project is all about and how to develop your own version, please look at the Excel archive file article listed below:
Exclusive Excel Tip of the Week #402 - VBA case study: Capitalising titles
  • Article
  • 13 Jul 2021
This week, we have a Developer level post in which we’re going to look at how to build a custom function that will convert text into title case.
Exclusive Data visualisation – small multiples
  • Article
  • 07 Jul 2021
With the introduction of many new chart types in Excel 2016 and later versions, Excel now has over a dozen main charts with lots of sub-types available. Good as Excel's charting capabilities might be, using Power BI to present the data from your Excel workbook opens up a whole new set of possibilities
Exclusive Top ten excel formulas: your questions answered
  • Article
  • 07 Jul 2021
Answers to questions asked during the recent webinar, The Top 10 Excel Formulas
Excel Tip of the Week #401 - Excel on Reddit
  • Article
  • 06 Jul 2021
This week we have a Basic User post in which I’ll be sharing with you an outline of one of my favourite free Excel resources, the Excel subreddit.
Excel Community round-up June 2021
  • Article
  • 05 Jul 2021
Here are all the new Excel articles and webinars from the Excel Community in June 2021. Posts marked as public can be accessed by anyone; other articles are accessible to Excel Community & Tech Faculty subscribers and can be accessed by logging in to your ICAEW account.
Exclusive Goals gone wild
  • Article
  • 05 Jul 2021
Given each Excel spreadsheet can contain up to 1,048,576 rows and 16,384 columns, with each cell containing as many as 32,767 characters, that’s an awful lot of data you can trawl through. Wildcards can help. These are symbols used to replace or represent one or more characters, typically for use in text strings.
Displaying 1-10 of 917 results