Learn the most advanced formulas, functions, and types of financial analysis to be an Excel power user. This advanced Excel training course builds on our Excel Fundamentals – Formulas for Finance. It is designed specifically for spreadsheet users who are already proficient and looking to take their skills to an advanced level. This advanced tutorial will help you become a world-class financial analyst for careers in investment banking, private equity, corporate development, equity research, and FP&A.
1. Introduction
2. Interface
3. Tabs and Ribbons
4. Document Windows
5. Navigation Tips
6. Office Button and Save
7. Workbook Passwords
8. Protecting Workbooks
9. Unlocking Cells
10. Save As Previous Version
11. Auto Recover Save Options
12. Templates
13. Save As PDF
14. Save As Web Page
15. Macro-Enabled Workbook
1. Introduction
2. Entering Data
3. Fonts, Fills, and Alignment
4. Cut, Copy, and Paste
5. Paste Special
6. Undo and Redo
7. Moving, Finding, and Replacing a Value
8. Cell Styles
9. Comments
1. Introduction
2. Currency Format
3. Format Painter
4. Formatting Dates
5. Custom and Special Formats
1. Introduction
2. Naming and Moving Worksheets
3. Copying Worksheets
4. Adding, Deleting and Hiding Worksheets
5. Grouping Worksheets
6. Moving, Copying, Deleting and Hiding Grouped Worksheets
7. Inserting and Deleting Columns and Rows
8. Inserting & Deleting Cells
9. Inserting Multiple Columns & Rows
10. Modifying Cell Width and Height
11. Hiding and Unhiding Rows and Columns
12. AutoFill a Series
13. Creating Custom Lists
14. Series Formatting
1. Introduction
2. Highlight Cells Rules
3. Top/Bottom Rules
4. Data Bars
5. Color Scales
6. Custom Formatting Rule
1. Introduction
2. Insert a Table and Style Options
3. Add Rows and Columns
4. Perform a Function in a Table
5. Summarise With Pivot Table
1. Introduction
2. Workbook Views & Show/Hide
3. Zoom Features & Freeze Panes
4. Split Windows
5. Viewing Multiple Windows
6. Minimize The Ribbon
7. Worksheet Backgrounds & Watermarks
1. Introduction
2. Data Validation
3. Drop-Down Lists
4. Removing Duplicates
5. Text To Columns
6. Goal Seek
7. Scenario Manager
1. Introduction
2. Using Operations
3. Creating Formulas
4. AutoSum
5. Common Formulas
6. Searching for Formulas
7. Copying Formulas
1. Introduction
2. Cell Names
3. Named Ranges
4. Formulas with Cell Names
5. Date Formulas
1. Introduction
2. VLOOKUP
3. VLOOKUP Exact Match
4. HLOOKUP
5. HLOOKUP Exact Match
1. Introduction
2. IF Statement
3. Nested IF
4. AND
5. OR
6. NOT
7. IFERROR
8. SUMIF
9. AVERAGEIF
10. COUNTIF & COUNTIFS
11. SUMIFS
12. AVERAGEIFS
1. Introduction
2. Case Formulas
3. Fix Number Fields
4. Trim Spaces
5. Substitute Text
1. Introduction
2. Multiple Sheet References
3. Consolidating Data – With or Without Links
4. Trace the Precedents and Dependents
5. Using the Watch Window
1. Introduction
2. Chart Types
3. Instant Chart
4. Update Chart
5. Column Chart
6. Picture Fill
7. Adjust Chart Size
8. Line Chart
9. Scatter Chart
1. Introduction
2. Chart Styles
3. Chart Layouts
4. Add Labels
5. Axis Options
6. Chart Title
7. Legends
8. Data Labels
1. Introduction
2. Insert Pictures
3. Modifying Pictures
4. Insert Shapes
5. Insert Smart Art
6. Apply Themes and Arrange
1. Introduction
2.Group and Ungroup
3. Sort Data
4. Sort Multiple Levels
5. Filter Data
6. Advanced Filter
7. Conditional Sorting and Filtering
8. Sorting with Custom Lists
9. Subtotal
1. Introduction
2. Creating PivotTables
3. Choosing Fields
4. PivotTable Layout
5. Filtering PivotTables
6. Modifying PivotTable Data
7. PivotCharts
1. Introduction
2. Document Properties
3. Inserting Hyperlinks
4. Sharing a Workbook
5. Track Changes
6. Accept/Reject Changes
7. Mark as Final
1. Introduction
2. Page Orientation
3. Page Breaks
4. Print Area
5. Margins
6. Print Titles
7. Headers and Footers
8. Scaling
9. Sheet Options
1. Introduction and Macro Security
2. Recording a Macro
3. Assign a Macro to a Button or Shape
4. Run a Macro upon Opening a Workbook
5. How to Inspect and Modify a Macro
1. To Define KPIs (Key performance Indicator)
2. Customer Service Dashboards or Project Management Dashboard (Gantt Chart)
3. Dashboard Reports Based on Tables
4. Number or Charts/Graphs or Both
Regular Batch: 25-30 Sessions* (1.5hrs)
Weekend Batch: 15-18 Sessions*(2hrs)
Fast Track: 10-12 Days*(3.5hrs)
Eligibility : 12th+ Having basic knowledge of Computer