Advanced Excel

Understanding of Excel Objects:

1. Introduction to MS Excel Sheet
2. Moving along/across MS Excel Sheet
3. Entering and Editing Data into Cells
4. Naming cells
5. Copy/Cut and Paste
6. Format Painter
7. Ranges of Paste Special
8. Font & Font size changing
9. Fill Color & Font Color
10. Applying Borders
11. Alignment
12. Orientation changing
13. Wrap Text & Merging Cells
14. Increasing & Decreasing decimals
15. Row/Column Inserting & Deleting
16. Filling Cells
17. Sorting & Filtering
18. Finding & Selecting
19. Hiding Cells and Gridlines 
20. Naming, Adding, & Deleting Worksheets
21. Changing Worksheet Tab Color
22. Linking and Referencing inside and across worksheets
23. Relative and Absolute Referencing
24. Linking Across Different Files
25. Row Height & Column Width
26. Hiding and Unhiding Rows and Columns
27. Insert Copied Cells
28. Understanding Functions and Formula in Excel
29. Operators for Writing Formulas
30. Types of Functions in Excel
31. Copying Formulas and Functions

Customization of Wordbook/Sheets/Data:

1. Conditional Formatting
2. Format as Tables
3. Cell Styles
4. Number Formatting
5. Entering the current date or time into a cell.
6. Making Charts & Sparklines
7. Freeze Panes
8. Go To Special
9. Using Hyperlinks

ADVANCE SKILLS ON EXCEL FUNCTIONS – I

• Logical Functions in Excel

1. IF and nested IF functions
2. And & Or logics
3. IFERROR. 

• Statistical Functions

1. Summing and Averaging
2. MIN & MAX
3. Counting numbers, texts and blanks

• Text Functions:

1. CONCATENATE
2. PROPER, UPPER, LOWER
3. LEN, LEFT, RIGHT
4. TEXT, TRIM

ADVANCE SKILLS ON EXCEL FUNCTIONS – II

This session is a continuation of the last session.

1. Vertical LOOKUP Function
2. Horizontal LOOKUP Functions
3. Variations of Date functions
4. INDEX Function
5. MATCH Function
6. INDIRECT Function
7. SUMIF and SUMIFS
8. COUNTIF and COUNTIFS

OPTIMIZATION AND RISK MANAGEMENT TOOLS IN EXCEL

1. Goal Seek for seeking target values
2. Scenario Analysis
3. Use of Solver
4. Use of Developer Tab
5. Data Validation Techniques
6. Data sorting
7. General Filtering
8. Grouping & Ungrouping
9. Subtotal
10. Pivot Table

       1.Basic knowledge on Financial Management.

2. Basic knowledge on Investment in securities

Basic concept on power pivot. 

Case study to business appraisal preparation.

Basic concept of Company valuation and financial modelling.

Exam