Microsoft Excel Training in Bangalore

About Microsoft Excel Certification Training Course in Bangalore

In the Microsoft Excel Certification Training Course in Bangalore, the trainers cover a wide range of necessary concepts like Tabs, cell style, formatting dates, using operations, autosum, changing views, referencing formulas, ranges, and dates, text formulas, adding graphics, protecting data, etc. At Besant Technologies, we enable our students to memorize all the concepts through practice and application of Microsoft Excel in different projects and assignments. We focus more on practicing practical applications of Microsoft Excel rather than the traditional classroom approach of rote learning the important points.

We also focus on helping students build an analytical and problem-solving mindset through the Microsoft Excel Training Course in Bangalore. If you want to acquire the skills of Microsoft Excel and become adept at using and applying it to gain fast results in the workplace then Besant Technologies’ Microsoft Excel Certification Training Course in Bangalore is the best option in the industry.

Besant Technologies has already helped many students to become proficient at Microsoft Excel in a very short time and has also helped them to land really good jobs in the industry. When you complete the Microsoft Excel Certification Course in Bangalore, you can easily obtain global certifications like Microsoft Office Specialist: Microsoft Excel Certification that will give you an advantage in the job market. A person who is proficient at using Microsoft Excel can easily earn an income of ₹5,45,000 INR per year in the industry. Microsoft Excel Certification Training Course in Bangalore at Besant Technologies can help you gain a stable career in the industry.

Microsoft Excel Training Syllabus

Section  I: Basic Excel (Duration: 10Hrs)

Learning Object:

In this Section, We are going to Discuss the Basic Overview and details about excel menu bar, top-level details about the

Topics:

• Excel tutorial
• Text to Columns
• Concatenate
• The Concatenate Function
• The Right Function with Concatenation
• Absolute Cell References
• Data Validation
• Time and Date Calculations
• Conditional Formatting
• Exploring Styles and Clearing Formatting
• Using Conditional Formatting to Hide Cells
• Using the IF Function
• Changing the “Value if false” Condition to Text
• Pivot Tables
• Creating a Pivot Table
• Specifying PivotTable Data
• Changing a PivotTables Calculation
• Filtering and Sorting a PivotTable
• Creating a PivotChart
• Grouping Items
• Updating a PivotTable
• Formatting a PivotTable
• Using Slicers
• Charts
• Creating a Simple Chart
• Charting Non-Adjacent Cells
• Creating a Chart Using the Chart Wizard
• Modifying Charts
• Moving an Embedded Chart
• Sizing an Embedded Chart
• Changing the Chart Type
• Chart Types
• Changing the Way Data is Displayed
• Moving the Legend
• Formatting Charts
• Adding Chart Items
• Formatting All Text
• Formatting and Aligning Numbers
• Formatting the Plot Area
• Formatting Data Markers
• Pie Charts
• Creating a Pie Chart
• Moving the Pie Chart to its Own Sheet
• Adding Data Labels
• Exploding a Slice of a Pie Chart
• Data Analysis − Overview
• types of Data Analysis
• Data Analysis Process
• Working with Range Names
• Copying Name using Formula Autocomplete
• Range Name Syntax Rules
• Creating Range Names
• Creating Names for Constants
• Managing Names
• Scope of a Name
• Editing Names
• Applying Names
• Using Names in a Formula
• Viewing Names in a Workbook
• Copying Formulas with Names
• Difference between Tables and Ranges
• Create Table
• Table Name
• Managing Names in a Table
• Table Headers replacing Column Letters
• Propagation of a Formula in a Table
• Resize Table
• Remove Duplicates
• Convert to Range
• Table Style Options
• Table Styles
• Cleaning Data with Text Functions
• Removing Unwanted Characters from Text
• Extracting Data Values from Text
• Formatting Data with Text Functions

Hands-on

All concepts we can practice with examples in excel sheet

Advance Excel (Duration: 15Hrs)

Section II: Date Formats (Duration: 2Hrs)

Learning Objective:

In this Section We are going to Discuss about the Date format one by one

Topics:

• Converting Dates in Serial Format to Month-Day-Year Format
• Converting Dates in Month-Day-Year Format to Serial Format
• Obtaining Today’s Date
• Finding a Workday after Specified Days
• Customizing the Definition of a Weekend
• Number of Workdays between two given dates
• Extracting Year, Month, Day from Date
• Extracting Day of the Week from Date
• Obtaining Date from Year, Month and Day
• Calculating Years, Months and Days between two dates

Hands-on

All concepts we can practice with examples in excel sheet

Section III: Conditional Formatting (Duration: 2Hrs)

Learning Objective:

In this Section We are going to Discuss about the Conditional format one by one

Topics:

• Highlight Cells Rules
• Top / Bottom Rules
• Data Bars
• Color Scales
• Icon Sets
• New Rule
• Clear Rules
• Manage Rules

Hands-on

All concepts we can practice with examples in excel sheet

Module IV: Sorting (Duration: 2Hrs)

Learning Objective:

In this Section We are going to Discuss about the Sorting format one by one

Topics:

• Sort by Text
• Sort by Numbers
• Sort by Dates or Times
• Sort by Cell Color
• Sort by Font Color
• Sort by Cell Icon
• Sort by a Custom List
• Sort by Rows
• Sort by more than one Column or Row

Hands-on

All concepts we can practice with examples in excel sheet

Module V: Filtering (Duration: 2Hrs)

Learning Objective:

In this Section We are going to Discuss about the Filter format one by one

Topics:

• Filter by Selected Values
• Filter by Text
• Filter by Date
• Data Analysis with Excel
• Filter by Numbers
• Filter by Cell Color
• Filter by Font Color
• Filter by Cell Icon
• Clear Filter
• Advanced Filtering
• Filter Using Slicers

Hands-on

All concepts we can practice with examples in excel sheet

Module VI: Other Topics (Duration: 2Hrs)

Learning Object:

In this Section We are going to Discuss about the miscellaneous format one by one

Topics:

• Subtotals with Ranges
• Subtotals
• Nested Subtotals
• Quick Analysis
• Quick Analysis with TOTALS
• Sum
• Average
• Count
• %Total
• Running Total
• Sum of Columns

Hands-on

All concepts we can practice with examples in excel sheet

Module VII: Lookup Functions (Duration: 3Hrs)

Learning Objective:

In this Section We are going to Discuss about the LookUp Functions format one by one

Topics:

• Using the VLOOKUP Function
• Using VLOOKUP Function with range lookup TRUE
• Using VLOOKUP Function with range lookup FALSE
• Using the HLOOKUP Function
• Using HLOOKUP Function with range lookup FALSE
• Using HLOOKUP Function with range lookup TRUE
• Using the INDEX Function
• Using MATCH Function

Hands-on

All concepts we can practice with examples in excel sheet

Module VIII: Pivoting (Duration: 2Hrs)

Learning Object:

In this Section We are going to Discuss about the Pivoting format one by one

Topics:

• PivotTables
• Creating PivotTable
• Recommended PivotTables
• PivotTable Fields
• PivotTable Areas
• Nesting in the PivotTable
• Filters
• Slicers
• Summarizing Values by other Calculations
• PivotTable Tools
• Using Pictures in Column Charts
• Band Chart
• Thermometer Chart
• Gantt Chart
• Waterfall Chart
• Sparklines
• Pivot Charts
• PivotChart from PivotTable
• PivotChart without a PivotTable
• Working with Multiple Sheets
• Multiple Worksheets with same Structure
• Creating a Formula across Multiple Worksheets
• Summarizing Data in Multiple Worksheets
• What-If Analysis

Hands-on

All concepts we can practice with examples in an excel sheet

Upcoming Batch Schedule for Microsoft Excel Training in Bangalore

Besant Technologies provides flexible timings to all our students. Here is the Microsoft Excel Training Classes in Bangalore Schedule in our branches. If this schedule doesn’t match please let us know. We will try to arrange appropriate timings based on your flexible timings.

• 04-11-2024 Mon (Mon - Fri)Weekdays Batch 08:00 AM (IST)(Class 1Hr - 1:30Hrs) / Per Session Get Fees
• 31-10-2024 Thu (Mon - Fri)Weekdays Batch 08:00 AM (IST)(Class 1Hr - 1:30Hrs) / Per Session Get Fees
• 02-11-2024 Sat (Sat - Sun)Weekend Batch 11:00 AM (IST) (Class 3Hrs) / Per Session Get Fees

Can’t find a batch you were looking for?

Request a Batch

Trainer Profile of Certified Microsoft Excel Training

The trainers at Besant Technologies work really hard to make the learning experience of students better. The best qualities that qualify them as the best trainers are:

• Highly proficient in using Microsoft Excel
• Possess an analytical mindset
• Experienced in training many batches
• Humble and kind natured trainers

Microsoft Excel Exams & Certification

Besant Technologies Certification is Accredited by all major Global Companies around the world. We provide after completion of the theoretical and practical sessions to fresher’s as well as corporate trainees.

Our certification at Besant Technologies is accredited worldwide. It increases the value of your resume and you can attain leading job posts with the help of this certification in leading MNC’s of the world. The certification is only provided after successful completion of our training and practical based projects.

Key Features of Microsoft Excel Training

Training Courses Reviews

Frequently Asked Questions