Watch CoursePause
Video Player is loading.
Current Time 0:00
Duration -:-
Loaded: 0%
Stream Type LIVE
Remaining Time 0:00
 
1x
Excel Tables A Not So Hidden Feature Which Will Save You Time - Part 3
Earn 1 CPE Credit!
Exam price $19.
OR

All of our materials/exams are NASBA and the AICPA approved the revisions to the Statement on Standards for Continuing Professional Education (CPE) Programs (Standards).

Your Exam purchase includes

  • Course materials (video & PDF version)
  • Unlimited attempts to complete exam
  • Instant grading & certificate of completion
  • One year access to complete your CPE
  • Instructor discussion forum



Overview

To efficiently manage, analyze, and reporting 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. Far more than just a formatting tool, tables should revolutionize how you work with data in Excel, including serving as dynamically resizing 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 – and you have the recipe for unparalleled efficiency when managing, analyzing, and reporting with Excel, even if your source data lies in other data sources! You do not want to miss this chance to learn how to harness the power of these tools by participating in this program! In this episode, we take a detailed look at sorting and filtering data effectively using tables. We'll examine just about every way possible to slice and dice your data!

  • Identify structured reference formulas and the benefits associated with using them
  • List and define the four key components of structured reference formulas
  • Construct Excel charts that utilize tables as their data source, including charts that receive filtered data from tables and creating multiple charts from the same table
  • Create formulas outside of tables that refer to data inside tables, including VLOOKUP formulas;
  • Use Excel’s Fuzzy Lookup add-in with tables.
  • None, but it would be recommended to check out earlier episodes to catch up on the action.
  • None
  • Basic
  • 103648

No Reviews