Learn Excel skills in six key areas: collaborate with other users and secure workbooks; use tables to analyze and report data; integrate and manipulate data from external sources; create and audit complex formulas; use advanced data analysis tools; and analyze and communicate information using visualization techniques. Highlights
Secure sensitive information
Dynamic data ranges, structured reference formulas
Import and link data from external sources
Power Query and other cleanup tools
Advanced functions, such as SUMPRODUCT, VLOOKUP, HLOOKUP, MATCH, INDEX, NETWORKDAYS, RAND, RANDBETWEEN, NPV, IRR, XNPV, and XIRR
Data tables, subtotals, slicers, filters, and PivotTables
Registration
PICPA Member: $299 Nonmember: $399
More Information
Course No.
624000
Level:
Advanced
Prerequisites:
Experience with Excel
Notes
This course is only offered once in 2018.
Speaker(s)
Thomas Stephens
K2 Enterprises
Thomas G. Stephens, Jr.,
CPA.CITP
Bachelor of Science in Business Administration, Major in
Accounting,AuburnUniversity
Master
of Science, Major in Finance (emphasis in Corporate Finance), GeorgiaStateUniversity
Twenty-five
Years of Public Accounting Experience, Five Years of Corporate Internal
Auditing Experience, Four Years of Corporate and Cost Accounting Experience
Nineteen
Years of Experience as a Continuing Professional Education Discussion
Leader
Member
of the American Institute of Certified Public Accountants and the Georgia
Society of Certified Public Accountants; Past Member of the Institute of
Internal Auditors
To
Date, Has Presented Over 1,800 Continuing Education Sessions to Over 55,000
Participants