One day training programme on 

Microsoft Excel

Discover the power of data analysis with Microsoft Excel! Whether you're in finance, marketing, or any other field, mastering Excel can revolutionize how you interpret and use data. With its user-friendly interface and powerful tools like pivot tables, Excel makes it easy to organize and understand complex data sets. From conditional formatting to financial functions, Excel offers a range of features to help you uncover insights and make informed decisions. Explore the possibilities and unlock your potential with Excel for data analysis!​

LEARNING OBJECTIVES 

Introduction
  • Excel interface and navigation
  • Working with Views in Excel 
  • Naming cells and ranges
  • Using references in formulas
  • Navigation Bar in Excel
  • Ribbon and toolbar overview
  • Creating and saving workbooks 

Compound & Complex Formulas
  • SUMIF, COUNTIF, IF
  • VLOOKUP, Xlook, Indexmatch
  • Introduction to basic logical functions, ifs, IFNA
  • CONCATENATE, TEXT, LEFT, RIGHT, MID
  • DATE and TIME functions, Text Join, Text Split
  • Group by, Pivot by Formulas
  • Nested functions
  • Unique, filter, sequence

Data Management
  • Sorting and filtering data                            
  • Advanced filtering
  • Removing duplicates

Conditional Formatting
  • Data Bars and Color Scale
  • Icon Sets and Symbols
  • Formulas in Conditional Formatting
  • Conditional Formatting with Dates and Times
  • Advanced Techniques with Conditional Formatting

Pivot Charts, Slicers & More
  • Inserting Pivot Chart
  • More Pivot Table Functionality
  • Working with Power Pivot
  • Use pivot tables to analyse data. 
  • Edit pivot tables
  • Format pivot tables
  • Calculated Fields, Summarize, Filter Reports, Layout
  • Insert pivot charts
  • Use Slicers

Working with Charts
  • Creating a simple chart 
  • Formatting and customizing charts
  • Adding trendlines and data labels
  • Creating Dynamic Charts

Data validation & Goal Seek & Analysis Tool pack
  • Data validations - Creating dynamic Lists using data validation and Named Range
  • Using Goal Seeks
  • Use Data Validation to restrict the type of data that can be entered into a cell
  • Consolidate data from a number of different ranges into one new range
  • Use Goal Seek to figure out the value to input to obtain a specific result
  • Power Query Basic functions
  • Understanding Power Query and its benefits
  • Accessing Power Query in Excel
  • Importing data from various sources
  • Basic data transformations using Power Query

Introduction to Macros, VBA using Chat GPT
  • How to record a macro
  • Developer Tab, VBA Code editor
  • How to write simple vba codes using Chat GPT

FEES

  1. Rs.3500 + 18% GST per participant.
  2. Group rate: Rs.3000+18% GST per participant if three or more participants are nominated from the same organization. 
  3. The fees include the cost of course material, stationery, lunch, tea and certification charges. The Cheque / D.D should be drawn in favor of M&HR Solutions Private Limited payable at Bangalore. We prefer online payment and our bank account details are given below.
To maximize the learning experience, participants have to bring their 
laptops with Microsoft Excel installed.

M&HR Solutions Private Limited Bank Details

Account Number: 369505000632
Account Type: Current Account
IFSC Code:  ICIC0003695
MICR Code: 560229107
ICICI Bank
No. 888, 80 Feet Road, Papareddypalya,
​Nagarbhavi 2nd Stage, Bangalore -560072 

Venue

RG Royal Hotel
19, Behind Ravindu Toyota, Near ISKCON Temple, 
Yeshwanthpur Industrial Suburb, Mahalakshmi Layout, Bengaluru-560086

Date

Friday, 25th July 2025

TIMINGS

9.30 am - 05.30 pm

Faculty

Ismail Chalil is a passionate Independent Trainer with more than 20+ years of global experience. He has delivered several programs at top MNC across India. He has handled training assignments across the spectrum of key industries from lower level to managerial level.
Latest Assignments
  1. Business Dashboard 
  2. Predictive Analysis  
  3. Data Analytics using Excel 
  4. Advanced Excel

Qualifications/Certifications
  • Post graduate in CRM
  • BSc Graduate
  • Diploma in Software Engineering 
  • Six Sigma Green Belt Certified
  • Mortgage certification, USA
  • Insurance certification, USA
​
Work Experience - Infosys
His role focused on driving operational efficiency by leveraging data analysis and automation, contributing to the company's success through streamlined processes.

ABOUT M&HR SOLUTIONS PRIVATE LIMITED

M&HR Solutions Private Limited is an emerging business partner for providing solutions for your HR, Admin, ER, Safety, POSH, Compliance Management, Translations, Office Management, and other needs.

    Register Here