2:32
Excel visualization trick - Scattered plot is one power way to generate insights!
4 views • 6 days ago
1:42
Excel analytics - Are the stock of Google and McDonald's correlated? The answer may surprise you
6 views • 7 days ago
3:09
Excel basics - count, counta, and countif
1 view • 7 days ago
1:41
Excel shortcut trick - Ctrl+Enter is something you have to use to see how great it is!
3 views • 7 days ago
4:55
Excel for finance - Use two-way DataTable to study the effect of TWO variables on mortgage payment
2 views • 7 days ago
6:20
Excel for finance - Use DataTable to figure out the sensitivity of down payment on mortgage amount
2 views • 7 days ago
2:16
Excel trick - Use FV (future value) function to calculate total interest payment of your loan
1 view • 7 days ago
2:36
Excel for finance - Future Value (FV) functions
No views • 8 days ago
3:47
Excel visualization trick - Histogram is my favorite. Here is an old-fashion way of drawing one.
1 view • 8 days ago
4:43
Excel function tricks - MATCH and INDEX used together can locate the data point you are looking for.
2 views • 8 days ago
1:43
Excel for finance - Internal rate of return (IRR) function
6 views • 8 days ago
1:55
Excel visualization basics - A line chart
2 views • 8 days ago
5:25
Excel modes for business - Building an "Excel-lent" model
No views • 8 days ago
2:37
Excel of finance - Use IF function to perform some stock market sentiment analysis
3 views • 8 days ago
2:14
Excel for finance - Number of Payment (NPER) function
No views • 8 days ago
2:39
Excel for finance - Net Present Value (NPV)
2 views • 8 days ago
5:55
Excel Pivot Table basics - If you want to master data analytics with Excel, Pivot Table is a must.
11 views • 9 days ago
4:20
Excel for finance - Payment function PMT
4 views • 9 days ago
3:24
Excel tricks - Clever use of $ to reference different cells (i.e. absolute vs relative referencing)
No views • 9 days ago
3:16
Excel analytics - The Quartile function
2 views • 9 days ago
1:55
Excel for analytics - Rank function
6 views • 9 days ago
2:50
Excel for finance - RATE function.. It is not what you think!
1 view • 10 days ago
4:20
Excel basics - functions that process texts like magic!
5 views • 10 days ago
3:05
Excel basics - COUNTIF and SUMIF are useful functions to start your analytics started
No views • 10 days ago
2:40
Excel trick - Use VLOOKUP to find exact matching and then merge two data tables.
7 views • 11 days ago
1:28
Excel trick - Select multiple ranges with Control (for PC) or ⌘ (for Mac) Key
6 views • 11 days ago
1:30
Excel trick - I hate the Paste action, because it secretly pastes A LOT OF things (formula, value)..
1 view • 11 days ago
3:02
Excel trick - You can call your cell/table anything you like! A neat trick in building your formula
6 views • 11 days ago
2:14
Excel trick - Freeze Panes can be your dear friend, if you have a small screen or a large dataset!
1 view • 11 days ago
1:26
Excel trick for Mac users - Super efficient navigation with your Command (⌘) key!
No views • 11 days ago
Load More