After completing MS Excel training course, students will be able to address the following questions:
- Understand the basic layout and setup
- Get familiar with important shortcuts
- Comprehend how to Cut, Copy, Paste, Hide, and Unhide data in rows, columns, and sheets
- Overview of Merge & Center
- Understand Text Alignment and Text Indent
- Learn Custom Formatting and Conditional Formatting
- Learn Basic/Advanced Charting – Pie charts, Combo charts, Waterfall charts, Gantt charts, etc.
- Understand how to make Pivot tables
- Understand Data Validation and Filters
- Know how to utilize Goal Seek to validate assumptions
- Protecting and Sharing – Cells, Worksheets, and Workbooks
- Learn basic functions, including Sum, Sumif, And, Average, Choose, Vlookup, Hlookup, Count, Countif, Max, Median, Sumproduct, Today, Eomonth, NPV, PMT, and IRR.
- Learn advanced functions, including Match/Index, Offset, String functions, Date and Array functions.
- 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