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, Basic Excel, Excel VBA Training, Excel Macro 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
Training in Computer tools usage, Basics of Computer usage, Training in Software application 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, Basic Excel, Excel VBA Training 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, Basic Excel, Excel VBA Training, Excel Macro 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
Training in Computer tools usage, Basics of Computer usage, Training in Software application 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?
Post your Learning Need
Let us shortlist and give the best tutors and institutes.
or
Send Enquiry to Ram Rawat
Let Ram Rawat know you are interested in their class
Reply to 's review
Enter your reply*
Your reply has been successfully submitted.
