Excel Bootcamp for Finance & Accounting

This is not your grandma’s Microsoft Excel course. Our CPE qualifying online Excel course will only teach you the most important Excel formulas and functions to conquer any spreadsheet or analysis.  

Play Video about Free online excel course

Access all courses starting at $25/month.

🕔

2 hrs 46 mins

📖

39 Lessons

🎓

5.0 NASBA CPE Credits

🌐

Language: English

Level up your Excel skills to save time, improve efficiency and impress your team.

Excel is the most used, yet most underutilized, business tool. Conquering Excel can put you years ahead of your peers. We’ll start by spending quite a bit of time learning keyboard shortcuts which are key to maximizing your efficiency.

After this, you’ll learn powerful functions such as IF statements, VLOOKUPs, SUMIFSConditional Formatting and other powerful tools. We finish the course by learning how to create PivotTables. We have left out all the fluff and get right to the heart of Excel.

At completion, you’ll have the tools to master pretty much any analysis in Excel!

💡

In this course, you'll learn...

✅  Fundamental and advanced Excel techniques, including formulas, functions, and formatting.

✅  The power of keyboard shortcuts to significantly improve your efficiency.

✅  How to build clear, accurate, and professional spreadsheets by mastering formatting standards.

✅  Practical use of essential formulas like VLOOKUP, SUMIFS, COUNTIFS, and absolute cell references.

✅  Advanced techniques for dynamic and scalable spreadsheet modeling.

✅  Real-world application of Excel in case studies to solve complex problems with ease.

🔍

How you'll apply these skills...

  • Save hours of work each week with keyboard shortcuts and automation tips.
  • Build spreadsheets that impress stakeholders with clarity and professionalism.
  • Avoid common pitfalls and errors through smart formatting and formula usage.
  • Leverage Excel to analyze and present data in corporate settings, enhancing decision-making.
  • Design scalable and dynamic models that adapt to changing data inputs effortlessly.
  • Become the go-to Excel expert in your team, standing out for your ability to streamline tasks and solve problems effectively.

Additional Info

📝  Format
      3-6 minute videos, 6 quizzes, and a final exam

🖥️  Field of Study
      Computer Software & App

💼  CPEs
      5.0

📋  Prerequisites
      You should have a beginner knowledge of Excel (e.g. SUM, AVERAGE, Charts, etc.). We also recommend taking our Excel VBA Macros Bootcamp after which is a great complement to this course.

Access all courses starting at $25/month.

Corey

Corey is the owner of Wisdify.  He is passionate about learning and development, he loves helping people achieve their professional and personal goals. Corey is a big believer in the power of online learning and community with 15 years of finance and accounting experience.

Kelsey Murphy

Kelsey is Wisdify’s expert content developer. Taking feedback from our students, Kelsey creates extremely relevant blog posts and leads the development of Wisdify’s other free resources.

Prior to Wisdify, Kelsey worked as a business technology strategy consultant for Forrester, a global research and advisory firm. While there, she acted as project manager for numerous research-based consulting projects.

Kelsey earned a BA in Economics and Mathematics from Wellesley College.

Madison Bess

Madison oversees the social media strategy at Wisdify and makes sure we stay closely connected with our students, receive their feedback, and provide our students with valuable information.

Prior to Wisdify, Madison successfully ran the social media accounts for multiple companies. She also found time to start her own personal training company (which she still runs).

Madison earned a BA in English from Brigham Young University.

Maryn Coughran

Maryn is a co-founder and leads the marketing and outreach efforts at Wisdify. She ensures we are connecting with our customers, hearing their feedback, and then implementing their suggestions.

Prior to Wisdify, Maryn co-founded (along with Nate) BostonExcel, a Microsoft Excel training company that worked with dozens of companies in virtually every industry. Maryn’s clients included numerous Fortune 1000 companies, prestigious universities, startups and everything in between. She also happened to write and illustrate a children’s book. Let’s just say she’s a woman of many talents.

Maryn earned a BA in Economics from Wellesley College.

Joe

Joe is the owner of Wisdify.  He is passionate about learning and development, he loves helping people achieve their professional and personal goals. Joe is a big believer in the power of online learning and community with 20 years of finance and accounting experience.

 

The Buckaroos

Gwyn, Jack, and Kate are the adorable tow-heads that lead up Wisdify’s campaigns on cuteness, energy, and sleep-deprivation.