CONSULTEASE.COM

Sign In

Microsoft Excel Certification Course for Beginners to Intermediate

Created by Anshuman Tandon,
5 (1 ratings)  
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

 

About Microsoft Excel Certification Course for Beginners to Intermediate

It's time to show who's the boss. Whether you're starting from scratch or you want to become a pro-Excel user, you've come to the right place.



This course is going to give you a detailed understanding of Microsoft Excel, & after that, we are going to discuss formulas and functions that transform your Excel spreadsheet from a normal worksheet into a reliable, dynamic, and powerful tool. 



Why this course is worth joining?



This course worth your attention, because most of the Excel courses will teach you simply what each feature & formula of Excel does, however, I am going to teach you contextual examples which are designed to show you why these features & formulas are super awesome & the process of how they can be applied in various ways to transform Excel into anything you want. I will train you not only to record data & use formulas, but I am also going to teach you how to THINK & TRANSFORM Excel.



By the completion of the course you'll be able to:



1. Start using Excel as a tool of your journey towards success

2. Writing robots dynamic Excel Formulas

3. Easy build dynamic reports in Excel

4. Design your own Excel Formula to define your needs

5. Become the boss and design your own formula-based Excel formatting rules

6. Join datasets from multiple sources with Excel's LOOKUP, INDEX & MATCH functions

7. Manipulate dates, times, text, and arrays

8. Maintain large sets of Excel data in the way you want

9. Use Excel 100 Times faster by mastering Excel Shortcuts

10. Make dynamic reports wth features of reducing errors by using Data Validation

11. Use Excel as an Analytics tool by using Filters & Pivot Tables

12. Understand how Excel understand you to feel its power



Eligibility: Find eligibility criteria to learn Microsoft Excel online



Although there are no fixed eligibility criteria but deep desire to learn Excel is required. With this, anyone with the very basic knowledge of using a computer can join as we are going to start from very scratch



Duration: Course duration for this certificate course on Excel Course



The course continues 10 hours of videos and Excel Exercise Workbooks



Features: Unlock your maximum potential on Excel with our online 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


Course Schedule

Profile photo of Anshuman Tandon
1.1

Basics of Excel

Expert - Anshuman Tandon

Things you need to know to start your journey with Excel Making you familiar with Excel Application Features,

  • Things you need to know to start your journey
    with Excel
  • Making you familiar with Excel Application
  • Features, Structure & Formulas available in Excel
  • Points to note to work with Data & Cells in Excel
Read more
01 hour 57 min 56 sec
17 th Apr, 2021
Profile photo of Anshuman Tandon
2.1

101 Shortcuts

Expert - Anshuman Tandon

All Excel important shortcuts to note How to increase speed of using Excel Way to find Shortcut of anything in Excel

  • All Excel important shortcuts to note
  • How to increase speed of using Excel
  • Way to find Shortcut of anything in Excel
Read more
01 hour 49 min 09 sec
18 th Apr, 2021
Profile photo of Anshuman Tandon
3.1

All Excel important formulas

Expert - Anshuman Tandon

All Excel important formulas Financial Formulas Logical Formulas Text Formulas Date Formulas

All Excel important formulas

  • Financial Formulas
  • Logical Formulas
  • Text Formulas
  • Date Formulas
  • Lookup Formulas
  • How to create a formula for your specific use
Read more
01 hour 48 min 11 sec
25 th Apr, 2021
Profile photo of Anshuman Tandon
4.1

Filter & Pivot Table

Expert - Anshuman Tandon

How to use Filters & Tables How to use Pivot Table Basics & Advance

  • How to use Filters & Tables
  • How to use Pivot Table
  • Basics & Advance features of Pivot Table
Read more
01 hour 47 min 24 sec
02 nd May, 2021
Profile photo of Anshuman Tandon
5.1

Data Validation & Report Building

Expert - Anshuman Tandon

How to build Reports of your need How to modify data using Excel Formulas & Features How to use Data Validation i

  • How to build Reports of your need
  • How to modify data using Excel Formulas & Features
  • How to use Data Validation in Excel Reports
  • Advance Excel Data Validation
Read more
01 hour 50 min 08 sec
09 th May, 2021
Profile photo of Anshuman Tandon
6.1

Basic to intermediate google sheets

Expert - Anshuman Tandon

Basic to intermediate google sheets

Basic to intermediate google sheets

Read more
01 hour 49 min 14 sec
16 th May, 2021

Experts/instructors panel

 

Course features

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


 

Areas covered


  • Basics of Excel

  • 101 Shortcuts

  • Excel Formulas

  • Filter & Pivot Table

  • Data Validation & Report Building

  • Basic to intermediate google sheets


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

Participant Feedbacks

April 29, 2021

Ashish Miglani

Excellent Course, Value for Money, Learned lot of new shortcuts. Sir Explained all the things in Detail which makes everyone to understand in easy way.

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