Data Analytics using Microsoft Excel

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

Rs.3500 + 18% GST per participant.
Group rate: Rs.3000+18% GST per participant if three or more participants are nominated from the same organization.
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.