Login

If you are a CPA Alberta member, or have a CPA Alberta account, please login with your account information.

If you are a non-member and do not already have an account, please create an account.

Forgot your account number or password?

Need help registering for a seminar? See our How to Register instructions.

  1.  
  2.  

Centennial 2010
  • Location:
 

EXCEL GURU: TIPS TO MAKE YOUR HEAD SPIN


Level: Advanced
Competency: Information Technology
Seminar Code: 01643
Format: Webinar 2 Hours
CPD Hours: 2
Availability: This seminar occurs in the past. To view other offerings of this seminar, go to "Additional Offerings"


Register before Apr 17, 2018 and pay the early fee!
Date: Tuesday, Apr 24, 2018
Time: 8:00 AM-10:00 AM
Location:

,
Meeting Room:
Fee Options: Tickets Required: N/A
(Passport Tickets can only by used 14 days prior to seminar start date)
Fee Required: $79.00 - Early Member
$79.00 - Early Non-Member
$79.00 - Regular Member
$79.00 - Regular Non-Member
Seminar Description: These webinars are delivered by K2E which is an American based company. Please note some US based content and examples will be used during this webinar.

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.

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

Prerequisite: Good working knowledge of Excel

The participant must be logged in during the live webinar and participate when prompted. Failure to participate and respond to the prompts will result in no credit earned for the seminar as attendance will be monitored and recorded. Recordings of a live webinar will not be available after it has concluded.
Seminar Outline:
  • 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
Pre-requisite:
Who Will Benefit: Accountants and finance professionals who want to put the power of Excel to use in innovative ways to improve personal productivity
Seminar Leader(s): MCCLELLAND, Mac
Special Notes: These webinars are delivered by K2E which is an American based company. Please note some US based content and examples will be used during this webinar. Login credentials will be emailed 2 – 5 business days before a live webinar starts. Cancellation of registrations and transfers received less than ten (10) business days, and more than five (5) business days before the Live Webinar, will be subject to a $50 + GST fee which must be paid prior to the transaction being completed. Refunds will not be granted if the request is received five (5) business days or less before the Live Webinar begins.
Additional Offerings:
Can't make it to this session? See the other offerings of this seminar.

Terms and Conditions