How to use Excel’s Camera tool to achieve the effect of multiple chart types.
Microsoft Excel
Microsoft Excel: How to use Scenario Manager
How to use Microsoft Excel’s built-in Scenario Manager tool.
Tips and ideas for teaching Excel
Excel skills are an essential part of the accounting curriculum, but they’re not always the easiest topic to teach.
Microsoft Excel: How to insert an image into a cell
How to insert an image into an Excel cell.
Microsoft Excel: Including an ‘&’ in headers and footers
In Excel’s custom headers and footers box, the ampersand character (&) is used as a marker to indicate that a special formatting code follows.
Microsoft Excel: Pick a new color for your gridlines
How to change the color of the default gridlines in Excel.
Microsoft Excel: Create a picture-based dashboard report
There are many ways to create a dashboard in Excel, but my preferred method may surprise you.
Microsoft Office: Rounding time in Excel
How to round time calculations to the nearest 10th of an hour, or six-minute increments.
How tax reform — and Excel — are changing the CPA Exam
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.
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.
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.
Microsoft Office: 9 PivotTable enhancements in Excel 2016
Microsoft has made several improvements to Excel 2016’s PivotTables.
Microsoft Office: Excel’s versatile CONVERT function
How to use Excel’s CONVERT function to convert a multitude of units of measurements.
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.
Microsoft Excel: Count the words in a cell
Use this formula to count the number of words in a Microsoft Excel cell.
Features
SPONSORED REPORT
Get your clients ready for tax season
Help clients avoid surprises with year-end planning strategies for managing taxable income, maximizing deductions, and adjusting to OBBBA changes affecting individuals and businesses.
