Dampier Nagar, Mathura, India - 281001.
Details verified of Ram Rawat✕
Identity
Education
Know how UrbanPro verifies Tutor details
Identity is verified based on matching the details uploaded by the Tutor with government databases.
Hindi
English
Computer Diploma 3 Years 2007
Bachelor of Arts (B.A.)
Dampier Nagar, Mathura, India - 281001
Phone Verified
Email Verified
Report this Profile
Is this listing inaccurate or duplicate? Any other problem?
Please tell us about the problem and we will fix it.
Class Location
Online (video chat via skype, google hangout etc)
Student's Home
Tutor's Home
Years of Experience in Microsoft Excel Training classes
10
Teaches following Excel features
Advanced Excel, Excel Macro Training, Basic Excel, Excel VBA Training
Teaching Experience in detail in Microsoft Excel Training classes
Introduction to the data and data formats. Working with sheets, cells, rows, Columns workbooks. Using Lookup & Reference Function(LOOKUP, VLOOKUP, HLOOKUP, MATCH, INDEX). Text Functions such as Left, Right, Mid, LEN, Concatenate, Upper, Lower, Proper, Rept and Trim. Using Logical Functions such as If, Multiple Ifs . Using Date and Time Functions such as Today, Now, Date, Day, Month, Year, Workdays and Networkdays , Networkdays.intl. Using Statistical Functions such as Count, Counta, Countblank, Countif, Countifs, Sumif, Sumifs, Average if, Max, Min. If, with OR, If with AND, If with AND &OR, If with OR&AND. If with Trim, If with Concatenation, If with Left, Mid, Right. Date & Time Functions – Date, Datedif, DateValue, Days360, Hours, Minute, Month, Years. Use of Count if, Countifs, Averageif, Averaefis with the Name Ranges. GOTO Special Operations, Freeze pane. Data Consolidation, Validation, Flash fill, Slicer, text to column. Pivot Table Creating Method . Pivot form the Multiple Source of Data. Insert slicer in Pivot Table and Pivot charts. Dynamic Pivot Table . Working with Form Control, Combo Box, Check Box List Box and Option Box. Conditional Formatting, custom and dynamic validation, filter, custom filter, table creation.
Class Location
Online (video chat via skype, google hangout etc)
Student's Home
Tutor's Home
Years of Experience in Computer Classes
10
Type of Computer course taken
Basics of Computer usage, Training in Software application usage, Training in Computer tools usage, Software Programming
Teaching Experience in detail in Computer Classes
I have 10 Years experience in different domain like Banking, E-commerce, IT. currently working as a Senior Analyst in MNC. i have good knowledge of excel, advance excel, MIS reporting, Macros, Power BI, MS Access, MS Sql and all the functions and formulas used in any types of industry.
1. What Excel features do you teach?
Advanced Excel, Excel Macro Training, Basic Excel and others
2. Which classes do you teach?
I teach Computer and Microsoft Excel Training Classes.
3. Do you provide a demo class?
Yes, I provide a free demo class.
4. How many years of experience do you have?
I have been teaching for 10 years.
Class Location
Online (video chat via skype, google hangout etc)
Student's Home
Tutor's Home
Years of Experience in Microsoft Excel Training classes
10
Teaches following Excel features
Advanced Excel, Excel Macro Training, Basic Excel, Excel VBA Training
Teaching Experience in detail in Microsoft Excel Training classes
Introduction to the data and data formats. Working with sheets, cells, rows, Columns workbooks. Using Lookup & Reference Function(LOOKUP, VLOOKUP, HLOOKUP, MATCH, INDEX). Text Functions such as Left, Right, Mid, LEN, Concatenate, Upper, Lower, Proper, Rept and Trim. Using Logical Functions such as If, Multiple Ifs . Using Date and Time Functions such as Today, Now, Date, Day, Month, Year, Workdays and Networkdays , Networkdays.intl. Using Statistical Functions such as Count, Counta, Countblank, Countif, Countifs, Sumif, Sumifs, Average if, Max, Min. If, with OR, If with AND, If with AND &OR, If with OR&AND. If with Trim, If with Concatenation, If with Left, Mid, Right. Date & Time Functions – Date, Datedif, DateValue, Days360, Hours, Minute, Month, Years. Use of Count if, Countifs, Averageif, Averaefis with the Name Ranges. GOTO Special Operations, Freeze pane. Data Consolidation, Validation, Flash fill, Slicer, text to column. Pivot Table Creating Method . Pivot form the Multiple Source of Data. Insert slicer in Pivot Table and Pivot charts. Dynamic Pivot Table . Working with Form Control, Combo Box, Check Box List Box and Option Box. Conditional Formatting, custom and dynamic validation, filter, custom filter, table creation.
Class Location
Online (video chat via skype, google hangout etc)
Student's Home
Tutor's Home
Years of Experience in Computer Classes
10
Type of Computer course taken
Basics of Computer usage, Training in Software application usage, Training in Computer tools usage, Software Programming
Teaching Experience in detail in Computer Classes
I have 10 Years experience in different domain like Banking, E-commerce, IT. currently working as a Senior Analyst in MNC. i have good knowledge of excel, advance excel, MIS reporting, Macros, Power BI, MS Access, MS Sql and all the functions and formulas used in any types of industry.
Want to learn from Ram Rawat?
Share this Profile
Recommended Profiles
Also have a look at
Reply to 's review
Enter your reply*
Your reply has been successfully submitted.
Certified
The Certified badge indicates that the Tutor has received good amount of positive feedback from Students.
Jogeshwari East, Mumbai 
