top of page
Excel Course BK Engineering

Microsoft Excel Training In Hyderabad

About the Course

INTRODCUTION:

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.

 

SCOPE OF COURSE:

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.

 

CAREER PROSPECTS / JOB ROLES:

 

  • Data Analyst.

  • Business Analyst.

  • Business Intelligence Specialist.

  • Operations Executive.

  • Business Intelligence Consultant.

  • Business Analyst.

​

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.

BK Engineering Location

bottom of page