Excel

Technology

Keyboard Shortcuts for Saving & Emailing Spreadsheets as PDF

Many users go through several mouse clicks instead of choosing PDF as the file type in the Save As dialog box. However, this technique can be streamlined even further with a single mouse-click.
Technology

When Excel Dates Mysteriously Shift by 4 Years

Sometimes the most mundane tasks, such as copying and pasting a series of dates from one workbook to another, can send you down a mysterious rabbit hole where things become frustrating.

High Impact Excel: Shortcuts Edition

Do you work Excel? Or does it work you? In this presentation Excel expert David Ringstrom, CPA focuses exclusively on how to perform repetitive tasks more efficiently in Excel. Hidden techniques abound in Excel, as a simple double-click or right-click with your mouse can uncover hidden functionality.

High Impact Excel: Error Prompt Edition

In this session Excel expert David Ringstrom, CPA tackles what to do when bad things happen to good spreadsheets. Users often get stopped in their tracks by disabled features, inscrutable error prompts, or just quirky behavior in Excel.
Technology

High Impact Excel: Linked Workbooks Edition

Many Excel users have a love-hate relationship with workbook links. For the uninitiated, workbook links allow you to connect one Microsoft Excel spreadsheet to other spreadsheets, Word documents, databases, and even web pages.
Technology

High Impact Excel: Dashboard Edition

In this jam-packed presentation Excel expert David Ringstrom, CPA will give you a crash-course in creating spreadsheet-based dashboards. A dashboard condenses large amounts of data into a compact space, yet enables the end user to easily drill down into details when warranted.
Technology

Exploring the Nuances of Excel's SUM Function

The SUM function may be the most used—and abused—of all worksheet functions. Although it's far better than manually adding cells together, there are some importance nuances.
Technology

Maximizing Excel's Alt-Down Arrow Keyboard Shortcut

Alt-Down Arrow is one of the most versatile Excel keyboard shortcuts, giving users an easy means to speed through repetitive data entry, and more. Learn its three main uses.
Technology

High Impact Excel: Data Validation Edition

Excel spreadsheets are often akin to the American Wild West, where users can input anything they want into any worksheet cell. Excel's Data Validation feature allows you to restrict user inputs to selected choices, but there are many nuances to the feature that often trip users up.
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!

Pages


Already a member? log in here.