Advanced-Microsoft-Excel Course
3.2 (9 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.
859 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Advanced-Microsoft-Excel Course to your Wishlist.

Add to Wishlist

Advanced-Microsoft-Excel Course

Excel Advance Training with the some extra tips and tricks
3.2 (9 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.
859 students enrolled
Created by Mr.Sarwar Ahmed
Last updated 4/2016
Current price: $10 Original price: $20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
  • 2.5 hours on-demand video
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Will I Be Able To Keep Up
  • will be able to create a dashboard in excel
  • will be able to put formulas in excel
  • Will be able to create a data base sheet
  • Will bi able to use conditional formatting
  • Will be able to use and add new rules in excel sheet
View Curriculum
  • Excel
  • basic computer

The Advanced Excel training will help me get my job done very quickly and easily. The things that I used to take many hours will now take only a few minutes with the use of formulas, macros and other tricks I learnt in the Excel 2010 workshop Excel’s own language – VBA, allows us to give instructions to Excel to get things done. This is a simple, but extremely powerful way to extend Excel’s functionality. Advanced users of Excel are familiar with VBA & can write macros to automate their day to day work, thus saving countless hours of time & money. 

Formulas make Succeed intelligent. Without them, Succeed is just a knowledge maintaining device. But by using treatments, you can crisis information, evaluate it and get solutions to most complicated concerns. While anyone can use a simple SUM or IF system, a sophisticated customer of it would be able to easily create & merge treatments like SUMIFS, SUMPRODUCT, INDEX, MATCH, LOOKUP treatments. Apart from understanding the treatments, innovative Succeed customers know how to debug them, review them and how to use which system for which event (and they also know few options for any given system problem).

Excel has many powerful & advanced features packaged into it. Data tables: help us model practical problems & analyze massive amount of data for a solution. Solver: helps us model practical problems & find a solution by iterating thru all possibilities. For example, finding cheapest way to ship goods from one location to another.Simulations: We can simulate real world data & situations in Excel using various random functions & statistical methods.

Excel Advance Training

How to Create VBA?
How To Create Table in Excel using VBA?
How to create Code in VBA forms?
How to Create a Dashboard?

How to create a data base files? 

How to use count a and count if formulas?

How to Speed Up Your PC?

How to Get Free Keys Word Press Plugins?

How Earn Money FaceBook?


Who is the target audience?
  • Who know about computer or laptop work basic
  • Who Know excel basic
Students Who Viewed This Course Also Viewed
Curriculum For This Course
25 Lectures
Advanced Microsoft Excel Course
1 Lecture 05:23
Excel Advance Training
15 Lectures 01:32:15

Create from table in excel using VBA

Use the Excel Code here

Excel form code

How to add VB code in Excel user form?

Make maintinance file

How to use count if and count a

How to use countifs for free

How to give access in excel to multiple user

How to create a page break in excle sheet

Conditional formatting

Pivot Table with Chart



How to show Developer ribbon in excel?

How to Speed Up Your PC OR Laptop?
4 Lectures 16:27

Speed Up your PC

Speed Up your Laptop

Increase your Computer speed

Select below option which is the best answer 

How to Speed UP Your Laptop with Software?
1 question
Word Press Plugins
1 Lecture 08:01
Akismet WordPress
1 Lecture 05:01
Check Visa Status
Facebook Earning
1 Lecture 07:23
TSU Earning
2 Lectures 04:29
How to update Window 10

Window 10 Reset
About the Instructor
Mr.Sarwar Ahmed
3.9 Average rating
136 Reviews
8,037 Students
4 Courses
Graphic Designing ,SEO Expert & blogger,wordpress,Youtube,

Hi, this is Sarwar Ahmed a blogger, wordpress, Urdu video training online tips and tricks, instructor & Seo.

I am deeply involved in making money online, I love to provide online tips and tricks with practically explain how to earn online money with different ways. I do have knowledge about SEO, blogger, wordpress, PPC, and google adsense.

The reason I'm here on Udemy is to provide high quality courses which can be useful and practical for students, I've been creating courses which have turned students into web developers and newbies into entrepreneurs. I try to create courses for students which can change their life.

Do join my courses on Udemy, I'll always be around you for help and support because I know the reason you want to join a course. I do interact with students in a real time world. Best of luck!


Sarwar Ahmed