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.
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.
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.
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.
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.
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.
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.
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.
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.