4th of July offer on myCPE Prime, Unlimited courses and credits for just $199. Hurry! (Offer expires on July 04) Click here to start.

Get access to all certificate courses only @$299/annually.

Microsoft Excel Certification: The Complete Excel Essentials! (MSEC)

Broaden your essential skill-set with the complete excel essentials and demonstrate competency in creating, managing, and distributing professional spreadsheets for a variety of specialized purposes and situations.

Certified Course Overview

  • Using functions, formulas, VBAs, and Macros efficiently in Excel
  • Mastering Pivot tables, charts, and formatting in Excel
  • How to start and build a career with Excel
  • How to save hours of time and boost your productivity in Excel
  • How to be a better, faster, stronger Excel user

Why this certification course

The Complete Excel Essential Course helps you gain the essential Excel skills and apply them efficiently for achieving professionals and business success. This online Certificate Course will help you understand the A-to-Z of Excel and its application. The speaker Juan Galven has years of experience in helping people strategize their success. Using practical approach, recommendations, and examples his courses create a rich experience that will help you in taking essential skills. With his effective method of exploring each subject through an example and concluding with a personal experience and recommendation note, you will bag a ton of applications of excel basic through advanced levels that readily help you through a lot of questions. 

This Excel CPE certificate course is packed with practical hands-on examples that you can follow step by step. Even if you already have experience, or you just want to explore the advanced features of Excel, this CPE certificate course will be very helpful. This certificate course is based on the core principles of continuing education that will take you away from burdensome costs and inefficient methods. The energy, broad-mindedness, and big picture thinking styles that the speaker represents will surely help you more than what you expect from this course.

Recommended For:

  • CPAs, CMAs, CIA, CFA, IAP, QIAL and Other Professionals who desire to help their clients with the efficient application of excel.
  • CPAs in Canada who wish to support their personal and business clients with effective Excel skills.
  • Any Professional interested in upgrading their knowledge on Excel.
  • All the professionals interested in learning A-to-Z of excel.

Modules

Course Title Educational Credits
Introduction to Excel 0.5
  • To discuss introduction to Microsoft Excel.
  • To analyze Excel industry and marketplace.
  • To investigate Excel job opportunities.
Getting Started With Excel 0.5
  • To discuss how to get started with Excel.
  • To analyze Excel industry and marketplace.
  • To investigate Excel job opportunities.
  • To discuss Excel Functions.
Values, Referencing and Formulas in Excel 0.5
  • To discuss values in Excel.
  • To analyze Excel referencing.
  • To inspect Excel formulas.
Intro to Excel Functions 0.5
  • To discuss values in Excel.
  • To analyze Excel referencing.
  • To inspect Excel functions.
Adjusting Excel Worksheets 0.5
  • To describe how to move around in a spreadsheet
  • To discuss how to select, cut, copy and paste data in seconds
  • To describe how to add or delete rows and columns
  • To describe how to adjust column width and row height
  • To discuss how to hide or unhide rows and columns
  • To describe how to move sheets across workbooks
Visually Pleasing Cell Formatting in Excel 0.5
  • To describe how to move around in a spreadsheet
  • To format texts and highlight them in order of relevance
  • To make data attractive
  • To print data 
  • To format cells by conditions
  • To align data in a worksheet
How to Insert Images and Shapes in Excel 0.5
  • To describe how to insert pictures on a worksheet from the device
  • To discuss how to insert pictures on a worksheet from stock
  • To determine how to insert Online pictures in a worksheet
  • To describe how to insert shapes on a worksheet 
  • To discuss how to give effects to different shapes
  • To discuss how to add SmartArt on a worksheet
Visualize Data with Charts in Excel 0.5
  • To generate a chart from a table
  • To change the layout of a chart
  • To change elements of a chart
  • To change labels and legends in data
  • To change a chart type
Excel's Printing Options 0.5
  • To Print pages in an excel workbook
  • To change orientation of pages while printing
  • To adjust the printing area using margins
Auditing Formulas & Custom Views in Excel 0.5
  • To recall the location of the menu command that allows you to determine categorically if a workbook contains links or not.
  • To Define how to transform cell references into range names. State the location of the Enable Iterative Calculations setting within the Excel Options dialog box.
  • To Implement the Watch Window to monitor the ramifications of even minor changes to your workbooks.
Excel: Yielding More Through Templates and Forms 1.5
  • To describe how to create a new workbook using a template.
  • To determine how to enter your data into templates.
  • To discuss the benefits of using excel templates.
  • To describe how to cut out all the noise of working with large sets of Microsoft Excel Data by tailoring the Excel Users experience and interface.
  • To describe how a seamless, accessible interface to your Excel users saves time and money.
  • To explain how to develop interactive Excel interfaces with Excel VBA User Forms.
  • To discuss ways to take advantage of the most powerful aspect of Microsoft Excel to streamline your Excel interactions.
Working with Excel Datasets 0.5
  • To analyze to work with Excel datasets
  • To discuss how to sort datasets
  • To discuss the filter datasets
  • To analyze how to remove duplicates
  • To use a subtotal command
Excel Data Validation 0.5
  • To build data validation rules for numbers, dates and times, and texts
  • To build Cascading data validation lists.
  • To use custom formulas for data validation
Excel Database Functions 0.5
  • 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.
Excel's Conditional Functions 0.5
  • To discuss the conditional functions in Excel
  • To analyze how to add formulas in Excel
  • To investigate how to enter complex sets of AND and OR conditions.
  • To discuss how to use COUNT and related functions in Excel
Excel's Lookup Functions 0.5
  • To identify how to construct and use the VLOOKUP functions
  • 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
Text Based Functions in Excel 0.5
  • To describe the specified number of characters from a specific side of a text string
  • To discuss the number of texts in a string
  • To determine how to remove unwanted spaces from a sentence
  • To describe how to look through a single column or row to find a particular value from the same place in another column or row
  • To describe how to find the relative position of an item in an array that matches a specified value in a specified order
  • To determine how to join several text strings into a sentence.
  • To discuss how to find the number of the character at which a specific character or text string is first found.
Excel PivotTables 0.5
  • To insert Pivot Table from a data table
  • To build reports, sort, filter, and group data using pivot table
  • To insert slicers
  • To insert Pivot Chart
Excel's PowerPivot Add-In 0.5
  • To investigate the PowerPivot application and importing data.
  • To discuss how to manipulate data in a PowerPivot worksheet.
  • To create reports using PowerPivot data.
  • To analyze how to use DAX functions in PowerPivot.
  • To inspect how to distribute PowerPivot Data.
Welcome to Excel VBA 0.5
  • To analyze how to develop macros.
  • To discuss the format worksheets.
  • To inspect how to create an interactive worksheet.
  • To investigate work with multiple worksheets.
  • To discuss how to perform calculations.
The VBA Language 0.5
  • To understand the basics of VBA language
  • To understand properties window and user forms
  • To learn the functions procedures and code modules.
Writing VBA Code 1
  • 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
Important VBA Tools and Logic 0.5
  • To learn the logic of VBA
  • To understand the important tools of VBA
  • To learn how to use the VBA tools
Excel VBA Loops 0.5
  • To learn the basics of VBA loops
  • To understand various VBA loop statements
  • To learn different types of VBA loops
Excel’s “What If?” Tools 0.5
  • To discuss the basics of What-if Analysis
  • To describe how to use scenarios to consider many different variables
  • 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
Triggering Macros 0.5
  • To discuss the basics of macro
  • To describe how to trigger macros using buttons
  • To determine how to use temporary variables in macros
  • To explore control buttons in Excel.
Starting a Career in Excel 1
  • 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

Our Certificate

Mastering Excel can be an invaluable professional skill, whether you are launching a new business, trying to improve an existing business, or looking for a career position. This 15.5 CPE certificate course provides you with the learning to harness the full power of Microsoft Excel from basic to advanced level. Starting with the basics, most common functions, formulas, Pivot tables, charts, creating reports, handling large data sets and automating day-to-day tasks through Macros and VBA. With numerous years of experience in helping people manage their business efficiently, the speaker Juan Galvan takes the learning to the next level using practical examples and easy to understand explanations. The learned speaker is also going to provide you with rich recommendations at each stage that will help you build top excel skills. This certificate course ensures a great learning experience through vast coverage and years of experience as a successful practitioner from the speaker.

Get Access @$299 Only

Request for More Information

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 certificate course, 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 certificate course. 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."

We use cookies to improve your experience on our website. Cookies store information about how a user interacts with Website. By clicking "Accept Cookies", you agree that MY-CPE LLC can store cookies on your device. All your data is anonymised and cannot be used to identify you.