Microsoft Excel 2016

Excel 2016: Data Analysis with PivotTables

Course Outline

 

  • Preparing Data and Creating PivotTables
    • Prepare Data
    • Create a PivotTable from a Local Data Source
    • Create a PivotTable from Multiple Local Data Sources
    • Create a PivotTable from an External Data Source
  • Analyzing Data Using PivotTables
    • Summarize PivotTable Data
    • Organize PivotTable Data
    • Filter PivotTable Data
    • Format a PivotTable
    • Refresh and Change PivotTable Data
  • Working with PivotCharts
    • Create a PivotChart
    • Manipulate PivotChart Data
    • Format a PivotChart

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

Excel 2016: Data Analysis with Power Pivot

Course Outline

 

  • Getting Started with Power Pivot
    • Enable and Navigate Power Pivot
    • Manage Data Relationships
  • Visualizing Power Pivot Data
    • Create a Power Pivot Report
    • Create Calculations in Power Pivot
  • Working with Advanced Functionality in Power Pivot
    • Create a Key Performance Indicator
    • Work with Dates and Time in Power Pivot
  • Appendix A: Commonly Used DAX Functions

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

Excel 2016: Level 1

Course Outline

 

  • Lesson 1: Getting Started with Microsoft Office Excel 2016
    • 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 and Functions
  • 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: Apply Text Formats
    • Topic B: Apply Number Formats
    • Topic C: Align Cell Contents
    • Topic D: Apply Styles and Themes
    • Topic E: Apply Basic Conditional Formatting
    • Topic F: Create and Use Templates
  • Lesson 5: Printing Workbooks
    • Topic A: Preview and Print a Workbook
    • Topic B: Set Up the Page Layout
    • Topic C: Configure Headers and Footers
  • Lesson 6: Managing Workbooks
    • Topic A: Manage Worksheets
    • Topic B: Manage Workbook and Worksheet Views
    • Topic C: Manage Workbook Properties
  • Appendix A: Adding Borders and Culors to Worksheets
  • Appendix B: Basic Excel Customization

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

Excel 2016: Level 2

Course Outline

 

  • Lesson 1: Working with Functions
    • Topic A: Work with Ranges
    • Topic B: Use Specialized Functions
    • Topic C: Work with Logical Functions
    • Topic D: Work with Date & Time Functions
    • Topic E: Work with Text Functions
  • Lesson 2: Working With Lists
    • Topic A: Sort Data
    • Topic B: Filter Data
    • Topic C: Query Data with Database Functions
    • Topic D: Outline and Subtotal Data
  • Lesson 3: Analyzing Data
    • Topic A: Create and Modify Tables
    • Topic B: Apply Intermediate Conditional Formatting
    • Topic C: Apply Advanced Conditional Formatting
  • Lesson 4: Visualizing Data with Charts
    • Topic A: Create Charts
    • Topic B: Modify and Format Charts
    • Topic C: Use Advanced Chart Features
  • Lesson 5: Analyzing Data with PivotTables and PivotCharts
    • Topic A: Create a PivotTable
    • Topic B: Analyze PivotTable Data
    • Topic C: Present Data with PivotCharts
    • Topic D: Filter Data by Using Timelines and Slicers
  • Appendix A: Microsoft Office Excel 2016 Exam 77-TBD
  • Appendix B: Microsoft Office Excel 2016 Expert Exams 77-TBD and 77-TBD
  • Appendix C: Financial Functions
  • Appendix D: Working with Graphical Objects
  • Appendix E: Using Array Formulas

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