Please enable JavaScript.
Coggle requires JavaScript to display documents.
Introduction to Advanced Excel (External Data (Query editor, Databases,…
Introduction to Advanced Excel
Logical Operators
IF
Nested IF
AND
OR
Financial Formulas
Subtotal
Interest rates
Amortization tables
Text Formulas
LEN
LEFT
RIGHT
Dates and Times
Custom field formatting
DATEDIF and secret formulas
Lookup
VLOOKIP
HLOOKUP
INDEX
MATCH
Pivot Tables
Pivot Charts
Slicers
Timelines
Macros
Security
Applications
VB Code
Filters
Text filters
Multi-variable calculations
Solver
Product mix problems
Scenario manager
Visually analyze and present data
Dashboards
PowerView
3D Maps
Goalseek
What-if analysis
Single variable analysis
Multi variable analysis
Stats
Arrays
3D Formulas
Higher dimensional data
Troubleshooting
Error Tracing
IFERROR custom error messages
Nested IF for errors
External Data
Query editor
Databases
Forecasting
Data Model
BI
Common Formulas
Top 10 Forumulas
SUM
AVERAGE
COUNT