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.
Excel expert Neale Blackwood CPA began writing his monthly Excel Yourself column in INTHEBLACK magazine in 2002. He recently “opened the vault” on those early articles to review the information and add newer and easier solutions or built-in functions. This month: learn about Data Validation, Paste Link and zero values.
Dynamic arrays make array functionality easy to access for all users.
Using Excel's index-match combination is the easiest way to include a flexible range in conditional calculation functions.
Excel expert Neale Blackwood CPA is fast approaching his 200th INTHEBLACK article since he began writing his monthly Excel Yourself column in INTHEBLACK magazine in 2002. He recently “opened the vault” on those early articles to review the information and add newer and easier solutions or built-in functions. See what’s new.
Here are some ways to use the function to deal with frequently occuring budget issues.
Excel expert Neale Blackwood CPA began writing his monthly Excel Yourself column in INTHEBLACK magazine in 2002. He recently “opened the vault” on those early articles to review the information and add newer and easier solutions or built-in functions. This month: Contents sheets, General Purpose Macros and more.
Sparkline charts are a data visualisation aid that work well on a dashboard.
Excel expert Neale Blackwood CPA began writing his monthly Excel Yourself column in INTHEBLACK magazine in 2002. He recently “opened the vault” on those early articles to review the information and add newer and easier solutions or built-in functions. This month: listing all range names in a workbook, Formula Auditing, Flash Fill and more.
Excel expert Neale Blackwood CPA began writing his monthly Excel Yourself column in INTHEBLACK magazine in 2002. He recently “opened the vault” on those early articles to review the information and add newer and easier solutions or built-in functions. This month: Page Layout, SUM hours and more.
Power Query is a flexible tool for creating date tables for any financial year.
Excel expert Neale Blackwood CPA revisits some of his earlier Excel how-tos. Updated this month: inserting a new line within a cell, 3D Sum, dynamic ranges and sheet navigation icons.
The SUMIFS function allows you to perform multi-criteria summing typically on vertical data, but it also works on horizontal data. Here's how.
Excel expert Neale Blackwood CPA began writing his monthly column in INTHEBLACK magazine in 2002. He recently “opened the vault” on those early articles to review the information and add newer and easier solutions or built-in functions.