Friday 20 January 2017

Advanced MS Excel

After completing MS Excel training course, students will be able to address the following questions:
  1. Understand the basic layout and setup
  2. Get familiar with important shortcuts
  3. Comprehend how to Cut, Copy, Paste, Hide, and Unhide data in rows, columns, and sheets
  4. Overview of Merge & Center
  5. Understand Text Alignment and Text Indent
  6. Learn Custom Formatting and Conditional Formatting
  7. Learn Basic/Advanced Charting – Pie charts, Combo charts, Waterfall charts, Gantt charts, etc.
  8. Understand how to make Pivot tables
  9. Understand Data Validation and Filters
  10. Know how to utilize Goal Seek to validate assumptions
  11. Protecting and Sharing – Cells, Worksheets, and Workbooks
  12. Learn basic functions, including Sum, Sumif, And, Average, Choose, Vlookup, Hlookup, Count, Countif, Max, Median, Sumproduct, Today, Eomonth, NPV, PMT, and IRR.
  13. Learn advanced functions, including Match/Index, Offset, String functions, Date and Array functions.
  14. Understand niche functions, including Etworkdays.Intl, Yield, Transpose, Forecast and Trend, Text, Mod, Db, Sln, Ipmt and Ppmt, Find, Len, Left, Right, Mid, and Mirr.

No comments:

Post a Comment