Microsoft Excel - from Beginner to Advance

This course is designed for all whether they are studying in schools or working in corporates. This course will add a highly valuable asset to your professional portfolio. The course starts from scratch where you will start with basic spreadsheet skills and at the end of this course, you will be excellent in Excel where you will be able to do complex calculations, plot graphs, charts, and analyze data for problem-solving. You will learn 360 degree of Learning of Microsoft Excel. This course is divided into 6 Sessions where you will cover 45 Topics.

Session 1:

1. Introduction

2. Starting Excel

3. Screen

4. Templates

5. Ribbon and Backstage View

6. Quick Access Toolbar

7. Smart Lookup

8. Interface Elements

Session 2:

1. Navigation

2. Keyboard Shortcuts

3. Entering Text

4. Number Format

5. Deleting & Formatting

6. AutoSum

7. Simple Formulas

8. Simple Functions

Session 3:

1. Absolute Referencing

2. Moving & Copying Data

3. Inserting Rows & Columns

4. AutoFill

5. Cell Styles

6. Worksheet Themes

7. Create Templates

8. Freeze Panes

Session 4:

1. Grouping Worksheets

2. Page Layout View

3. Custom Views

4. Spell Check

5. Printing

Session 5:

1. Introduction to Table

2. Overview of List Design

3. Formatting Lists as Tables

4. Filtering Records from Lists or Tables

5. Removing Duplicates from Lists or Tables

6. Flash Fill

7. Single & Multi-Level Sorting

8. Inserting Automatic Subtotals in Lists

Session 6:

1. Introduction to chart

2. Inserting Data Charts Using Recommended Charts

3. Formatting & Editing Chart Elements

4. Creating & Applying Custom Chart Templates

5. Adding & Removing Data from Charts

6. Inserting Sparklines

7. Printing Charts