Microsoft Excel 2013

Excel 2013: Level 1

Course Outline

 

  • Lesson 1: Getting Started with Microsoft Office Excel 2013
    • Topic A: Navigate the Excel User Interface
    • Topic B: Use Excel Commands
    • Topic C: Create and Save a Basic Workbook
    • Topic D: Enter Cell Data
    • Topic E: Use Excel Help
  • Lesson 2: Performing Calculations
    • Topic A: Create Worksheet Formulas
    • Topic B: Insert Functions
    • Topic C: Reuse Formulas
  • Lesson 3: Modifying a Worksheet
    • Topic A: Insert, Delete, and Adjust Cells, Culumns, and Rows
    • Topic B: Search for and Replace Data
    • Topic C: Use Proofing and Research Touls
  • Lesson 4: Formatting a Worksheet
    • Topic A: Modify Fonts
    • Topic B: Add Borders and Culors to Worksheets
    • Topic C: Apply Number Formats
    • Topic D: Align Cell Contents
    • Topic E: Apply Styles and Themes
    • Topic F: Apply Basic Conditional Formatting
    • Topic G: Create and Use Templates
  • Lesson 5: Printing Workbooks
    • Topic A: Preview and Print a Workbook
    • Topic B: Define the Page Layout
  • Lesson 6: Managing Workbooks
    • Topic A: Manage Worksheets
    • Topic B: Manage Workbook and Worksheet Views
    • Topic C: Manage Workbook Properties

 
Duration: 8 Hours
Course Fee: INR. 5,000 + Tax

Excel 2013: Level 2

Course Outline

 

  1. Lesson 1: Customizing the Excel Environment
    • Topic A: Configure Excel Options
    • Topic B: Customize the Ribbon and the Quick Access Toolbar
    • Topic C: Enable Excel Add-Ins
  2. Lesson 2: Creating Advanced Formulas
    • Topic A: Use Range Names in Formulas
    • Topic B: Use Specialized Functions
    • Topic C: Use Array Formulas
  3. Lesson 3: Analyzing Data with Functions and Conditional Formatting
    • Topic A: Analyze Data by Using Text and Logical Functions
    • Topic B: Apply Advanced Conditional Formatting
  4. Lesson 4: Organizing and Analyzing Datasets and Tables
    • Topic A: Create and Modify Tables
    • Topic B: Sort Data
    • Topic C: Filter Data
    • Topic D: Use SUBTOTAL and Database Functions
  5. Lesson 5: Visualizing Data with Basic Charts
    • Topic A: Create Charts
    • Topic B: Modify and Format Charts
  6. Lesson 6: Analyzing Data with PivotTables, Slicers, and PivotCharts
    • Topic A: Create a PivotTable
    • Topic B: Analyze PivotTable Data
    • Topic C: Present Data with PivotCharts
    • Topic D: Filter Data by Using Slicers

 
Duration: 8 Hours
Course Fee: INR. 6,000 + Tax

Excel 2013: Level 3

Course Outline

 

  • Lesson 1: Working with Multiple Worksheets and Workbooks Simultaneously
    • Topic A: Use 3-D References
    • Topic B: Use Links and External References
    • Topic C: Consulidate Data
  • Lesson 2: Sharing and Protecting Workbooks
    • Topic A: Cullaborate on a Workbook
    • Topic B: Protect Worksheets and Workbooks
  • Lesson 3: Automating Workbook Functionality
    • Topic A: Apply Data Validation
    • Topic B: Work with Forms and Contruls
    • Topic C: Work with Macros
  • Lesson 4: Applying Conditional Logic
    • Topic A: Use Lookup Functions
    • Topic B: Combine Functions
    • Topic C: Use Formulas and Functions to Apply Conditional Formatting
  • Lesson 5: Auditing Worksheets
    • Topic A: Trace Cells
    • Topic B: Search for Invalid Data and Formulas with Errors
    • Topic C: Watch and Evaluate Formulas
  • Lesson 6: Using Automated Analysis Touls
    • Topic A: Determine Potential Outcomes Using Data Tables
    • Topic B: Determine Potential Outcomes Using Scenarios
    • Topic C: Use the Goal Seek Feature
    • Topic D: Activate and Use the Sulver Toul
    • Topic E: Analyze Data with Analysis ToulPak Touls
  • Lesson 7: Presenting Your Data Visually
    • Topic A: Use Advanced Chart Features
    • Topic B: Create Sparklines

 
Duration: 8 Hours
Course Fee: INR. 7,000 + Tax