Displaying 1-20 of 1264 results
Exclusive
Simple but effective, 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
Top 12 Excel Combinations: 6. MAP LAMBDA
- 18 Jul 2024
- Liam Bastick
In the latest instalment of his series counting down the "Top 12" of Excel function combinations, Liam Bastick considers MAP LAMBDA.
Exclusive
EXCEL TIP OF THE WEEK
Excel Tips & Tricks #492 - How to add a custom ribbon to your workbook
- 12 Jul 2024
- Ruth Butler-Lee
Hello and welcome back to Excel Tips and Tricks! This week, we have a Developer level post exploring how to get started with creating a basic custom ribbon in your workbook using VBA.
YOUR QUESTIONS ANSWERED
Your Questions Answered #11 – Tips and Tricks Live extended
- 11 Jul 2024
- David Benaim
In last month’s ‘Excel Tips and Tricks live – your questions answered’ webinar, David Benaim and Ian Pay tackled Excel questions and queries covering best practices when using Power Query, the use of formulas such as XLOOKUP, and a range of techniques for data handling and analysis in Excel. In this article, David returns to answer some of the unanswered questions from the webinar.
Exclusive
Article archive portal – new resource report page
- 10 Jul 2024
- Simon Hurst
A new report page available in the article archive portal helps users of the new on-demand Excel course series to discover additional content on relevant topics.
Exclusive
The truth about the FILTER function
- 05 Jul 2024
- Mark Proctor
In this article, Mark Proctor takes us deep into the world of TRUE and FALSE to demonstrate creative ways of using the FILTER function.
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, 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.
EXCEL COMMUNITY ROUND UP
Excel Community round up – June 2024
- 01 Jul 2024
- Excel Community
Here are all the new Excel blogs and webinars from the Excel Community in June 2024.
Exclusive
Simple but effective, 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
Top 12 Excel Combinations: 7. OFFSET MATCH
- 24 Jun 2024
- Liam Bastick
In the latest instalment of his series counting down the "Top 12" of Excel function combinations, Liam Bastick considers OFFSET MATCH.
Exclusive
General Election 2024
- 24 Jun 2024
- Simon Hurst
General Election 2024 – why the numbers are wrong
NEW TECH FEATURES
Excel, Teams, Power BI, Canva, Zoom, Google Sheets++: New tech features for Mar-May 2024
- 14 Jun 2024
- 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.
The easy way to implement Excel principles
- 13 Jun 2024
- PerfectXL
What unites accountants? Excel, of course! I’m sure you'll agree that Excel's integral role in accountancy demands that spreadsheets meet certain standards, but that is easier said than done. In this article, PerfectXL explore what exactly you should be mindful of when working in Excel.
Exclusive
Article archive access
- 06 Jun 2024
- Simon Hurst
Article archive access – have we already solved your Excel issue?
EXCEL COMMUNITY ROUND UP
Excel Community round up - May 2024
- 03 Jun 2024
- Excel Community
Here are all the new Excel blogs from the Excel Community in May 2024.
Exclusive
EXCEL TIP OF THE WEEK
Excel Tips & Tricks #491 – Creating a dynamic lead schedule
- 29 May 2024
- James Berridge
Hello and welcome back to Excel Tips and Tricks! This week, we have a Creator level post exploring how to use VSTACK, CHOOSECOLS and FILTER to create a dynamic lead schedule and dynamic dropdown options.
Exclusive
Simple but effective, part 4
- 28 May 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. This time we focus on the use of Data Validation and Dynamic Arrays to automate the creation of summary reports.
Exclusive
Avoid Column Name errors in Power Query
- 24 May 2024
- Mark Proctor
Changing column names are a frequent cause of Power Query errors. This article explores a few techniques to avoid those errors and ensure Power Query refresh runs smoothly.
Exclusive
Top 12 Excel Combinations: 8. INDEX SEQUENCE
- 22 May 2024
- Liam Bastick
In the latest instalment of his series counting down the "Top 12" of Excel function combinations, Liam Bastick considers INDEX SEQUENCE
Displaying 1-20 of 1264 results
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.