MS – EXCEL with Project
Chapter 1 : Introduction to Spreadsheet
Electronic Spreadsheet
Working with Spreadsheet
Advantage of Spreadsheet
Application of Spreadsheet
Operators
Function
Chapter 2 : Using Workbook
Creating a new Workbook
Opening a Workbook
Saving a Workbook
Inserting & Deleting Sheets
Renaming a Sheets
Selecting & Moving between Sheets
Chapter 3 : Formatting a Worksheets
Hide & Unhide Column in a Worksheet
Adjusting Row’s Height
Formatting all characters in a cell
Adding a pattern or Colors
Adding a border and Lines
Protecting & Un protecting sheets
Conditional Formatting
Chapter 4 : Graphs & Charts
Introduction
Embedded Chart & Chart in Chart Sheet
Creating a Chart
Changing the type of a chart
Modifying the Axes
Inserting Data Labels
Inserting Legends
Changing the type of a chart
Chapter 5 : Data
Get External Data
Data Validation
Consolidate
Goal Seek
Scenario
Lab Assignment, Short Key & MCQ
Advance Excel with Project
Chapter 1 : Creating Formulas for Financial Application
Loan Calculations
PPMT
PMT
PMT
RATE
NPER
P V
Chapter 2 : Data Table
One Way
Two Way
Chapter 3 : Function in Excel
Using Insert Function
Editing Function
Math & Trigonometry Function
Logical Function
Statistical Function
Date & Time Function
Text & Data Function
Lookup & Reference Function
Chapter 4 : Data Tab
Solver
Histogram
Rank & Percentile
Chapter 5 : Macros
Macros
Mail Merge using Excel
Hyperlink
Chapter 6 : Pivot Table
Pivot Table & Pivot Chart
Depreciation
Simple Interest
Compound Interest
Lab Assignment & Short Key & MCQ