### Intermediate Excel

Course
Time
8 hours 33 minutes
Difficulty
Intermediate
CEU/CPE
9

### Video Transcription

00:01
OK, so at the end, off this course, I'm going to do a recap off everything that was mentioned in it and everything that you have been able to learn about.
00:14
So first thing we started with was use of a raise in excel. And what we talked about this what are the rare ease? A raise? What type of fairies do you have in Excel?
00:26
What is the difference between a raise and plain ranges that you mentioned in functions?
00:33
And then we skip to using a raise and formulas. So I talked about the type of Fae Wray formulas are single cell and melted self formulas.
00:45
And, uh, we did some examples, and at the end, we
00:52
we're working on or you were able to listen
00:56
Two ways to dio
00:59
otherwise impossible things reduce Gary's So a raise Kenbrell some extra functionality in the standard use off itself.
01:11
Oh,
01:12
so the next thing
01:15
next topic was Advanced Excel functions. And we didn't this, uh, module. I talked about four types of functions of Matt functions, text functions, information, functions and look of functions.
01:32
And what is very important is that I mentioned that I wasn't talking about all the functions that they're available in Excel. I just picked those that they see thought that are important for this level off course. And also for a regular user, for example, Matt functions
01:51
I didn't talk about in math functions. They didn't talk about trick trigonometry functions
01:57
for very simple reason. Those people that need them, they actually probably already knows to use them. And they're very simple functions. They have just one argument.
02:06
So there was nothing about debt
02:09
also in text functions, and I wasn't going through all of them as well as information, functions and look a function. I just show you some things that you can do. We'd look up functions.
02:22
So, um,
02:23
the next very important chapter module in this course was about creating macros. So when this within this module I talked about what are the Mac Rose types of microbes? The shoulder examples.
02:38
And then we moved to more complex programming structures, meaning if then, else structure
02:44
and loops.
02:46
And within these lessons, I gave you the
02:51
correct ah
02:53
usage examples of correct usage off these structures in the
03:01
sometimes something that could be considered a really life for re a world problem. solving. And then, at the end, I showed paid a lot off
03:14
the time and energy into showing you some practical use of Micro's for some very, very realistic potentially was arrested situations that you could potentially meet in your everyday work.
03:31
Okay, so, um, then
03:35
there was about importing data from other programs
03:39
in including the explanation of what is the difference between opening and importing, then how to import text of files, helping poor database files, healthy part Web data and, at the end, a little bit about how to export data.
03:55
And finally,
03:58
uh, there was a talk about how to customize Excel interface. It wasn't a big model, but it's important one, because you can make your life a lot easier. For example, if you're working in the in visual basing and doing a lot off
04:13
forms that need meaning, making Mac rose and from time to time you have to use some functions in the home tab. You can put them on the top off your Excel window and don't have to switch between tabs just, for example, to center the techsters like that.
04:30
And the final learning lesson was about map charts where I talked to you about a relatively new thing in Excel, which allows you to put data on being maps or on the two D or three D maps worldwide maps
04:46
and use that this is effective way of presenting if you are using some kind of global or geographical data.
04:54
So the final module was about three problems that require thinking, problem solving skills and quite a lot off knowledge of Excel. And I gave you a possible one possible solution for each of these examples of each of these problems how to solve them. Of course there are others,
05:14
but I gave you the one that I found. It is more straightforward one
05:16
and more mostly ah, appropriate for your level of knowledge.
05:25
So again,
05:26
thank you for your time. Thank you for listening to this course. And I really hope you learned a lot about XL 2019 and how to use it effectively to the level that will probably astonish your colleagues. Goodbye.

### Intermediate Excel

Being an intermediate level user of Excel can help save a user hours of work time and take full advantage of the Excel application. Taking an intermediate Excel training will help students advance their skills and pass an intermediate Excel exam.

### Instructed By

Milan Cetic
IT Security Consultant
Instructor