M&HR
  • HOME
  • About Us
  • HR & Employment Law Classes - Every Fortnight
  • Our Services
  • Training Programmes
    • Microsoft Excel Training - 2025
  • HR Books / Online Store
  • HR Blog
    • Kannada Blog
  • Join HR Online Groups
  • Collaborate with M&HR
  • Contact Us
  • HOME
  • About Us
  • HR & Employment Law Classes - Every Fortnight
  • Our Services
  • Training Programmes
    • Microsoft Excel Training - 2025
  • HR Books / Online Store
  • HR Blog
    • Kannada Blog
  • Join HR Online Groups
  • Collaborate with M&HR
  • Contact Us
M&HR
M&HR Solutions Private Limited
In association with Nirathanka, NGO
Presents

Microsoft Excel (Corporate) 
Training Programme
(ONLINE / OFFLINE)

Basic Excel 7-7/5 hours of Training
  • Starting Excel: Different methods
  • Overview of Workbooks and Worksheets, Navigating Worksheets, Renaming sheet Tabs 
  • Number of Columns and Rows, R1C1 referencing style
  • Knowing the Name box, Ribbon and status bar, customizing the quick access tool bar and ribbon
  • Freeze panes, wrap text, CTRL ENTER technique
  • Basic cell references, operations & using the Function Wizard (Function Arguments screen)
  • Selecting Ranges (Basic shortcuts of Selection)
  • Basic Functions: SUM, COUNT, COUNTA, AVERAGE, MAX, MIN, VLOOKUP, COUNTIF, SUMIF, TODAY
  • Basic Text Functions: PROPER, UPPER, LOWER, LEFT, RIGHT, MID, LEN, TRIM, CONCATENATE
  • Using the ‘equal to’ operator to check for a condition, Basic IF function
  • Simple VLOOKUP of exact match nature to fetch only one column of data, Properties of VLOOKUP
  • Creating simple drop-down lists using Data Validation
  • Basic Conditional Formatting to apply color, Top-Bottom Rules
  • Introduction to Sorting and Filtering
  • Creating a Simple Pivot Table and a Chart

Intermediate Excel: 7 to 15 hours of Training (1 day or 2 days)
  • Name box and its uses, properties associated with Named Ranges, using Name Manager
  • Creating Custom Lists. For e.g.: type Ambarish and his list pops up
  • Referencing: Absolute and Partial(using the dollar symbol with F4 effectively)
  • Using the OPTIONS Tab while Finding and Replacing Data
  • Statistical functions: SUMIFS, COUNTIFS, AVERAGEIFS, LARGE, SMALL and others
  • Other important functions: MROUND, FLOOR, CEILNG,
  • Database functions: DCOUNT, DCOUNTA, DSUM, DMAX, DMIN, DAVERAGE
  • Logical functions: IF, IF with OR, IF with AND, IF with NOT, IF with OR with AND combination
  • NESTED IF scenarios, IFS, SWITCH
  • VLOOKUP with Named Range v/s Regular VLOOKUP with manual selection
  • VLOOKUP with Exact match (False or 0) v/s VLOOKUP with Range (True or 1)
  • DATE functions (Using DATEDIF and other functions)
  • Applying drop down lists using Validation, exploring other options in the Validation window
  • Multi-Level, Custom Sorting &Text Filtering along with an overview of Advanced Filter
  • Consolidation
  • Conditional Formatting: Data Bars, Icon Sets, Color Scales
  • Pivot Tables, Grouping and ungrouping, Multiple sheets from a Pivot in one go, Dynamic Pivot
  • Working with Charts: Column, Bar, Pie
  • Recording a Macro and Properties associated with a Macro
 
Advanced Excel: 7 to 15 hours Training
  • Quick review on Various Referencing Techniques, Named Ranges and Custom Lists
  • GO-TO window (Various options within the GO-TO SPECIAL window)
  • CTRL ENTER method and CTRL SHIT ENTER (Array Method)
  • Nested IF with OR AND combination, NESTED IF with DATE VALUE, Multiple scenarios
  • VLOOKUP with MATCH with Partial Referencing and Drop-Down Validation
  • When to use VLOOKUP With TRUE over Nested IF
  • INDEX MATCH combination
  • CHOOSE function
  • INDEX with MATCH with Partial Referencing and Drop-Down Validation
  • Data Validation: Dependent and independent drop-down lists, custom functions, input & error
  • Multi-level sorting, Custom sorting, Advance Filtering with AND OR BETWEEN NOT scenarios
  • Subtotal (Single level and multi-level), Removing Subtotals
  • New rules within Conditional Formatting, Customizing functions within New Rules of formatting
  • Pivot Table: Advanced Features of Pivot. Using Slicers and Timelines in Pivot,
  • Creating multiple Pivot Tables and linking them with a slicer
  • Examples of PowerPivot
  • Example of Power Query
  • Working with Charts: Combination Charts
  • Recording a Macro and assigning short cuts and/or button to it, editing the recorded Macro
  • ​Writing a VBA code to generate a user defined function

TRAINER

Picture
ISMAIL CHALIL
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.


site map


Site

  • HOME
  • ABOUT US
  • COLLABORATE WITH M&HR
  • HR BLOG
  • HR LEARNING AND SKILL BUILDING ACADEMY
  • ​VIDEOS
  • HR & EMPLOYMENT LAW CLASSES - EVERY FORTNIGHT​​​

PUBLICATIONS

  • LEADER'S TALK​
  • ​TRANSLATING & TYPING

Job

  • JOB PORTAL​
  • FREELANCE TRANSLATOR

HR SERVICES

  • COMPLIANCE SUPPORT
  • CONSULTING
  • CONTRACT LABOUR
  • CONTRACT LABOUR LICENCE & CONSULTING​​​
  • PAYROLL
  • RECRUITMENT & STAFFING SERVICES
  • STAFFING - WHITE & BLUE COLLAR
  • ​STANDING ORDERS CERTIFICATION

OTHER SERVICES

  • APARTMENT RESIDENTS WELFARE ASSOCIATION REGISTRATION​

Training 

  • ​TRAINING PROGRAMMES

POSH

  • OUR ASSOCIATES
  • OUR CLIENTS
  • POSH
  • POSH BLOG
  • ​WANT TO BECOME AN EXTERNAL MEMBER FOR AN IC?

​​NGO & CSR

  • ​CSR
  • TREE PLANTATION PROJECT

Our Other Website:

  • WWW.NIRUTAPUBLICATIONS.ORG​

subscribe 


HR and Employment Law Classes - Every Fortnight

50,000 HR PROFESSIONALS ARE CONNECTED ​THROUGH OUR HR GROUPS. 
​YOU CAN ALSO JOIN AND PARTICIPATE IN OUR GROUP DISCUSSIONS.
Are you looking to enhance your knowledge of HR and labor laws? Join Nirathanka's HR and Employment Law Classes-Every Fortnight—a one-of-a-kind opportunity to learn from experienced professionals and industry experts.
Join Here

MHR Learning Academy

Picture
Picture
Download App Here
Picture
Online Courses Available on Our App
Picture


Copyright : MHRSPL-2021, website designed and developed by : www.nirutapublications.org.