CONSULTEASE.COM

Sign In

Microsoft Excel - Advance course

Microsoft Excel - Advance course

Created by Anshuman Tandon,
 
Get instant access to this course
₹1,500 ₹599 * GST Extra
Buy this course

This Course Includes

  • 12+ Hours
  • No limitation on views
  • Hindi
  • Yes
  • No Exam

Questions? We're just a call away...
Have any questions about the course? Just reach out to us.

+91 9625740572shikha@consultease.com

Microsoft Excel - Advance course
Microsoft Excel - Advance course

 

About Microsoft Excel - Advance course

It's time to change the way you look into Excel. If you're a professional, who uses (or will be using Microsoft Excel) on a daily basis, this is the course for you!



This course is going to transform the way you are using Excel by giving you an advanced understanding of Microsoft Excel, by which you will be able to solve complex problems in Excel very easily & here, problems not only means the difficulties you are facing but it includes complex calculations & reporting you to have to do at your workplace



Why this course is worth joining??





This course worth your attention, because in this course we are going to make those things possible in Excel which seems nearly impossible to you till now, also we will be solving complex problems live in this course by using Excel Formulas so that your vision of using formulas will be changed, after that, we will see how experts work in Excel to reduce their hours of working using Excel features like Advance Pivot Table, Data Validation & especially the best feature of Excel which is Excel VBA (Macros), I am going to teach you how to THINK & TRANSFORM Excel


Course Schedule

Profile photo of Anshuman Tandon
1.1

Advance Formulas & Tricks (1)

Expert - Anshuman Tandon

All Excel Important Formulas Tricks: Financial Formulas Logical Formulas Text Formulas Date Fo

All Excel Important Formulas Tricks:

  • Financial Formulas
  • Logical Formulas
  • Text Formulas
  • Date Formulas
  • Lookup Formulas
Read more
01 hour 55 min 30 sec
23 rd May, 2021
Profile photo of Anshuman Tandon
2.1

Advance Formulas & Tricks (2)

Expert - Anshuman Tandon

All Excel Important Formulas Tricks: Financial Formulas Logical Formulas Text Formulas Date Fo

All Excel Important Formulas Tricks:

  • Financial Formulas
  • Logical Formulas
  • Text Formulas
  • Date Formulas
  • Lookup Formulas
Read more
02 hour
29 th May, 2021
Profile photo of Anshuman Tandon
3.1

Advance Excel Tricks (1)

Expert - Anshuman Tandon

Different Examples & Tricks ( Advance Excel ) Include Tricks suing Pivot Table, Advance Filters, Data Validation etc.

Different Examples & Tricks ( Advance Excel )

  • Include Tricks suing Pivot Table, Advance Filters, Data Validation etc.
Read more
02 hour 14 min 43 sec
30 th May, 2021
Profile photo of Anshuman Tandon
4.1

Advance Excel Trick (2)

Expert - Anshuman Tandon

Different Examples & Tricks ( Advance Excel ) Include Tricks suing Pivot Table, Advance Filters, Data Validation etc.

Different Examples & Tricks ( Advance Excel )

  • Include Tricks suing Pivot Table, Advance Filters, Data Validation etc.
Read more
02 hour 04 min 23 sec
06 th Jun, 2021
Profile photo of Anshuman Tandon
5.1

Excel VBA

Expert - Anshuman Tandon

Lear Hou to use Macros Examples & Tricks of VBA code

Lear Hou to use Macros

  • Examples & Tricks of VBA code
Read more
02 hour
15 th Jun, 2021
Profile photo of Anshuman Tandon
6.1

Excel VBA Forms

Expert - Anshuman Tandon

Learn to develop data entry form in Excel VBA  All types of forms control are included

Learn to develop data entry form in Excel VBA 

  • All types of forms control are included
Read more
01 hour 13 min 23 sec
20 th Jun, 2021

Experts/instructors panel

 

Course features

Salient features of Microsoft Excel - Advance Excel Course:-

1. Completely online, no bar on access. You can access it anytime and from anywhere

2. Everything is discussed with an example & detailed cases so that practical situations. Issues in its applicability faced by the industries and businesses are covered and discussed with solution

3. Working Files are shared so that it will be easy for the students to perform their practice

4. Every aspect is discussed with practical files & real-life problems

5. A lot of tricks & cases are discussed so that way of using Excel can be changed


 

Areas covered

All Excel important formulas tricks




  • Financial Formulas

  • Logical Formulas

  • Text Formulas

  • Date Formulas

  • Lookup Formulas



Different Examples & Tricks




  •   Include tricks of suing Pivot Table, Advance Filters, Data Validation, etc



Learn How to use Macros




  • Examples & Tricks of VBA Codes



Learn to develop data entry forms in Excel VBA




  •  All types of forms control are included



 


Course creator

Mr. Anshuman Tandon is an Excel Expert, he is the founder of Excel Man, an online platform to teach MS Office & Google softwares to all professionals, he had worked as a Tax Specialist at Masters India Pvt Ltd a GST Suvidha Provider, & had worked with concerns like Flipkart, Hindware, Maruti Suzuki, L&T & India Mart in dealing their GST related tasks & resolving their queries, he has also worked with over 180 MSMEs in dealing their day to day GST related queries & work all over India He has also worked in Jaypee Brothers Medical Publishers Pvt Ltd as a Senior Executive Finance a well-known medical publisher of India & dealt their top management reporting He is having a total of 10 years experience in MS office products & has expertise in all of them, he had taught MS Excel to over 2000 professionals in the past year Currently, he is working as a Manager - Taxation in Alde Medi Impex Ltd a well known Medicine Manufacturer in India

Get instant access to this course
₹1,500 ₹599 * GST Extra
Buy this course

This Course Includes

  • 12+ Hours
  • No limitation on views
  • Hindi
  • Yes
  • No Exam

Questions? We're just a call away...
Have any questions about the course? Just reach out to us.

+91 9625740572shikha@consultease.com

Easy to use Dashboard Interface

chat icon chat icon chat icon chat icon

Get your questions answered

Watch anytime, any number of times

Download all associated documents

Test your skills and get CE Certified

Other courses of your interest

Card image cap
Card image cap
Card image cap
Card image cap
Card image cap

Easy to use Dashboard Interface

chat icon chat icon chat icon chat icon

Get your questions answered

Watch anytime, any number of times

Download all associated documents

Test your skills and get CE Certified

Other courses of your interest

Card image cap
Card image cap
Card image cap
Card image cap
Card image cap