Please enable JavaScript.
Coggle requires JavaScript to display documents.
Excel Functions (Visualisation (Sparklines, Bar Plot, Pie Chart, Radar…
Excel Functions
Visualisation
Sparklines
Bar Plot
Pie Chart
Radar Chart
Scatter Plot
Multi-dimensional Chart
Line Chart
Maps integration
Win/Loss Sparklines
Macros & VB
How to record a Macro
basics on Programming
Input box funtion
Message box function
IF Else Statement
Loops
User Form
Events
Arrays
Data Analysis Toolpack
Pareto Chart
Histogram
Descriptive Stats
Solver Add-in
Linear Regression
Scenario Manager
Functions
Text
LEFT()
RIGHT()
FIND()
Statistical
Mean()
Median()
Shortcuts (link to Cheat Sheet)
Delete a Row
Delete a Column
Apply a filter
Probability
Randbetween()
Choose
Rand()
Logic
AND()
OR()
NOT()
Financial
NPV
Interest
Art
Cell Formatting
Font Type
No Grid lines
Example of a Chart
Name Range
Adding Symbols
Connections
Data Connections in Desktop (.txt)
Web connections
Connection to Power BI
Connection to PPT
APIs (Wolfram)
Auditing
Watch window
Trace precedents/dependents
Evaluate Formula
Conditional Formatting
Google Spreadsheets
Google insights
Google Add-ins
XMLpath()
Datasets
Titanic
Lemonade Stand
mtcars
Pivot Functions
Slicing and Dicing
Timelines
Simulation
Integration with Netlogo
Timer() code