July 2, 2018
Categorized in: Excel
There are many tools to help you squeeze information out of your data, but it needs to be in the right shape.
May 7, 2018
Categorized in: Excel
In the newest version of Excel, you may have noticed the “data model.” This allows you to connect multiple datasets and analyze them as one.
May 1, 2016
Categorized in: Excel
Keeping minutes; find/replace; formatting
December 6, 2015
Categorized in: Excel
The Conditional Formatting tool on the Home tab, Cell Styles group offers something called Highlight Duplicate Values. Before you start jumping for joy, it really means values, not rows.
September 2, 2015
Categorized in: Excel
Q. Is there an easier way to create a formula across work sheets than clicking on each cell you want to add to the formula?
There are some pretty geeky ways to create forms in Microsoft Office. Start with these less geeky solutions first.
March 4, 2015
Categorized in: Excel
Q. I can’t get FlashFill to work in Excel 2013. What am I doing wrong?
February 2, 2015
Categorized in: Excel
Recover your outline levels in subtotal mode … Hide a row quickly … Create a table from anywhere inside a well-built list.
The Office app remains a relatively new option for iPad users, but one that can really help you boost productivity when you can’t use your laptop or desktop computer.
December 3, 2014
Categorized in: Excel
Microsoft Office Certified Trainer answers two questions about pound signs and circular cell references.