Displaying 1-20 of 157 results
Exclusive
Finding the missing link – Edit links enhanced
- Article
- 25 Apr 2024
- Simon Hurst
Links to cells in other workbooks are a frequent cause of confusion. It can be particularly difficult to track down some of the more elusive ways in which one spreadsheet can be linked to another. A Find Next command available as part of an enhancement to the previous Edit Links command might now be able to help.
Exclusive
IRR, XIRR & MIRR – What are they? When to use them?
- Article
- 23 Apr 2024
- Mark Proctor
IRR is commonly used to help make project investment decisions. In this article, Mark Proctor returns to explore the use of the IRR function in Excel and potential alternatives.
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.
Exclusive
Spreadsheet review – can Power Query help? Part 3
- Article
- 23 Feb 2024
- Simon Hurst
In part 1 of this series, we looked at some of the advantages of adding Power Query to your review toolkit. This time we are going to move on from the Profile table that we created in Part 2 to rearranging our Table and positioning it above our original data for ease of reference. We will be using a range of techniques that demonstrate the versatility of the Power Query tools.
Exclusive
Spreadsheet review – can Power Query help? Part 2
- Article
- 16 Feb 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. In part 2 we are going to look in more detail at some of those tools and techniques.
Exclusive
Spreadsheet review – can Power Query help: part 1?
- Article
- 13 Feb 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. However, it’s worth considering the addition of Power Query to your review toolkit on the grounds of simplicity and ease of use.
Exclusive
EXCEL TIP OF THE WEEK
Excel Tips & Tricks #487 – An Introduction to Slicers
- Article
- 09 Feb 2024
- Thomas Edmunds
Hello and welcome back to Excel Tips and Tricks! This week, we have a Basic User level post exploring the basics of setting up, customising and using slicers in Excel to filter and sort through data.
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
Getting Internet data into Excel just got easier
- Article
- 18 Dec 2023
- Simon Hurst
Trying to link Power Query to data on a web page could be tedious at best. An enhancement to the ‘From Web’ data connector makes things a lot easier and uses AI to help you get the information that you need.
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...
Exclusive
EXCEL TIP OF THE WEEK
Excel Tips & Tricks #479 – Advanced Filter redux
- Article
- 15 Sep 2023
- Bani Lamba
Hello and welcome back to Excel Tips and Tricks! This week we have a Creator level post where we will take another look at the ‘Advanced Filter’ feature.
EXCEL COMMUNITY ROUND UP
Excel Community round up - August 2023
- Article
- 01 Sep 2023
- Tracy Gray
Here are all the new Excel blogs from the Excel Community in August 2023.
Exclusive
Power Query – matching lists part 2
- Article
- 24 Aug 2023
- Simon Hurst
In the first part of this two-part article, we looked at using lists in Power Query to create a list of articles that matched a set of keywords within the existing archive portal, in order to support a new Excel Community project. After seeing how we could create a table containing the relevant information in part 1, this time we will see how to use those techniques to add our filter in Power BI.
Exclusive
YOUR QUESTIONS ANSWERED
Your Questions Answered #7 - How do I combine tables from multiple files into a single table?
- Article
- 24 Aug 2023
- Ian Pay
In a recent ‘Excel Tips and Tricks live – your questions answered’ webinar, Ben Ducker and Ian Pay tackled excel questions and queries covering best practice, the use of functions and functionality, and application of Excel techniques to accounting scenarios. Ian returns to deep dive into how tables from multiple files in different locations can be combined into a single table in Excel.
Exclusive
TECH NEWS
Power Query – matching lists part 1
- Article
- 17 Aug 2023
- Simon Hurst
In the first part of a two-part article, we start looking at how to use lists in Power Query to add a new filter to our archive portal to support a new Excel Community project.
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 #4 – Is Excel still the go to application for financial modelling?
- Article
- 27 Jun 2023
- Craig Stirk
In a recent webinar on ‘Financial Modelling and Scenario Planning: Mastering Effective Decision-Making’, Craig Stirk and Ben Ducker explored why scenario planning is important and why structured models can help. Craig returns to answer some questions from the webinar they were unable to respond to during the session.
Exclusive
Is there anything that Power Query can't do?
- Article
- 30 May 2023
- Simon Hurst
There are many things that Power Query can't do but, in this occasional series, we will be looking at some of the less obvious techniques available. In this episode we look at automating the changing of column heading text.
Exclusive
TECH NEWS
Excel fundamentals training – what should be included?
- Article
- 04 May 2023
- Simon Hurst
Should basic Excel training stick to simple formulas and functions or should it extend the horizons of learners to consider the likes of Dynamic Arrays, PivotTables and Power Query?
Displaying 1-20 of 157 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.