Scribd
Upload
285 views12 pages

Excel Notes Basic To Advanced

This document provides a comprehensive guide to Microsoft Excel, covering basic to advanced levels of skills and practical tasks. It includes topics such as data entry, formatting, formulas, multiple worksheets, charts, advanced functions, pivot tables, and macros. The content is designed for both students and professionals, with practical tasks to reinforce learning at each level.

Uploaded by

ry657372
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
285 views12 pages

Excel Notes Basic To Advanced

This document provides a comprehensive guide to Microsoft Excel, covering basic to advanced levels of skills and practical tasks. It includes topics such as data entry, formatting, formulas, multiple worksheets, charts, advanced functions, pivot tables, and macros. The content is designed for both students and professionals, with practical tasks to reinforce learning at each level.

Uploaded by

ry657372
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd

Excel Notes: Basic to Advanced

• Includes Theory and Practical


• For Students and Professionals
BASIC LEVEL: Introduction to Excel
• - What is Microsoft Excel?
• - Uses of Excel in different fields
• - Excel Interface: Workbook, Worksheet,
Ribbon, Tabs, Cells, Rows & Columns
BASIC LEVEL: Data Entry &
Formatting
• - Entering and editing data
• - Formatting cells: Bold, Italic, Font size,
Borders
• - Merge & center, wrap text
• - Number formatting
BASIC LEVEL: Basic Formulas &
Functions
• - Arithmetic operators: +, -, *, /
• - Common functions: SUM, AVERAGE, MAX,
MIN, COUNT
• - Cell referencing: Relative, Absolute, Mixed
BASIC LEVEL: Practical Tasks
• - Create a student mark sheet
• - Format an invoice table
• - Use SUM & AVERAGE
INTERMEDIATE LEVEL: Multiple
Worksheets
• - Renaming, adding, deleting sheets
• - Linking data across sheets
• - 3D references
INTERMEDIATE LEVEL: Validation &
Charts
• - Data validation (drop-down list)
• - Conditional formatting
• - Column, Bar, Pie, Line charts
INTERMEDIATE LEVEL: Practical
Tasks
• - Sales report with charts
• - Attendance sheet formatting
• - Drop-down for grades
ADVANCED LEVEL: Functions
• - IF, IFERROR, IFS
• - VLOOKUP, HLOOKUP, XLOOKUP
• - INDEX & MATCH
• - TEXT, LEFT, RIGHT, MID, LEN
ADVANCED LEVEL: Pivot Tables &
Data Tools
• - Pivot tables and charts
• - Sort & Filter
• - Flash Fill, Remove Duplicates
• - Grouping and Subtotals
ADVANCED LEVEL: Practical Tasks
• - Employee database with VLOOKUP
• - Sales analysis with Pivot Table
• - Customer list with filters
EXPERT TOOLS: Macros &
Protection
• - Recording and using macros
• - Introduction to VBA
• - Protecting sheets
• - Sharing and collaboration

You might also like