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