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

Map Location

Quick Enquiry