Skip to main content
by learnformula
search
For Business
Team license & compliance management
For Higher Education
Academic partnerships
For Government Agencies
Government training solutions
For Instructors & Course Creators
Teach on our marketplace
Become a Sponsor
Reach professionals where they learn
Log inStart 7-Day Free TrialStart Free TrialStart Free Trial
search
  1. Courses
  2. /Office Productivity
  3. /MS Excel

Excel - Solver

Gain a Deep Understanding of Solver, Learn how Solver works under the Hood

Created byPannaga Kasbe
IntermediateUpdated Oct 30, 2019

What You'll Learn

  • check_circleUnderstand how Excel Solver works.
  • check_circleSolve real-world optimization problems.
  • check_circleUse Goal Seek effectively.
  • check_circleExplore Solver integration with VBA.
  • check_circleApply advanced Excel tips and tricks.
  • check_circleImprove data analysis and decision-making skills.

About This Course

Welcome to the Excel Solver course—your practical guide to mastering one of Excel’s most powerful problem-solving tools. Solver is widely used to tackle complex scenarios that require analytical thinking and multiple iterations. In this course, you’ll gain not just functional knowledge of Solver, but a deeper understanding of how it works behind the scenes. You’ll explore real-world applications and develop confidence in using Solver for business decisions and optimization challenges.

In addition to Solver, the course covers complementary tools like Goal Seek, along with valuable Excel tips and tricks to boost your overall productivity. You’ll also learn how to enhance Solver’s capabilities using VBA for more dynamic and automated solutions. Whether you're a beginner or looking to refine your skills, this course equips you with the tools to take your Excel problem-solving to the next level.

Course Content

13 activities • 44 videos • duration: 1h 24m

remove
Section 1 - Solver Intro-Part11 videos • 1 min
  • videocamSolver Intro
    Duration 1:14
add
Section 2 - Understanding Excel-Part14 videos • 9 min
add
Section 3 - Goal Seek-Part16 videos • 8 min
add
Section 4 - Understanding Solver-Part13 videos • 5 min
add
Section 5 - Solver Problem 1-Part15 videos • 16 min
add
Section 6 - Solver Problem 2-Part13 videos • 7 min
add
Section 7 - Solver Problem 3-Part14 videos • 3 min
add
Section 8 - Solver problem 4-Part14 videos • 5 min
add
Section 9 - VBA Intro-Part11 videos • 3 min
add
Section 10 - Solver Problem 5-Part15 videos • 9 min
add
Section 11 - Solver Problem 6-Part11 videos • 5 min
add
Section 12 - Solver Problem 7-Part14 videos • 4 min
add
Section 13 - Excel Tips and Tricks-Part13 videos • 3 min

Your Instructor

Pannaga Kasbe

Avid math lover And Entrepreneur

menu_book1 courses
star71 reviews

She has a Bachelor in Engineering in Electrical & Electronics and also Certified Professional in Electrical Cadd. Technically skilled in AutoCAD, Revit-MEP, Primavera-P6. She was always fascinated by mathematics and secured 3rd Rank in school level in “Mathematica-2002” Maths Talent Examination.She truly enjoys sharing her knowledge with others and from her early twenties she has been teaching courses in mathematics. She has received an Award of appreciation from Emats All India General Knowledge Test in 2002 & 2003. Having secured outstanding grade in NIIT@School in 2004, she has been involved in the design and implementation of mobile apps, desktop applications. She has a keen interest in learning new languages, an avid bookworm and a passionate photographer. Being a socially active person, she followed her passion to learn more about humanity and social science for which she got certification by Universiteit Gent, Belgium.

Credit Information

Is this course eligible for my CPD requirements as a Canadian CPA?

Provincial regulators of CPAs in Canada do not require that independent providers of CPD be approved to offer courses. Instead, individual CPAs are responsible for assessing whether a CPD activity meets their requirements, and may take activities from any source provided those requirements are met.

Every course offered on LearnFormula is delivered by a qualified subject matter expert or learning organization, and advances learning objectives that are relevant to the responsibilities or professional competencies of Canadian CPAs. All activities on LearnFormula are quantifiable in terms of hours, and are also verifiable, in that users receive documented evidence of their attendance via a certificate of completion after finishing a course (and this certificate is stored by LearnFormula indefinitely). Nearly 100,000 Canadian CPAs successfully satisfy their CPD requirements via LearnFormula on an annual basis.

What Students Are Saying

4.5 out of 5
Student's Choice
71 reviews
  • IM
    Ida M.
    starstarstarstarstar

    The subject matter requires more than 1.5 hours for certain users.

Frequently Asked Questions

We are a registered provider with 300+ associations and regulatory bodies worldwide. We operate across 27 global markets including Canada, the US, Australia, and the UK. Every course page clearly displays its specific accreditations. Upon completion, you receive a professional certificate that can be validated online. Our certificates include all necessary accreditation details, credit hours, and completion dates, and are formatted specifically to meet the submission requirements of most global regulatory bodies.

You May Also Like

  • Ethics: Business Ethics

    2026 Ethics and Corporate Compliance

    starRated5.0out of 5,(556 reviews)
    2 CPD hrs
  • Finance: Budgeting & Financial Forecasting

    Critical Skills for CFOs & Controllers: Budgeting & Forecasting Strategies for Today’s World

    starRated5.0out of 5,(113 reviews)
    2.5 CPD hrs
  • Accounting & Tax: Technology for Accountants

    Claude Fundamentals for Accountants (2026 Update)

    starRated5.0out of 5,(646 reviews)
    2.5 CPD hrs