Displaying 1-20 of 466 results
Exclusive
Simple but effective, part 2
- Article
- 18 Apr 2024
- Simon Hurst
In this series we are going to examine some of the capabilities of Excel Tables. In part 1 we considered different ways of turning a range of cells into an Excel Table and demonstrated the importance of Tables in helping to ensure that ranges in formulas adapt automatically to changes in the dimensions of the Table. This time, we will look in more detail at adding rows and columns to existing Tables and see how this can contribute to automating your spreadsheets.
Exclusive
Top 12 Excel Combinations: 10. SUMPRODUCT SIGN (Multiple Conditions with OR)
- Article
- 03 Apr 2024
- Liam Bastick
I the latest instalment of his series counting down the “Top 12” of Excel function combinations, Liam Bastick considers . SUMPRODUCT SIGN (Multiple Conditions with OR).
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
A short introduction to Power Query M code
- Article
- 25 Mar 2024
- Mark Proctor
While M code in Power Query may look overwhelming and confusing, the functional language is similar to Excel formulas built using the LET function. In this article, Mark Proctor explores how to get started with understanding and using M code in Excel
Exclusive
Spreadsheet review – can Power Query help? Part 4
- Article
- 13 Mar 2024
- Simon Hurst
Legacy Excel supports a range of functions and techniques that can help identify potential errors and problems within a spreadsheet as part of a review process. In part 1 of this series we looked at some of the advantages of adding Power Query to your review toolkit and, in parts 2 and 3, explored some of the available tools. In part 4 we are looking at the output of those tools in more detail.
Excel's new functions might change data analysis forever
- Article
- 29 Feb 2024
- Liam Bastick
Excitement is building, as a range of new functions introduced by Microsoft towards the end of last year are – hopefully – edging closer to general release. Here, Microsoft MVP Liam Bastick explores how they work and what they might mean for you.
Exclusive
Top 12 Excel Combinations: 11. IF ISERROR (Error Trapping)
- Article
- 19 Feb 2024
- Liam Bastick
I the latest instalment of his series counting down the “Top 12” of Excel function combinations, Liam Bastick examines IF ISERROR (Error Trapping).
Exclusive
Top 12 Excel Combinations: 12. IF IF (Nested IFs)
- Article
- 26 Jan 2024
- Liam Bastick
Liam Bastick introduces a new series counting down the “Top 12” of Excel function combinations - starting in 12th place, he considers Nested IFs.
Exclusive
Get your errors right
- Article
- 24 Jan 2024
- Simon Hurst
It can be very important to predict errors that might occur in your spreadsheet and then to build in mechanisms for highlighting them, or dealing with them automatically. Knowing the best functions to use can not only simplify your formulas, but also help to avoid your error handling making the initial problem even worse.
Exclusive
First Normal Form: the most important Excel concept nobody told you about
- Article
- 22 Jan 2024
- Mark Proctor
In his first article for the Excel community, Mark Proctor explores how to apply the basic principles of First Normal Form to Excel to reduce the complexity of working with data in spreadsheets.
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
Allowing for Errors with SUMPRODUCT
- Article
- 18 Dec 2023
- Liam Bastick
Liam Bastick examines the ongoing usefulness of the SUMPRODUCT function, in the era of Office 365.
Exclusive
EXCEL TIP OF THE WEEK
Excel Tips & Tricks #485 – Refreshing NETWORKDAYS and WORKDAY functions
- Article
- 12 Dec 2023
- Thomas Edmunds
Hello and welcome back to Excel Tips and Tricks! This week, we have a Creator level post refreshing NETWORKDAYS and WORKDAY functions that can be used to simplify calculations in scenarios that involve counting numbers of working days.
Exclusive
Advanced Data Validation – part 4: optimise data input dropdown lists with dynamic arrays
- Article
- 24 Nov 2023
- Simon Hurst
Having covered the basics of the Excel Data Validation feature in the first part of this series, the use of the Custom option to construct more complex data validation rules in part 2, and working with basic lists in part 3, in this final part we look at using Dynamic Arrays to filter and sort lists automatically.
Exclusive
Enhancing data display and entry with Excel Form Controls
- Webinar
- 13 Nov 2023
Form Controls are objects that can be used to display data or make it easier for users to enter data, to perform an action or to make a selection.
Exclusive
Advanced Data Validation – part 3: lists
- Article
- 10 Nov 2023
- Simon Hurst
Having covered the basics of the Excel Data Validation feature in the first part of this series and the use of the Custom option to construct more complex data validation rules in part 2, this part looks at using Data Validation to allow users to select from lists.
Exclusive
YOUR QUESTIONS ANSWERED
Your Questions Answered #9 – What is the purpose of # when using dynamic arrays?
- Article
- 09 Nov 2023
- Thomas Edmunds
In a recent webinar “Dynamic Arrays refreshed”, Tom Edmunds introduced Dynamic Arrays and explored some of the latest dynamic array functions. In this article Tom returns to answer some questions from the webinar he was unable to respond to during the session.
Exclusive
Advanced Data Validation – part 2: preventing duplicate entries
- Article
- 31 Oct 2023
- Simon Hurst
Having covered the basics of the Excel Data Validation feature in the first part of this series, this time we are going to look at the use of the Custom option to construct more complex data validation rules including preventing duplicate entries.
Exclusive
Advanced Data Validation – part 1
- Article
- 30 Oct 2023
- Simon Hurst
Data Validation can make data entry easier as well as helping to avoid the entry of incorrect values. In this series we are going to explore some of the more advanced uses of Data Validation, but we will start with a quick guide to the Data Validation basics.
Exclusive
Dynamic Arrays refreshed
- Webinar
- 18 Oct 2023
In this webinar, we will recap the basic concepts around dynamic arrays.
Displaying 1-20 of 466 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.