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
• 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