Advanced Excel

microsoft excel course

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, 
Advance Formula :-
  • 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

Popular posts from this blog

Goods and Services Tax Certification

Diploma in Computer Application

Income Tax Certification