From the course: Excel: Advanced Formulas and Functions
Unlock the full course today
Join today to access over 23,100 courses taught by industry experts.
ROMAN and ARABIC
From the course: Excel: Advanced Formulas and Functions
ROMAN and ARABIC
- [Narrator] Here, I'm going to show you a couple of functions in this video, that you may never use it. I'm just being honest with you... but I'm showing you these functions to get you to explore, to help you see that when you do have a need around data, Excel probably does have you covered. So, right now we are looking at some movies, then the copyright year. If you notice in films, they usually have the copyright year in Roman numerals. Okay, and we have genres, but we want to know, what are these years? Meet Miss Laura. MCMLIX. What is that? I don't know. Okay, here is what we're going to do. I'm going to put year, good. And I am going to put this into a table. Format as table, let's grab this light blue. Table does have headers. Okay, get rid of the filter buttons. All right, so now, equals. What do we need? Okay, we need Arabic. Converts Roman numeral to Arabic. Okay, double click... grab that…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.