Excel Data Analysis and Financial Reporting (EXD00)

Printer Friendly
Text Size: A A A A
REGISTRATION STATUS: CLOSED - Online registration for this course is now closed. Please contact the Member Service Center at (850) 224-2727 or (800) 342-3197 if you wish to inquire about registering.

Date:Friday, June 06, 2014
Time:8:30am - 4:30pm (Registration at 8:00am )
City:Ft. Lauderdale
Facility:Renaissance Ft. Lauderdale, Ft. Lauderdale
CPE Credit:8 Technical Business
Instructor: J Carlton Collins
Subject:Specialized Knowledge, Technology
Course Level:Intermediate


This course educates attendees all about Excel's powerful data analysis tools, data commands, and selected functions, which include: PowerView, PivotTables, Queries, Quick Analysis, Sparklines, Conditional Formats, What-if Analysis, Goal Seeking, Outlining, Subtotaling, Consolidation, Filtering, Charting, Two-way data tables, Scenario Manager, Linking and Link Management, Traffic Light Reporting, Data Bar Reporting, LARGE, RANK, LOOKUP, VLOOKUP, MATCH and INDEX.

To educate CPAs about Excel's powerful data analysis and financial reporting capabilities

Who Should Attend:

This course is designed for CPA who want to increase their Excel knowledge in order to get their job done better and faster using the full power Excel has to offer. Your instructor will also share special tricks and techniques for building the kind of financial statements and reports that would satisfy the financial reporting needs of virtually any demanding company. Attendees will receive dozens of ready-to-use Excel templates and the course includes many useful tips and tricks.


Basic familiarity with any version of Microsoft Excel

Advanced preparation:


FICPA Seminar EZMaterials! Instead of picking up paper manuals at the event, you’ll be able to download the EZMaterials as searchable PDFs to your laptop, tablet or other device seven days before the event. For an additional fee you may choose to purchase a hardcopy of the seminar manuals. If requested during registration at least eight days prior to the course, your hardcopy will be available for pickup at the event. Click here for more information.

Regular Price: $345 FICPA Members, $470 Non-Members

Friday, June 6, 2014
General Sessions