M&HR
  • HOME
  • About Us
  • Our Services
    • Human Resource
    • Publications
    • NGO & CSR
    • PoSH
    • Training Programmes
    • Certificate Training Courses
  • Online Store
  • Leader's Talk
  • HR Blog
  • Kannada Blog
  • Find Freelance Jobs
  • Current Job Openings
  • Videos
  • Search
  • Join HR Online Groups
  • Contact Us
  • HOME
  • About Us
  • Our Services
    • Human Resource
    • Publications
    • NGO & CSR
    • PoSH
    • Training Programmes
    • Certificate Training Courses
  • Online Store
  • Leader's Talk
  • HR Blog
  • Kannada Blog
  • Find Freelance Jobs
  • Current Job Openings
  • Videos
  • Search
  • Join HR Online Groups
  • Contact Us
M&HR

HR BLOG 

Inviting meaningful articles
For More Details

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
    Announcement
    Case Studies
    Contract Labour
    ESI
    Excel Training
    Factories Act
    General
    Google Group
    HR Jobs
    HR Training
    HR Videos
    HR Workplace Solutions
    Human Resource
    Industrial Relations
    Interviews
    Labour Law
    Latest Notifications
    Model Forms And Precedents
    Personality Development
    PF Act
    PoSH (Sexual Harassment)
    Powerpoint Training
    ಕನ್ನಡ ಲೇಖನಗಳು

    Archives

    May 2022
    April 2022
    January 2022
    May 2021
    April 2021
    March 2021
    December 2020
    September 2020
    July 2020
    June 2020
    May 2020
    April 2020
    March 2020
    October 2019
    April 2019
    January 2019
    August 2018
    June 2018
    December 2017


    Picture

    Inviting Articles

    More details

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

    M&HR Solutions Private Limited

    ​List Your Product on Our Website


    RSS Feed


    Human Resources And Labour Law Classes



Site

  • Home
  • About Us
  • Leader's Talk
  • HR Blog
  • Find Freelance Jobs
  • Current Job Openings
  • Videos
  • Join HR Online Groups
ONLINE STORE
Vertical Divider
JOIN HR ONLINE GROUPS 
Picture
20,000 HR PROFESSIONALS ARE CONNECTED THROUGH OUR NIRATHANKA HR GROUPS.
YOU CAN ALSO JOIN AND PARTICIPATE IN OUR GROUP DISCUSSIONS.
Join HR Online Groups
Vertical Divider

Contact Us

No. 326, 2nd Floor, Opp. Canara Bank, Near Dr. AIT College, Kengunte, Mallathahalli, Bangalore - 560 056
  • 080-23213710, +91-8073067542
  • E-mail - hrniratanka@mhrspl.com
Our Other Websites:
  • www.nirutapublications.org
  • www.niratanka.org

Picture
MHR LEARNING ACADEMY
  • Build your HR & Labour Law skill set with video courses
  • Customize your experience with learning reminders
  • Learn anywhere with offline viewing
Picture
Download App Here

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