https://www.clickmagick.com/user/links/?page=1
EXCEL MASTERY COURSE 
Learn the World's most Powerful reporting tool
BECOME AN EXCEL EXPERT
Nowadays EXCEL is a mandatory tool. Learning Excel in a proper, structured way can not only help you save time, but also help you become better at your job and can give you time to focus on the right thing.

This course is designed by Mr. Hamid Tarafder based on his 12 + years of experience in MS Excel, Data Analysis and other financial areas .

This course is beneficial from Freshers to Working professionals .

What are some Excel Tools and Functions you will Learn in this Course ?
                                                                                                       
* How to clean and prepare data by sort, Filter , Find, Replace , Remove Duplicates.

* The most useful Excel functions like SUBTOTAL, SUMIF,SUMIFS, IF,IFS,COUNTA,COUNTIFS.

* How to write advanced Excel formulas by VLOOKUP, HLOOKUP, XLOOKUP INDEX AND MATCH FUNCTIONS.

* Excel Pivot Tables so you can quickly get insights from your data. 
                               
* How to create interactive dashboards in Excel by using Slicer and Pivot Charts.
     
* How to create various Excel Charts and designs.
                                                                
*  Work in Excel faster by using HOT KEY SHORTCUTS.
                                                     
* Quizzes and Practice sheets for each Chapter. 
                                    
* Uses of MACRO , Flash Fill & Concatenate.

* PMT, IPMT, PPMT Formula.

 
   
                                                                                                                                               




Here's What You Are Getting...
When you complete the transaction today, you'll get
EXCEL MASTERY COURSE
50+ Hindi Tutorials + Free Practice Sheets + Quiz for each chapter
Selling Price

₹1999/-
Diwali Offer Price
499/-
LIMITED TIME ONLY.



Lock Your Spot Now
Here's What You're Getting:
  • HIGH QUALITY HINDI TUTORIALS - Learn Excel from Basic to Advanced Level. 
  • LIFETIME COURSE ACCESS
  • QUIZ FOR EACH CHAPTER 
  • FREE PRACTICE SHEETS FOR EACH CHAPTER 
  • COURSE  COMPLETION CERTIFICATE 
Total Real Value: ₹1999/-
₹499/- Right Now!
(You Save: ₹1500/-)
This is a LIMITED TIME offer. Will Be Closing Soon
DO NOT MISS YOUR CHANCE - LOCK IN NOW!

Curriculum

CHAPTER 1

  • Introduction
  • Basics: Workbook, Title bar, Ribbon ,Tab, Formula Bar, Row, Column, Save , Save as
  • Basics : Heading , Merge & Centre, Wrap Text, Format Cells, Border , Cell Colour, Font Changing, Allignment, Cut, Copy, Paste.
  • ​Basics : Number Formatting, Percentage, Comma, Decimal increase & decrease, Short Date, Long Date , Time.
  • ​Basics: Basic Formulas, Sum, Relative referencing, Absolute referencing
  • ​Quiz
  • ​Practice Sheets

CHAPTER 2

  • Auto sum, Fill, Clear Function
  • Sort Function
  • Navigation
  • ​Quiz
  • ​Practice Sheets

CHAPTER 3

  • Flash Fill Command with Examples
  • Page Layout, Printing Functions
  • Date
  • ​Concatenate
  • ​Quiz
  • ​Practice Sheets

CHAPTER 4

  • Conditional Formatting
  • ​Filter Function with Shortcut key
  • Advance Filter
  • ​Text Functions
  • ​Right Tick and Cross Tick with Conditional Formatting
  • Quiz
  • ​Practice Sheets

CHAPTER 5

  • Count, CountA, CountIF, CountIFS
  •  IF,IFAND,IFOR Function
  • ​IFS with IFSERROR Function
  • SUMIF and SUMIFS
  • ​Quiz
  • ​Practice Sheets

CHAPTER 6

  • VLOOKUP_Exact Match
  • VLOOKUP_Approx Match
  • VLOOKUP With IFERROR
  • ​VLOOKUP With Subtotal, Average, Min, Max, Data Validation
  • ​Use of Double VLOOKUP
  • ​Quiz 
  • ​Practice Sheets

CHAPTER 7

  • PIVOT Table
  • PIVOT Chart
  • PIVOT Slicer
  • ​PIVOT Table with IF Function
  • ​Page Layout in PIVOT Table
  • ​Create Group in Pivot Table
  • ​Other Functions of Pivot Table
  • ​Quiz
  • ​Practice Sheets

CHAPTER 8

  • Chart 1
  • Chart 2
  • Chart 3
  • ​Quiz
  • ​Practice Sheets

CHAPTER 9

  • PMT,IPMT,PPMT Formula
  • Round, Roundup, Rounddown, MRound
  • INDEX and MATCH
  • ​HLOOKUP Function
  • ​XLOOKUP Function
  • ​Two way Lookup With XLOOKUP
  • ​Quiz
  • ​Practice Sheets

CHAPTER 10

  • MACRO_Example 1
  • MACRO_Example 2
  • How to use BUTTON in Macro
  • ​Quiz
  • ​Practice Sheets

CHAPTER 11

  • DGET Function
  • Five Important Excel Shortcuts
  • Five most usable Excel Shortcuts
  • ​MS EXCEL Shortcut Keys
  • ​How to find duplicate values-Three Tricks
  • ​Quiz
  • ​Practice Sheets

CHECK OUT SOME REVIEWS FROM STUDENTS OF EXCEL MASTERY COURSE

                                     
# Priyanka Paul : I have gone through this course, very useful. Thank you.

# Sanket Chakraborty : Very useful Course. It helped me a lot in my professional career.

# Chandan Dey : Very good and useful course for everyone.

# Niamul Sanjavi : Very useful and nice course for people like us who have to use excel on day to day basis. A must course for everyone.

# Amrita Sinha : Could not have asked for anything better. I found this excel course very helpful in my work place .I have gained a lot from this course. Looking forward for more such courses from you.

#Arindam Roy : Useful for everyone. I have purchased it and found it very helpful. I recommended others to purchased it also.

# Baishaki Kargupta : I really happy to get it.

# Ashim Mandal : I have bought this course. Awesome content.

# Prof. Samprit Chakraborty : Good content. Benefited from this course.


MEET YOUR COACH


Hi,  I am Hamid Tarafder. Your Coach and Mentor.
I have 12+ years of working experience as a Finance Manager in various Industries. During my whole career i have been using Excel and other Business Intelligence tools. If you want to become an Excel expert , follow my courses.

I have a mission to help 1,00,000 students find their path to success. I wanted to create a Virtual place where students will come and buy the courses they need and want to explore. As a result, I have created Hamid’s Smart Learning HUB.

Follow me on my Socials

 
All of our terms, privacy policies and disclaimers for this program and website can be accessed via the link above.

We feel transparency is important and we hold ourselves (and you) to a high standard of integrity. Thanks for stopping by.

We hope this training and content brings you a lot of value.
Hamid's Smart Learning HUB  2020 
Private Policy