facebook-no-script
Transforming Education Since 2014
Refer & Earn Become an Instructor

MS Excel Online Certification Course with MIS Reports

Microsoft Excel Online Certification Course, In this syllabus, you will learn the basics to the advanced level of MS Excel programs with MIS reports from India’s top online learning education platform, Tyariexamki.

In this certificate course, we will cover spreadsheet software, data entry, formatting and formulas, analysis, chart creation, and all short-cut keys. Which are used in daily work. Advanced features like pivot tables, all functions, data validation, macros, conditional formatting, data visualization, VBA and MIS Report, etc. This MS Excel online training course is a job saving course, featuring lots of practical training and practice on the client’s real data. Which gives candidates a very good industrial and practical knowledge of full MS Excel. After completing this course, you become a Certified Professional. The fees for this course are very low. The languages of this course are both Hindi and English.

What will you learn

 Introduction to Microsoft Excel

Microsoft Excel is a powerful spreadsheet program developed by Microsoft Corporation. It is part of the Microsoft Office suite of applications and is widely used for various purposes, including data analysis, management, calculation, visualization, and reporting. Its intuitive interface and robust features make it indispensable for various tasks.

 Key Features

Excel offers an extensive array of functions and formulas for versatile data manipulation and statistical analysis. Its charting tools enable users to create dynamic visual representations of data.

 Applications and Industry Usage

Excel is widely utilized across industries for financial modeling, budgeting, and reporting. It serves as a vital tool in finance, accounting, marketing, and education, supporting efficient data-driven decision-making processes.

  • Live Class on ZOOM by Top Mentors
  • 1 Year Complete Access of Live Recorded
  • Instant Solve Your Query in Live Class
  • Full Access on Mobile, PC, Tablet and TV
  • Live Doubt Session on Weekly and Monthly Basis
  • Instant Support through WhatsApp, email and Telegram
  • Downloadable Class Notes, Forms and Study Material
  • Training on Real Data with Real Clients ( Practical Course )

₹ 2995

Go To Cart
Wishlist Enquire Now

CURRICULUM

No of Subjects

12 +

No of Lessons

25+

No of Assignment

20+

Here you will get all Days wise Class Notes, Assignment and Practice Sets

Class Notes, Assignment and Practice Sets

In this class, you will learn about, Introduction Of Microsoft Excel, Launching Excel Quick Access Tool bar, Understanding Excel Interface And Structure Of Workbook, Moving Between Cells, Selecting cells And Range, Creating Of New File, Open File, Sa

Introduction Of Microsoft Excel

Formatting and modifying an Microsoft Excel cells

Working with basic formulas and functionS

Learn How to Short and Filter

Excel Formulas

Excel Formulas Class-2

Excel Tools- Freeze panes and Text to Column

Excel Formulas(V lookup and H lookup)

Excel Class 1 : Introduction
Excel Class 2 : Cell Format, Cell Referencing
Excel Class 3 : Formula Function, Basic and Advanced Filter
Excel Class 4 : IF, AND, OR
Excel Class 5 : SUM ( SUMIF, SUMIFS ), COUNT ( COUNT, COUNTA, COUNTIF, COUNTIFS )
Excel Class 6 : Conditional Formatting
Excel Class 7 : Conditional Formatting, Vlookup
Excel Class 8 : VlookUp, Hlookup, Xlookup
Excel Class 9 : Text Formating
Excel Class 10 : Data Validation
Excel Class 11 : Index, Match, Vlookup Match, Match, Index Data Validation, Name Manager
Excel Class 12 : What if Analysis( Goal Seek Status, Data Table, Scenario Manager)
Excel Class 13 : Sub Total, Group - Ungroup, For Casting sheet, Chart Related Information ( 2-D )
Excel Class 14 : Chart, 2D, Chart Bar, Pie Chart(Simple, 3D), Doughnut, Line, Combo, WaterFall, Tree
Excel class 15 : Pivot Table(Summarize Value by, Show Value in, Design, Report Layout, Blank Rows)
Excel Class 16 : Pivot Table Fields (Dashboard Designing)
Excel Class 17 : Power Pivot Table

Course Mentors

...
CMA GAURAV KUMAR

( FCMA,B.COM(H))
Experience: 18 YRS.
Training session: 2156
Student trained : 13560
Experties: Cost Accountancy, ROC Compliance, MIS Reporting

...
Mr. Anup Prakash Pradhan

( B. Tech, MBA in HR, Cambridge English : Business Certificates (BEC), Data Analysis, Excel and Power )
Experience: 11+ Years.
Training session: 1278
Student trained : 7226+
Experties: HR Generalist, Payroll, Data Analysis, Adv. Excel and Power BI, Data Reporting and MIS etc.

Talk to an Expert

img
 Call now  Chat with Us
Quick Enquiry
captcha