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
Ready to elevate your Excel skills? The Certified Advanced Excel Professional Course (CAEPC) is designed for professionals eager to master Excel’s advanced capabilities. You’ll learn to automate reports, create sophisticated financial models, and design interactive dashboards. With an emphasis on Power Pivot, Power Query, and data integration, this course will transform your ability to manage and analyze complex data.
Get Deeper Understanding of:
Automating financial models with advanced Excel features.
Designing interactive dashboards to visualize key data insights.
Creating dynamic reports using Excel formulas and advanced functions.
Building budgeting models and financial projections in Excel.
Enhancing data analysis with advanced Excel charting techniques.
Recommended For:
CPAs and financial professionals seeking to advance their Excel expertise, focusing on complex data analysis, automation, and financial modeling beyond basic Excel skills.
Professionals in finance, business intelligence, or data analytics aiming to optimize reporting, create advanced financial models, and extract insights using Excel’s most powerful features.
Individuals wanting to master advanced Excel tools to enhance productivity, automate tasks, and develop sophisticated reports and dashboards for strategic decision-making.
Why take the Certified Advanced Excel Professional Course (CAEPC) Course with MYCPE ONE?
Computer Software and Applications for
Certified Public Accountants (CPA-US)
1 CPE
Approved
Computer Software and Applications for
CPA in Canada
1 CPD
Eligible
Computer Software and Applications for
Delaware Licensed Public Accountant (DE-LPA)
1 CPE
Eligible
Compliance with laws and regulations for
Certified Government Financial Manager (CGFM)
1 CPE
Eligible
Computer Software and Applications for
Certified Fraud Examiner (CFE)
1 CPE
Eligible
Association of Chartered Certified Accountants (ACCA)
1 CPD
Eligible
Chartered Accountant - ICAEW
1 CPD
Eligible
Computer Software and Applications for
Iowa Licensed Public Accountant (IA-LPA)
1 CPE
Eligible
Computer technology for
Maryland Tax Preparer (MRTP)
(Approval No. GEHNZ-T-01264-22-S)
1 CE
Approved
Computer Software and Applications for
Maine Licensed Public Accountant (ME-LPA)
1 CPE
Eligible
Chartered Accountants - Ireland (CAI)
1 CPD
Eligible
Chartered Accountants - Scotland
1 CPD
Eligible
CPA - Ireland
1 CPD
Eligible
Information Technology (inc. Excel) for
Certified FP&A Professional (FP&A)
1 CE
Eligible
License details
Credits
Status
Computer Software and Applications for
Certified Public Accountants (CPA-US)
1 CPE
Approved
Computer Software and Applications for
CPA in Canada
1 CPD
Eligible
Computer Software and Applications for
Delaware Licensed Public Accountant (DE-LPA)
1 CPE
Eligible
Compliance with laws and regulations for
Certified Government Financial Manager (CGFM)
1 CPE
Eligible
Computer Software and Applications for
Certified Fraud Examiner (CFE)
1 CPE
Eligible
Association of Chartered Certified Accountants (ACCA)
1 CPD
Eligible
Chartered Accountant - ICAEW
1 CPD
Eligible
Computer Software and Applications for
Iowa Licensed Public Accountant (IA-LPA)
1 CPE
Eligible
Computer technology for
Maryland Tax Preparer (MRTP)
(Approval No. GEHNZ-T-01264-22-S)
1 CE
Approved
Computer Software and Applications for
Maine Licensed Public Accountant (ME-LPA)
1 CPE
Eligible
Chartered Accountants - Ireland (CAI)
1 CPD
Eligible
Chartered Accountants - Scotland
1 CPD
Eligible
CPA - Ireland
1 CPD
Eligible
Information Technology (inc. Excel) for
Certified FP&A Professional (FP&A)
1 CE
Eligible
On Demand (video)
Analyze solutions for handling changes to Print Preview in Word 2010 and later versions.
Recover and explore the From Text command in Excel 2019 and Microsoft 365, and examine the Threaded Comments feature in Microsoft 365.
Analyze and apply the new XLOOKUP worksheet function in Microsoft 365 for more efficient data lookups.
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
Blair Cook
Partner, Executive Finance Partner Inc.
Blairis a many-time and active financial executive, corporate director, author, speaker, and thought leader. His educational videos of accounting and finance have million of views on YouTube. He has keynoted and spoken at national conferences from New York to Toronto. Along with Jen, he co-hosts CPA Canada’s podcast series “CPA Success Podcast.” He works with real businesses experimenting with theories and best practices to share his experiences and stories with others of what works, what doesn’t, and what was learned. He is the author of The Illiterate Executive: An Executive’s Handbook for Mastering Financial Acumen.
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
Dr. Knight's journey in the world of numbers began with a Bachelor’s degree in Accounting from LSU, followed by a Master of Science in Accountancy from the University of North Texas. His career took off at Deloitte and Touche, LLP, one of the prestigious Big Four accounting firms, where he not only honed his skills but also completed the CPA requirements.
With 15 years under his belt in the realms of accounting and financial analysis, Dr. Knight has mastered diverse areas including tax, financial reporting, financial analysis, and business management. His wealth of experience is matched by his passion for education.
In 2015, he achieved a Doctorate of Business Administration (DBA) and transitioned into academia. Today, he inspires the next generation of accountants and business professionals through his engaging courses at various colleges and universities.
Dr. Knight also conducts impactful training seminars and runs Accounting Hound, a website dedicated to accounting education. An accomplished author, he has published several journal articles and a book on basic accounting principles. Dr. Knight’s dynamic teaching style and extensive expertise make him a sought-after educator in the field of accounting and finance.
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.
Energetic, ambitious and Result-oriented professional, offering +15 years of extensive experience in Management, operations, Finance, Audit, Risk management, marketing and Customer experience.
Manish has hands-on experience in Monthly Reporting and Pnl Analysis, Budgeting and strategic planning.
Passionate for learning and development, thinking in innovative and non-traditional ways, Manish is your business partner for growth.
Manish is experienced with leading projects for change. He has led ERP implementation for 16 hotels in Htoo Group.
Manish is focused, display positive attitude and Topline growth approach towards business problems. He believes in efficiencies and lean management.
He is also on his Entrepreneurial journey and founded https://ehotelmanagementschool.com for sharing knowledge and experience via online classes and sessions. Startup also help small hotels and other startups with finance and management consulting.
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!
Excel Mastery Achieved
“I have taken a lot of Excel courses, but this one truly transformed my skills! The advanced techniques and practical tips I learned have helped me automate tasks and create powerful reports in no time. Definitely a game-changer for my career! ”
James Martinez, ACCA
Accountant
Unlocking Excel Potential
“I am a financial analyst, and this course has taken my Excel abilities to a whole new level. The advanced formulas and automation skills I have gained are already making a big difference in my work. Go for it if you are serious about mastering Excel! ”
John Harrison, CPA US
Financial Analyst
Powerful Excel Techniques
“As a CPA, I have always considered myself proficient with Excel, but this course pushed me to become truly advanced. The Power Pivot and financial modeling lessons were especially valuable, and the ability to automate reports has saved me countless hours. Plus, MYCPE ONE made the process easy with clear, organized materials. If you are looking to level up your Excel skills, this is the course for you! ”
This certification dives deep into advanced Excel skills, focusing on powerful features such as PivotTables, Power Pivot, and dynamic formulas. You'll master data automation techniques, streamline financial modeling, and learn how to build interactive dashboards. The course also covers Excel's role in financial reporting, automating data entry, creating detailed reports, and integrating Excel with external data sources using Power Query and Power BI. By the end, you’ll be equipped to handle complex data analysis and reporting tasks with ease.
This certification will enhance your ability to leverage Excel for advanced data management and reporting. You'll gain expertise in automating manual tasks, creating insightful financial models, and building interactive dashboards that are critical for data-driven decision-making. Additionally, mastering Power Query and Power BI will allow you to integrate and analyze data from multiple sources seamlessly. Whether you’re in finance, accounting, or data analysis, these skills will increase your productivity, improve your ability to manage large datasets, and position you as a leader in using Excel to drive business insights and efficiencies.
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
Eliyahu purchased a subscription.
Subscribed
Jean purchased a subscription.
Subscribed
Aspasia purchased a subscription.
Subscribed
Brett purchased a subscription.
Subscribed
James purchased a subscription.
Subscribed
Nandini purchased a subscription.
Subscribed
Chee purchased a subscription.
Subscribed
Leo purchased a subscription.
Subscribed
Audrey purchased a subscription.
Subscribed
Alex purchased a subscription.
Subscribed
Linda purchased a subscription.
Subscribed
Leonard purchased a subscription.
Subscribed
Alicia purchased a subscription.
Subscribed
CORA purchased a subscription.
Subscribed
Bertrand purchased a subscription.
Subscribed
Elsy purchased a subscription.
Subscribed
Steven purchased a subscription.
Subscribed
Donald purchased a subscription.
Subscribed
Shelby purchased a subscription.
Subscribed
Maggie purchased a subscription.
Subscribed
Sandra purchased a subscription.
Subscribed
Richard purchased a subscription.
Subscribed
Neil purchased a subscription.
Subscribed
Dennis purchased a subscription.
Subscribed
rose purchased a subscription.
Subscribed
Khalil purchased a subscription.
Subscribed
Marika purchased a subscription.
Subscribed
Jogina purchased a subscription.
Subscribed
Dulce purchased a subscription.
Subscribed
Michael purchased a subscription.
Subscribed
Michele purchased a subscription.
Subscribed
Pamela purchased a subscription.
Subscribed
Laura purchased a subscription.
Subscribed
Wayne purchased a subscription.
Subscribed
sabrina purchased a subscription.
Subscribed
Lisa purchased a subscription.
Subscribed
Kelly purchased a subscription.
Subscribed
Candace purchased a subscription.
Subscribed
GRANADA purchased a subscription.
Subscribed
Sarah purchased a subscription.
Subscribed
Roberta purchased a subscription.
Subscribed
Jayavaraman purchased a subscription.
Subscribed
Katie purchased a subscription.
Subscribed
KEVIN purchased a subscription.
Subscribed
Madeline purchased a subscription.
Subscribed
Anurodh purchased a subscription.
Subscribed
Mariah purchased a subscription.
Subscribed
Hyo Kyung purchased a subscription.
Subscribed
Denise purchased a subscription.
Subscribed
Moises purchased a subscription.
Subscribed
Gretchen purchased a subscription.
Subscribed
Olamide purchased a subscription.
Subscribed
Adam purchased a subscription.
Subscribed
Beth purchased a subscription.
Subscribed
Darlene purchased a subscription.
Subscribed
Alejandra purchased a subscription.
Subscribed
Marco purchased a subscription.
Subscribed
Shawn purchased a subscription.
Subscribed
Ryan purchased a subscription.
Subscribed
Ruben purchased a subscription.
Subscribed
Guy purchased a subscription.
Subscribed
Derek purchased a subscription.
Subscribed
Elizabeth purchased a subscription.
Subscribed
Brent purchased a subscription.
Subscribed
JODIE purchased a subscription.
Subscribed
Zachary purchased a subscription.
Subscribed
Kim purchased a subscription.
Subscribed
Galina purchased a subscription.
Subscribed
Pratin purchased a subscription.
Subscribed
Rebecca purchased a subscription.
Subscribed
Tracy purchased a subscription.
Subscribed
Zora Faye purchased a subscription.
Subscribed
Nicholas purchased a subscription.
Subscribed
Sandra purchased a subscription.
Subscribed
Taylor purchased a subscription.
Subscribed
Michael purchased a subscription.
Subscribed
IOAN purchased a subscription.
Subscribed
Catherine purchased a subscription.
Subscribed
Marcin purchased a subscription.
Subscribed
Lisa purchased a subscription.
Subscribed
Dane purchased a subscription.
Subscribed
Scott purchased a subscription.
Subscribed
Wanda purchased a subscription.
Subscribed
Caroline purchased a subscription.
Subscribed
Evgenia purchased a subscription.
Subscribed
Angela purchased a subscription.
Subscribed
Joseph purchased a subscription.
Subscribed
Amy purchased a subscription.
Subscribed
Carrie purchased a subscription.
Subscribed
ibrahim purchased a subscription.
Subscribed
ADAM SCHAEFER purchased a subscription.
Subscribed
Debbie purchased a subscription.
Subscribed
Djibril purchased a subscription.
Subscribed
Antoinette purchased a subscription.
Subscribed
Pankaj purchased a subscription.
Subscribed
Carrie purchased a subscription.
Subscribed
donald purchased a subscription.
Subscribed
Angela purchased a subscription.
Subscribed
Cheryl purchased a subscription.
Subscribed
Chris purchased a subscription.
License details have been successfully updated to your profile.