Excel 2013: Advanced Macro with Goal seek, Solver & More !

Learn macro to automate process in excel. Use goal seek, solver, functions & features for better productivity in office.
4.5 (8 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
601 students enrolled
$19
$60
68% off
Take This Course
  • Lectures 28
  • Length 1 hour
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 8/2015 English

Course Description

If you spend your few hours with this course, you will definitely see increase in your day to day work productivity with in a week. Using excel programming features like Macro, goal seek and Solver are the best way to decrease your repetitive manual working time and impress your boss, colleagues and friends.

Course Highlights:

  1. Start Macro recording to automate the process and calculations.
  2. Use VBA editor to make changes in macro code.
  3. Learn loops to repeat the process till you want.
  4. Many practical problems solved with macro.
  5. Learn using solver Add in to solve optimization problems.
  6. Learn Goal seek with macro to automate the pricing process of products.
  7. Ask any problems you face in your day to day work in Excel (I am always available for help)

What are the requirements?

  • Excel 2007/2010/2013(recommended)
  • Basic knowledge of Excel.
  • Willingness to learn advance features in Excel.

What am I going to get from this course?

  • Record macro to automate the task.
  • Use Visual Basic Editor (VBE) to edit your macro code.
  • Use loops in macro code to repeat the process again and again.
  • Use Goal Seek to prepare product costing and pricing.
  • Use macro with goal seek to automate the process of pricing of products.
  • Use solver add in to solve complex problems.
  • Use advanced functions and techniques in excel for better productivity.
  • Solution to your any question (ask any time) in discussion part or my personal email address.

What is the target audience?

  • Any person working in office who use basic features of Excel.
  • Students of all level.
  • Self employed business man.
  • Professional accountants, business man.
  • Business entrepreneur.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction
02:04

In this video, student will see the overall contents of this course. Recording Macro in Excel, manipulation of macro code in VBA editor in excel, applying loops in VBA code, solving optimization problems using goal seek, solver are the key contents of this course. The main objective of this course is to teach advanced macro in Microsoft Excel to automate the process of any repetitive task.

Section 2: Macro automation : Fundamentals
00:45

Student will learn how to enable developer tab in Microsoft excel.

00:38

Student will learn various methods of recording macro like using developer tab, view tab and status bar.

02:15

Student will learn how to record first macro in Microsoft Excel.

00:47

Learn how to assign macro to button or shape in Microsoft Excel.

03:15

Learn difference between absolute and relative reference in macro code in Excel VBA programming.

Section 3: Macro automation : Loops in depth
02:30

Learn how to use for next loop in macro code in Excel.

01:44

Learn how to use Do Until loop in Excel macro code.

00:53

Learn how to use Do While Loop in Excel macro code.

03:01

Learn how to use vba code to design live clock in excel single cell.

Section 4: Macro automation : An ultimate solution with macro !
Available information and required result.
Preview
00:57
Macro recording process explained.
04:07
Editing macro code and applying loops.
03:20
Finalizing the code for neat and clean report.
02:22
Assigning macro to a shape for final result.
Preview
00:43
Codes for this section
3 pages
Section 5: What if Analysis: Goal seek with macro automation.
01:48

Learn how to use goal seek to find out any specific value from a excel model.

Goal Seek in action to solve simple problem
01:25
Business process and price structure of trading business.
Preview
02:16
Product pricing with goal seek
01:57
06:53

How to use macro code with goal seek features in Excel.

Using shape button to run recorded macro.
Preview
02:27
Codes for this section.
1 page
Section 6: Using solver to solve problems.
00:57

Learn how to enable solver add in in Microsoft Excel.

03:40

Learn how to formulate excel solver model to solve any optimization problems.

04:12

Watch how solver model works to solve optimization problems like optimum product quantity, etc.

04:00

Learn how to solve Sudoku using excel solver add in.

Solver in action to solve sudoku
02:20

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Rit Shrestha, Chartered Accountant

Hi, I am Rit Shrestha, a qualified chartered accountant. Teaching and motivating my students in using smart way of working in Microsoft Excel is my passion. I have been continuously using Excel functions, features and macro with VBA code since past 7 years in my accounting, finance and taxation career. I have expert level knowledge in Microsoft Excel, Access and many accounting software. I am providing various services as an instructor, tax consultant and financial manager in various group of companies and individuals.

Ready to start learning?
Take This Course