16EXCEL1: K2's Excel Tips, Tricks and Techniques for Accountants
If you have questions about this event, please call us at 952-831-2707.
Thursday, April 21, 2016
8:30am - 4:30pm Central Time
8 CPE (8 technical)
Minnesota Society of CPAs, Bloomington
Excel is likely your tool of choice to analyze and report financial data, but have you ever received formal training? Stop wasting time and making spreadsheet errors. Get hundreds of tips, tricks and techniques to improve your Excel productivity, work more efficiently and spend less time on mundane tasks. Delve into topics tailored to the needs of accountants and financial professionals, and return to your office with insights you can immediately implement.
Find out if this class is right for you. Take the online assessment.
Major subjects
-
Productivity tips -- freeze panes, split windows, autocorrect, Office Clipboard, paste special and more
-
Formatting -- multiline column headings, accounting format, custom dates and numbers, conditional formatting and more
-
Customizing -- ribbon, quick access toolbar, Excel options, templates and more
-
Formula-building -- manipulating text and dates, VLOOKUP and HLOOKUP functions, conditional calculations, circular references and more
-
Linking data and three-dimensional workbooks -- linking across multiple Excel worksheets and workbooks, updating links, and creating sum-through formulas and rolling reports
-
Printing essentials -- Excel-based reports, adjusting settings, using the camera feature to create report forms, working with custom views to automate settings and more
Learning objective(s)
-
Understand Excel tips and tricks to increase efficiency, accuracy and productivity
Who should take this program?
CPAs, accountants and financial professionals in industry and public practice
Fees
Our records indicate
you are a
nonmember.
If you register, you will be charged
$349.00
(Standard Nonmember Fee).
Members: Please
log in
to receive member fee.
Standard Member Fee |
$299.00
|
Standard Nonmember Fee |
$349.00
|