Advanced Excel
Advanced
Excel
Duration - 2 Month
OBJECTIVE :-
Provide Basic Understanding of Excel, Make user Familiar to Create Formula and give Platform to Make Good Analysis and Introduce Powerful Tools of Advance Excel so that user can Make Advance Analysis with the help of Those Tools.
TOPICS COVERED :-
- Introduction of Excel and Basic Understanding.
- Menu Tab Understanding and Printing worksheet.
Basic Formula :-
- Sum, Sumif, Sumifs.
- Count, Counta, Count blank. Countif.
- Average, Max, Large Min, Abs,
- Lower, Upper, Proper, Trim, Len, Left, Right, Mid, Concatenate, Subtotal, And, Or, Day, Year, EOmonth, Edate, Net workdays, Substitute Today, Weekday, Week number, Workday, Find,
- Search. V-lookup, H-lookup, Day and Time Calculation, Numeric Calculation
- If Logical Condition
- Pivot Table
- Pivot Chart
- Dynamic Pivot
- Dynamic Chart
- Conditional Formatting
- Dated if
- What If Analysis
- Match
- Index
- Index Match
- Index Match Match
- Offset Function
- User form Function in Excel
- Data Validation
- Data VAlidation With Conditional
- Advance Filter, Sorting
- Group & Ungroup
- Data split
- Text Function (Data Separation)
v Assignment,
Project Work
v MCQs
Carrer in Microsoft Excel
We scrounged up a list of jobs (in no particular order) that make use of Excel to give you a head start.
1. Financial Analysts. Financial Analysts are expected to know MS Excel inside out. ...
2. Retail Store Managers. ...
3. Project Managers. ...
4. Business Analysts. ...
5. Data Journalists. ...

Comments
Post a Comment