Excel Tip of the Week #413 - Flattening and unfolding data
Hello all and welcome back to the Excel Tip of the Week! This week, we have a Creator level post in which we’re looking at how to take a column of data and unfold it into a table – or to do the reverse and flatten a table into a single column. These are some common data transformation tasks but there’s no single feature or function for doing them (with one notable exception) – but both are possible with some careful work.
Excel Tip of the Week #412
This week, we’re looking at how to best manage workbooks with a large number of worksheets in them. These kinds of workbooks are particularly common in some areas of accounting and modelling, and can make life pretty tricky.
Depending on Data Validation Lists
Liam Bastick explores data validation: one of the simplest and most intuitive ways to control what end users input into an Excel spreadsheet.
Excel Tip of the Week #411
Hello all and welcome back to the Excel Tip of the Week! This week we have a General User level post in which we are taking a fresh look at the handy Flash fill data reformatting tool.
Excel Escaping from cells
Principle 5 of the ICAEW 20 Principles for Good Spreadsheet Practice states that you should: "Before starting, satisfy yourself that a spreadsheet is the appropriate tool for the job". One of the most common transgressions of this principle is the use of a spreadsheet to input and manage data that would be better stored in a database application.
Our quarterly digest of new features across Microsoft 365 & other business tech products in written, images & video format.
Hello all and welcome back to the Excel Tip of the Week! This week, we have a Developer level post in which we are making a definitive review of how to install VBA macros and user-defined functions in your Excel – even if you don’t know any VBA yourself.
Here are all the new Excel articles and webinars from the Excel Community in August 2021. Posts marked as public can be accessed by anyone; other articles are accessible to Excel Community & Tech Faculty subscribers and can be accessed by logging in to your ICAEW account.
Excel Tip of the Week #409 - Controls redux
Hello all and welcome back to the Excel Tip of the Week! This week, we have a Developer post in which we’re making a comprehensive review of the various controls which you can use to drive your Excel spreadsheets – from Form controls to ActiveX controls, and a few other pieces besides.
The Tech Faculty is changing. 2021 is the last year that we will be collecting subs and providing an additional, paid-for service for members. From 2022 onwards, all tech content will become available to all ICAEW members.