Get the most out of Excel with these how-to articles, videos and sample spreadsheets
Excel's new LET function is a useful tool in speeding up calculation time in large files.
Knowing what a cell contains can be useful when developing your formulas. Excel has a collection of IS functions that can help.
There are several ways to create dynamic charts in Excel. Here's what you need to know.
Slicers are an easy-to-use filter interface for pivot tables. Most people don't realise that you can also use slicers on formatted tables.
Excel is not a database, but with recent changes, it can pretend to be a basic one. For small data sets, the solution detailed below can work well.
User defined functions in Excel are a helpful way of creating your own spreadsheet functions.
Text boxes are an old Excel feature that can provide flexibility to all types of Excel files. You can apply multiple formats to the text within a text box. You can also link a text box to a cell on the sheet to provide dynamically changing text.
The VLOOKUP function is heading for early retirement after decades of service. See how its replacement offers more options and flexibility.
The last two editions of Excel Yourself covered how dynamic arrays work and two new functions. This month, we will look at the remaining four new functions associated with dynamic arrays.
The last Excel yourself column explained the basics of how dynamic arrays work. This month, we focus on two new functions associated with dynamic arrays.