Microsoft Excel tips and tricks for accountants

Mike Decker, the vice president of examinations at the AICPA, discusses changes being made to the exam as a result of tax reform — and about how Excel will now be available for use on the test.

June 1, 2018

Microsoft Office: Use Excel’s I-Beam tool to swap data in 2 cells

You can swap the contents of two cells in Excel if the cells are adjacent to each other. Here’s how.

May 1, 2018

Convert your Excel PivotTable to a formula-based report

How to use Excel’s new Cube-based functions and conversion tools to convert a PivotTable to a formula-based report.

March 1, 2018

Microsoft Office: 9 PivotTable enhancements in Excel 2016

Microsoft has made several improvements to Excel 2016’s PivotTables.

March 1, 2018

Microsoft Office: Excel’s versatile CONVERT function

How to use Excel’s CONVERT function to convert a multitude of units of measurements.

March 1, 2018

Factoring in the time value of money with Excel

This Technology Workshop illustrates how to leverage a number of functions to perform calculations in Excel involving the time value of money.

January 1, 2018

Microsoft Excel: Count the words in a cell

Use this formula to count the number of words in a Microsoft Excel cell.

December 1, 2017

How to boost Excel efficiency with Power Query

This article shows how Microsoft Power Query for Excel can streamline the ongoing delivery of additional data for analysis by PivotTables.

FROM THIS MONTH'S ISSUE

Flip out with the latest Tech Q&A

The September Technology Q&A column shows how to create dynamic to-do lists with Excel's checkboxes and also how to set up multifactor authentication texts that don't rely on phones. Flip through both items and view a video walkthrough in our digital format.