Enroll Now

Microsoft Excel 2016 Course Details

StudySection offers the best online Microsoft Excel 2016 course for users who want to learn the new features in MS Excel 2016 along with advanced concepts. This is a well-organized course in which study notes are provided to the students to understand the subject clearly. The course is divided into three units; after thoroughly studying the notes for each unit, you have to attempt a unit test. Each unit test is composed of multiple-choice questions. After successfully passing the unit test, you will be allowed to move on to the next unit. In this way, you have to pass all three levels. A hardcopy certificate will be provided after the successful completion of the course. Those who are admitted as students of StudySection get a significant discount on the course fee.

  • Introduction to Microsoft Excel 2016

    • 1.1 Introduction

      a) General Uses for Microsoft Excel 2016

      b) Excel 2016 Interface

      c) Create Workbook

      d) Open a Workbook

      e) Using Templates

      f) Convert a Workbook from the previous version to Excel 2016

      g) Save and Save As 

      h) Export workbook as a PDF file

      1.2 Working on Cells

      a) Commands on Cells

      b) Cell Content

      c) Formatting Cells

      d) Understanding Number Formats

      1.3 Working with Multiple Worksheets

      a) Insert a New Worksheet

      b) Create a duplicate worksheet

      c) Rename a Worksheet

      d) Delete a Worksheet

      e) Group Worksheets

      f) Ungroup Worksheets

      1.4 Find and Replace

      a) Find Content

      b) Replace the Cell Content

      1.5 Spell Check

      1.6 Printing and Page Layout 

      a) Print a Workbook

      b) Content Adjustment while Printing

  • Data Processing

    • 2.1 Adding Formulas and Functions

      a) Cell Reference

      b) Create a Formula

      c) Copying Formula with File Handler

      d) Relative and Absolute Cell References

      2.2 Functions in Excel 2016

      a) Arithmetic Operators

      b) Comparison Operators

      c) Reference Operators

      d) Microsoft Excel In-built Functions

      2.3 Working with Data

      a) Freezing Rows and Columns

      b) Sorting Data

      c) Filtering Data

      d) Advanced Text Filters

      e) Advanced Numerical Filters

      f) Group Rows and Columns

      g) Creating Subtotals

      2.4 Working with Tables

      a) Modifying Tables

      2.5 Charts in MS Excel 2016

      a) Types of Charts

      2.6 Conditional Formatting

      2.7 Comments

  • Doing More with Excel

    • 3.1 Protecting Workbooks

      a) Options available in MS Excel 2016 for protecting a Workbook 

      b) Protecting an Excel Worksheet

      3.2 Pivot Table in Excel

      a) Add Filters in Pivot Table

      b) Add a slicer

      c) Pivot Charts

      3.3 What-if analysis

      a) Create Scenarios

      3.4 Microsoft Excel Keyboard Shortcuts

    • Enroll Now

    or
    Strength:
    Password must be 6+ characters and contain at least one digit and letter.

    Course Duration -  3 Months

    Course Price -  ₹ 3000 / US $50 (50% discount if you have taken Admission to StudySection)

    Course Path:

    • Enroll the course
    • Access to Study notes per Chapter (on a sequential basis)
    • Unit Test per Chapter (minimum 40% to pass, see grade information below)
    • Your Course Certificate is Issued

    You will be awarded a Course Certificate Softcopy and Hardcopy with the Grade achieved by you in the Unit Tests on successful completion.

    • 80% to 100% - Grade A1
    • 60% to 79.99% - Grade B1
    • 40% to 59.99% - Grade C1
    • Less than 40% - Certificate will not be issued

    This website uses cookies to improve user experience. By using our website you consent to all cookies in accordance with our Cookie Policy. More info. I Agree