Join Dennis Taylor for an in-depth discussion in this video Extract information with the CELL and INFO functions, part of Excel: Advanced Formulas and Functions.
- [Instructor] Excel has a number … of different information functions. … Tow of the are called Cell and Info. … That's the name of the worksheet we're looking at … in our chapter 10 exercise file. … If you go to the Formulas tab in the ribbon, … off to the right you'll see More Functions, Information. … And we'll be covering some of these in follow-up movies. … Here's the function, Cell, the we're about to look at. … It turns information about the formatting location … or contents of the first cell, and on and on and on. … Also, Info, returns information … about the current operating environment. … These two functions are probably not widely used. … On the other hand, they could be valuable … in providing certain kinds of documentation … or possibly of use when auditing Excel. … Let's take a look at, first, Cell. … Left parenthesis, we've got lots of choices here. … And by the way, these are also displayed over in column B. … If we were to choose here, we don't see a description … of what's going on. …
Author
Released
4/1/2019- Displaying and highlighting formulas
- Debugging formulas
- Creating 3D formulas
- Creating nested IF functions
- Exploring VLOOKUP, MATCH, and INDEX
- Tabulating data with COUNTIFS, SUMIFS, and AVERAGEIFS
- Finding values with statistical functions
- Adjusting results with rounding functions
- Converting values between measuring systems
- Calculating dates
- Returning reference data
- Manipulating text
- Extracting information
Skill Level Intermediate
Duration
Views
Related Courses
-
Excel: Power Query (Get & Transform)
with Oz du Soleil1h 49m Intermediate -
Excel Tips Weekly
with Dennis Taylor28h 47m Intermediate
-
Introduction
-
1. Formula and Function Tips and Shortcuts
-
Use the auditing tools6m 18s
-
2. IF and Related Functions
-
3. Lookup and Reference Functions
-
Use the XLOOKUP function5m 19s
-
4. Power Functions
-
Use MAXIFS and MINIFS2m 36s
-
5. Statistical Functions
-
6. Math Functions
-
7. Date and Time Functions
-
8. Reference Functions
-
9. Text Functions
-
10. Information Functions
-
Conclusion
-
Next steps34s
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press 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 the CELL and INFO functions