KEMBAR78
Excel Full Course Beginner To Advanced | PDF
Scribd
Upload
1K views2 pages

Excel Full Course Beginner To Advanced

This document outlines a comprehensive Microsoft Excel course covering topics from basic to advanced levels. It includes sections on Excel interface, formatting, functions, data management, visualization, and data analysis tools. The course also addresses advanced features like PivotTables, conditional formatting, and exporting options.

Uploaded by

arbazahmad340
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
1K views2 pages

Excel Full Course Beginner To Advanced

This document outlines a comprehensive Microsoft Excel course covering topics from basic to advanced levels. It includes sections on Excel interface, formatting, functions, data management, visualization, and data analysis tools. The course also addresses advanced features like PivotTables, conditional formatting, and exporting options.

Uploaded by

arbazahmad340
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/ 2

Microsoft Excel Full Course - Beginner to Advanced

1. Introduction to Excel

- Excel interface overview

- Workbook vs Worksheet

- Cells, rows, columns

- Basic data entry

2. Formatting and Basic Functions

- Formatting text, numbers, borders

- Basic formulas: SUM, AVERAGE, MIN, MAX, COUNT

3. Data Sorting and Filtering

- Sorting data: ascending/descending

- Using AutoFilter and custom filters

4. Charts and Visualization

- Creating charts: bar, line, pie

- Modifying chart elements

5. Formulas and Cell Referencing

- Arithmetic operations

- Cell referencing: relative, absolute, mixed

6. Intermediate Functions

- Logical functions: IF, AND, OR, NOT

- Combining functions (nested formulas)

7. Data Validation and Protection

- Data entry rules (drop-down lists)


- Protecting cells, sheets, and workbooks

8. Pivot Tables

- Creating PivotTables

- Summarizing, grouping, filtering data

9. Conditional Formatting

- Rules for highlighting cells

- Data bars, color scales

10. Lookup Functions

- VLOOKUP, HLOOKUP, XLOOKUP

- INDEX and MATCH combinations

11. Advanced Tools

- Introduction to Macros

- Goal Seek, Scenario Manager

12. Excel for Data Analysis

- Managing large datasets

- Slicers, filters, charts for analysis

13. Exporting and Sharing

- Saving as PDF

- Printing options and sharing

You might also like