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!
Exclusive
Using Power BI bookmarks to highlight report content
- Article
- 19 Jan 2023
In order to support a short series of articles on the four current ICAEW spreadsheet publications, we have added a bookmark navigator to our Power BI archive article portal to allow the display of the list of articles relevant to a publication with a single click. Here we look at how to create bookmarks in Power BI including which page settings they can hold and apply, before creating a ‘navigator’ that automatically adjusts as we add and change our bookmarks.
Taking a Break
- Article
- 20 Dec 2022
This month, we look at a common “clean up” problem in Excel – how to separate text and numbers. Before everyone writes in and tells me “use Power Query”, the point here is to create a formulaic solution which will not need refreshing when data changes.
Exclusive
Excel Tips & Tricks #463 – Top Tips of 2022
- Article
- 14 Dec 2022
As we approach the end of the year, we pause to look back at the best content from the Excel Community this year.
Office applications and GIFs
- Article
- 12 Dec 2022
A GIF (Graphics Interchange Format) file is a graphic file, like a bitmap or JPEG file, but it has a superpower: the ability to display an animation rather than just a single still image. You might be familiar with GIFs from their use in Social Media applications or as short, silent animations within online training material. As well as demonstrating how much you are laughing out loud at a friend’s latest message, GIFs can be very useful as a training or troubleshooting aid.
Risk Bubble Charts – Part 2
- Article
- 01 Dec 2022
Liam Bastick looks at the Risk Bubble Charts in Excel. This is part two of the article.
Exclusive
Excel Tips and Tricks #462 - New text manipulation functions - TEXTBEFORE and TEXTAFTER
- Article
- 01 Dec 2022
Hello and welcome to the Excel Tips and Tricks! This week, we are back with a Creator level post in which we are looking at specific examples of using the new TEXTBEFORE and TEXTAFTER functions in Excel.
The Excel community has produced an extensive list of helpful tips and tutorials including its 'Excel tip of the week' series.
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!
Exclusive
Excel Tips & Tricks #463 – Top Tips of 2022
- Article
- 14 Dec 2022
As we approach the end of the year, we pause to look back at the best content from the Excel Community this year.
Exclusive
Excel Tips and Tricks #462 - New text manipulation functions - TEXTBEFORE and TEXTAFTER
- Article
- 01 Dec 2022
Hello and welcome to the Excel Tips and Tricks! This week, we are back with a Creator level post in which we are looking at specific examples of using the new TEXTBEFORE and TEXTAFTER functions in Excel.
Exclusive
Excel Tips and Tricks #461 – Things Google Sheets (still) does better than Excel
- Article
- 22 Nov 2022
Hello and welcome back to Excel Tips and Tricks! This week, we’ve got a General User post that looks at some of the functionality you can find in Google Sheets that Excel is yet to fully master.
Exclusive
Excel Tips and Tricks #460 - Revisiting hidden worksheets
- Article
- 11 Nov 2022
Creator level article looking at how hiding and unhiding worksheets works.
Exclusive
Excel Tips and Tricks #459 - Examples of using LAMBDA() in Excel
- Learning material
- 01 Nov 2022
Hello all and welcome back to the Excel Tips and Tricks! This week we have a Creator level post in which we’re looking at examples of using LAMBDA() in Excel.
Exclusive
Excel Tips and Tricks #458 - Revisiting Line breaks in Excel
- Article
- 24 Oct 2022
Hello and welcome back to Excel Tips and Tricks! This week we have a short Basic User-level post in which we are going to quickly summarise how line breaks and multi-line formatting works in Excel.
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.