Advanced Excel Productivity Series (Currently Unavailable)
In today's business world, Excel is a must have skill for accounting and finance professionals. Designed for CPAs and Accounting Professionals, this series focuses on the features, functions and techniques that enable you to get your work done faster. This series also includes how to automate recurring tasks and streamline processes to prepare financial reports in less time.
In this session, we'll discuss ways to improve personal productivity by using Excel more efficienctly.
What is your number one most-used function of all time? Is it...the SUM function? Well, it shouldn't be...at least if your goal is building more efficient workbooks. In this session, we'll discuss a function that allows you to SUM no more.
In this session, we'll discuss one of Excel's most important functions, the conditional summing function SUMIFS.
In this session, we'll discuss lookups and dig into the many subtle details of the VLOOKUP function.
In this session, we'll discuss error trapping functions and discover how they can be used to substitute a desired value for an error to clean up our reports.
Dates are often an integral part of our worksheets and understanding that Excel has functions that operate on, and return, date values helps improve efficiency.
In this session, we'll discuss joining text strings and how this simple idea creates huge effiency gains in reporting.
In this session, we'll use two Excel items, tables and SUMIFS, together to build a mapping table.
Total: 8 courses (16 CPE hours)
