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 funda- mentals 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.
DESIGNED FOR
Anyone who has been using Excel and wants to master advanced features.
BENEFITS
- 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
- 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 PowerBI Tools
- Tools for presenting your spreadsheets in a meaningful way
COURSE LEVEL
Intermediate
PREREQUISITES
Good understanding of Excel.
ADVANCE PREPARATION
None
ADDITIONAL NOTES
Note: You will need to bring your own PC with Excel pre-installed.
NJCPA Goes Green - Registrants Save $20
New for 2018, course materials will be distributed electronically and we're passing the savings along to you. All 8-hour seminar pricing has been reduced by $20. To access, visit your My Events page. Download to your laptop or tablet prior to your seminar. Handouts are added as received.
Help Feed Those in Need- The NJCPA Emerging Leaders Council is hosting a Food Drive to benefit the Community FoodBank of New Jersey. Please bring your nonperishable items and canned goods to this event. Peanut butter and tuna fish are always needed.