Exclusive
Excel Tip of the Week #429 - Revisiting cross-sheet formulas
- Article
- 18 Jan 2022
Hello all and welcome back to the Excel Tip of the Week! This week we have a General User post in which we’re taking a fresh look at how to write and work with formulas that reference cells on other worksheets. This was first discussed in TOTW #275.
The 2021 Excel Community pantomime – the answers part 2
- Article
- 17 Jan 2022
We have split the answers to the 2021 Christmas pantomime function name hunt across two articles to make the list of functions more manageable and to extend the suspense.
The 2021 Excel Community pantomime – the answers, part 1
- Article
- 13 Jan 2022
Answers to the first half of the 2021 Christmas pantomime function name hunt. We have included a list of the functions with brief descriptions of their purpose and, where applicable, links to Excel Community articles that cover the use of the function.
Exclusive
Excel Tip of the Week #428 - Converting between statistical measures
- Article
- 11 Jan 2022
Hello all and welcome back to the Excel Tip of the Week! This week we have a General User post in which we’re going to dive into some statistics, and in particular examine how to convert between various different common statistical measures.
Excel Community round-up December 2021
- Article
- 06 Jan 2022
Here are all the new Excel articles and webinars from the Excel Community in December 2021. Posts marked as public can be accessed by anyone; other articles are accessible to Excel Community subscribers and can be accessed by logging in to your ICAEW account.
Excel Tip of the Week #425 - Revisiting unpivoting
- No content type
- 21 Dec 2021
Hello all and welcome back to the Excel Tip of the Week! A very merry Christmas from all of us here at ICAEW to you and yours. This week we have a Creator post in which we’re going to look at how at some uses of the very handy “unpivot” data operation in Power Query. This is building on our first look at the tool in TOTW #318.
Excel Tip of the Week #424 - Filters redux
- Article
- 14 Dec 2021
Hello all and welcome back to the Excel Tip of the Week! This week, we have a Basic User post in which we are refreshing our coverage of the quintessential data navigation feature, the filter.
The 2021 Excel Community pantomime - Min and Max return!
- Article
- 13 Dec 2021
Some years ago, the Excel Community Christmas Special posts featured Min and Max as the heroes of our Christmas pantomime. It seems that now might be the time for another pantomime to take our mind off other things. As a precursor to our imminent competency framework self-assessment test, we will use the pantomime for you to assess your Excel expertise, based on the number of function names you spot.
Exclusive
Excel Tip of the Week #429 - Revisiting cross-sheet formulas
- Article
- 18 Jan 2022
Hello all and welcome back to the Excel Tip of the Week! This week we have a General User post in which we’re taking a fresh look at how to write and work with formulas that reference cells on other worksheets. This was first discussed in TOTW #275.
The 2021 Excel Community pantomime – the answers part 2
- Article
- 17 Jan 2022
We have split the answers to the 2021 Christmas pantomime function name hunt across two articles to make the list of functions more manageable and to extend the suspense.
The 2021 Excel Community pantomime – the answers, part 1
- Article
- 13 Jan 2022
Answers to the first half of the 2021 Christmas pantomime function name hunt. We have included a list of the functions with brief descriptions of their purpose and, where applicable, links to Excel Community articles that cover the use of the function.
Exclusive
Excel Tip of the Week #428 - Converting between statistical measures
- Article
- 11 Jan 2022
Hello all and welcome back to the Excel Tip of the Week! This week we have a General User post in which we’re going to dive into some statistics, and in particular examine how to convert between various different common statistical measures.
Excel Community round-up December 2021
- Article
- 06 Jan 2022
Here are all the new Excel articles and webinars from the Excel Community in December 2021. Posts marked as public can be accessed by anyone; other articles are accessible to Excel Community subscribers and can be accessed by logging in to your ICAEW account.
Excel Tip of the Week #427 - Power Query: Word frequency analysis
- Article
- 04 Jan 2022
Hello all and welcome back to the Excel Tip of the Week! This week, we have a Creator level post in which we are reviewing where you can add passwords to Excel – and which are strong and which are weak. This was last discussed in TOTW #216.
Excel Tip of the Week #426 - Passwords redux
- Article
- 28 Dec 2021
Hello all and welcome back to the Excel Tip of the Week! This week, we have a Creator level post in which we are reviewing where you can add passwords to Excel – and which are strong and which are weak. This was last discussed in TOTW #216.
Excel Tip of the Week #425 - Revisiting unpivoting
- No content type
- 21 Dec 2021
Hello all and welcome back to the Excel Tip of the Week! A very merry Christmas from all of us here at ICAEW to you and yours. This week we have a Creator post in which we’re going to look at how at some uses of the very handy “unpivot” data operation in Power Query. This is building on our first look at the tool in TOTW #318.
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 open to everyone - non ICAEW members are also welcome to join. You also have the option to Join the Tech Faculty, where Excel Community membership is included.
