Microsoft Excel

Excel 2011: Level 1 (Macintosh)

Course Outline

 

  • Lesson 1: Getting Started with Excel
    • Topic 1A: Identify the Elements of the Excel Interface
    • Topic 1B: Navigate and Select Cells in Worksheets
    • Topic 1C: Customize the Excel Interface
    • Topic 1D: Create a Basic Worksheet
  • Lesson 2: Performing Calculations in an Excel Worksheet
    • Topic 2A: Create Formulas in a Worksheet
    • Topic 2B: Insert Functions in a Worksheet
    • Topic 2C: Reuse Formulas
  • Lesson 3: Modifying a Worksheet
    • Topic 3A: Edit Worksheet Data
    • Topic 3B: Find and Replace Data
    • Topic 3C: Manipulate Worksheet Elements
  • Lesson 4: Modifying the Appearance of a Worksheet
    • Topic 4A: Apply Font Properties
    • Topic 4B: Add Borders and Culors to Cells
    • Topic 4C: Align Content in a Cell
    • Topic 4D: Apply Number Formatting
    • Topic 4E: Apply Cell Styles
  • Lesson 5: Managing an Excel Workbook
    • Topic 5A: Manage Worksheets
    • Topic 5B: View Worksheets and Workbooks
  • Lesson 6: Printing Excel Workbooks
    • Topic 6A: Define the Page Layout
    • Topic 6B: Print a Workbook

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

Excel 2011: Level 2 (Macintosh)

Course Outline

 

  • Lesson 1: Calculating Data with Advanced Formulas
    • Topic 1A: Apply Cell and Range Names
    • Topic 1B: Calculate Data Across Worksheets
    • Topic 1C: Use Specialized Functions
    • Topic 1D: Analyze Data with Logical and Lookup Functions
  • Lesson 2: Organizing Worksheet and Table Data
    • Topic 2A: Create and Modify Tables
    • Topic 2B: Format Tables
    • Topic 2C: Sort or Filter Data
    • Topic 2D: Use Functions to Calculate Data
    • Topic 2E: Create a PivotTable Report
  • Lesson 3: Presenting Data Using Charts
    • Topic 3A: Create a Chart
    • Topic 3B: Modify Charts
    • Topic 3C: Format Charts
  • Lesson 4: Inserting Graphic Objects
    • Topic 4A: Insert and Modify Pictures and Clip Art
    • Topic 4B: Draw and Modify Shapes
    • Topic 4C: Illustrate Workflow Using SmartArt Graphics
    • Topic 4D: Layer and Group Graphic Objects
  • Lesson 5: Customizing and Enhancing the Excel Environment
    • Topic 5A: Customize the Excel Environment
    • Topic 5B: Customize Workbooks
    • Topic 5C: Manage Themes
    • Topic 5D: Create and Use Templates

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

Power BI Immersion

Course Outline

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