M&HR Solutions Private Limited
In association with Nirathanka, NGO
Presents
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
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
Advanced Microsoft Excel Topics
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
Corporate Trainer for Microsoft Office suite/Office 365 user apps.
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.
Experience:
Training Forte:
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