Excel Advanced

1 : Advanced financial analysis tools

Structure, organization, duplicate sheets, grouping
Anchoring, formatting, and grouping cells
Editing multiple sheets, naming cells
Tracing precedents and dependents
Go to special, conditional formatting
Dynamic titles and headers
Date functions and time periods

2 : IF Function formulas

Key Excel Functions: If
Key Excel Functions: Sum, Sumif, Sumifs
Key Excel Functions: Count, Counta, Countif, Countifs
Key Excel Functions: Average & Averageif
Key Excel Functions: Left, Right, Mid, Upper, Lower, Proper, Concatenate
Find the Highest and Lowest Values in a Range: Max & Min, Small & Large
Sum, average, sumproduct, median
Rounding, and absolute functions
IFERROR function
Find and replace
Use Round in Your Financial Models

3 : Other analysis tools and formulas

All look up functions - Vlookup, Hlookup, Xlookup
Index, Match, and Their Combination - The Perfect Substitute for Vlookup
A Useful Tool for Financial Analysis - The Rank Function
Goal Seek Will Help You Find the Result You Are Looking For
Perform Sensitivity Analysis with Excel's Data Tables Functionality

4 : Charts and Graphs

Line chart
Column and bar charts
Waterfall chart
Pie Chart
Combo charts

Page updated

Google Sites

Report abuse