myCPE

March Mastery Sale : 67% Savings on Subscription. Offer Ends Soon! March Mastery Sale :
67% Savings on Subscription. Offer Ends Soon!
00hrs : 00min : 00sec

View Offer

Get access to all Certification Programs only @$199/annually.

Key Highlights

Add a highly valuable asset to your employability portfolio

Continuing Education approved courses for Multiple Qualifications

On-Demand Courses

Individual Certificates for each Module

Courses authored by Subject Matter Experts

Shareable Certificate on LinkedIn

What You’ll learn

Due to the universal applicability, mastering Excel has come to be an invaluable and essential skill. No matter who you are working for, creating, managing, analyzing, and representing data can be made much easier with this knowledge. The complete Excel Essentials provide effective tips, techniques, formulas, and more to access and analyze information effectively.

Get Deeper Understanding of:
  • Excel Fundamentals and templates

  • Adding and editing images, shares, and charts

  • Database functions and validations

  • VBA basics, tools, and logic

  • Macros in Excel and its basic

Recommended For:
  • CPAs, CFEs, CMAs, CVAs, CFFs, and other professionals who desire to improve their excel knowledge from basics to advanced levels.

  • CPAs in Canada who want to learn easy excel spreadsheet functions to save time in their work.

  • Any current or aspiring professionals who desire to have a long and promising career in any industry at any position.

Why become a Certified Excel Specialist with myCPE?

Resources included
  • Handout PDFs for every Module
  • Glossary/Key Terms for every modul
  • Q&A directly with instructors.
Career Opportunities
  • Project Coordinator/Manager
  • MIS Executive
  • Market Researcher and Analyst
  • Business and Market Analyst
  • Data Journalist
  • Financial Analyst
Value Addition to your skills
  • Cleanliness in Data management
  • Clarity in Data analysis
  • Automation
  • Logical functions in Excel
  • Dashboards representation
  • VBA in improving user experience

Module

Module Name

Duration

Introduction to Excel

0.5 Hour

  • To discuss introduction to Microsoft Excel.
  • To analyze Excel industry and marketplace.
  • To investigate Excel job opportunities.
Instructor
Juan E. Galvan
Juan E. Galvan

Co-Founder & CEO , Lunes Holdings, LLC

Getting Started With Excel

0.5 Hour

  • To discuss how to get started with Excel.
  • To analyze Excel industry and marketplace.
Instructor
Juan E. Galvan
Juan E. Galvan

Co-Founder & CEO , Lunes Holdings, LLC

Values, Referencing and Formulas in Excel

0.5 Hour

  • To analyze Excel referencing.
  • To inspect Excel formulas.
Instructor
Juan E. Galvan
Juan E. Galvan

Co-Founder & CEO , Lunes Holdings, LLC

Intro to Excel Functions

0.5 Hour

  • To discuss values in Excel.
  • To inspect excel functions.
Instructor
Juan E. Galvan
Juan E. Galvan

Co-Founder & CEO , Lunes Holdings, LLC

Adjusting Excel Worksheets

0.5 Hour

  • To describe how to move around in a spreadsheet
  • To describe how to adjust column width and row height
  • To describe how to move sheets across workbooks
Instructor
Juan E. Galvan
Juan E. Galvan

Co-Founder & CEO , Lunes Holdings, LLC

Visually Pleasing Cell Formatting in Excel

0.5 Hour

  • To format texts and highlight them in order of relevance
  • To make data attractive
  • To format cells by conditions
Instructor
Juan E. Galvan
Juan E. Galvan

Co-Founder & CEO , Lunes Holdings, LLC

How to Insert Images and Shapes in Excel

0.5 Hour

  • To explore inserting images and shapes in Excel
  • To discuss about different effects to different shapes
  • To recall adding SmartArt on a worksheet
Instructor
Juan E. Galvan
Juan E. Galvan

Co-Founder & CEO , Lunes Holdings, LLC

Visualize Data with Charts in Excel

0.5 Hour

  • To generate a chart from a table
  • To change layout, elements, labels, and legends in chart
  • To explore changing chart types
Instructor
Juan E. Galvan
Juan E. Galvan

Co-Founder & CEO , Lunes Holdings, LLC

Excel's Printing Options

0.5 Hour

  • To print pages in an excel workbook
  • To change orientation or pages, and adjust printing area
Instructor
Juan E. Galvan
Juan E. Galvan

Co-Founder & CEO , Lunes Holdings, LLC

Auditing Formulas & Custom Views in Excel

0.5 Hour

  • To explore transforming cell references into range names
  • To implement Watch Window to monitor the ramifications of changes
Instructor
Juan E. Galvan
Juan E. Galvan

Co-Founder & CEO , Lunes Holdings, LLC

Excel: Yielding More Through Templates and Forms

1.5 Hours

  • To explore using a template for creating a new workbook and populating data sets in it.
  • To discuss advantages of using excel template
  • To explore developing interactive Excel interfaces with VBA user form
Instructor
Juan E. Galvan
Juan E. Galvan

Co-Founder & CEO , Lunes Holdings, LLC

Working with Excel Datasets

0.5 Hour

  • To discuss sorting and filtering data sets
  • To explore removing duplicates from data set
  • To apply subtotal command to a data set
Instructor
Juan E. Galvan
Juan E. Galvan

Co-Founder & CEO , Lunes Holdings, LLC

Excel Data Validation

0.5 Hour

  • To build data validation rules for numbers, text, date, & time
  • To build Cascading data validation list
  • To use custom formula for data validation
Instructor
Juan E. Galvan
Juan E. Galvan

Co-Founder & CEO , Lunes Holdings, LLC

Excel Database Functions

0.5 Hour

  • To query and aggregate data DSUM and DCOUNT
  • To analyze how to enter complex sets of AND and OR conditions.
  • To extract a single row from a table that matches specific conditions by using the DGET function.
Instructor
Juan E. Galvan
Juan E. Galvan

Co-Founder & CEO , Lunes Holdings, LLC

Excel's Conditional Functions

0.5 Hour

  • To discuss adding conditional functions in Excel
  • To explore entering complex set conditions
  • To recognize using COUNT and related functions
Instructor
Juan E. Galvan
Juan E. Galvan

Co-Founder & CEO , Lunes Holdings, LLC

Excel's Lookup Functions

0.5 Hour

  • To analyze how to Summarize Tables for future-proofing VLOOKUP
  • To identify how to construct and use the HLOOKUP function
  • To discuss how to use MATCH and INDEX functions
Instructor
Juan E. Galvan
Juan E. Galvan

Co-Founder & CEO , Lunes Holdings, LLC

Text Based Functions in Excel

0.5 Hour

  • To describe the specified number of characters from a specific side of a text string
  • To determine how to remove unwanted spaces from a sentence
  • To determine how to join several text strings into a sentence
Instructor
Juan E. Galvan
Juan E. Galvan

Co-Founder & CEO , Lunes Holdings, LLC

Excel PivotTables

0.5 Hour

  • To insert PivotTable from a data table
  • To build reports, sort, filter, and group data using PivotTable
Instructor
Juan E. Galvan
Juan E. Galvan

Co-Founder & CEO , Lunes Holdings, LLC

Excel's PowerPivot Add-In

0.5 Hour

  • To investigate the PowerPivot application and importing data
  • To create reports using PowerPivot data
  • To analyze how to use DAX functions in PowerPivot
Instructor
Juan E. Galvan
Juan E. Galvan

Co-Founder & CEO , Lunes Holdings, LLC

Welcome to Excel VBA

0.5 Hour

  • To analyze how to develop macros.
  • To inspect how to create an interactive worksheet.
  • To discuss how to perform calculations.
Instructor
Juan E. Galvan
Juan E. Galvan

Co-Founder & CEO , Lunes Holdings, LLC

The VBA Language

0.5 Hour

  • To understand the basics of VBA language
  • To understand properties window and user forms
  • To learn the functions procedures and code modules
Instructor
Juan E. Galvan
Juan E. Galvan

Co-Founder & CEO , Lunes Holdings, LLC

Writing VBA Code

1 Hour

  • To analyze how the VBA works
  • To discuss how to write VBA codes
  • To explain the common mistakes to be avoided while writing VBA codes
Instructor
Juan E. Galvan
Juan E. Galvan

Co-Founder & CEO , Lunes Holdings, LLC

Important VBA Tools and Logic

0.5 Hour

  • To learn the logic of VBA
  • To understand the important tools of VBA
  • To learn how to use the VBA tools
Instructor
Juan E. Galvan
Juan E. Galvan

Co-Founder & CEO , Lunes Holdings, LLC

Excel VBA Loops

0.5 Hour

  • To learn the basics of VBA loops
  • To understand various VBA loop statements
  • To learn different types of VBA loops
Instructor
Juan E. Galvan
Juan E. Galvan

Co-Founder & CEO , Lunes Holdings, LLC

Excel’s “What If?” Tools

0.5 Hour

  • To discuss the basics of What-if Analysis
  • To describe how to use goal seek to find out how to get the desired result
  • To discuss how to use data tables to see the effect of one or two variables in a formula
Instructor
Juan E. Galvan
Juan E. Galvan

Co-Founder & CEO , Lunes Holdings, LLC

Triggering Macros

0.5 Hour

  • To discuss the basics of macro
  • To describe how to trigger macros using buttons
  • To determine how to use temporary variables in macros
Instructor
Juan E. Galvan
Juan E. Galvan

Co-Founder & CEO , Lunes Holdings, LLC

Starting a Career in Excel

1 Hour

  • To discuss the importance of excel
  • To explore ways to start career in excel
  • To discuss the benefits of using excel for your career development
Instructor
Juan E. Galvan
Juan E. Galvan

Co-Founder & CEO , Lunes Holdings, LLC

Instructors

Testimonials

Disclaimer

Certificate awarded upon the successful completion of the myCPE Advanced Certification Program is proof that user has successfully undergone the training and passed the quiz. This certificate marks completion of the said courses and learning activities and completion of the review quiz to earn continuing educational credits for specific qualification mentioned. This advance certificate program is not approved by any educational institution, training institute or regulatory body.

Ratings and Review

4.8

259 Ratings

Excellent

204

Very Good

54

Average

1

Poor

0

Terrible

0

BC

Brian Carey, CPA (US)

Aug 20th, 2023

I've wanted to increase my skills in order to add value: improve efficiency and presentation of info. I have been very pleased with my-cpe.com and the training courses related to the Excel Certification. I'm hungry for more!

AS

Andrew Smullen, CPA/CFF, CPA (US), CA - Scotland

Mar 5th, 2024

This is a comprehensive course that introduces a number of features and methods that many people might not realize are included in Excel. This course is well worth the time.

LK

Laxmikant Kabra, CPA Student, Tax Professional, Masters (Accountancy), QB Pro Advisor

Jan 28th, 2024

Excel is a powerful tool.

ME

Monty Epps

Mar 15th, 2023

It is highly recommended that you visit mycpe.com if you are an aspiring MSEC. They offer an end-to-end comprehensive solution that covers all the necessary subject areas. Their webinars are both informative and relevant.

EF

Estela Flanagan

Mar 7th, 2023

I am pleased to have chosen myCPE to fulfill my Excel-related basic to essential requirements. My practice was relevant to the webinars offered in the package.

Frequently Asked Questions

This certificate course will cover the A-to-Z of Excel and its skillful applications. It will cover basic understanding of excel; application of math, statistical, logic, functions, formulas, Pivot tables & charts, VBA, and Macros etc. The course will also help you be faster, better, and stronger excel-user with key recommendations saving hours of time and boosting productivity. 

With years of rich experience from speaker Juan Galvan, this certification will enable you to learn A-to-Z of Excel and its application. You will be able to apply excel skills to be faster, better, and stronger, for your business, as well as clients. With a dedicated module assigned to how to land your job as an excel expert, the course provides you with unique guidance to improve on multiple fronts.

Certificate course is created by a qualified and experienced instructor(s). myCPE Certificate Courses includes Self-study Courses. Most of the courses are in the form of On-demand Videos. The Self-study Video courses in Certificate courses may be Live recorded presentations converted into Self Study (On-Demand Videos).

You can take your time and attend the course at your own pace. You can take exam unlimited time. So, don’t worry, if you are not able to pass an exam. You will be getting a chance to attend the exam again.

After completion of each course of this Certification Programs, you will be able to download a certificate with the course title and number of hours. Certificates, as well as your study records, are stored for life and you can access them anytime. Certificates are valid proof for your continuing education credits and you can also add it as an additional designation.

Once you register you will have complete access to all the courses of this Certification Programs. The self-study format allows you to access the material online 24x7 and study at your own pace.

As per NASBA guidelines, you have one year from date of purchase of your certificate to complete each program. After completion of each course, you can attend final exam any time and get CPE Credit instantly. You can retake the exam multiple times without any additional charges.

Course have minimum passing score of 70% in the final exam and you can take multiple attempts of the said exam.

Our video player tracks & stores the watch time and will show you in the progress bar. But you make sure that you don’t fast forward or manually try to move the progress bar. If you have fast forwarded the video or tried to manually move the progress bar of the video. System wouldn’t capture your watch time. So please, let the video go on its own. However, being on-demand video you can pause and play and whenever you want and you can watch it in pieces. It will pick up from where you left off. So, for a self study courses you will have to
1. Complete the entire video 100%.
2. Answer all the review questions correctly. The review questions are at the bottom of the same page where you are viewing the course video.
3. Once you have watched the whole video and answered all the review questions, the Final Quiz will open up. You need to score more than 70% in the Final Quiz to avail your CPE credit. Multiple attempts are allowed for submitting Review and Final Quiz questions.
4. Once you have completed the Review and Final quiz questions, you shall be able to download the credit certificate from the ‘My Certificates’ section. Kindly ensure you have allowed Multiple File download from your web browser to download all certificates.
5. You can download individual certificate from your "Account" as well as from this page once you complete a particular courses. Also, you can download "Consolidated Certificate" from the package page or from your account.

A Self-study course is a recorded video (If it’s a recording of a live course you may see polling questions appearing on the screen. You do not need to answer the polling questions and just let the video play). Do not fast forward. If you fast forward, we may not be able to capture your watch time and you may be required to watch it multiple times. In order to avail your credits for the self-study course, you need to answer the review questions correctly and complete the entire video. Once you have done that, the Final Quiz will open up in which you need to score a minimum 70% to qualify for the credit. You can attempt multiple times for answering the review questions and Final quiz questions. Once you have completed the Review and Final quiz questions, you shall be able to download the credit certificate from ‘My Certificates’ section.
If neither of the above cases works, please drop an email to support@my-cpe.com or contact our support team through live chat support.

The evaluation form will be sent to attendees in the next 24 hours after passing the final quiz with at least 70% marks. Kindly note that the evaluation form will only be available to attendees who remained logged in till the end of the course and answered all the polling questions.

MY-CPE LLC is PCI Compliant - Approved. myCPE uses a secure payment gateway (Stripe.com) to process your payment details. This payment gateway is in accordance with the PCI-DSS Compliance. Therefore, your payment details are secure through SSL encryption. CLICK HERE to view our PCI compliance certificate. Once you have register for the package and paid for it you shall not be granted any refund unless you are not able to access courses for any reason etc.

"For some, Continuous Education is a compliance that helps them to renew their licenses. For some, it’s a worthwhile learning experience that keeps them and their firm up-to-date by taking valuable insights from continuing education courses / courses. At myCPE, we believe in providing quality continuing education beyond CPE credits. myCPE, the first ever web & mobile CPE/CE platform has launched a path-breaking social initiative “1 Credit = 1 Meal” under which we donate one meal to an underprivileged for each credit earned by a professional on our Platform. Check out our “1 Credit = 1 Meal” Timeline."