Get the most out of Excel with these how-to articles, videos and sample spreadsheets
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.
Challenge yourself to learn something new in Excel.
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.