M&HR Solutions Private Limited In association with Nirathanka, NGO Presents
Online Microsoft Excel (Corporate) Training Programme
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
Enabling & working on Drag handlers, Double click method
Understanding the date concept
Referencing techniques, Array (matrix) technique
Name Range Concept – Defining names, working with named ranges
DB-Functions like DSUM or DCOUNTA
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
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
Entire Workbook Protection (Document Encryption)
Specific Sheet Protection
Basics of Recording a Macro in Excel
Advanced Microsoft Excel Topics
Introduction to Excel Interface
Need to know
Sort & Filter
Introduction to Macros
Ambarish Tarte Corporate Trainer for Microsoft Office suite/Office 365 user apps.
Certified Certificates of 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.
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
Microsoft Office (2007/2010/2013/2016/2019, Office 365 End user apps)