[go: up one dir, main page]
Scribd
Upload
142 views11 pages

Excel Complete Notes

The document provides comprehensive notes on Microsoft Excel, covering topics from basic operations to advanced tools. It includes sections on data handling, functions, charts, pivot tables, and data analysis, as well as an introduction to macros and VBA. Additionally, it offers useful shortcuts and tips for efficient navigation and data management.

Uploaded by

Mazhar Ghaffar
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
142 views11 pages

Excel Complete Notes

The document provides comprehensive notes on Microsoft Excel, covering topics from basic operations to advanced tools. It includes sections on data handling, functions, charts, pivot tables, and data analysis, as well as an introduction to macros and VBA. Additionally, it offers useful shortcuts and tips for efficient navigation and data management.

Uploaded by

Mazhar Ghaffar
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
You are on page 1/ 11

Microsoft Excel - Complete Notes (Basic to Advanced)

1. Introduction to Excel

- What is Excel?
- Interface Overview (Ribbon, Tabs, Worksheets, Cells)
- Workbook vs Worksheet
- Basic Navigation (Mouse, Keyboard shortcuts)
- File Types (.xlsx, .xls, .csv)
Microsoft Excel - Complete Notes (Basic to Advanced)

2. Basic Operations

- Entering and Formatting Data


- Adjusting Rows and Columns
- Using Autofill
- Basic Formulas (+, -, *, /)
- Cell References (Relative, Absolute, Mixed)
Microsoft Excel - Complete Notes (Basic to Advanced)

3. Formatting Techniques

- Font, Borders, Fill Colors


- Conditional Formatting
- Format Painter
- Number Formats (Currency, Percentage, Date)
Microsoft Excel - Complete Notes (Basic to Advanced)

4. Data Handling

- Sorting Data
- Filtering Data
- Find and Replace
- Data Validation (Dropdown lists, Input messages)
Microsoft Excel - Complete Notes (Basic to Advanced)

5. Functions and Formulas

- Math Functions (SUM, AVERAGE, ROUND)


- Text Functions (LEFT, RIGHT, MID, CONCATENATE, TEXTJOIN)
- Logical Functions (IF, AND, OR, NOT)
- Lookup Functions (VLOOKUP, HLOOKUP, INDEX, MATCH, XLOOKUP)
- Date & Time Functions (TODAY, NOW, DATEDIF)
Microsoft Excel - Complete Notes (Basic to Advanced)

6. Charts and Visualizations

- Creating Basic Charts (Bar, Line, Pie)


- Chart Customization (Labels, Axis, Legends)
- Sparklines
Microsoft Excel - Complete Notes (Basic to Advanced)

7. Pivot Tables

- Creating a Pivot Table


- Drag and Drop Fields
- Pivot Table Tools
- Grouping and Filtering
- Pivot Charts
Microsoft Excel - Complete Notes (Basic to Advanced)

8. Advanced Tools

- Named Ranges
- Data Tables
- Scenario Manager
- Goal Seek and Solver
- Flash Fill
- Power Query Basics
Microsoft Excel - Complete Notes (Basic to Advanced)

9. Excel for Data Analysis

- Descriptive Statistics (AVERAGE, MEDIAN, MODE, STDEV)


- Using Analysis ToolPak
- Correlation and Regression
- Histograms and Frequency Distribution
Microsoft Excel - Complete Notes (Basic to Advanced)

10. Macros and VBA (Intro)

- What are Macros?


- Recording a Macro
- Assigning Macros to Buttons
- Introduction to VBA Editor
- Basic VBA Code Example
Microsoft Excel - Complete Notes (Basic to Advanced)

11. Excel Shortcuts and Tips

- Ctrl + Arrow keys for quick navigation


- Ctrl + Shift + L for Filters
- Ctrl + ; for today's date
- F4 to repeat last action
- Best practices for large datasets

You might also like