One day training programme on 

Data Analytics using Microsoft Excel

ABOUT 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
  • Ribbon and toolbar overview
  • Creating and saving workbooks
  • Naming cells and ranges
  • Using references in formulas

BASIC FORMULAS
  • SUM, AVERAGE, MIN, MAX, COUNT
  • Relative and absolute cell references
  • Basic troubleshooting of formula errors

MORE FUNCTIONS
  • 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
  • Nested functions
  • Unique, filter, sequence

PIVOT CHARTS, SLICERS & MORE
  • Inserting Pivot Charts
  • More Pivot Table Functionality
  • Working with Power Pivot 
  • Use pivot tables to analyse data
  • Edit pivot tables
  • Format pivot tables
  • Insert pivot charts
  • Use Slicers

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.
NOTE: Participants have to bring their laptops with Excel Pre-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, 19th April 2024

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
  • Business Dashboard
  • Predictive Analysis
  • Data Analytics using Excel
  • 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 a Trusted Placement and Contract Labour Firm based in Bangalore. Our process has been proven since 2011 (Formerly known as Nirathanka Management Services). For the last four years, we have grown in placing professionals across multiple industries with varied skills. We provide all types of Recruitment Services that includes Contract Labour, Placement Services, Manpower Recruitment, HR Consultancy, and Staffing Solutions. We have deputed around 400 contract workers in various industries. We are also acknowledged as a reliable Labour Law Consultant. We train people in Managerial, Executive, Supervisory and Workmen levels. We provide end-to-end solutions for start-ups, small, medium and other organizations. We have a team of like-minded trainers and consultants, who have vast knowledge and rich experience in various industries of India. We strongly believe in process. We have quality systems and procedures that are at par with the very best in the industry.

TRAINING PHOTOS