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
M&HR Solutions Private Limited
In association with Nirathanka, NGO
Presents

Online Microsoft Excel (Corporate) 
Training Programme

Basic Excel 7-7/5 hours of Training
  • Starting Excel: Different methods
  • Overview of Workbooks and Worksheets, Navigating Worksheets, Renaming sheet Tabs 
  • Number of Columns and Rows, R1C1 referencing style
  • Knowing the Name box, Ribbon and status bar, customizing the quick access tool bar and ribbon
  • Freeze panes, wrap text, CTRL ENTER technique
  • Basic cell references, operations & using the Function Wizard (Function Arguments screen)
  • Selecting Ranges (Basic shortcuts of Selection)
  • Basic Functions: SUM, COUNT, COUNTA, AVERAGE, MAX, MIN, VLOOKUP, COUNTIF, SUMIF, TODAY
  • Basic Text Functions: PROPER, UPPER, LOWER, LEFT, RIGHT, MID, LEN, TRIM, CONCATENATE
  • Using the ‘equal to’ operator to check for a condition, Basic IF function
  • Simple VLOOKUP of exact match nature to fetch only one column of data, Properties of VLOOKUP
  • Creating simple drop-down lists using Data Validation
  • Basic Conditional Formatting to apply color, Top-Bottom Rules
  • Introduction to Sorting and Filtering
  • Creating a Simple Pivot Table and a Chart

Intermediate Excel: 7 to 15 hours of Training (1 day or 2 days)
  • Name box and its uses, properties associated with Named Ranges, using Name Manager
  • Creating Custom Lists. For e.g.: type Ambarish and his list pops up
  • Referencing: Absolute and Partial(using the dollar symbol with F4 effectively)
  • Using the OPTIONS Tab while Finding and Replacing Data
  • Statistical functions: SUMIFS, COUNTIFS, AVERAGEIFS, LARGE, SMALL and others
  • Other important functions: MROUND, FLOOR, CEILNG,
  • Database functions: DCOUNT, DCOUNTA, DSUM, DMAX, DMIN, DAVERAGE
  • Logical functions: IF, IF with OR, IF with AND, IF with NOT, IF with OR with AND combination
  • NESTED IF scenarios, IFS, SWITCH
  • VLOOKUP with Named Range v/s Regular VLOOKUP with manual selection
  • VLOOKUP with Exact match (False or 0) v/s VLOOKUP with Range (True or 1)
  • DATE functions (Using DATEDIF and other functions)
  • Applying drop down lists using Validation, exploring other options in the Validation window
  • Multi-Level, Custom Sorting &Text Filtering along with an overview of Advanced Filter
  • Consolidation
  • Conditional Formatting: Data Bars, Icon Sets, Color Scales
  • Pivot Tables, Grouping and ungrouping, Multiple sheets from a Pivot in one go, Dynamic Pivot
  • Working with Charts: Column, Bar, Pie
  • Recording a Macro and Properties associated with a Macro
 
Advanced Excel: 7 to 15 hours Training
  • Quick review on Various Referencing Techniques, Named Ranges and Custom Lists
  • GO-TO window (Various options within the GO-TO SPECIAL window)
  • CTRL ENTER method and CTRL SHIT ENTER (Array Method)
  • Nested IF with OR AND combination, NESTED IF with DATE VALUE, Multiple scenarios
  • VLOOKUP with MATCH with Partial Referencing and Drop-Down Validation
  • When to use VLOOKUP With TRUE over Nested IF
  • INDEX MATCH combination
  • CHOOSE function
  • INDEX with MATCH with Partial Referencing and Drop-Down Validation
  • Data Validation: Dependent and independent drop-down lists, custom functions, input & error
  • Multi-level sorting, Custom sorting, Advance Filtering with AND OR BETWEEN NOT scenarios
  • Subtotal (Single level and multi-level), Removing Subtotals
  • New rules within Conditional Formatting, Customizing functions within New Rules of formatting
  • Pivot Table: Advanced Features of Pivot. Using Slicers and Timelines in Pivot,
  • Creating multiple Pivot Tables and linking them with a slicer
  • Examples of PowerPivot
  • Example of Power Query
  • Working with Charts: Combination Charts
  • Recording a Macro and assigning short cuts and/or button to it, editing the recorded Macro
  • ​Writing a VBA code to generate a user defined function
TRAINER
Picture
Ambarish Tarte
Corporate Trainer for Microsoft Office suite/Office 365 user apps.
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

VIDEOS


    Register Here

Submit



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