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.
When you record a macro in Excel, you create a repeatable set of commands in a language called Visual Basic for Applications (VBA). Here's how to add basic interaction to a recorded macro by using message boxes.
Neale Blackwood CPA began writing his monthly Excel Yourself column in 2002, before the articles and their popular accompanying videos were available online.
Conditional formatting in Excel enables you to apply a format to a cell or range of cells, so you can identify important information. The video tutorial below explains.
Excel expert Neale Blackwood began writing his monthly column in INTHEBLACK magazine in 2002, and recently “opened the vault” on those early articles to review the information and add newer and easier solutions or built-in functions.