Basic Excel Training Program:
(Duration – 2 Full Days):
Basic Excel Training Program is designed for all those users who have limited knowledge on Microsoft Excel and they want to enrich their skills on it. Participants will learn MS Excel Essentials, Data Editing, Data Formatting, Data Validation, Sorting, Basics of Pivot Table, Formulas etc.
Basic Excel Training Content:
- Excel Essentials.
– Copy Paste (Advance Tips and Tricks).
– Relative, Absolute & Fixed Reference.
– Go To & Go To Special (Basics).
– Wild Characters.
- Introduction to Tables.
- Basic Customized Sorting.
- Conditional Formatting.
- Data Validation.
- Basics of Name Manager.
– Introduction to Name Manager.
– Types of Name Range.
– Usage of Name Manager.
- Working with Dates and Time.
- Pivot Tables.
- “What if” Analysis – Goal Seek.
– Text formulas (Left, Right, Trim, Len, Upper, Lower, Proper etc.).
– Lookup Formulas (Vlookup, Hlookup, Transpose etc.).
– Logical Formulas (If, And, or etc.).
– Date and Time (Date, Datevalue, EOMonth, Workday etc.).
– Math & Trig (If, Sumif, Sumproduct etc.).
– Nested Formulas.
– Edit and understand the formula.
– Advance Auto-Filter.
- Charts (Basics).
- Case Study based on Basic Excel Training Content.
We can customize all our MS Excel Training Programs as per the Company’s need and requirement. Customization can be there in terms of Contents, Duration of Training Program etc.
You may also consider our other training Programs, in case you are looking for different level of Training Programs.