19EBP: K2's Excel Best Practices
If you have questions about this event, please call us at 952-831-2707.
Monday, June 24, 2019
8:30am - 4:30pm Central Time
8 CPE (8 non-technical)
Minnesota Society of CPAs, Bloomington
As spreadsheets evolve, so must your methods for working with them. Learn the productivity shortcuts and best practices the experts know and start using Excel to its full potential. This in-depth course covers tips related to creating and editing spreadsheets, workbook security, collaboration and data reporting. Return to your office with insights you can immediately use to minimize data errors, improve efficiency and work more productively in Excel.
Major subjects
-
Designing and constructing spreadsheets
-
Tips for improving spreadsheet performance
-
Creating, auditing and verifying formulas
-
Securing Excel data and workbooks
-
Collaborating and sharing
-
Reporting and communicating
Learning objective(s)
-
List critical spreadsheet design fundamentals
-
Identify techniques used to minimize data input errors
-
Use Excel's table feature as a foundational component of spreadsheets
-
Implement three different techniques for consolidating data
-
Use various Excel features, such as Go To Special, to solve specific spreadsheet issues
-
Apply four techniques for sharing an Excel workbook and collaborating with others
-
Implement techniques for auditing and error-checking Excel workbooks, including trace precedents, trace dependents and formula auditing
-
Identify the advantages of working with defined names in Excel
-
Apply six techniques for securing Excel data
Who should take this program?
CPAs in all sectors and industries
Fees
Our records indicate
you are a
nonmember.
If you register, you will be charged
$375.00
(Standard Nonmember Fee).
Members: Please
log in
to receive member fee.
Standard Member Fee |
$325.00
|
Standard Nonmember Fee |
$375.00
|