top of page

About the Course


Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS. It features calculation or computation capabilities, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. Excel forms part of the Microsoft Office suite of software.


These skills are especially useful in the MNCs where it helps in creating MIS reports, ratio analysis, and various other reports. In India and the world, the demand for skilled MIS professionals is growing rapidly.


  • Data Analyst.

  • Business Analyst.

  • Business Intelligence Specialist.

  • Operations Executive.

  • Business Intelligence Consultant.

  • Business Analyst.

Microsoft Excel


₹ 4999


40 Hours

Download Syllabus

Syllabus for Microsoft Excel Courses in Hyderabad

Custom and Conditional Formats

  • Introduction

  • Creating Conditional Formatting using color scales

  • Using Icon sets

  • Conditional formatting using New rule

  • Conditional formatting using manage rules and clear rules

Data Validation

  • Specifying a valid range of value of a cell

  • Specifying a valid value for a cell

  • Specifying custom validation based on formula for a cell

  • Prevent duplicate entries

Working with Range Names

  • Using Range names

  • Creating range names

  • Using range names in formulas

  • Deleting range names

  • Advanced Range Options

Advanced Table Option

  • Creating Tables

  • Naming the Tables

  • Changing the Table style

  • Creating a total row

  • Creating a calculated column

  • using FIltering in Table

  • Removing the duplicate record

Array Functions

  • Array functions using CTRL+SHIFT+ENTER

  • One Dimensional Array

  • Two Dimensional Array

  • Single cell and Multi cell Array

Using Formulas and Functions

  • Text Function

  • Logical Functions

  • Date and Time Functions

  • Math and Trigonometry Functions

  • Statistical Functions

  • Lookup and reference functions

Working with Charts

  • Creating a chart

  • Formatting a chart

  • Adding Labels

  • Changing the chart type, Data source

Working with Pivot Tables

  • Creating Pivot tables

  • Adding Pivot table Report Fields

  • Refreshing Pivot table Reports

  • Changing the summary functions

  • Creating report filter page

  • Creating Subtotals

  • Multiple Level subtotals

  • Creating Pivot tables

  • Formatting and customizing Pivot tables

  • Using advanced options of pivot table

  • pivot charts

Worksheet Protection

  • Protecting your work sheet

  • Protecting range with password

  • Protecting your Workbook and Excel Files

  • Sharing a workbook

  • Opening and editing a shared workbook

What-IF Analysis

  • Goal Seek

  • Data Tables

  • Scenario Manager

Import and Export

  • Import a text file by opening it in excel

  • Import a text file by connecting to it

  • Export data to a text file

  • Changing the delimiter

  • Change the separator in all .CSV text file

Working with Macros and VBA

  • Display the developer Tab

  • Changing Macro security Settings

  • Recording and running a Macro

  • Delete a Macro

  • VBA (Visual Basic Application)

  • Advantages and features

  • VBA Message Box , Comments

  • InputBox using VBA

  • Sub and Functions using VBA

  • VBA Constants , variables

  • VBA Operators

  • Loops

  • VBA Decisions

  • User form in VBA

FAQs on Microsoft Excel Course

What is the best way to learn Microsoft Excel?

If you're new to Excel, an introductory course can help get you up to speed quickly on Excel basics. Online Excel courses may explore how to set up an Excel sheet, perform basic calculations, use formulas, and create data visualizations with charts and graphs.

What are the 5 basic Excel skills?

Below you have the top ten basic Excel skills to learn by anyone who is just starting out with Excel needs to learn.

  • Saving and Opening a Workbook. ...

  • Managing Worksheets. ...

  • Formatting Cells. ...

  • Printing. ...

  • Excel Functions (Basic) ...

  • Charts. ...

  • Sorting Data. ...

  • Find and Replace Option.

How much time to learn Excel?

How Much Time Does It Take To Learn Advanced Excel? This question is subjective in nature as it depends on your grasping capability, but, on an average 12-14 hours well-curated course does the trick.

What are the 4 types of Excel?

Excel data types are the four different kinds of values in Microsoft Excel. The four types of data are text, number, logical and error. You may perform different functions with each type, so it's important to know which ones to use and when to use them.

Are Excel skills in demand?

Yes, Excel skills are in demand because this application is one of the best spreadsheet applications around. It has all the function functions you’ll need to manipulate and organize data. However, keep in mind that Excel skills are usually combined with other skills such as data analysis.

Is Excel easier to use than Word?

Learning Microsoft Word is easier than learning Microsoft Excel. However, Word isn’t used for data manipulation, so it’s likely that you will need to learn both.

Your Instructor

Bhargava Krishna

Bhargava Krishna

Meet our experienced Data Analytics Instructor, with over 8 years of experience in the field of data analysis and visualization. They are well-versed in various tools and techniques used for data analytics such as Tableau, Power BI, SQL, and Excel. With their expertise, they have helped numerous students and professionals alike in gaining a strong understanding of data analysis and how to apply it to real-world problems. They have a passion for teaching and have a proven track record of delivering engaging and informative classes. Their industry experience, combined with their instructional skills, makes them a valuable resource for anyone looking to advance their skills in the field of data analytics.

bottom of page