★ Want to automate Excel? Check out our training academy ★
[ Ссылка ]
★ Get the example file ★
Sign up for our free Insiders program and get the example file:
[ Ссылка ]
File Reference for this video: 0239 Excel dirty secrets.zip
★ About this video ★
Do you ever have those situations where Excel does things you just don't expect?
In this video, we are looking at 5 of Excel's dirty little secrets; the things it does that catch us out and cause us to calculate the wrong numbers.
It may be that one of these is causing your workbook to calculate the wrong numbers right now... and you don't even realize it.
0:00 Introduction
0:22 [1] Lookups don't always return the correct value!
2:56 [2] Excel changes formula references... sometimes!
4:13 [3] Multi-column lookups don't exist!
6:24 [4] Excel keeps a secret cache of data!
9:04 [5] Named ranges change scope!
11:07 Wrap-up
★ Download 30 most useful Excel VBA Macros ebook for FREE ★
[ Ссылка ]
★ Where to find Excel Off The Grid ★
Blog: [ Ссылка ]
Twitter: [ Ссылка ]
#MsExcel
