In Excel and MS Office
Master in Excel: Become A Smart Professional
Intermediate- English
- 12 Learners
- Validity: 45 days
-Introduction
Excel is a powerful tool which helps professionals in tackling data. It helps in presenting, analysing, summarising and sorting data like no other tool. Professionals in all streams use this tool to enhance their application and analysis skills of the information at their disposal. With the increasing amount of data being used by companies, use of tools like Excel has become mandatory for all professionals to be effective and efficient.
What Will You Learn?
This course aims at giving detailed knowledge on Excel and it is suitable both students and working professionals. This programme is divided into 3 levels thus making it suitable for both beginners and advanced level. This course is a must for the students of financial modelling and equity valuation.
Topics Covered
Level 1:
- Excel Basics
- Excel as a Calculator
- Error
- Sort and Filter
- Charts
- Formatting
Level 2:
- Aggregrate
- Function Wizard
- Cell Referencing
- Logical Functions
- LOOKUP Functions
- INDEX MATCH Functions
- Data Time text Functions
- Nested Functions
- Annoating Functions
- Conditional Formatting
- Custom Number Formatting
- Hyperlink
Level 3:
- Auto Filter
- Subtotal
- Data Consoldiation
- Data Validation
- Sumif and Countif Functions
- Age Calculator
- Nested IF
- Pivot Tables and Charts
- Goal Seek
- What If-Scenario Manager
- Password Protection
- Import and Export Data
- Amortization of Loans
- Sparkline, Trendline, Candlestick Charts
- Macros
- VBA
- SUMIF and COUNTIF Functions
Once taken, you can access this course for a period of 1 month.
Intended Participants
- Students
- Working professionals
- Financial modelling and equity valuation students
- Computer application students
No preview video is available at this moment
