Events Search
  Summary & Check Out (0)
Wednesday, August 31, 2016 Live

K2’s Excel Tables & Data Models – Efficiently Managing, Analyzing, and Reporting Your Data (E1608233)

8:30 AM - 4:30 PM EDT

Registration: 8:00 AM EDT

NJCPA Education Center

425 Eagle Rock Avenue,
Roseland , NJ 07068

8 CPE Credits in CS

OVERVIEW

To efficiently manage, analyze, and report in Excel, you need more than traditional ranges of data – you need tables and data models! Two of Excel’s best features about which most users know very little, tables and data models allow you to process large volumes of data into dynamic reports and analytical elements with unsurpassed ease, accuracy, and speed. Learn how to harness the power of these tools!

DESIGNED FOR

Accounting and business professionals who use Excel 2013 and Excel 2016 and are seeking to manage, analyze, and report data more efficiently using Excel.

BENEFITS

Upon completing this course, participants should be able to:
  • List the key features and advantages of working with tables and data models
  • Create tables and data models in Excel, including using Power Query to reference data from external data sources into tables and data models
  • Construct formulas in tables using Structured References, including formulas that refer to tables in other worksheets and workbooks
  • Build Data Analysis Expressions in Data Models to extend their usefulness
  • Use tables as automatic re-sizing data sources for other objects, including PivotTables and PivotCharts
  • Use Excel’s Power Pivot tools to summarize large data models with extreme ease
  • Sort and filter data in tables, including applying Slicer filters
  • Generate financial reports and data analyses – including PivotTables – which reference information from tables and data models and update dynamically

HIGHLIGHTS

  • Revolutionize how you work with data in Excel, including dynamically re-sizing ranges of data, providing a simplified means of writing formulas, and facilitating quick and easy sorting of large volumes of data
  • Couple tables with data models – a means of joining, or relating, two or more tables together
  • Achieve unparalleled efficiency when managing, analyzing, and reporting with Excel

COURSE LEVEL

Advanced

PREREQUISITES

Fundamental knowledge of Microsoft Office Excel 2007 or or higher.

ADVANCE PREPARATION

None

ADDITIONAL NOTES

This is not a hands-on course.

INSTRUCTOR

Steven Phelan

Steven M. Phelan, CPA, CITP

K2 Enterprises

Steven M. Phelan, CPA.CITP Associate, K2 Enterprises Oklahoma City, Oklahoma steven@k2e.com Steven M. Phelan, CPA.CITP manages an accounting practice based in Oklahoma City, Oklahoma. Areas of practice include taxation, accounting, business advisory and technology consulting services. He is both a Certified Public Accountant and Certified Information Technology Professional and received his Bachelor of Accountancy degree from the University of Oklahoma. He also holds several vendor specific software certifications. Steven is a member of the Oklahoma Society of CPAs (OSCPA) and the American Institute of CPAs. Through the OSCPA, he has served on the board of directors, was instrumental in creating the New CPA Committee, served as chair of the Technology Committee and has served on numerous other committees. In 2012, Steven was selected as a Trailblazer, an OSCPA member under 40, recognizing innovation, professional dedication and community commitment. He also received the OSCPA President’s Award for his work with the New CPA Committee. Steven is active in the Mustang, Oklahoma community and is currently serving as Treasurer for the Mustang Public School Foundation. Previously, Steven served as Treasurer for Friends of the Mustang Public Library, Inc. Steven was added as a discussion leader for K2 Enterprises in 2013. Through K2 Enterprises, Steven speaks to CPAs throughout the nation covering a variety of computer software and technology related topics. Mr. Phelan is also a frequent speaker at seminars and conferences sponsored by a variety of state and local organizations. Steven has written a number of technology related articles for state and national publications. He is a frequent contributor to CPA Practice Advisor where he reviews tax and accounting related software solutions.

PRICING

$299.00 - Member

$399.00 - Nonmember

Event Cancelled

This event has been cancelled.

ADDITIONAL OPTIONS

Print a registration form

COURSE DEVELOPER

K2 Enterprises