Excel & Advanced Excel Trainng

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