Creating maps in Excel

September 4, 2018 Categorized in: Excel

Did you know that you can create maps from geographically recognizable data in Excel using standard country/region, state/province, county or postal code?

Excel: Shape up your data

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.

Connecting datasets in Excel

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.

Microsoft Office Notes: May ’16

May 1, 2016 Categorized in: Excel

Keeping minutes; find/replace; formatting

Excel: Spot duplicate rows

December 6, 2015 Categorized in: Excel

The Conditional Formatting tool on the Home tab, Cell Styles group offers something called Highlight Dupli­­cate Values. Before you start jumping for joy, it really means values, not rows.

The magic of Excel 3-D references

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?
Q. I can’t get FlashFill to work in Excel 2013. What am I doing wrong?

Keyboard shortcuts: Excel

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.

Make the most of MS Office on your iPad

January 28, 2015 Categorized in: ExcelOrganizingWord

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.

Excel Quandaries

December 3, 2014 Categorized in: Excel

Microsoft Office Certified Trainer answers two questions about pound signs and circular cell references.

Creating better Excel spreadsheets

August 15, 2014 Categorized in: Excel

Improve your Microsoft Excel skills and build better spreadsheets with these tips from OfficeTeam.

Working with Pivot Tables

March 25, 2014 Categorized in: Excel

Q. How can I avoid changing the data source each time my source data grows?

It’s all about Excel

November 7, 2013 Categorized in: Excel

How is the new Excel Sumlfs different from SumIf, and how do you dissect a formula to troubleshoot?