Scribd
Upload
3 views2 pages

Advanced Excel Topics

The document outlines advanced Excel topics, including advanced formulas and functions such as INDEX + MATCH and XLOOKUP, as well as data analysis tools like Pivot Tables and Power Pivot. It covers data cleaning and preparation techniques, Power Query for ETL processes, and dashboard visualization methods. Additionally, it highlights automation features, data analysis and reporting techniques, advanced features, and productivity shortcuts.

Uploaded by

poojanathan06
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
3 views2 pages

Advanced Excel Topics

The document outlines advanced Excel topics, including advanced formulas and functions such as INDEX + MATCH and XLOOKUP, as well as data analysis tools like Pivot Tables and Power Pivot. It covers data cleaning and preparation techniques, Power Query for ETL processes, and dashboard visualization methods. Additionally, it highlights automation features, data analysis and reporting techniques, advanced features, and productivity shortcuts.

Uploaded by

poojanathan06
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

Advanced Excel Topics

Advanced Formulas & Functions

1 INDEX + MATCH

2 XLOOKUP

3 IF, IFS, Nested IF

4 SUMIFS, COUNTIFS, AVERAGEIFS

5 TEXT Functions (LEFT, RIGHT, MID, LEN)

6 Logical Functions (AND, OR, NOT)

7 Array Formulas

Data Analysis Tools

1 Pivot Tables & Pivot Charts

2 Power Pivot (Data Modeling)

3 What-If Analysis (Goal Seek, Scenario Manager)

4 Data Tables

Data Cleaning & Preparation

1 Remove Duplicates

2 Text to Columns

3 Flash Fill

4 Data Validation

5 Conditional Formatting

Power Query (ETL)

1 Import Data from Multiple Sources

2 Data Cleaning & Transformation

3 Merge and Append Tables

4 Automation of Data Tasks

Dashboard & Visualization

1 Interactive Dashboards
2 Slicers & Timelines
3 Dynamic Charts
4 KPI Indicators

Automation

1 Macros
2 VBA (Visual Basic for Applications)
3 Automating Reports

Data Analysis & Reporting

1 Trend Analysis
2 Forecasting
3 MIS Reporting Techniques

Advanced Features

1 Named Ranges

2 Sparklines

3 Sheet Protection & Sharing

4 Collaboration Tools

Shortcuts & Productivity

1 Keyboard Shortcuts
2 Quick Navigation Tricks
3 Efficient Data Handling

You might also like