K2's Excel Guru - Tips to Make Your Head Spin

  • Wednesday, December 20, 2017

    10:00am – 12:00pm
  • 2
    Computer Software and Applications

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.


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


  • 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
  • Additional Information

    Designed For

    ccountants and finance professionals who want to put the power of Excel to use in innovative ways to improve personal productivity


    K2 Enterprises

    Advanced Preparation



    Good working knowledge of Excel

    Field of Study

    Computer Software and Applications

    Course Number


    Level of Knowledge


    Add to Cart

    View All Courses