Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

Excel & Advanced Excel Trainng

3 Reviews

Course type: Online Instructor led Course

Platform: Goto Meeting/Google Hangout

Course ID: 24790

Course type: Online Instructor led Course

Platform: Goto Meeting/Google Hangout

Students Interested 0 (Seats Left 0)

₹ 3,500

3 Reviews

Date and Time

Not decided yet.

Uday Kumar picture
Uday Kumar

B.Com (Computers)

4 Years of Experience

About Uday Kumar

About 6 years of experience in training and have been working on excel projects and automation for corporate.
C

Christophil Varghese

Attended Excel & Advanced Excel Trainng

An excellent trainer who drives you to attain solutions to the problems at hand with data.

M

Mathew Blake

Attended Excel & Advanced Excel Trainng

I can give ***** rating for his training as he explains complex topics in a simple way with lot of industry examples.

M

Mathew Blake

Attended Excel & Advanced Excel Trainng

I enrolled online class for excel training in July, 2014. He has a very good selection of topics and a plenty of valuable tips, but I enjoyed the advanced formulas section a lot. The first day we had a problem in connecting class through online, however it was fine on the second day on-wards.

About the Course

This Excel training is to help everyone to learn, develop and to get exposure to their MS-Excel knowledge. It will help you to get knowledge on various world class examples. This training is based on the practical experience and not just an explanatory course. This aim of this training is to make users expert in excel.

Topics Covered

1. Introduction to Excel. Advantages of Excel & where all it can be used. Navigation through ribbons
2. Introduction & Use of Formatting Cells
3. About Format Painter
4. About Paste Special
5. About Format Cells Window
6. Custom Cell Formats
7. Number Formats
8. Date/Time/Date & Time Formatting
9. Split sheets/Freezing Rows
10. ROWS, COLUMNS
11. References & Freezing references
12. Round function
13. RoundUp
14. RoundDown
15. IF Conditions
16. Nested IF
17. Combination of IF & Round Functions [Industry Example(s)]
18. MATCH
19. INDEX
20. OFFSET
21. IFERROR, ISERROR
22. SMALL & LARGE
23. Text Function (Format)
24. Clean Function
25. Concatenate Function
26. Find Function
27. Left/Right Function
28. Mid Function
29. REPT function
30. Trim Function
31. Upper/Lower/Proper Functions
32. Excel Challenge/Quiz: [Industry Example(s)]
33. Finding system current date
34. Finding system current time
35. Workday
36. Net workdays
37. Weekdays
38. Hour/Minute/Second Function
39. Calculating the age of a person
40. Calculating SLAs (Service Line Agreements)
41. Calculating TAT (Turn Around Time)
42. Examples of TAT & SLAs [Industry Example(s)]
43. Excel Challenge/Quiz: To get only date out of date & time [Industry Example(s)]
44. Introduction of Condition Formatting
45. Difference between Formatting & Conditional Formatting
46. Conditional Formatting Using values
47. Formulas in Conditional Formatting
48. Excel Challenge to Trainees: Icons usage
49. Industry Examples on Conditional Formatting
50. Hiding cell value to appear and only Color to display
51. Removing Conditional Formatting
52. Introduction of Data tables
53. Advantages of using data tables
54. Introduction of Pivot table
55. Creation of Pivot tables
56. Summary functions
57. Calculations in Pivot tables & custom calculation with Calculated Fields & Calculated Items
58. Writing formulas to perform some calculations
59. Grouping & ungrouping of Data in pivot tables
60. Pivot Table Tips
61. Creating of Pivot Charts – Basic
62. Arranging data in ascending and descending order
63. Sorting for different types of data – by Numbers, dates, alphabets
64. Sorting challenges for excel 2003 users only
65. How to use auto filter
66. Customize filters using different options
67. Advance Filter - Finding Unique records using advance filter
68. Data Validations
69. Different types of data validation
70. Data validation through a formula
71. Error message in data validation
72. Input message in data validation
73. LOOKUP array
74. VLOOKUP
75. HLOOKUP
76. Advanced LOOKUP
77. Sumif function
78. SUMIFS & COUNTIFS
79. SUMPRODUCT
80. Excel Challenge/Quiz: [Industry Example(s)]
81. Named Ranges
82. Introduction to Charts
83. Various chart(s) in Excel
84. Formatting options in Charts
85. Displaying Charts for Turn Around Time (TAT)
86. Importing Text Files
87. Text to Columns
88. How to play around with the Imported Data
89. Most commonly used Excel Shortcuts
90. Customizing Quick Access Toolbar
91. Introduction to Macros
92. Recording and running macros
93. How to get Visual Basic Editor
94. Excel Project

Who should attend

Who has passion towards learning Excel

Pre-requisites

Basic knowledge of computers and excel

What you need to bring

As this is an online training, require an internet access and will contact for further details once interested"

Key Takeaways

At the end of the class students will be able to write Excel formulas and can work on excel projects

Reviews (3) See all Reviews

C

Christophil Varghese

Attended Excel & Advanced Excel Trainng

An excellent trainer who drives you to attain solutions to the problems at hand with data.

M

Mathew Blake

Attended Excel & Advanced Excel Trainng

I can give ***** rating for his training as he explains complex topics in a simple way with lot of industry examples.

M

Mathew Blake

Attended Excel & Advanced Excel Trainng

I enrolled online class for excel training in July, 2014. He has a very good selection of topics and...

Gallery (2)

Video

A sample Introduction of Excel Online...

Document

Excel & Advanced Excel Trainng

Discussions (2)

Your kindness and enthusiasm for Excel are fantastic. The numerous shortcuts that you teach are invaluable....

By Kiran

Uday Kumar

Top Answer

Thanks Kiran, Hope you are using Ctrl+1, Ctrl+Shift+L

0 Dislike
Comment
View all answers
Hi Uday, Hope you remember me. Thanks much for the excel training which happened in July. I would like...

By Mathew

Uday Kumar

Top Answer

Thanks Mathew, Excel Dashboard Training will kick start in January

0 Dislike
Comment
View all answers

Students Interested 0 (Seats Left 0)

₹ 3,500

Post your requirement and let us connect you with best possible matches for Microsoft Excel Training classes Post your requirement now
₹ 3,500 Enquire

Enquire

Submit your enquiry for Excel & Advanced Excel Trainng

Please enter valid question or comment

Please enter your name.

Please enter valid Phone Number

Please enter the Pin Code.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With Uday

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at support@urbanpro.com for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer