Does Excel know if you’re working on PC or Mac? Believe it or not, it actually does. And, it knows other important information that could help your Excel work.
In this video, I introduce you to Excel’s little-known =INFO formula and demonstrate five useful things that it can tell you about your system. As we see, there are important implications for your Excel work …
Let’s take PC or Mac as an example. At first glance it might feel interesting, but only in an academic way, ‘Hhhmm, I didn’t know Excel could do that?’ I’ve been in many situations in my career, however, where Excel files have behaved differently on Mac vs. PC – with serious consequences for client projects!
The =INFO formula would have really helped me then. In the same way, the =INFO formula can tell which version of Excel you’re working on. Need to know if your model should use =XLOOKUP (not available in Excel 2019) or =INDEX / =MATCH? With this formula, you can programme Excel to choose the best option according to the version of Excel being used. Cool!
The formula can also tell you the file path, whether you’re in automatic or manual calculation mode, and, bizarrely perhaps, the address of the top-left cell currently displayed on the interface.
Were you aware of the =INFO formula, and what applications can you see for it in your work? Let me know in the YouTube comments!
00:00 START 00:05 Working on PC or Mac? 00:28 Find the file path 00:54 Find the top-left visible cell 01:44 In auto or manual Calculation? 03:52 Version of Excel?
ABOUT MEMBERS' MONDAY This video is taken from our unique and exclusive Members' Monday learning community. Looking to build your data analysis skills in a supported environment with expert access, with a group of like-minded individuals?
Need structured materials with a practical focus, and a place to go for help?
Want to take a long-term approach to your learning and get real improvement, rather than lurching from one problem to the next?
You'll love our Members' Monday community! "I love this community!" - MEMBER FEEDBACK
View a FREE 1-hour taster session and more at this link Click HERE
