Get the most out of Excel with these how-to articles, videos and sample spreadsheets
The IFERROR macro is a useful function for handling different types of errors in Excel.
Here is how the LET function offers useful solutions to tricky Excel challenges.
Hyperlinked index sheets are useful tools for speeding up and simplifying navigation around large Excel files.
Importing multiple Excel files is a straightforward process, provided the file structures and naming conventions are consistent.
Here's what you need to know about making conditional formats work for you in dashboards and reporting.
Once you have your figures right, the next step is presenting them. Here are a few ideas to help you improve your formatting and make your files easier to read, understand and use.
Dependent drop-down lists offer straightforward and scalable solutions to several Excel challenges.
Excel has evolved considerably over the past decade, and each version contains different solutions to a range of problems.
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.