Buying for a Team? Gift This Course
Wishlisted Wishlist

Please confirm that you want to add Advance Excel Project Based Training to your Wishlist.

Add to Wishlist

Advance Excel Project Based Training

Amazing Advance Excel injection that make you stand out of the crowd. if you are lazy in reporting, excel is for you
4.0 (21 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.
578 students enrolled
Created by Saad Nadeem
Last updated 11/2016
$10 $60 83% off
4 days left at this price!
30-Day Money-Back Guarantee
  • 6.5 hours on-demand video
  • 21 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?

***** COURSE UPDATED: July 2016 *****

If you have already been using Microsoft Excel then you know that the calculation, graphing and tables available help you track, manipulate and report important data. There is more to excel than a few SUMs, though, and this is the training course to get you into the advanced uses of Excel so you can really use the data and numbers you are tracking to your advantage.

No matter if you are beginner or existing user of excel , this course is suitable both. It will improve your skills and open the hidden secrets and wonders of excel possibilities with this versatile spreadsheet program. In this course we will discuss and bring your excel knowledge & skills to the next level.

The course is tremendously comprehensive and the best part is you will learn advance functionalities in small chunks of real practical industry scenario based assignments that is easier for you to digest and follow along

The Ultimate Excel course over 60+ precise videos. Not by discussing only the functionalities but discussing the functionalities and possibilities in excel while doing a real client project.

 In this course I have provided you with free downloadable Excel workbooks for each tutorial

I have been helping thousands of people further their careers by teaching them Excel the easiest and most comfortable way. These tutorials will give you career-building skills that you can use to become better and more efficient at your job.

The Ability to Master Excel

By the end of this course you will be able to grasp most of the excel advance features that excel amazing tools has to offer. Which enables you to get more power and incredibly reducing you time & effort by increasing your efficiency in data analysis & reporting tasks

What is the target audience?

  • New users, beginners, intermediates and advanced Excel users

What am I going to get from this course?

  • Over 60 lectures and 6 hours of content!
  • Well-designed and easy-to-understand materials
  • Detailed explanations with comprehensible Case Studies based on real situations
  • Downloadable course materials & Workbooks to follow along
  • Lifetime Access to all the lectures on the course.
  • Regular Video updates!
  • Fast and responsive support for any feedback or questions !
  • If you're not Satisfied, there's a 30 day money back guarantee !

By the completion of this course you will:

  • Work comfortably with Microsoft Excel and many of its advanced features
  • Become one of the top Excel users in your team
  • Be much quicker at carrying out regular tasks
  • Know how to create a model with multiple scenarios


Learning Excel if you are completely new to excel , becoming an excel guru is very easy. But it takes effort & continuous practice. For that we have provided compressive project based assignments videos with downloadable workbooks to follow along. Watch the lectures , try dong that by yourself, pause where ever it is required. But don't try to take it in all at once.

If you feel like you can do 1 section a week, do 1 section a week.

If you have time, do 1 section a day.

But don't stress out.

Best of Luck with Your amazing journey of unfolding unlimited possibilities of excel !

Who is the target audience?
  • New users, beginners, intermediates and advanced Excel users
Students Who Viewed This Course Also Viewed
What Will I Learn?
work comfortably with Microsoft excel and many of its advance features
Become one of the top Excel users in your team
Be much quicker at carrying out regular tasks
Know how to create a model with multiple scenarios
View Curriculum
  • existing user of excel is an ideal student for this course
Curriculum For This Course
Expand All 56 Lectures Collapse All 56 Lectures 06:32:04
1 Lecture 00:46

This video contains a basic introduction is all about and what is the benefit of using excel , as it is very useful tool for each individual

Preview 00:46
Fill Series & Excel Key Shortcuts
4 Lectures 22:37

Fill series plays a vital role in reducing your time and effort to write the values when in series by yourself, you can even drag the formula with a double click

Preview 07:35

The Marksheet
12 Lectures 01:06:51
The Marksheet

Random Number Generation

Clearing Formula With Intact Values

Key Components of Marksheet

Introduction to IF-Then Conditions

Nested IF's (Looping Function)

Ranking Positions

Conditional Formatting & Data Bars

Freeze Panes

Table Formatting & Range Conversion

Sort & Filters

Max Min Average Countblank Count if and Much More
Sales & Bonus Report
8 Lectures 57:06
Prepare a Sales and Bonus Report With Manual Totalling

Grouping and Auto totalling

Hiding and Unhiding Rows Grouping and Auto Totalling

Removing Duplicates and Sales Summary With Sum if Function

Understanding Absolute and Relative Refrencing

Applying Sumif With Absolute and Relative Refrencing

Sumif with External Sheet Refrences

IF Conditions With Multiple Logics
The Aged Debtors Analysis
8 Lectures 01:11:56
Introduction to Aged Debtors Analysis

Arranging the data to get Started

Automate data arrangement

Quick Trick Formatting

Conditional formatting Advance

Applying Advance Formatting Tricks

Formula Analysis for Aging

Absolute , Relative Functions & Date values
Live Aging Analysis
1 Lecture 08:06
Advance Search Tricks
9 Lectures 59:17
Introduction to Vlookup

Using Named Ranges and IF ERROR

Simplifying Even More With data Validation

Using Combo Boxes

The Hlookup Function

Lookup for Inverse Data

Introduction To Index Match

Quiz Assignment Remington Pharma Explanation

Invoicing System Remington Pharmaceuticals
Advance Analysis Tricks
3 Lectures 33:22
Sum If and IFS

Forget filters - use DSUM Search Box

Amazing Advance Filters & Macros
Pivot Table & Dashboard Reporting
5 Lectures 41:27
Introduction to Pivot tables

Grouping In Pivot Tables

Calculated Fields

Pivot Charts

Dashboard Reporting
Some Other Amazing Tricks & Time Savers
5 Lectures 30:36
Automated Cheque Printing System (Using Mail Merge)

Introduction to Hyperlinks

Hyperlinks With External Sheet Refrences

Columns Seperation & Concatenation

Excel Flash Fill Saves The day
About the Instructor
4.0 Average rating
21 Reviews
578 Students
1 Course
Financial Analyst & Software Trainer at Udemy

Hello friends. My name is Saad Nadeem, I hold a professional Qualification ACCA ( Associate Charted Certified Accountant) Qualified having over 7 years of experience in diversified field of accountancy, management and corporate training .I have trained over 500 students successfully on different accounting software's.

This has been the basis of my entire career – as an Accountant, as a corporate trainer, and as a software consultant – over the past 7 years. I spend half my time in the world of business, explaining complex technical topics to business owners and stakeholders so that they can understand and agree with my approach to solving their business problems with technical solutions. And the other half with developers, explaining the business reasons behind decisions and ensuring that any decisions made on the technical side don't restrict the business in unexpected ways.

And I'm here on Udemy to teach what I know in an approachable way. I started teaching courses on personal level, and now with power of online training i have taught over 7,000+ students on that subject since then. 

Please don't hesitate to drop me a message if you have a suggestion for a topic for one of my courses, or need help with something. I may not always be able to help you directly, but I would still love to talk to you !

Report Abuse