Displaying 1-10 of 332 results
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!
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.
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.
Displaying 1-10 of 332 results