8 hours 33 minutes
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.
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?
What is the difference between a raise and plain ranges that you mentioned in functions?
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.
And, uh, we did some examples, and at the end, we
we're working on or you were able to listen
Two ways to dio
otherwise impossible things reduce Gary's So a raise Kenbrell some extra functionality in the standard use off itself.
so the next thing
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.
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
I didn't talk about in math functions. They didn't talk about trick trigonometry functions
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.
So there was nothing about debt
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.
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.
And then we moved to more complex programming structures, meaning if then, else structure
And within these lessons, I gave you the
usage examples of correct usage off these structures in the
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
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.
Okay, so, um, then
there was about importing data from other programs
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.
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
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.
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
and use that this is effective way of presenting if you are using some kind of global or geographical data.
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,
but I gave you the one that I found. It is more straightforward one
and more mostly ah, appropriate for your level of knowledge.
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.
Data Analyst Excel
The Data Analyst Excel Test is a premium Cybrary assessment created by iMocha and intended ...
Monitor a Web App
In this IT Pro challenge, participants get hands-on experience activating server logging and using Application ...
Learn On Demand