Scribd
Upload
39 views15 pages

MS Excel Complete Course Guide

The MS Excel Complete Course Guide covers a comprehensive range of topics from basic to advanced levels, focusing on job-oriented skills. It includes sections on Excel basics, formatting, formulas, logical functions, data tools, charts, pivot tables, and advanced features like macros and VBA. Practical applications such as salary sheets, inventory management, and sales reports are also included to enhance learning.

Uploaded by

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

MS Excel Complete Course Guide

The MS Excel Complete Course Guide covers a comprehensive range of topics from basic to advanced levels, focusing on job-oriented skills. It includes sections on Excel basics, formatting, formulas, logical functions, data tools, charts, pivot tables, and advanced features like macros and VBA. Practical applications such as salary sheets, inventory management, and sales reports are also included to enhance learning.

Uploaded by

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

MS Excel Complete Course Guide

Basic to Advanced Level (Job Oriented)


1. Excel Basics

• Introduction to MS Excel
• Workbook and Worksheet
• Rows, Columns, Cells
• Data Entry and Editing
• Save, Open, Close File
• AutoFill and Flash Fill
• Find and Replace
2. Formatting

• Font Formatting (Bold, Italic, Size, Color)


• Cell Alignment
• Number Formatting (Currency, Date, Percentage)
• Borders and Fill Color
• Conditional Formatting (Highlight Rules, Data Bars)
• Format Painter
3. Basic Formulas

• Understanding Formula (= sign)


• Arithmetic Operations (+, -, *, /)
• Percentage Calculation
• SUM Function
• AVERAGE Function
• COUNT and COUNTA
• MAX and MIN
4. Logical Functions

• IF Function (Single and Nested)


• AND Function
• OR Function
• NOT Function
• IFERROR Function
5. Text Functions

• LEFT, RIGHT, MID


• LEN Function
• TRIM Function
• CONCAT and CONCATENATE
• UPPER, LOWER, PROPER
6. Date & Time Functions

• TODAY and NOW


• DATE and TIME
• DAY, MONTH, YEAR
• DATEDIF Function
7. Lookup Functions

• VLOOKUP (Exact and Approximate Match)


• HLOOKUP
• XLOOKUP
• INDEX Function
• MATCH Function
• INDEX + MATCH Combination
8. Data Tools

• Sort (Single and Multiple Level)


• Filter and Advanced Filter
• Data Validation (Drop Down List)
• Remove Duplicates
• Text to Columns
9. Charts

• Column Chart
• Bar Chart
• Line Chart
• Pie Chart
• Area Chart
• Combo Chart
10. Pivot Table

• Creating Pivot Table


• Pivot Table Fields
• Grouping Data
• Slicer
• Pivot Chart
11. Advanced Excel

• What-If Analysis (Goal Seek, Scenario Manager, Data Table)


• Named Ranges
• Excel Tables (Ctrl + T)
• Basic Power Query
• Basic Power Pivot
12. Macros & VBA

• Enable Developer Tab


• Record a Macro
• Run a Macro
• Basic VBA Structure
• Buttons and Form Controls
13. Printing & Page Setup

• Page Layout Settings


• Print Area Setup
• Header and Footer
• Page Break
14. Job-Oriented Practice Topics

• Salary Sheet Preparation


• Inventory Management Sheet
• Attendance Sheet
• Sales Report with Pivot
• Dashboard Basics

You might also like