Displaying 1-10 of 1101 results
10 must-read tips for designing and formatting your spreadsheets
- Listing
- 03 Feb 2023
Welcome to the Excel Community! To help you get the most out of the community content, we've rounded up 10 top articles, drawing on content from years gone by, to help you master the design and format of your spreadsheets.
Add-ins or bad-ins? The dangers of Excel XLL files.
- Article
- 02 Feb 2023
Most Excel users know about the dangers of running macros received from an untrusted source. However, as Microsoft strengthens its security procedures relating to macros, the danger might increasingly come from another direction: Excel add-ins and, in particular, .XLL files.
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.
A robust data entry table in Google Sheets
- Article
- 02 Feb 2023
One key aspect to robust data entry is Data Validation, and Google Sheets’ version got a hefty upgrade last month making it far superior to Excel’s equivalent. Watch the video or see the descriptions with updated tips.
Lookout for VLOOKUP and HLOOKUP
- Article
- 24 Jan 2023
Often you will need to look up data in a table – and two functions most modellers are very familiar with are VLOOKUP and HLOOKUP, even in these new halcyon days of XLOOKUP – but let’s discuss that function next time. For now, do you realise it’s very easy to make a mistake with these functions?
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.
Exclusive
Welcome to the Excel Community: Twenty principles for good spreadsheet practice
- Article
- 11 Jan 2023
Simon Hurst introduces the ‘Twenty principles for good spreadsheet practice’, and other key publications, to members who have recently joined the Excel community.
Exclusive
Excel Community round up December 2022
- Article
- 04 Jan 2023
All the new Excel blogs and webinars from the Excel Community in December 2022.
Exclusive
Your 2023 Excel Community
- Article
- 03 Jan 2023
We’re delighted to welcome all of our members – new and old alike – to our bigger, better Excel Community for 2023.
Displaying 1-10 of 1101 results