Scribd
Upload
2K views4 pages

Excel Notes 2025

Excel Notes 2025 covers a comprehensive range of topics from basic to advanced Excel functionalities, including workbook navigation, formatting tools, core functions, and data analysis techniques. It also includes sections on PivotTables, Power Query, Macros, and collaboration features, providing users with essential skills for effective data management. The document serves as a detailed guide for users looking to enhance their proficiency in Excel.

Uploaded by

moon star
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
2K views4 pages

Excel Notes 2025

Excel Notes 2025 covers a comprehensive range of topics from basic to advanced Excel functionalities, including workbook navigation, formatting tools, core functions, and data analysis techniques. It also includes sections on PivotTables, Power Query, Macros, and collaboration features, providing users with essential skills for effective data management. The document serves as a detailed guide for users looking to enhance their proficiency in Excel.

Uploaded by

moon star
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/ 4

Excel Notes 2025 (Basic to Advanced)

Excel Notes 2025 (Basic to Advanced)

1. Excel Basics

- Workbook vs Worksheet

- Data Types: Text, Number, Date, Boolean

- Basic Navigation: Ribbon, Tabs, Name Box, Formula Bar

- Cell Referencing: Relative (A1), Absolute ($A$1), Mixed (A$1, $A1)

2. Formatting Tools

- Number formatting (Currency, %, Date)

- Conditional Formatting

- Cell styles & themes

- Data validation (drop-downs)

3. Core Functions

- Math & Stats: SUM, AVERAGE, MIN, MAX, ROUND, INT, MOD

- Logical: IF, IFS, AND, OR, NOT

- Text: CONCATENATE, TEXTJOIN, LEFT, RIGHT, MID, LEN, TRIM, UPPER, LOWER, TEXT

- Date & Time: TODAY(), NOW(), DATEDIF, EDATE, EOMONTH, NETWORKDAYS

4. Lookup & Reference

- VLOOKUP, HLOOKUP, XLOOKUP

- INDEX, MATCH, OFFSET, CHOOSE

- INDIRECT, ADDRESS
Excel Notes 2025 (Basic to Advanced)

5. Data Tools

- Sort & Filter

- Remove Duplicates

- Data Validation

- Flash Fill

- Text to Columns

- What-If Analysis: Goal Seek, Data Table, Scenario Manager

6. Charts & Graphs

- Column, Bar, Line, Pie, Area

- Combo Charts

- Sparklines

- Dynamic Charts with Formulas

7. PivotTables & PivotCharts

- Creating PivotTables

- Value Field Settings: Sum, Count, Average

- Grouping: by date, category

- Slicers & Timelines

- PivotCharts with dynamic filters

8. Advanced Functions

- SUMIFS, COUNTIFS, AVERAGEIFS

- FILTER, SORT, UNIQUE (Excel 365/2021+)


Excel Notes 2025 (Basic to Advanced)

- LET, LAMBDA

- SEQUENCE, RANDARRAY, TEXTSPLIT

9. Array Formulas

- Dynamic Arrays (Excel 365+)

- Legacy CSE formulas (CTRL + SHIFT + ENTER)

- Examples: Sum of top N values, Multi-criteria lookups, Transpose arrays

10. Power Query (Get & Transform)

- Import from multiple sources (Excel, Web, SQL, etc.)

- Clean, shape, and transform data

- Merge & Append Queries

- Load to Table or PivotTable

11. Power Pivot & Data Models

- Relationships between tables

- DAX formulas (CALCULATE, RELATED, SUMX)

- KPIs and calculated fields

- Advanced dashboards

12. Macros & VBA (Intro)

- Recording Macros

- Understanding VBA Editor

- Writing basic procedures: Sub, Function

- Automating repetitive tasks


Excel Notes 2025 (Basic to Advanced)

13. Excel Shortcuts

Task | Shortcut

-------------------|----------

Save | Ctrl + S

Select Column | Ctrl + Space

Insert Row | Ctrl + Shift + +

AutoSum | Alt + =

Go To | Ctrl + G

Format Cells | Ctrl + 1

14. Security & Collaboration

- Protect Sheets/Workbook

- Track Changes

- Shared Workbooks

- Excel Online collaboration

15. Import/Export

- Import CSV, XML, JSON

- Connect to APIs (via Power Query)

- Export tables to PDF, CSV

- Use Excel with Power BI or SQL Server

You might also like