Learn BASIC TO ADVANCE Microsoft Excel Course

About Learn BASIC TO ADVANCE Microsoft Excel Course

This course will teach you the following things

1) Excel Basic Introduction

2) Look up and functions

3) Conditional formatting

4) Graphical Representation of Data using Excel

5) Sorting and filtering

6) Data analysis using tool pack

7) Pivot chart and Pivot Table

This course is design for the students who want to learn excel in an easy way in urdu or hindi language .as we know that

The main uses of Excel include:

Data entry.

Data management.

Accounting.

Financial analysis.

Charting and graphing.

Programming.

Time management.

Task management

Overview

Learn the basics of creating spreadsheets in Excel. Enter data, formulas, format and print workbooks.

Target Student

This course is for individuals whose job responsibilities include creating, inputting and printing basic spreadsheets.

Prerequisites

Basic Windows, keyboarding and mouse skills.

Course Outline

Getting Started

Starting Excel

Opening a Workbook

Understanding the Display Screen

Working with the Ribbon

Exploring the File Tab

Working with the Quick Access Toolbar

Working with the Status Bar

Switching Between Opened Workbooks

Using Excel Help

Entering Data

Moving the Cell Pointer

Selecting a Range of Cells

Creating a New Workbook

Inserting, Renaming, and Deleting Worksheets

Entering Constant Values

Using Auto Fill to Enter Data

Saving a Workbook

Editing Cell Contents

Clearing Cell Contents

Working with Undo and Redo

Closing a Workbook

Using Formulas

Entering Formulas

Using Auto Fill with Formulas

Using the SUM Function

Summing Columns or Rows Automatically

Using Statistical Functions

Working with the Range Finder

Using Formula Error Checking

Working with Constant Values and Formulas

Copying and Pasting Constant Values and Formulas

Cutting and Pasting Constant Values and Formulas

Using Collect and Paste

Formatting Worksheets

Formatting Numbers

Changing the Font Format

Aligning Cell Contents

Merging Cells

Adding Borders

Applying Cell Styles

Modifying Columns and Rows

Changing Column Width

Changing Row Height

Inserting and Deleting Columns or Rows

Hiding Columns or Rows

Editing Workbooks

Working with AutoCorrect

Checking Spelling

Using Find and Replace

Printing Worksheets

Using Print Preview

Working with Print Settings

Using Page Setup Tools

Working in Page Layout View

Creating a Header and Footer

Using Page Break Preview

Printing a Worksheet

Exiting Excel