Spreadsheets Archives - Page 2 of 11 - CFO

Tax Compliance Toughens for Intercompany Transactions

Tax Compliance Toughens for Intercompany Transactions

Many U.S. companies are still making the internal process changes needed to comply with the OECD's base erosion and profit shifting project.

By Therese Tucker | May 23, 2017

Presidential Campaign Spotlights Net Operating Losses

Presidential Campaign Spotlights Net Operating Losses

While federal NOL rules are fairly straightforward, state rules are complex. And there are different ones for each state.

By Ken Crutchfield | October 17, 2016

Robots, Robots Everywhere

Robots, Robots Everywhere

Rather suddenly, virtual robots are bringing big change to corporate finance processes.

By David McCann | September 15, 2016

Metric of the Month: Audit Control Violations

Metric of the Month: Audit Control Violations

It’s safe to say that more automation means fewer control violations involving audits.

By Mary C. Driscoll | April 19, 2016

Augmenting Reality

Augmenting Reality

There’s a lot of corporate productivity and convenience improvement potential in 'augmented reality' applications.

By John Parkinson | February 9, 2016

Accelerating IT Planning for Revenue Recognition Changes

Accelerating IT Planning for Revenue Recognition Changes

The myriad of industry-specific guidance made the full automation of revenue accounting too unique and complex a problem for ERP vendors to solve.

By Jeff Johnson and John McGaw | February 8, 2016

Excel Tip: Illustrate the Flow

Excel Tip: Illustrate the Flow

Draw an arrow to visually illustrate that two cells are connected.

By Bill Jelen | October 21, 2015

Excel Tip: Fast Stepping

Excel Tip: Fast Stepping

How to do horizontal subtotals.

By Bill Jelen | August 25, 2015

Excel Tip: How Does It Look?

Excel Tip: How Does It Look?

Make spreadsheets look better with cell styles.

By Bill Jelen | August 3, 2015

Mastering Predictive Analytics

Mastering Predictive Analytics

Analyzing data may be second nature to finance chiefs, but can they get their C-suite colleagues to buy in?

By Vincent Ryan | July 30, 2015

Excel Tip: Bars, Scales, and Sets

Excel Tip: Bars, Scales, and Sets

Convert a table of numbers to a visualization.

By Bill Jelen | July 27, 2015

Excel Tip: Time Formats

Excel Tip: Time Formats

Convert text dates to real dates.

By Bill Jelen | June 18, 2015

Excel Tip: Double Trouble

Excel Tip: Double Trouble

Removing duplicate datasets.

By Bill Jelen | June 4, 2015

Excel Tip: ‘Find and Replace’ Problems

Excel Tip: ‘Find and Replace’ Problems

Why can't Excel find a number?

By Bill Jelen | May 28, 2015

Excel Tip: Texting, Kind Of

Excel Tip: Texting, Kind Of

Two tricks for dealing with blocks of text in an Excel spreadsheet.

By Bill Jelen | May 27, 2015