Signup as a Tutor

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

# Excel & Advanced Excel Trainng

4 Reviews

Course type: Online Instructor led Course

Course ID: 24790

Course type: Online Instructor led Course

Students Interested 0 (Seats Left 0)

4 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
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
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
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
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

Not decided yet.

## Gallery (2)

A sample Introduction of Excel Online...

## Students also enrolled in these Courses

5 Avg Rating

5 Reviews

4 Students

3 Courses

Uday Kumar

B.Com (Computers)

4 Years of Experience

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

5.0

Average Rating

100%
0%
0%
0%
0%

## Reviews

C

Christophil Varghese

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

M

Mathew Blake

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

M

Mathew Blake

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.

K

Kiran

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.

## Discussions (2)

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

By Kiran

Uday Kumar

Thanks Kiran, Hope you are using Ctrl+1, Ctrl+Shift+L
0 Dislike
Comment
Hi Uday, Hope you remember me. Thanks much for the excel training which happened in July. I would like...

By Mathew

Uday Kumar

Thanks Mathew, Excel Dashboard Training will kick start in January
0 Dislike
Comment

Students Interested 0 (Seats Left 0)

Post your requirement and let us connect you with best possible matches for Microsoft Excel Training classes Post your requirement now

Enquire

Please enter valid question or comment

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 Enter valid Email or Phone Number