Displaying 1-20 of 248 results
Exclusive
Including calculations in Microsoft Word
- Article
- 27 Mar 2024
- Simon Hurst
Excel might be the obvious application for all sorts of calculations, but Word also has a calculation feature based on Field Codes that can perform simple calculations, use some functions and also format the result.
Exclusive
YOUR QUESTIONS ANSWERED
Your Questions Answered #10 – Tips and Tricks Live extended
- Article
- 25 Mar 2024
- Bani Lamba
In this year’s first 'Excel Tips and Tricks live – your questions answered' webinar, John Yeldham and Ian Pay tackled Excel questions and queries covering best practice, the use of functions and functionality, and a range of techniques for data handling and analysis in Excel. Bani returns to answer some of the unanswered questions from the webinar.
Exclusive
Don’t be a check box Charlie
- Article
- 26 Jan 2024
- Simon Hurst
In preparation for a very useful enhancement to the Excel check box feature that is currently available to those on the Insider update channel, we take a look at how check boxes work at the moment before seeing how much easier they will be to use in the near future.
Exclusive
EXCEL TIP OF THE WEEK
Excel Tips & Tricks #486 – Revisiting inserting hyperlinks
- Article
- 12 Jan 2024
- Bani Lamba
Hello and welcome back to Excel Tips and Tricks! This week, we have a Basic User level post in which we take look another look at how to create hyperlinks in your file, to aid quick navigation. We will also cover the differences between hyperlinks in Excel Online and the desktop versions.
Exclusive
Animated Excel Christmas tree follow-up
- Article
- 08 Jan 2024
- Simon Hurst
Following the response to our 2023 Christmas special, we are extending our interactive Excel Christmas card to demonstrate some additional Conditional Formatting techniques.
Exclusive
Animated Excel Christmas tree
- Article
- 19 Dec 2023
- Simon Hurst
What better way to spread Christmas cheer than by sending someone an interactive Excel Christmas tree? In this article we use a range of techniques including conditional formatting, Dynamic Arrays and a LAMBDA() function to bring some added sparkle to Christmas.
NEW TECH FEATURES
Excel, Teams, Power BI, Canva, Zoom, Google Sheets++: New tech features for Sep-Nov 2023
- Article
- 19 Dec 2023
- David Benaim
David Benaim presents a digest of new features across Microsoft 365 and other business tech products in written, images and video format, covering the last three months.
Exclusive
Histogram Hiccoughs part 2
- Article
- 27 Oct 2023
- Liam Bastick
Last time, I provided several reasons why Excel’s built-in Histogram charts can cause problems. This time, I consider workarounds to achieve the same visualisations.
Exclusive
EXCEL TIP OF THE WEEK
Excel Tips & Tricks #481 – Refreshing Cell Styles
- Article
- 20 Oct 2023
- Ian Pay
Hello all and welcome back to Excel Tips and Tricks! This week, we have a General User post in which we're revisiting the topic of cell styles to help support consistency of formatting.
Exclusive
Advanced conditional formatting – part 3: the horror of peril sensitivity
- Article
- 02 Oct 2023
- Simon Hurst
Applying default conditional formats is very straightforward and can be accomplished with just a couple of clicks, but delving a little deeper can help you to use conditional formatting in additional ways and to tailor your format to your own requirements. After looking in part 1 at some of the more advanced ways to use cell formats as part of conditional formatting and in part 2 at the graphical conditional formats, this time we will look at some other uses of conditional formatting including how it works with PivotTables and Power Query tables as well as some more unusual applications of con...
EXCEL COMMUNITY ROUND UP
Excel Community round up - September 2023
- Article
- 02 Oct 2023
- Tracy Gray
Here are all the new Excel blogs from the Excel Community in September 2023.
Exclusive
Advanced conditional formatting – part 2: the highlights
- Article
- 25 Sep 2023
- Simon Hurst
After looking in part 1 at some of the more advanced ways to use cell formats as part of conditional formatting, in this episode, we are looking in depth at the graphical conditional formats.
Exclusive
Advanced conditional formatting – part 1: automatic currency exchange
- Article
- 14 Sep 2023
- Simon Hurst
Applying default conditional formats is very straightforward and can be accomplished with just a couple of clicks, but delving a little deeper can help you to use conditional formatting in additional ways and to tailor your format to your own requirements. In the first part of a short series, we look beyond the default formats and include a practical example using number formatting.
How can “GO TO SPECIAL” help you understand a spreadsheet?
- Article
- 07 Sep 2023
- Ben Ducker
Part 1 of this series covered the basics on how to use the “Go To Special” function. The second part of this three-article series will cover how to use the function to quickly understand a spreadsheet you’re not familiar with.
Exclusive
EXCEL TIP OF THE WEEK
Excel Tips & Tricks #478 - Introduction to Power Automate
- Article
- 05 Sep 2023
- Thomas Edmunds
Hello and welcome back to Excel Tips and Tricks! This week we have a Developer level post where we will demonstrate how to use Power Automate to run an Office Script against multiple Excel files simultaneously.
What’s so special about “GO TO SPECIAL”?
- Article
- 22 Aug 2023
- Ben Ducker
“Go To Special” is a function that can help users get to grips with new spreadsheets a bit quicker and can also be used as part of spreadsheet auditing techniques. The first part of this three-article series will cover the basics of what the “Go To Special” function is and how to use it, what it can do, and some specific applications and use cases.
Exclusive
Fraudulent Numbers
- Article
- 25 Jul 2023
- Liam Bastick
Sometimes, things aren’t what they seem. Like false advertising, optical illusions and hidden agendas, on occasion numbers in Excel may appear “fraudulent”. And that can cause issues for spreadsheets, whether you are using them for data manipulation / reporting, forecasting, budgeting or modelling.
Exclusive
YOUR QUESTIONS ANSWERED
Your Questions Answered #5 – Tips and Tricks Live extended: What is your favourite underappreciated formula?
- Article
- 13 Jul 2023
- Ben Ducker
In a recent ‘Excel Tips and Tricks live – your questions answered’ webinar, Ben Ducker and Ian Pay tackled Excel queries covering best practice, the use of functions and functionality and more. Ben returns to answer questions they were unable to respond to during the session.
Exclusive
EXCEL TIP OF THE WEEK
Excel Tips & Tricks #475 - Using ‘Show Changes’: keeping track of cell edits and the power of cloud storage
- Article
- 05 Jul 2023
- Thomas Edmunds
Hello and welcome back to Excel Tips and Tricks! This week, we have a Basic User level post in which we explore using ‘Show Changes’ to keep track of cell edits and learn more about the power of cloud storage.
Exclusive
EXCEL TIP OF THE WEEK
Excel Tips & Tricks #473 – Refreshing customising the ribbon
- Article
- 30 May 2023
- Jonelle Johnson Turner
This week, we have a Creator level post in which we're dipping our toes back into the pool of customisation options available through Excel.
Displaying 1-20 of 248 results
Search the Excel Community archive
This archive of Excel Community content from the ION platform will allow you to read the content of the articles but the functionality on the pages is limited. The ION search box, tags and navigation buttons on the archived pages will not work. Pages will load more slowly than a live website. You may be able to follow links to other articles but if this does not work, please return to the archive search. You can also search our Knowledge Base for access to all articles, new and archived, organised by topic.