cpdformula.com Open in urlscan Pro
3.162.3.40  Public Scan

Form analysis
3 forms found in the DOM

<form class="position-relative"><span class="material-icons-outlined form-control-icon py-2">search</span><input class="form-control rounded-pill ps-5 py-2" placeholder="Search courses" name="search"></form>

<form class="position-relative"><span class="material-icons-outlined form-control-icon py-2">search</span><input class="form-control rounded-pill ps-5 py-2" placeholder="Search courses" name="search"></form>

<form class="form-inline mt-3">
  <div class="input-group mb-3 w-100"><input id="email" type="email" class="form-control mb-2 " placeholder="Enter your email" style="background:#f4f5f6" value=""></div>
  <div class="d-flex justify-content-start align-items-center w-100"><input id="sender-agreement" class="form-check-input me-2 " type="checkbox" name="terms" checked="" value="1"><label class="form-check-label text-start" for="sender-agreement">I
      agree to receive special offers and updates by email. See<!-- --> <a href="#">Email Privacy Policy</a></label></div><button type="submit" class="mb-2 btn btn-primary w-100 mt-3 text-16">Start for free</button>
</form>

Text Content

CPDFormula
by learnformula
CPD for CPAs in Canada
search
shopping_cart

Sign inGet started

search
Custom Package
Packages
Video Courses
Ebooks
Podcasts
Latest Intelligence Requirements
COURSEMS Excel


EXCEL SKILLS FOR 2024 AND BEYOND


EXCEL MADE SIMPLE

schedule 1 hour
starstar
starstar
starstar
starstar
star_halfstar
4.5(161 ratings)
Created By Jason Stein
CPA Alberta
CPA British Columbia
CPA Manitoba
CPA New Brunswick
CPA Nova Scotia
Show more
CA$119
shopping_cart Add to Cart

auto_storiesINSTRUCTOR(S)
Jason Stein
 * Overview
 * Content
 * Instructors
 * Reviews


ABOUT THIS COURSE

Video Player is loading.
Play Video
Play
Mute

Current Time 0:00
/
Duration 0:36
Loaded: 33.33%


0:00
Stream Type LIVE
Seek to live, currently behind liveLIVE
Remaining Time -0:36
 
1x
Playback Rate

Chapters
 * Chapters

Descriptions
 * descriptions off, selected

Captions
 * captions settings, opens captions settings dialog
 * captions off, selected

Audio Track
 * default, selected

auto
 * Quality
 * 480p
 * 720p
 * Auto, selected

Picture-in-PictureFullscreen

This is a modal window.



Beginning of dialog window. Escape will cancel and close the window.

TextColorWhiteBlackRedGreenBlueYellowMagentaCyanTransparencyOpaqueSemi-TransparentBackgroundColorBlackWhiteRedGreenBlueYellowMagentaCyanTransparencyOpaqueSemi-TransparentTransparentWindowColorBlackWhiteRedGreenBlueYellowMagentaCyanTransparencyTransparentSemi-TransparentOpaque
Font Size50%75%100%125%150%175%200%300%400%Text Edge
StyleNoneRaisedDepressedUniformDropshadowFont FamilyProportional
Sans-SerifMonospace Sans-SerifProportional SerifMonospace SerifCasualScriptSmall
Caps
Reset restore all settings to the default valuesDone
Close Modal Dialog

End of dialog window.


CONFIRMATION

Please confirm that you are still watching this video course.

Confirm

This course covers the most important advanced Excel functionality necessary to
succeed in a data-driven environment.

The content is covered in an easy-to-understand step-by-step guide, making more
complex concepts simple.

Also covered, is the use of Tables as introduced to Excel in 2007. Tables are
underutilized by data analysts. This course covers the analytical and efficiency
gains in working with Tables.

By the end of this course, you will be able to use conditional functionality to
seamlessly manipulate data, saving you time, and giving you an analytical edge.

The course covers the following broad topics:

Sum
Sumif
Sumifs
Average
Averageif
Averageifs
Count
Counta
Countif
Countifs
Textjoin
Concatenate
If
Vlookup
Dropdowns
Linking sheets
Working with Tables
Practical exercise using sales data

The course includes the Excel file used in the video.


MEETS THE STANDARDS OF:


CPA Alberta (Chartered Professional Accountants Alberta)
CPA British Columbia (Chartered Professional Accountants British Columbia)
CPA Manitoba (Chartered Professional Accountants Manitoba)
CPA New Brunswick (Chartered Professional Accountants New Brunswick)
CPA Nova Scotia (Chartered Professional Accountants Nova Scotia)
CPA Ontario (Chartered Professional Accountants of Ontario)
CPA Prince Edward Island (Chartered Professional Accountants Prince Edward
Island)
CPA Saskatchewan (Chartered Professional Accountants Saskatchewan)
CPA Newfoundland & Labrador (CPA Newfoundland & Labrador)
CPA Quebec Order (Ordre des CPA du Québec)
Do you have questions about your organization's requirements? Read Requirements
What you will learn?
Work with conditional functionality in Excel
Work with Excel Tables for efficiency gains
Set up drop down menus to save repetitive data entry
Know which Excel functions to use in different scenarios

COURSE PREVIEWS

play_arrowExcel Course.mp4
schedule
1 hour on-demand video
emoji_events
Certificate of completion
bar_chart
Advanced level
error_outline
   Prerequisites
 * Basic understanding of Excel functionality

check_circle
No preparation required
lock
1 year access
calendar_month
Published At Jan 3, 2023
calendar_month
Updated At Feb 8, 2024

--------------------------------------------------------------------------------

CA$119

--------------------------------------------------------------------------------

verified 100% moneyback guarantee
If you cancel within 10 days and you’re not completely satisfied, we’ll give you
all your money back. No questions asked.

WANT TO SAVE UP TO 50% OFF?

Create your own CPD for CPAs in Canada Custom package picking any courses across
the platform

Try Custom Package

TRAINING 2 OR MORE PEOPLE?

Get your team access to 3526 top CPDFormula courses anytime, anywhere.

Try team license


Browse course content

1 VIDEO

|

1 QUIZ

|
schedule
1 hours
Section 1.
play_arrow PREVIEW

EXCEL COURSE.MP4

1h 1m 17s
Final Quiz

EXCEL SKILLS

questions

Learn from the best
Jason Stein/ INSTRUCTOR
Accounting Guru
Jason is a Charted Management Account and Certified Public Accountant (CPA) of
Australia who has over fifteen years of financial services experience in England
and Switzerland in banking and real estate. After his move to Australia, he
spent three years working as a lecturer and course designer in the fields of
accounting and general business studies. Prior to his move to Australia, he
worked as a consultant for a college, designing and rolling out learning
programs across South Africa. Programs included simulated work environments to
satisfy the work experience requirements of accounting institutes with which
students were registered. He set up a non profit organization in South Africa to
uplift mathematics and language education standards in rural areas.


PACKAGES INCLUDING THIS COURSE

PACKAGE
Excel CPD: Advanced Techniques for Data Analysis & Reporting
starstar
starstar
starstar
starstar
star_halfstar
4.4
book 8 courses
CA$547 / yearCA$1,197
schedule
20h
Student Reviews
4.5
starstar
starstar
starstar
starstar
star_halfstar
(161)
5 stars

97
4 stars

39
3 stars

15
2 stars

3
1 star  

2
MG
Maya G
starstar
starstar
starstar
starstar
starstar
Good refresh knowledge, with the benefit of few added functionalities for me to
learn
Jan 23, 2024
AM
Annalisa M
starstar
starstar
starstar
starstar
starstar
Good coverage of basic excel
Jan 18, 2024
MA
Michael A
starstar
starstar
starstar
starstar
starstar
Very good knowledge transfer by practical examples.
Jan 1, 2024
JP
James P
starstar
starstar
starstar
starstar
starstar
Good basic instruction.
Dec 31, 2023
CV
Chacko V
starstar
starstar
starstar
starstar
starstar
a very good presentation
Dec 31, 2023
4.5
starstar
starstar
starstar
starstar
star_halfstar
(161)
5 stars

97
4 stars

39
3 stars

15
2 stars

3
1 star

2
 * chevron_left
 * 1
 * 2
 * ...
 * 8
 * chevron_right


MORE COURSES BY JASON STEIN

Video Course
Master Data Cleansing, Power Query, Pivot Tables & Charts
Jason Stein
starstar
starstar
starstar
starstar
starstar
4.8 (4)
CA$59
schedule
1h
Video Course
Master Interactive Dashboards in Excel
Jason Stein
starstar
starstar
starstar
starstar
star_halfstar
4.7 (3)
CA$59
schedule
1h
Video Course
Accounting and Financial Reporting Fundamentals
Jason Stein
starstar
starstar
starstar
starstar
starstar
2.0 (5)
CA$59
schedule
1h
Video Course
Financial Independence, Retire Early (FIRE)
Jason Stein
starstar
starstar
starstar
starstar
star_halfstar
4.4 (32)
CA$59
schedule
1h

FREE COURSE INVITATION

Enter your email to get the course invitation link
I agree to receive special offers and updates by email. See Email Privacy Policy
Start for free

YOUR REQUEST HAS BEEN SENT!

Please check your email and validate. Thanks!

Homepage
Become an Instructor
Latest Intelligence
Terms of use
Contact us
Privacy policy
Report Abuse

Copyright @ 2024 CPDFormula LearnFormula | Professional Development Course
Marketplace