EXCEL & Adv. EXCEL
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
Adv. Excel
Chapter 1 : Creating Formulas for Financial Application
- Loan Calculations
- PPMT
- PMT
- IPMT
- 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
- Annova Single Factor
- Solver
- Histogram
- Rank & Percentile
- Descriptive Statistics
Chapter 5 : Macros
- Macros
- Mail Merge using Excel
- Hyperlink
Chapter 6 : Pivot Table
- Pivot Table & Pivot Chart
- Depreciation
- Simple Interest
- Compound Interest
Chapter 7. Charts
- Tree Map
- Maps
- Waterfall
- Funnel
- Bar & Whisker
Chapter 8. More
- Trace Precedents
- Trace Dependents
- Remove Arrows
- Show Formula
- Define Name
- Name Manager
Lab Assignment , Short Key & MCQ
