Excel

Education & Careers

High Impact Excel: Table Edition Redux

In this presentation Excel expert David Ringstrom, CPA revisits the Excel feature you should be using, but probably aren't. The Table feature offers the ability to both boost the integrity of your spreadsheets, but reduce maintenance as well.
Technology

Embed Frequently Used Lists into Excel

You can create a list of days of the week or months of the year in Excel—but there's more. This is part of the Custom Lists feature, and you can use it to add your own lists. It's easier than you probably thought.
Technology

High Impact Excel: Basics Edition

In this session Excel expert David Ringstrom helps beginners get up to speed in Microsoft Excel. However, even experienced Excel users will learn some new tricks, particularly when David discusses under-utilized aspects of Excel.
Technology

Excel Puzzler: MAXIF Without Using an Array Function

Special AccountingWEB Article: A recent piece addressed the lack of MAXIF in Excel. A clever reader uncovered an alternative buried deep in Excel. Can you uncover it too? Test your Excel skills!
Technology

Creating Excel's Equivalent of MAXIF

Excel doesn't have a MAXIF function, but you can easily adapt the MAX function. Learn how to write a special type of formula known as an array formula that will do the trick instead. Just take it step by step.
Technology

Streamlining Excel’s Paste Special Values Feature

Yes, you can create a macro to automate Excel's paste special values feature, but there are easier ways of streamlining the process—just look in the right place.
Practice

First Impressions of Excel for iPad

Four years after the first iPad spreadsheet, users finally have a Microsoft-sanctioned solution. I immediately saw its limitations, but Excel for iPad has certain strengths too.

High Impact Excel: iPad Edition

In this presentation Excel expert David Ringstrom, CPA covers Excel for iPad from top to bottom. In one hour you'll learn everything you can—and cannot—do in Excel for iPad. You'll be able to determine whether Excel for iPad is worth $99/year to you or not.
Technology

High Impact Excel: Table Edition

In this presentation Excel expert David Ringstrom, CPA brings you up to speed on the Excel feature you should be using, but probably aren't. The Table feature offers the ability to both boost the integrity of your spreadsheets, but reduce maintenance as well. Uncover power of this feature, but also get the low-down on the conflicts it can pose with other aspects of Excel.
Education & Careers

High Impact Excel: Macro Edition

In this session Excel expert David Ringstrom, CPA introduces you to a powerful but underutilized macro feature in Excel.
Education & Careers

High Impact Excel: Pivot Tables Redux

In this exciting presentation Excel expert David H. Ringstrom, CPA shares tricks that you can use with pivot tables every day. Remember, either you work Excel, or it works you!
Practice Management

How to Get Excel to Handle Social Security Numbers Properly

Almost every accountant handles Social Security numbers and almost every Excel spreadsheet screws them up. Here's how to fix them.
Technology

Excel: The Indispensable NCAA Bracket Tool

Sports enthusiasts should know that Excel isn't just for accountants: it's for anyone running a Final Four betting pool.
Technology

How to Improve Spreadsheet Integrity with VLOOKUP

Building complex spreadsheets without lookup formulas, such as VLOOKUP, is akin to putting a screw in the wall with a hammer. It’s possible, but the results aren’t pretty, and most probably won’t maintain integrity.
Technology

Spreadsheet-Based Form 1040 Available at No Cost for 2013 Tax Year

Although the IRS is still madly preparing for the 2013 filing season, one man remains ahead of the curve. Glenn Reeves has released his seventeenth spreadsheet-based version of the US Individual Income Tax Return, commonly known as Form 1040, which taxpayers can download and use for free.
Technology

Resolve to Learn and Use 14 Excel Keyboard Shortcuts in 2014

It’s a new year, which brings the promise of fresh starts, and resolutions to work smarter. Keyboard shortcuts are one of the best ways to both save time and reduce wear and tear on your wrists when working in Microsoft Excel.
Technology

AccountingWEB's Top Five Excel Tips From 2013

What do accountants count on most to do their jobs well? Yes, coffee is a good answer. No, I'm not thinking of booze. If you eliminate any and all kinds of medicating, the smart money is on Microsoft Excel.
Technology

The Curious Case of Strikethrough in Word and Excel

Excel expert David Ringstrom, CPA, describes a couple of ways that you can streamline access to the strikethrough feature – and pretty much any feature – in both Word and Excel.
Technology

Conditionally Displaying Decimal Places in Excel: Part 2

Excel expert David Ringstrom, CPA, describes how to use Excel's Conditional Formatting feature to handle just about every imaginable situation.
Technology

Conditionally Displaying Decimal Places in Excel: Part 1

In Part 1 of his two-part series, Excel expert David Ringstrom describes how to add decimal places on demand by way of using a custom number format.

Pages