Displaying 1-20 of 76 results
Exclusive
SIMPLE BUT EFFECTIVE TABLES
Simple but effective Tables. Part 10
- 23 Sep 2024
- Simon Hurst
In this series we are going to examine some of the capabilities of Excel Tables. We will be concentrating on the practical use of Tables to improve spreadsheet productivity. We are going to conclude our series of articles on the practical use of Excel Tables by looking at how Tables work with Power Query.
Exclusive
SIMPLE BUT EFFECTIVE TABLES
Simple but effective tables, part 9
- 09 Sep 2024
- Simon Hurst
In this series we are going to examine some of the capabilities of Excel Tables. We will be concentrating on the practical use of Tables to improve spreadsheet productivity. The previous two-part article looked at the use of structured references to refer to all or part of an Excel Table, from cells outside of the Table as well as cells within the Table. We are going to conclude our exploration of Tables by looking at Filtering and Sorting, and using Sparklines and check boxes in Table columns. Then, in the next part of the series, we will look at how Tables work with Power Query.
Exclusive
SIMPLE BUT EFFECTIVE TABLES
Simple but effective tables, part 8
- 07 Aug 2024
- Simon Hurst
In this series we are going to examine some of the capabilities of Excel Tables. We will be concentrating on the practical use of Tables to improve spreadsheet productivity. Last time we started looking at the use of structured references to refer to all or part of an Excel Table, using examples based on referring to the Table from cells outside the Table. This time we will look at structured references within a Table and some more advanced examples of how to use structured references.
Exclusive
SIMPLE BUT EFFECTIVE TABLES
Simple but effective tables, part 7
- 24 Jul 2024
- Simon Hurst
In this series we are going to examine some of the capabilities of Excel Tables. We will be concentrating on the practical use of Tables to improve spreadsheet productivity.
Exclusive
The underused Table feature in Excel & Google Sheets
- 04 Jul 2024
- David Benaim
From my experience, every spreadsheet user already considers their data to be in tables, simply by virtue of data being in rows & columns, but very few have ever used the actual feature called “Tables” which means sadly that almost every regular user is missing out on one of spreadsheets’ most useful features.
Exclusive
SIMPLE BUT EFFECTIVE TABLES
Simple but effective tables, part 6
- 03 Jul 2024
- Simon Hurst
In this series we are going to examine some of the capabilities of Excel Tables. We will be concentrating on the practical use of Tables to improve spreadsheet productivity. The last article finished with a brief introduction to the use of Slicers as interactive filters for Excel Tables. This time we show how Slicers can be used in practice to create an interactive dashboard from an Excel Table.
Exclusive
SIMPLE BUT EFFECTIVE TABLES
Simple but effective tables, part 5
- 24 Jun 2024
- Simon Hurst
In this series we are going to examine some of the capabilities of Excel Tables. We will be concentrating on the practical use of Tables to improve spreadsheet productivity. As part of our journey through the capabilities of Tables, this time we are going to examine some of the options available in the contextual Table Design Ribbon tab.
Exclusive
SIMPLE BUT EFFECTIVE TABLES
Simple but effective tables, part 3
- 09 May 2024
- Simon Hurst
In this series we are going to examine some of the capabilities of Excel Tables. So far, we have 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. We have also seen how new rows and columns are automatically incorporated into existing Tables. This time, we will start by changing the dimensions of Tables manually.
Exclusive
SIMPLE BUT EFFECTIVE TABLES
Simple but effective tables, part 2
- 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
SIMPLE BUT EFFECTIVE TABLES
Simple but effective tables, part 1
- 27 Mar 2024
- Simon Hurst
It’s very easy to format a block of data in your favourite colour scheme by using an Excel Table, but Excel Tables are so much more important than just facilitating formatting. In this series we are going to see just what they are capable of, starting with looking at how to create Excel Tables and going on to cover some simple examples of their practical use, such as avoiding global austerity.
Excel's new functions might change data analysis forever
- 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
Spreadsheet review – can Power Query help: part 1?
- 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
Enhancing data display and entry with Excel Form Controls
- 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
EXCEL TIP OF THE WEEK
Excel Tips & Tricks #482 – Get Data From Picture
- 30 Oct 2023
- Ian Pay
Hello all and welcome back to Excel Tips and Tricks! This week, we have a Creator level post in which we're covering some relatively new functionality that allows users to capture data into a spreadsheet from an image.
Exclusive
Advanced conditional formatting – part 3: the horror of peril sensitivity
- 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
Formatting Slicers
- 30 Aug 2023
- Liam Bastick
In earlier versions of Microsoft Excel, you can use report filters to filter data in a PivotTable report, but it is not easy to see the current filtering state when you filter on multiple items. In Microsoft Excel 2010 and later versions (that is, from when Slicers were introduced), you have the option to use Slicers to filter the data
Exclusive
YOUR QUESTIONS ANSWERED
Your Questions Answered #4 – Is Excel still the go to application for financial modelling?
- 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
Organisation Data Types
- 19 Jun 2023
- Simon Hurst
Once planned to include a whole range of general data to be provided through a now-terminated partnership with Wolfram Alpha, built-in Excel Data Types are now restricted to Geography, Stocks and Currencies. However, using Power BI Pro, it is possible to build your own ‘organisational’ Data Types to give your Excel users access to information from both within your organisation and more public sources of data.
Exclusive
Is there anything that Power Query can't do?
- 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
Power Query – building in checks and controls – part 1
- 21 Apr 2023
- Simon Hurst
In the first of a three-part mini-series we are going to see how Power Query can help identify potential problems in our output tables. In part 1 we examine the importance of total checks and see how to construct them.
Displaying 1-20 of 76 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.