K2's Excel Guru - Tips to Make Your Head Spin - On Demand (2 CPD Hours)

K2's Excel Guru - Tips to Make Your Head Spin - On Demand (2 CPD Hours)

  • $79.00

Course Description

How much do you know about Excel and the features and functionality it provides that could make a difference in your personal day-to-day productivity? Most accountants and other business professionals use less than 20% of the functionality of this product. Are you taking advantage of the features that are best for you? This session is sure to deliver many thought-provoking ideas and tips for getting better results with less effort and in less time.

Major Topics

  • Use the Data Model and cube formulas to improve analysis and reporting
  • Memorize complex formulas, constants, or array constants for future use
  • Utilize statistical procedures in the Data Analysis ToolPak to your advantage
  • Add slicers to individual or multiple Tables, Pivot Tables, or Pivot Charts
  • Use advanced functions such as AGGREGATE, RANDBETWEEN, EOMONTH, and WEEKDAY
  • Use SUMIFS to create analytical reports without using PivotTables
  • Use the Data Model effectively without PowerPivot

Learning Objectives

Upon completing this course, you should be able to:

  • Identify key productivity-enhancing Excel functionality and features
  • Differentiate between Excel functionality to select the best features for your objectives
  • List capabilities that have direct application to your practice or business
  • Apply the knowledge gained to improve your personal productivity

Who Should Attend: Accountants and finance professionals who want to put the power of Excel to use in innovative ways to improve personal productivity

Course Level: Advanced

CPE Credits: 2 Hours Computer Software and Applications  

Prerequisites: Good working knowledge of Excel

Advance Preparation: None

Instructional Delivery Method: QAS on-demand learning, including review and final exam questions. To earn credit, participants must pass the final exam with a score of 70% or better within one year of registering for this course. Participants may attempt take the final exam up to 10 times.