Displaying 1-20 of 1232 results
Exclusive
Simple but effective, 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.
Exclusive
Including calculations in Microsoft Word
- 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
- 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
YOUR QUESTIONS ANSWERED
Your Questions Answered #10 – Tips and Tricks Live extended
- 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
Spreadsheet review – can Power Query help? Part 4
- 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
EXCEL TIP OF THE WEEK
Excel Tips & Tricks #488 – The basics of charts in Excel
- 11 Mar 2024
- Thomas Edmunds
Hello and welcome back to Excel Tips and Tricks! This week, we have a Creator level post exploring the basics of the different chart types in Excel.
NEW TECH FEATURES
Excel, Teams, Power BI, Canva, Zoom, Google Sheets++: New tech features for Nov-Feb 2024
- 08 Mar 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.
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 3
- 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
Top 12 Excel Combinations: 11. IF ISERROR (Error Trapping)
- 19 Feb 2024
- Liam Bastick
It’s a new year and I thought I would use 2024 as an opportunity to count down a very subjective “Top 12” of Excel function combinations. You can tell I have thought of at least two for this theme.
Exclusive
Spreadsheet review – can Power Query help? Part 2
- 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
Microsoft Loop: Edit things from multiple entry points
- 14 Feb 2024
- David Benaim
Collaborating between apps has always been one of the weakest points of Microsoft Office. Loop Components allows users to edit a bullet list whilst in an Outlook email, whilst others edit in Teams’ meeting notes and it will update simultaneously in all places.
Exclusive
Office Scripts vs VBA: What’s the difference?
- 13 Feb 2024
- Mark Proctor
Office Scripts are a new scripting language for automating Excel. In this article, Mark Proctor explores how Office Scripts differ to VBA and what we can or cannot do with each.
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
EXCEL TIP OF THE WEEK
Excel Tips & Tricks #487 – An Introduction to Slicers
- 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.
EXCEL COMMUNITY ROUND UP
Excel Community round up - January 2024
- 01 Feb 2024
- Tracy Gray
Here are all the new Excel blogs and webinars from the Excel Community in January 2024.
Exclusive
Top 12 Excel Combinations: 12. IF IF (Nested IFs)
- 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
Don’t be a check box Charlie
- 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
Get your errors right
- 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
- 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.
Displaying 1-20 of 1232 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.