Use the CELL function to return information about the formatting, location, or contents of a cell, as well as the cell's protection status and the filename. Use the INFO function to return information about the current operating environment, including the Excel release version and the operating system.
- [Voiceover] We're looking at a worksheet…called Cell Info.…In the workbook, 13-information.…If you look on the Formulas tab,…you don't see the category for information,…unless you click the More Functions button,…and slide down to information.…We see some information functions.…For many of these,…they serve as documentation tools.…One of these functions is called Cell.…In the green panel to the right are the various entries…that we might want to consider using with this function.…So, for example,…in cell C1,…I'm gonna type equal cell,…left parentheses,…double quote,…file name.…
I could be using the data from cell B1,…but in the first example, I'll simply type it in.…Why would you do this?…It looks like we should know this, shouldn't we?…Don't we know the name of the file we're using?…Well, for documentation purposes,…not only does this tell is the file,…but reading from the right to the left,…we see the sheet name we're currently on,…the name of the file,…the folder that it's being stored in,…and the folder that that's being stored in,…
Author
Dennis Taylor
Released
5/26/2016- Understanding how the hierarchy of operators affects formula results
- Knowing when to use absolute vs. relative references
- Using Formula Builder for unfamiliar functions
- Displaying a worksheet's formulas and highlighting formula cells
- Converting formulas to values
- Creating 3D formulas to gather data from multiple sheets
- Creating and expanding nested IF functions; using AND, OR, and NOT with IF
- Looking up information with VLOOKUP, HLOOKUP, MATCH, and INDEX
- Analyzing data with the statistical functions: MEDIAN, MODE, etc.
- Using the power functions: COUNTIF, SUMIF, COUNTIFS, AVERAGEIFS, and more
- Calculating financial data such as payments
- Performing basic math
- Calculating dates and times
- Editing text with functions
- Using array formulas and functions
- Referencing data in other cells and files
- Extracting information from Excel worksheets
Skill Level Intermediate
Duration
Views
-
Introduction
-
Welcome46s
-
Exercise files25s
-
-
1. Formula and Function Tools
-
2. Formula and Function Tips and Shortcuts
-
3. IF and Related Functions
-
4. Lookup and Reference Functions
-
Use MATCH and INDEX together4m 40s
-
5. Statistical Functions
-
6. Power Functions
-
7. Selected Financial Functions
-
8. Math Functions
-
9. Date and Time Functions
-
10. Text Functions
-
11. Array Formulas and Functions
-
12. Reference Functions
-
13. Information Functions
-
Conclusion
-
Next steps25s
-
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: Extract information with CELL and INFO