M&HR
  • HOME
  • About Us
  • HR & Employment Law Classes - Every Fortnight
  • Our Services
  • Training Programmes
    • Prevention of Sexual harassment at workplace - 2025
  • HR Books / Online Store
  • HR Blog
    • Kannada Blog
  • Videos
  • Join HR Online Groups
  • Collaborate with M&HR
  • Contact Us
  • HOME
  • About Us
  • HR & Employment Law Classes - Every Fortnight
  • Our Services
  • Training Programmes
    • Prevention of Sexual harassment at workplace - 2025
  • HR Books / Online Store
  • HR Blog
    • Kannada Blog
  • Videos
  • Join HR Online Groups
  • Collaborate with M&HR
  • Contact Us
M&HR

Online Microsoft Excel (Corporate) Training Programme

5/11/2020

0 Comments

 
We are pleased to announce the online training programme titled “Microsoft Excel (Corporate) Training” the details of which are as under.  It covers in detail Microsoft Excel (Basic, Intermediate & Advanced).

Name of the programme: Microsoft Excel (Corporate) Training.
Duration: 10 Hours
For whom: Corporate Companies.

Mode:
It will be conducted online using Zoom App. Hence participants shall have the Zoom App in their laptop or desktop or smart phone along with internet connection. 
Fees:
Rs. 2000/- per participant. Please pay the fees online to our bank account. Our account details are as under. 
Name of the Account: M&HR Solutions Private Limited
Account No. 369505000632
IFSC Code:  ICIC0003695
MICR Code:  560229107
Account type:  Current Account
Bank Name:  ICICI Bank
Branch Name:  Nagarabhavi

Learning objectives: 
Basic Microsoft Excel Topics
  • ‘Save-as’ techniques such as Excel Templates, Excel Binary workbook
  • Understanding Compatibility mode, Extension types, File Conversion
  • Enabling & working on Drag handlers, Double click method
  • Understanding the date concept
  • Customizing lists
  • Referencing techniques, Array (matrix) technique
  • Name Range Concept – Defining names, working with named ranges
  • Arithmetic functions
  • Logical Functions
  • DB-Functions like DSUM or DCOUNTA
  • Text Functions
  • V-lookup & H-lookup
  • Understanding FALSE (0) v/s TRUE (1) in VLOOKUP (or HLOOKUP) 
  • Using the Name Range concept in VLOOKUP (or HLOOKUP)
  • Creating drop down lists 
  • Determining day of the week from a given date
  • Calculating the difference between two dates in terms of days, months & years
  • Applying conditional formatting
  • Sorting
  • Filtering 
  • An example of Advanced Filter
  • Introduction to Pivot Table field list and Pivot Layout
  • Creating a Pivot report out of a given data
  • Working with various features of Pivot like Grouping, Ungrouping
  • Creating Multiple sheet wise reports out of one Pivot
  • Modifying the given data range into a TABLE to make a dynamic Pivot
  • Charts and different types of Charts
  • Consolidation
  • Entire Workbook Protection (Document Encryption)
  • Specific Sheet Protection
  • Freezing panes
  • Basics of Recording a Macro in Excel

Advanced Microsoft Excel Topics
  • Introduction to Excel Interface
  • Need to know
  • Formulas
  • Lookup technique
  • Validation
  • Date Function
  • Sort & Filter
  • Consolidation
  • Conditional Formatting
  • Subtotal
  • Pivot
  • What-If Analysis
  • Introduction to Macros

TRAINER
Ambarish Tarte is a Corporate Trainer for Microsoft Office suite/Office 365 user apps. He conducts corporate training workshops for various corporate giants/multinational companies across the globe. He operate as a Corporate Training Consultant catering to M.S Office training requirements of various organizations.

Professional Background: 
Started his career with the B.P.O industry in July 2004, moved up the hierarchy from a call handling executive to a Supervisor and then a Manager. Good people management skills and effective training/coaching abilities enabled his gain experience into Operations, Quality as well as Training. Eventually moved into Corporate Training in July 2011 due to prior experience of conducting behavioral training & Process training within the organization. Took up Microsoft Office as the mainstream training module as it is the most commonly &extensively used tool by corporate users.

Experience: 
  • More than 15 years of Professional Corporate experience 
  • More than 10 years into Training&Coaching functionality at corporate level
  • More than 7 years into M.S Office training at corporate level

Training Forte:
  • Microsoft Office (2007/2010/2013/2016/2019, Office 365 End user apps) 
  • Excel (Basic, Intermediate & Advanced)
  • PowerPoint
  • Outlook
  • OneNote
  • Office 365 applications 
  • IT Induction program for new joiners
  • MS Office suite
Certified Certificates of Trainer

    Register Here

    * Indicates required field
Submit
0 Comments



Leave a Reply.


    Categories

    All
    General
    HR Jobs
    HR Videos
    Human Resource
    Industrial Relations
    Interviews
    Labour Law
    Personality Development
    PoSH (Sexual Harassment)
    ಕನ್ನಡ ಲೇಖನಗಳು


    Picture

    HR Learning and Skill Building Academy

    Join WhatsApp Channel

    Stay updated and informed by joining our WhatsApp group for HR and Employment Law Classes - Every Fortnight. The Zoom link for the sessions will be shared directly in the group.
    Picture
    Join Here

    M&HR Solutions Private Limited

    Human Resources And Labour Law Classes

    Leaders Talk

    Picture

    MHR LEARNING ACADEMY

    Get it on Google Play store
    Download App Here
    Online App Courses

    Picture
    Join WhatsApp

    Picture
    50,000 HR PROFESSIONALS ARE CONNECTED THROUGH OUR NIRATHANKA HR GROUPS.
    YOU CAN ALSO JOIN AND PARTICIPATE IN OUR GROUP DISCUSSIONS.
    Join HR Online Groups



    RSS Feed


    Human Resources And Labour Law Classes


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.