Advance Excel ECO

1.Introduction to Ms-Excel
What is Microsoft Excel?
Microsoft Excel Features
Create a new workbook
Quick Access Toolbar

2.Worksheets in Excel
Worksheet
Select a Worksheet
Insert a Worksheet
Delete a Row in Excel

3.Excel Calculation
Addition in Excel
Calculate average in Excel

4.Excel Formula
Excel Creating Formulas
What is the Formula in Excel?
The Difference between a Formula and Function
How to create a formula in Excel?
Using the Function Wizard

5.VLOOKUP Function
What is the VLOOKUP function in Excel?
VLOOKUP Formula in Excel

6.PivotTables
Using PivotTables
Create a PivotTable
Pivoting data
PivotCharts

7.Excel Data Analysis
Ranges and Tables
Data Cleaning
Conditional Formatting
 

Assignments

Assignment 1: Basic Spreadsheet Skills

Assignment 2: Arithmetic Formulas

Assignment 3: Basic Formulas and Functions

Assignment 4: Percentage Calculations

Assignment 5: Date Calculations

Assignment 6: Basic Data Sorting

Assignment 7: Data Sorting and Filtering

Assignment 8: Advanced Data Sorting

Assignment 9: Data Filtering

Assignment 10 : Create a Bill Invoice

Assignment 11 : Lookup and Function

Assignment 12: VLOOKUP function 

Assignment 13: HLOOKUP Function 

Assignment 14: Nested Lookup Function 

Assignment 15: Logical Function

Assignment 16: Advanced Logical Function 

Assignment 17: Income Tax Calculation

Assignment 18: GST Bill Calculation

Assignment 19: Data Validation

Assignment 20: Protecting a Worksheet

1.Introduction to Ms-Excel
What is Microsoft Excel?
Microsoft Excel Features
Create a new workbook
Quick Access Toolbar

2.Worksheets in Excel
Worksheet
Select a Worksheet
Insert a Worksheet
Delete a Row in Excel

3.Excel Calculation
Addition in Excel
Calculate average in Excel

4.Excel Formula
Excel Creating Formulas
What is the Formula in Excel?
The Difference between a Formula and Function
How to create a formula in Excel?
Using the Function Wizard

5.VLOOKUP Function
What is the VLOOKUP function in Excel?
VLOOKUP Formula in Excel

6.PivotTables
Using PivotTables
Create a PivotTable
Pivoting data
PivotCharts

7.Excel Data Analysis
Ranges and Tables
Data Cleaning
Conditional Formatting
 

Assignments

Assignment 1: Basic Spreadsheet Skills

Assignment 2: Arithmetic Formulas

Assignment 3: Basic Formulas and Functions

Assignment 4: Percentage Calculations

Assignment 5: Date Calculations

Assignment 6: Basic Data Sorting

Assignment 7: Data Sorting and Filtering

Assignment 8: Advanced Data Sorting

Assignment 9: Data Filtering

Assignment 10 : Create a Bill Invoice

Assignment 11 : Lookup and Function

Assignment 12: VLOOKUP function 

Assignment 13: HLOOKUP Function 

Assignment 14: Nested Lookup Function 

Assignment 15: Logical Function

Assignment 16: Advanced Logical Function 

Assignment 17: Income Tax Calculation

Assignment 18: GST Bill Calculation

Assignment 19: Data Validation

Assignment 20: Protecting a Worksheet