UrbanPro
true

Excel & Advanced Excel Trainng

LIVE
4 reviews
Ongoing

Course offered by Uday Kumar

5 reviews
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

Gallery (2)

Intro Video

About the Trainer

Uday Kumar picture

5 Avg Rating

5 Reviews

4 Students

4 Courses

Uday Kumar

B.Com (Computers)

10 Years of Experience

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

Students also enrolled in these courses

LIVE
57 reviews

Course offered by Multiple tutors

5 reviews
LIVE
57 reviews

Course offered by Multiple tutors

5 reviews
LIVE
57 reviews

Course offered by Multiple tutors

5 reviews
LIVE
57 reviews

Course offered by Multiple tutors

5 reviews

Reviews (4)

5 out of 5 4 reviews

Uday Kumar https://p.urbanpro.com/tv-prod/member/photo/660435-small.jpg J P Nagar
5.0054
Uday Kumar
C

Excel & Advanced Excel Trainng

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

Uday Kumar
M

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. "

Uday Kumar
M

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. "

Uday Kumar
K

Microsoft Excel Training

"Your kindness and enthusiasm for Excel are fantastic. The numerous shortcuts that you teach are invaluable. The best thing about his training is, its very simple and easy to understand. "

View All
Have you attended any class with Icmas?

Tutor has not setup batch timings yet. Book a Demo to talk to the Tutor.

Different batches available for this Course

5 out of 5 4 reviews

Uday Kumar https://p.urbanpro.com/tv-prod/member/photo/660435-small.jpg J P Nagar
5.0054
Uday Kumar
C

Excel & Advanced Excel Trainng

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

Uday Kumar
M

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. "

Uday Kumar
M

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. "

Uday Kumar
K

Microsoft Excel Training

"Your kindness and enthusiasm for Excel are fantastic. The numerous shortcuts that you teach are invaluable. The best thing about his training is, its very simple and easy to understand. "

Have you attended any class with Icmas?

Reply to 's review

Enter your reply*

1500/1500

Please enter your reply

Your reply should contain a minimum of 10 characters

Your reply has been successfully submitted.

Certified

The Certified badge indicates that the Tutor has received good amount of positive feedback from Students.

Different batches available for this Course

tickYou have successfully registered

Excel & Advanced Excel Trainng by Uday Kumar

Uday Kumar picture
LIVE
(4 reviews)

Class
starts in

01

Hour

01

Min

01

Sec

Select One

Register Now

Do you want to Register for this Free class?

Yes, Register No, not right now

Tell us a little more about yourself

Excel & Advanced Excel Trainng by Uday Kumar

Uday Kumar picture
LIVE
(4 reviews)

Class
starts in

01

Hour

01

Min

01

Sec

Please enter Student name

Please enter your email address.

Please enter phone number.

Verify Your Mobile Number

Please verify your Mobile Number to book this free class.

Update

Please enter 10 digit phone number.

Please enter your phone number.

Please Enter a valid Mobile Number

This number is already in use.

Resend

Please enter OTP.

Or, give a missed call and get your number verified

080-66-0844-42

This website uses cookies

We use cookies to improve user experience. Choose what cookies you allow us to use. You can read more about our Cookie Policy in our Privacy Policy

Accept All
Decline All

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 7.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more