Join Dennis Taylor for an in-depth discussion in this video Extracting information with the CELL and INFO functions, part of Excel 2016: Advanced Formulas and Functions.
- Excel has a category of functions…called Information functions.…On the Formulas tab you don't see that category at first.…It's under the heading More Functions.…Here we are, Information functions.…The CELL function, the INFO function,…not heavily used might have some interest for you.…In this worksheet here it's called CELL-INFO.…We might want to have the file name here.…The question might come up,…well why do I want to see the file name?…Don't I know which file I'm working with?…Well I might want to do this in many…of the files that I have open.…
Maybe I often have five or six files open.…It's always handy to know which file I have open…and also remind myself.…We could also possibly use this information in formulas.…Equal cell, left parenthesis.…Here are the kinds of things we might look for.…For more depth on what each of these means…in going to the help system and explore this a little bit.…I'm going to choose Filename right here,…Tab it into place and press Enter.…And it simply shows me the name of the file I have open…
Author
Dennis Taylor
Updated
3/1/2016Released
1/28/2016- Displaying and highlighting formulas
- Converting formulas to values
- Tabulating data from multiple sheets
- Understanding the hierarchy of operations in formulas
- Using absolute and relative references
- Creating and expanding nested IF statements
- Looking up information with VLOOKUP, MATCH, and INDEX
- Using the powerful COUNTIF family of functions
- Analyzing data with statistical functions
- Calculating dates and times
- Analyzing data with array formulas and functions
- Extracting data with text function
Skill Level Advanced
Duration
Views
Q: This course was updated on 03/01/2016. What changed?
A: We added one tutorial about the new formulas in Excel 2016.
-
Introduction
-
Welcome50s
-
-
1. Formula and Function Tips and Shortcuts
-
Using Auditing tools6m 15s
-
2. Formula and Function Tools
-
3. IF and Related Functions
-
IF logical tests4m 27s
-
-
4. Lookup and Reference Functions
-
Nesting lookup functions4m 12s
-
5. Power Functions
-
Using MAXIFS and MINIFS4m 14s
-
Preventing double counting4m 48s
-
6. Statistical Functions
-
7. Math Functions
-
8. Date and Time Functions
-
9. Array Formulas and Functions
-
10. Reference Functions
-
11. Text Functions
-
12. Information Functions
-
Conclusion
-
Next steps33s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Extracting information with the CELL and INFO functions