Advance MS Excel Training
What is this course ?
Microsoft Excel is one of the most commonly used products of Microsoft office. It is used for data entry, data analysis, data presentation, or calculation. The best thing about Microsoft Excel is that this totally depends on your skill level. You can use MS Excel for any beginner or advanced level task. It will be equally efficient & easy to use in either case.
This MS Excel course is Advance Level or Expert Level training especially for engineers, data analysts, data scientists, students, teachers, or researchers, or for anyone who has basic or intermediate level Microsoft Excel knowledge & now wants to learn Advance Level, MS Excel.
Course Contents
- Beginners introduction to Excel
- Basic Formatting techniques
- Absolute and Relative Cell referencing techniques
- Conditional Formatting
- Auto filter and advance data filtering
- Pivot Table
- Creating and designing charts
- Data validation
- Formula Auditing and Formula Valuation
- Error checking and data monitoring
- Protecting and hiding information and formulas
- Use of Financial Functions and formulas
- Logical functions
- Look up and reference functions
- What if analysis
Who can participate ?
Following people can participate in this course
Since this course is numerical calculations and non-numerical application, So any
professional can take participate in this program. They are:
- Managers, office secretaries, account
officers, finance officers, - Customer service related executives, sales and marketing staffs,
business owners, head of departments, - Front desk officers, personal assistants, human
resource department staffs, corporate planning executives,