Exclusive
Excel Tips and Tricks #480 – Refreshing securing workbooks
- Article
- 11 Oct 2023
Hello and welcome back to Excel Tips and Tricks! This week we have a Creator level post where we revisit various ways of securing Excel workbooks containing sensitive and confidential data.
Exclusive
Power Query – matching lists part 1
- Article
- 17 Aug 2023
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
Excel fundamentals training – what should be included?
- Article
- 04 May 2023
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?
Exclusive
LOOKUP
- Article
- 04 May 2023
Regular readers will recall I took VLOOKUP and HLOOKUP to task recently, before moving on to the INDEX MATCH combination and then XLOOKUP. You don’t always need the latest and greatest though: LOOKUP may seem a less versatile function upon first glance, but it is quite useful for modelling. It’s an “oldie but goodie”.
Exclusive
Excel Tips & Tricks #470 – Introducing Office Scripts in Excel
- Article
- 28 Apr 2023
Hello and welcome back to Excel Tips and Tricks! This week we have a Developer level post where provide a high-level overview of Office Scripts in Excel, a potential replacement for VBA to help automate tasks.
Exclusive
Excel Tips & Tricks #469 – Exploring the ‘Info’ view in Excel
- Article
- 04 Apr 2023
Hello and welcome back to Excel Tips and Tricks! This week we have a General User post where we explore document properties and version history in the ‘Info’ view in Excel to help manage spreadsheets, and show why it’s really important to use it correctly.
Exclusive
Excel Tips & Tricks #468 – Refreshing dealing with Objects
- Article
- 16 Mar 2023
Hello and welcome back to Excel Tips and Tricks! This week we have a General User post where we take a look at how to insert and deal with objects including images, charts, or files in Excel.
Exclusive
Excel Tips & Tricks #467 - Excel functions that do not return arrays or ranges
- Article
- 23 Feb 2023
Hello and welcome back to Excel Tips and Tricks! This week have a Creator level post where we take a look at Excel functions that are harder to use with arrays or ranges.
The Excel community has produced an extensive list of helpful tips and tutorials including its 'Excel tip of the week' series.
Exclusive
Excel Tips & Tricks #491 – Creating a dynamic lead schedule
- Article
- 29 May 2024
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
Excel Tips & Tricks #490 – Revisiting data entry shortcuts
- Article
- 21 May 2024
Hello and welcome back to Excel Tips and Tricks! This week, we have a Basic User level post revisiting simple keyboard shortcuts that helps expedite entry of data into Excel.
Exclusive
Excel Tips & Tricks #489 – The basics of charts in Excel part 2: Combo charts
- Article
- 08 Apr 2024
Hello and welcome back to Excel Tips and Tricks! This week, we have a Creator level post exploring the concept of a combo chart in Excel that can be used for two or more series of data.
Exclusive
Excel Tips & Tricks #488 – The basics of charts in Excel
- Article
- 11 Mar 2024
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.
Exclusive
Excel Tips & Tricks #487 – An Introduction to Slicers
- Article
- 09 Feb 2024
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
Excel Tips & Tricks #486 – Revisiting inserting hyperlinks
- Article
- 12 Jan 2024
Hello and welcome back to Excel Tips and Tricks! This week, we have a Basic User level post in which we take look another look at how to create hyperlinks in your file, to aid quick navigation. We will also cover the differences between hyperlinks in Excel Online and the desktop versions.
Exclusive
Excel Tips & Tricks #485 – Refreshing NETWORKDAYS and WORKDAY functions
- Article
- 12 Dec 2023
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.
Excel Tips & Tricks #484 – Best of 2023
- Article
- 24 Nov 2023
As we approach the end of the year, we pause to reflect on the best content from the Excel Community this year and look ahead as the community grows.
Join the Excel Community
Do you use Excel in your organisation? Are you using it to its maximum potential? Develop your skills and minimise spreadsheet risk with our Excel resources. Membership is free to ICAEW members. Non-ICAEW members are also welcome to join.