Limited Period Offer - Get Unlimited Access to 10k+ hours of content with myCPE Prime at $199Subscribe Now

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 document
  • 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 to transform, link, and categorize key data points
  • Identification of using appropriate functions with your data
  • Dashboards representation of summary, chat, and data points
  • VBA to make the user experience lively

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