Webcast: K2's Excel Guru - Tips to Make Your Head Spin (XKEGU17)
Tell a Friend About This EventTell a Friend
 

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.

9/7/2017
When: 09/07/2017
9:00 AM until 11:00 AM
Where: Webcast
K2 Enterprises
United States
Presenter: Mac McClelland


Online registration is closed.
« Go to Upcoming Event List  

Acronym XKEGU17
CPE 2 hours
Vendor K2 Enterprises
Category
Management
Level Advanced
Prerequisite Good working knowledge of Excel
Adv Prep None
Yellow Book? No
Designed for ccountants and finance professionals who want to put the power of Excel to use in innovative ways to improve personal productivity
Registration
Member $79
CPA Non-Member $104

The Member rate applies to LCPA members, other state society members, and non-CPA staff of LCPA members. To register online, use the ‘Register’ button above. To register by phone, call the LCPA Member Service Center at 800.288.5272 or 504.464.1040, Monday through Friday, 8am to 5pm.

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.

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

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