What Will I Learn?

Students will learn basics of Microsoft Excel like: "What is a Cell, Column, Row, Range", "Changing Font Size, Font Color, Fill Color, Border, Alignment (Left, Center, Right), Wrap Text, Merge & Center etc.", "How to Insert a Comment", "How to add/Delete Column, Row".
Students will learn some important Keyboard Shortcut keys like: "Inserting a Formula SUM for all required cells", "Creating Chart from Selected Data", "Numbers in Comma Format, Numbers in Currency Format, Numbers in Percentage Format", "Current Date, Current Time", "Select Entire Row, Column, Hide Rows, Columns", "New Line inside a Cell" etc.
Students will learn: Using SUM formula, Using Average, Max, Min Formulas, How to use Formulas in Reports like: "Sales Report (Simple Format)", "Mark Sheet (Simple Format)", "Cricket Series Report".
Students will learn "Data Analyzing" like: "Pivot Table", "Pivot Chart", "Subtotal", "Charts", "Consolidation (Consolidation (Example 1) (Simple), Consolidation (12 Months Sales Record), Consolidation (Count, Average, Max, Min)".
Students will learn "Data Validation": "Data Validation - Cricket Match ScoreCard", "Data Validation - Date of Current Year", "Data Validation - Numeric Values", "Data Validation - Entering Supplier Names", "Data Validation - Entering Item Names".
Students will learn "IF Function": "IF Function (Introduction)", "Simple IF (Qty Sold Example)", "Simple IF (Rate per Unit Example)", "Nested IF".
Students will learn Filter & Sort.
Students will be able to start working on Spreadsheets.
Students can start work on spreadsheet from the beginning.

Requirements

Microsoft Excel only.

Description

In this course I'll teach you Basics level of Microsoft Excel, and important is that you will learn quickly and in details and can save your much time.

In this course you can learn the following topics:

Introduction: "What is a Cell, What is a Column, What is a Row, What is a Range", "Changing Font Size, Font Color, Fill Color, Border, Alignment (Left, Center, Right), Wrap Text, Merge & Center etc.", "How to Insert a Comment", "How to add/Delete Column, Row".

Special Skills: I'll teach you about valuable Keyboard Shortcut keys like:

"Inserting a Formula SUM for all required cells", "Creating a Chart from Selected Data", "Numbers in Comma Format, Numbers in Currency Format, Numbers in Percentage Format", "Current Date, Current Time", "Select Entire Row, Column, Hide Rows, Columns", "New Line inside a Cell", "Save Active File, Save As Active File", "Insert New Worksheet", "Move Forward between Worksheets in same file / Move Back between Worksheets in same file".

Using Formula in Excel: "Using SUM Formula (Discuss in Details)".

Data Analyzing: "Pivot Table", "Pivot Chart", "Subtotal", "Charts",

"Consolidation: Consolidation (Example 1) (Simple), Consolidation (12 Months Sales Record), Consolidation (Count, Average, Max, Min)".

Data Validation: "Data Validation - Cricket Match ScoreCard", Data Validation - Date of Current Year", "Data Validation - Numeric Values", "Data Validation - Entering Supplier Names", "Data Validation - Entering Item Names".

Inserting Formulas in Simple Reports: "Sales Report (Simple Format)", "Mark Sheet (Simple Format)", "Cricket Series Report".

IF Function: "IF Function (Introduction)", "Simple IF (Qty Sold Example)", "Simple IF (Rate per Unit Example)", "Nested IF".

Filter & Sort: "Filter", "Sort".

So please enroll this course and improve your Microsoft Excel Skills. Please recommend to your friends and colleague.

Who is the target audience?

Anyone who wants to learn Microsoft Excel (Beginning Level).