Excel 2013: Advanced Macro with Goal seek, Solver & More !
4.4 (7 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.
611 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel 2013: Advanced Macro with Goal seek, Solver & More ! to your Wishlist.

Add to Wishlist

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.4 (7 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.
611 students enrolled
Created by Rit Shrestha
Last updated 8/2015
English
Current price: $10 Original price: $60 Discount: 83% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1 hour on-demand video
  • 2 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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.
View Curriculum
Requirements
  • Excel 2007/2010/2013(recommended)
  • Basic knowledge of Excel.
  • Willingness to learn advance features in Excel.
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)
Who 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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
28 Lectures
01:05:16
+
Introduction
1 Lecture 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.

Preview 02:04
+
Macro automation : Fundamentals
5 Lectures 07:40

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

Preview 00:45

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

Preview 00:38

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

Preview 02:15

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

Assigning macro to shape/buttons.
00:47

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

Absolute vs relative reference during macro recording.
03:15
+
Macro automation : Loops in depth
4 Lectures 08:08

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

For Next - Loop.
02:30

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

Do Until - Loop
01:44

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

Do While - Loop
00:53

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

Live digital clock in a cell using Do While Loop !
03:01
+
Macro automation : An ultimate solution with macro !
6 Lectures 11:29

Macro recording process explained.
04:07

Editing macro code and applying loops.
03:20

Finalizing the code for neat and clean report.
02:22


Codes for this section
3 pages
+
What if Analysis: Goal seek with macro automation.
7 Lectures 16:46

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

Simple Goal Seek model
01:48

Goal Seek in action to solve simple problem
01:25


Product pricing with goal seek
01:57

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

Automating product pricing with macro
06:53


Codes for this section.
1 page
+
Using solver to solve problems.
5 Lectures 15:09

Learn how to enable solver add in in Microsoft Excel.

Enabling solver add-in.
00:57

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

Formulation of solver model for optimal production plan.
03:40

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

Solver in action to solve optimal production decision.
04:12

Learn how to solve Sudoku using excel solver add in.

Model formulation to solve an interesting Sudoku.
04:00

Solver in action to solve sudoku
02:20
About the Instructor
Rit Shrestha
4.4 Average rating
7 Reviews
611 Students
1 Course
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.