Basic Excel

1. Day-1

• 1.1. Discussion on reporting and analysis using MS Excel
• 1.2. Working with Rows, columns, sheets and workbooks R
• 1.3. Navigation in Excel sheet andit’s shortcuts
• 1.4. Concept ofcells range,address,Name range, formula bar, etc..
• 1.5. Formatting cells, Fonts, Alignment, Numbers, Styles...

2. Day-2

• 2.1. Risk and protections (protecting cells, sheet and workbook)
• 2.2. Cut, copy, paste and Paste Special
• 2.3. Data Sorting
• 2.4. Data Filtering
• 2.5. Inserting images, Text boxes, Header & Footer
• 2.6. Page layouts –Margin, Orientation, size etc..

3. Day-3

• 3.1. Basic concept of Excel Operation and formula
• 3.2. Frequently used Excel Functions (Sum, count, left, right, find, If, Text etc..)
• 3.3. Trace Precedent, Dependents, error checking and Evaluate formula

4. Day-4

• 4.1. Reference formula in Excel (Vlookup, Hlookup, Index, Match, etc...)
• 4.2. Creating Dynamic Name Range using Offset function
• 4.3. Data validation, Remove duplicate, Text to Column
• 4.4. Group Ungroup and Subtotal
• 4.5. Shapes and Smart Art

Part–II: Advance Excel

5. Day-5

• 5.1. Lookup and Reference function
• 5.2. Text Function
• 5.3. Data & Time function
• 5.4. Nested formula in excel with conditional function –“If”

6. Day-6

• 6.1. Logical Functions
• 6.2. Information functions
• 6.3. Advance Conditional formatting
• 6.4. What if Analysis
  1. 6.4.1. Goal Seek
  2. 6.4.2. Scenario Manager
  3. 6.4.3. Data Table

Day-7

• 7.1. Array Formula
• 7.2. Basics concept of Excel charts
• 7.3. Advance chart techniques
• 7.4. All charts with an example
• 7.5. Form Controls

8. Day-8

• 8.1. Basic of Pivot Tables
• 8.2. Understanding of Row, columns, page and value field
• 8.3. Calculated field in pivot table
• 8.4. Formatting of pivot table

9. Day-9

• 9.1. Getting Started with PowerPivot
• 9.2. Enable and Navigate Power Pivot
• 9.3. Manage Data Relationships
• 9.4. Visualizing Power Pivot Data
• 9.5. Create a Power Pivot Report
• 9.6. Create Calculations in Power Pivot
• 9.7. Working with Advanced Functionality in Power Pivot
• 9.8. Create a Key Performance Indicator
• 9.9. Work with Dates and Time in Power Pivot

Projects

• Creating Reports in Excel
• Creating Scorecard in Excel
• Creating Dynamic Dashboard