Access to cutting-edge industry knowledge and practices.
Comprehensive training designed to meet professional needs.
Fulfill compliance requirements while acquiring valuable skills.
Ongoing updates to course content for relevant industry trends.
Sample Certificate
What You’ll learn
Explore your potential with the Certified Intermediate Excel Professional Course (CIEPC). This course bridges the gap between basic and advanced Excel knowledge, focusing on intermediate-level techniques for efficient data analysis, reporting, and automation. Gain proficiency in tools like PivotTables, logic functions, and dashboards to make your data-driven decision-making more effective and streamlined.
Get Deeper Understanding of:
Using PivotTables for effective grouping and summarization of data.
Mastering Excel's logic functions for precise and accurate calculations.
Designing interactive and visually appealing Excel dashboards for reporting.
Automating repetitive tasks with LET and LAMBDA functions.
Performing What-If Analysis to evaluate different scenarios and outcomes.
Recommended For:
CPAs and financial analysts who seek to advance their Excel skills beyond basic functions and gain expertise in data analysis, reporting, and automation.
Business Professionals like operations managers, marketing analysts, and project managers who need to enhance their ability to analyze and present data more effectively using intermediate Excel tools.
Individuals looking to strengthen their Excel capabilities for career growth, improve efficiency in data handling, and better support decision-making processes in various business settings.
Why take the Certified Intermediate Excel Professional Course (CIEPC) Course with MYCPE ONE?
Resources included
Handout PDFs for every Module
Glossary/Key Terms for every module
Q&A directly with instructors.
Career Opportunities
Data Analyst
Business Intelligence Analyst
Marketing Analyst
Operations Manager
Reporting Specialist
Value Addition to your skills
Enhanced Data Analysis and Reporting
Streamlined Automation with Excel Functions
Improved Decision-Making with What-If Analysis
Increased Proficiency in Excel Dashboards
Time-Saving Data Management Skills
Strong Problem-Solving and Analytical Capabilities
Accounting for
Certified Public Accountants (CPA-US)
4 CPE
Approved
Accounting for
CPA in Canada
4 CPD
Eligible
Accounting for
Delaware Licensed Public Accountant (DE-LPA)
4 CPE
Eligible
Accounting for
Certified Government Financial Manager (CGFM)
4 CPE
Eligible
Accounting for
Certified Fraud Examiner (CFE)
4 CPE
Eligible
Accounting for
Iowa Licensed Public Accountant (IA-LPA)
4 CPE
Eligible
Accounting for
Maine Licensed Public Accountant (ME-LPA)
4 CPE
Eligible
Financial accounting concepts for
Certified FP&A Professional (FP&A)
4 CE
Eligible
License details
Credits
Status
Accounting for
Certified Public Accountants (CPA-US)
4 CPE
Approved
Accounting for
CPA in Canada
4 CPD
Eligible
Accounting for
Delaware Licensed Public Accountant (DE-LPA)
4 CPE
Eligible
Accounting for
Certified Government Financial Manager (CGFM)
4 CPE
Eligible
Accounting for
Certified Fraud Examiner (CFE)
4 CPE
Eligible
Accounting for
Iowa Licensed Public Accountant (IA-LPA)
4 CPE
Eligible
Accounting for
Maine Licensed Public Accountant (ME-LPA)
4 CPE
Eligible
Financial accounting concepts for
Certified FP&A Professional (FP&A)
4 CE
Eligible
License details
Credits
Status
Accounting for
Certified Public Accountants (CPA-US)
4 CPE
Approved
Accounting for
CPA in Canada
4 CPD
Eligible
Accounting for
Delaware Licensed Public Accountant (DE-LPA)
4 CPE
Eligible
Accounting for
Certified Government Financial Manager (CGFM)
4 CPE
Eligible
Accounting for
Certified Fraud Examiner (CFE)
4 CPE
Eligible
Accounting for
Iowa Licensed Public Accountant (IA-LPA)
4 CPE
Eligible
Accounting for
Maine Licensed Public Accountant (ME-LPA)
4 CPE
Eligible
Financial accounting concepts for
Certified FP&A Professional (FP&A)
4 CE
Eligible
Identify QuickBooks features for streamlining reports and using pivot tables in Excel for faster analysis.
Explore how to enable browser settings for launching Excel files exported from QuickBooks Online.
Define ideal data for pivot tables and recall key techniques, like Text to Columns and selecting non-adjacent items in a Slicer.
Disclaimer : Before attending any course, please verify that the credit details align with your qualification requirements. This certificate is designed to help you acquire new skills and knowledge, which may or may not fulfill specific compliance criteria. While we have made every effort to ensure our courses adhere to compliance standards, we recommend reviewing the details to confirm applicability for your needs.
Instructors
David Ringstrom
President, EXCEL Accountant
I own an Atlanta-based training and consulting firm that helps businesses nationwide streamline accounting challenges. Our specialties include:
Microsoft Excel
Microsoft Access
Sage 50/Peachtree Accounting
QuickBooks
Our services include training, technical support, accounting automation, and problem solving. I have spoken at conferences or meetings for these organizations:
National Association of Certified Valuators and Analysts
Institute of Real Estate Managers
Georgia Society of CPAs
South Carolina Society of CPAs
Georgia Government Finance Officers Association
Atlanta chapter, American Society of Women CPAs
Perimeter Chapter, Georgia Society of CPAs
I teach over 200 live webinars annually on Microsoft Excel across roughly two-dozen training providers. I am available for in-house training or select conference engagements as well.
I am the co-author of Idiot's Guide to Introductory Accounting. I've published hundreds of freelance articles on various topics, including Lotus 1-2-3, Quattro Pro, Microsoft Excel, Microsoft Office Accounting, QuickBooks, Peachtree Accounting, and more.
I serve as the technical editor for several books in Wiley's Dummies series, including QuickBooks for Dummies, Quicken for Dummies, Peachtree for Dummies, and more.
Specialties: Microsoft Excel, Visual Basic for Applications, Sage 50, Peachtree Accounting, QuickBooks, Microsoft Office Accounting, freelance writing, training, business consulting
Lenny Wu was a Lecturer at Tsinghua University in Beijing, China. He also sat as an Examiner for the International English Language Testing System (or IELTS) in the 1990s. On top of these, he is an exam trainer for various high profile exams, such as GRE (or Graduate Record Examination), GMAT (or Graduate Management Admission Test), TOEFL (or Test of English as a Foreign Language), and math contests such as Euler, Gauss and Pascal. He has published books on test taking strategies.
Lenny received his MBA, Finance from The George Washington University in Washington, DC, USA, and currently is a Senior Financial Analyst with an international engineering company in Vancouver, BC, Canada.
Lenny's motto at work is "Don’t work hard, work smart". Lenny has passion in teaching how to build your own "robot" into everyday office work. He has over over 22 years working with Microsoft Excel, and he is a modeling expert in Power Query, Power Pivot, and Power BI.
In a career spanning 30+ years, Mike Thomas, a UK-based IT Trainer, has delivered thousands of courses and produced hundreds of written and video-based tutorials.
He is a subject matter expert in a range of technologies, his primary focus and passion being Microsoft Office (especially Excel) on both the Windows and Mac platforms and Power BI.
Mike is a Fellow of The Learning and Performance Institute and has worked with and for many global and UK-based companies and organizations across a diverse range of industries including healthcare, pharmaceutical and public sector.
In addition to training, he also designs and develops Microsoft Office-based solutions that automate key business tasks and processes.
80% of Content Rated 4.5+ Stars High-quality content rated by professionals.
4X More Content at 1/3rd the Price Serious value compared to your regular provider!
Non-Sponsored Content Purely educational, unbiased content for your learning.
Monthly & Quarterly Updates Keeping you ahead of trends and changes.
Podcasts with Industry Leaders Learn and Earn CPE from experts on the go.
Discover Why We’re the Preferred Choice!
Next-Level Excel Skills
“Taking this course was a game-changer for me! The practical Excel skills I gained helped me streamline my daily tasks, and I feel way more confident tackling complex data now. The course is definitely more than just basic Excel. It is perfect for someone ready to level up! ”
Sara Patterson, ACCA
Finance Manager
Enhancing Work Efficiency
“I have taken several Excel courses before, but this one was by far the most valuable. The focus on real-world applications made all the difference. I can now create dynamic dashboards and analyze data like a pro! Definitely recommend it to anyone looking to build on their Excel skills.”
James Clark, ACCA
Entrepreneur
Boosting Productivity with Excel
“After completing this certification, I have noticed a huge difference in my work productivity. The course covers everything from PivotTables to advanced functions, making it a perfect fit for someone like me who needs Excel skills beyond the basics. Plus, I loved how MYCPE ONE made the whole learning process so smooth and their platform is incredibly user-friendly.”
This course covers a wide range of intermediate Excel topics designed to enhance your data management and analytical skills. You'll learn how to use advanced PivotTables for efficient data analysis, apply powerful logic functions like IF, VLOOKUP, and SUMIF, and create interactive dashboards and dynamic spreadsheets. Additionally, the course introduces advanced problem-solving tools like LET, LAMBDA, and What-If Analysis to help streamline data processes and decision-making. By the end of the course, you'll be equipped with the Excel skills needed for more efficient data management and reporting.
This certification will significantly enhance your Excel proficiency by teaching you essential tools and techniques to streamline tasks, improve data analysis, and make data-driven decisions. You'll gain practical skills in automating processes, creating dynamic reports, and solving complex problems, which can be immediately applied to real-world scenarios. The knowledge gained will not only boost your productivity but also make you more efficient in handling data, reporting, and decision-making tasks in your professional role.
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.
Qualifications
Credits
Payment details
Congratulations!
Subscribed
THOMAS purchased a subscription.
Subscribed
Shi purchased a subscription.
Subscribed
Dave purchased a subscription.
Subscribed
RYAN purchased a subscription.
Subscribed
Michaela purchased a subscription.
Subscribed
Tom purchased a subscription.
Subscribed
Maxwell purchased a subscription.
Subscribed
John purchased a subscription.
Subscribed
julie purchased a subscription.
Subscribed
Lena purchased a subscription.
Subscribed
Lauren purchased a subscription.
Subscribed
Stuart purchased a subscription.
Subscribed
Richard purchased a subscription.
Subscribed
Miranda purchased a subscription.
Subscribed
Isaac purchased a subscription.
Subscribed
Ron purchased a subscription.
Subscribed
Linda C purchased a subscription.
Subscribed
Andrew purchased a subscription.
Subscribed
Nicole purchased a subscription.
Subscribed
Sonya purchased a subscription.
Subscribed
George purchased a subscription.
Subscribed
Mary Jane purchased a subscription.
Subscribed
stephanie purchased a subscription.
Subscribed
Karen purchased a subscription.
Subscribed
Melissa purchased a subscription.
Subscribed
Paul purchased a subscription.
Subscribed
Oladapo purchased a subscription.
Subscribed
Juli purchased a subscription.
Subscribed
Karlyn purchased a subscription.
Subscribed
Lilia purchased a subscription.
Subscribed
David purchased a subscription.
Subscribed
Amber purchased a subscription.
Subscribed
Eli purchased a subscription.
Subscribed
Tracee purchased a subscription.
Subscribed
Eda purchased a subscription.
Subscribed
Denise purchased a subscription.
Subscribed
Sumithra purchased a subscription.
Subscribed
Queena purchased a subscription.
Subscribed
Taewon purchased a subscription.
Subscribed
Althea purchased a subscription.
Subscribed
Shawn purchased a subscription.
Subscribed
Aidenith purchased a subscription.
Subscribed
Anthony purchased a subscription.
Subscribed
Melanie purchased a subscription.
Subscribed
Shawn purchased a subscription.
Subscribed
Biying purchased a subscription.
Subscribed
Laura purchased a subscription.
Subscribed
Robert purchased a subscription.
Subscribed
Byron purchased a subscription.
Subscribed
FATIH purchased a subscription.
Subscribed
James purchased a subscription.
Subscribed
Yunhee purchased a subscription.
Subscribed
Regina purchased a subscription.
Subscribed
Patricia purchased a subscription.
Subscribed
Fredricka purchased a subscription.
Subscribed
Tiffany purchased a subscription.
Subscribed
Barry purchased a subscription.
Subscribed
Constance purchased a subscription.
Subscribed
Javonnia purchased a subscription.
Subscribed
Roy purchased a subscription.
Subscribed
Savannah purchased a subscription.
Subscribed
Adrienne purchased a subscription.
Subscribed
Ali Kamran purchased a subscription.
Subscribed
Sally purchased a subscription.
Subscribed
Jackie purchased a subscription.
Subscribed
Ravi purchased a subscription.
Subscribed
Keith purchased a subscription.
Subscribed
Robyn purchased a subscription.
Subscribed
Sara purchased a subscription.
Subscribed
Masami purchased a subscription.
Subscribed
Jonathan purchased a subscription.
Subscribed
Melissa purchased a subscription.
Subscribed
Joy purchased a subscription.
Subscribed
Bryan purchased a subscription.
Subscribed
Rachel purchased a subscription.
Subscribed
Rosemary purchased a subscription.
Subscribed
Christopher purchased a subscription.
Subscribed
David purchased a subscription.
Subscribed
Pam purchased a subscription.
Subscribed
Holly purchased a subscription.
Subscribed
Megan purchased a subscription.
Subscribed
Robert Bob purchased a subscription.
Subscribed
Steve purchased a subscription.
Subscribed
Steven purchased a subscription.
Subscribed
JOANNE purchased a subscription.
Subscribed
STACEY purchased a subscription.
Subscribed
Leroy purchased a subscription.
Subscribed
Michael purchased a subscription.
Subscribed
Linda purchased a subscription.
Subscribed
Michael purchased a subscription.
Subscribed
Leslie purchased a subscription.
Subscribed
Jenna purchased a subscription.
Subscribed
Jeffrey purchased a subscription.
Subscribed
virginia purchased a subscription.
Subscribed
Ring purchased a subscription.
Subscribed
Kristine purchased a subscription.
Subscribed
Aaron purchased a subscription.
Subscribed
Melissa purchased a subscription.
Subscribed
Matthew purchased a subscription.
Subscribed
Carol purchased a subscription.
License details have been successfully updated to your profile.
