Using formulas turns Excel into the world's most powerful calculator. Whether you need to calculate loan repayments, generate a profit and loss account, solve maths or engineering problems, in fact, think of any scenario that involves addition, subtraction, division or multiplication of numbers and you'll find that Excel is the best tool for the job.
Excel expert David Ringstrom, CPA, shows you how to implement internal control features within your Excel spreadsheets in this enlightening presentation. David uses a simple invoice form as a teaching aid to present various ways to control users' actions within Excel spreadsheets and to protect worksheets and workbooks from unauthorized changes. David demonstrates every technique at least twice first, on a PowerPoint slide with numbered steps, and second, in Excel 2016. He'll draw to your attention any differences in Excel 2013, 2010, or 2007 during the presentation as well as in his detailed handouts. David also provides an Excel workbook that includes most of the examples he uses during the webcast.
If you're like millions of other business professionals, you probably use Microsoft Outlook every day to manage your email, calendar and to do's. It's available for Windows, Mac, mobile and there's even a web version. So there's no excuse not to be organised. Or so the theory goes. The reality is email overload, missed deadlines and calendars so full you have no room to breathe
Excel expert David Ringstrom, CPA, will share helpful tweaks you can use with the revered VLOOKUP function in this valuable webcast. VLOOKUP is the lookup function many users rely on to return data from other locations in a worksheet. However, using VLOOKUP isn't always the most efficient approach, so David will explain alternatives, including the INDEX and MATCH, SUMIF, SUMIFS, SUMPRODUCT, IFNA, and OFFSET functions.
Microsoft Excel has a tremendous amount of capability and features and is filled with shortcuts and methods not always visible to the casual user. Whether it's a keystroke shortcut or a hidden command sequence, such shortcuts can make you much more proficient and productive as you use this powerful and popular software.
OneNote is a digital notebook. It is available for Windows, Mac and mobile. Use it to capture, store and organise your ideas and information. OneNote notes can store text, images, videos, embedded files and even drawings and sketches. OneNote notebooks can be shared with colleagues and customers, in fact anyone, making it the perfect platform for collaborative work. Use OneNote to manage your projects. Use OneNote to manage your meetings. Use OneNote to manage your life.
Excel expert David H. Ringstrom, CPA, draws your attention to the What-If Analysis tools available within Excel's Data menu in this informative presentation. David teaches you how and when to make use of Excel's Scenario Manager as well as how to use the Data Table feature to compare calculation results based on two or three inputs. He also explains how Excel's Goal Seek feature empowers you to perform basic what-if analyses, in effect, solving for a single value.
VBA is the programming language that is built in to Excel (and the other applications in the MS Office Suite).VBA is used to automate tasks that would otherwise have to be performed manually by pressing keys and selecting items with the mouse-and if that sounds like a macro-well it is.
Learn from Excel expert David H. Ringstrom, CPA, how to create resilient and practical budget spreadsheets in this informative webcast. David shares a wide range of helpful techniques, including how to separate inputs from calculations, streamline formula writing, preserve key formulas, and create both operating and cash flow budgets. In addition, he explains the uses and benefits of a variety of Excel functions, including CHOOSE IFNA, IFERROR, and ISERROR ROUNDUP and ROUNDDOWN VLOOKUP and SUM and SUMIF.