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.3 (19 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.
573 students enrolled
Take This Course
  • Lectures 56
  • Length 6.5 hours
  • 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


Find online courses made by experts from around the world.


Take your courses with you and learn anywhere, anytime.


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

About This Course

Published 6/2016 English

Course Description

***** 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 !

What are the requirements?

  • existing user of excel is an ideal student for this course

What am I going to get from this course?

  • 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

Who is the target audience?

  • New users, beginners, intermediates and advanced Excel users

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.


Section 1: Introduction

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

Section 2: Fill Series & Excel Key Shortcuts

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

Editing Custom List
Excel Short keys & Golden Key
Introduction to Absolute & Relative References (Fixed & Variable)
Section 3: The Marksheet
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
Section 4: Sales & Bonus Report
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
Section 5: The Aged Debtors Analysis
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
Section 6: Live Aging Analysis
Live Aging
Section 7: Advance Search Tricks
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
Section 8: Advance Analysis Tricks
Sum If and IFS
Forget filters - use DSUM Search Box
Amazing Advance Filters & Macros
Section 9: Pivot Table & Dashboard Reporting
Introduction to Pivot tables
Grouping In Pivot Tables
Calculated Fields
Pivot Charts
Dashboard Reporting
Section 10: Some Other Amazing Tricks & Time Savers
Automated Cheque Printing System (Using Mail Merge)
Introduction to Hyperlinks
Hyperlinks With External Sheet Refrences
Columns Seperation & Concatenation
Excel Flash Fill Saves The day

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Saad Nadeem, Financial Analyst & Software Trainer at Udemy

Hello friends. My name is Saad Nadeem and i am enthusiastic excel lover from a very long time. 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 leading ultimately of forming up my own professional training institute named  Accountech Training & Solutions. We have trained over 500 students successfully on different accounting softwares.

Excel is Amazing if you talk about its powerful tools. In my journey to Excel of training a lots of students & corporate professionals even in Big companies. I have noticed that in lots of situation excel is being underutilized which decreases your working efficiency. I have developed such an amazing tricks that i can proudly say. "If there is only one laziest person on the earth & that is you" then excel is for you ;) 

Now its my turn to teach YOU the power of Excel with these high quality and easy to understand tutorials!

My aim is to get you to become comfortable & confident in Excel and use its power to make your job a lot easier & more efficient, create interactive reports that will reach top management and ultimately make you stand out from your colleagues and get that promotion or pay rise that you deserve!

Ready to start learning?
Take This Course