M&HR
  • HOME
  • About Us
  • HR Blog
  • POSH
    • Prevention of Sexual Harassment at Workplace (POSH) Online Training
    • Certificate course on Prevention of Sexual Harassment at Workplace (POSH)
    • Certificate course on Prevention of Sexual Harassment at Workplace (POSH)
    • POSH Training
  • Services
    • Domestic Enquiry
    • Payroll Services
  • HR Job Openings
  • Join Our Online Groups
  • Videos
  • Online Store
  • SEARCH
  • Contact Us
    • Office Login
  • HOME
  • About Us
  • HR Blog
  • POSH
    • Prevention of Sexual Harassment at Workplace (POSH) Online Training
    • Certificate course on Prevention of Sexual Harassment at Workplace (POSH)
    • Certificate course on Prevention of Sexual Harassment at Workplace (POSH)
    • POSH Training
  • Services
    • Domestic Enquiry
    • Payroll Services
  • HR Job Openings
  • Join Our Online Groups
  • Videos
  • Online Store
  • SEARCH
  • Contact Us
    • Office Login
M&HR

HR Blog 

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
    Books
    General
    HR Training
    Human Resource
    Labour Law
    ಕನ್ನಡ ಲೇಖನಗಳು

    M&HR Solutions Private Limited

    ​List Your Product on Our Website


    RSS Feed


    Human Resources And Labour Law Classes

Site

  • Home
  • About Us
  • HR Blog
  • HR Books
  • Services
  • HR Job Openings
  • ​​List Your Product on Our Website
Vertical Divider

Major Services

  • Prevention of Sexual Harassment (PoSH)
  • Domestic Enquiry
  • Translations & Typing
  • Contract Labour
  • Printing
  • Publications
  • Payroll
  • ​Registration Services

Our Other Websites

  • ​www.hrkancon.com  
  • www.niratanka.org  
  • www.socialworkfootprints.org
Vertical Divider

Training Programmes

  • Certificate Course on Prevention of Sexual Harassment (PoSH)
  • Disciplinary Proceedings & Domestic Enquiry
  • Plan Your Retirement
  • ​Microsoft Excel (Corporate) Training

Contact Us

  • 080-23213710
  • +91-8073067542
  • MAIL-hrniratanka@mhrspl.com

ONLINE STORE
List Your Products in our Website 
Receive email updates on the new books & offers for the subjects of interest to you.
M&HR Solutions Private Limited
Copyright :MHRSPL-2020, website designed and developed by :www.socialworkfootprints.org