Excel® Bootcamp: Tips, Tricks, & Features For Every CPA

8:30 am–12:15 pm ET

# of CPE Credits

4

Description

Whether you are relatively new to the accounting industry or have been around for a number of years, there is a good chance that you are developing your Excel® spreadsheets the hard way and leaving them susceptible to errors and omissions of important data. This course is designed to teach you the fundamentals of good spreadsheet design that will increase your accuracy and efficiency when creating Excel spreadsheets. You will also learn how to perform powerful data analysis using Excel. It will be well worth attending this course because of all the time it will save you in building your spreadsheets and analyzing your data. This is a fast-paced course that is sure to provide valuable knowledge to every Excel user.

Objective

Upon completing this course you will * Design spreadsheets with greater efficiency and accuracy * Understand how to use advanced Excel® functions * Use auditing techniques to build more accurate spreadsheets * Use advanced analytical tools to summarize detailed data * Make your spreadsheets more professional in appearance

Highlights

The key topics that will be covered in this course include * Building your spreadsheets for maximum efficiency and accuracy * The most popular functions and formulas * How to audit your spreadsheets to detect errors in formula logic * How to analyze your data with PivotTables and Excel's Power BI® Tools * Tools for presenting your spreadsheets in a meaningful way

Who Should Attend

All Excel® users who want to create accurate spreadsheets and analyze data using Excel

Required Knowledge

Good understanding of Excel®

Advanced Prep

None

Event Speaker(s)

John Higgins ( CPA Crossings, LLC, Rochester, MI ),

Additional Event Information

Technical Support
Contact NCACPA if you need assistance with your online program. For the quickest results, email the Online Learning Team at onlinelearning@ncacpa.org, and a team member will contact you shortly.

If you need assistance with internet access issues, browser capability, or when the NCACPA office is closed* please call Freestone Technical Support at 866-702-3278 or by email at support@peachnewmedia.com.

*NCACPA office hours are 9:00 am–5:00 pm ET. Online Learning Team members will be available via phone or email 30 minutes prior to the start of a live online program.

Test Your System
You may test your system by clicking here. Please test your system to ensure you have the proper components installed.

Also Available As

Webcast
Monday, March 18, 2019 (1:00 pm–4:45 pm ET)
Register >>
Webcast
Friday, February 15, 2019 (1:00 pm–4:45 pm ET)
Register >>

Share This Event

Event Vendor:CPA Crossings, LLC
Field of Study:Computer Software & Applications
Level: Intermediate
Other:New Course

Event Type:Webcast
Event Code:W34618

Registration Fees

Registration Fee Early Bird Regular
NCACPA Member N/A $145.00
Non-Member N/A $195.00