-552x564.jpg "Advanced Excel course")
| In
this course, we have tried to gather for you more than 60 of the most needed
and used, in our opinion, Excel functions. And in the lectures prepared for
you, you will not only get a solid theoretical basis, but also a lot of
interesting demonstrations that are not detached from real-life scenarios!
By consciously combining functions with each other, we will: Solve specific problems Create various dashboards, a monthly budget tracker and many other exciting things! In addition, you will have the opportunity to get to know more about: Formula validation tools Common errors in Excel formulas and how to fix them Conditional formatting, which has a formula at its core Array formulas (not to be confused with functions!) Matrices Hotkeys We've done everything we can to ensure that this course will transform you into an advanced Excel user. But there is one condition: you need to be fully into the learning process! By taking our course, you will gain much more knowledge and practical skills than the competition! Pre-requisites: Excel program installed on your PC Basic knowledge and skills in working with Excel Willingness to learn and practice The complete course contains: Downloadable resources required for learning. Homework assignments to complete on your own Tests to test your knowledge as you progress through the course Diploma of Completion Who this course is for: Those wishing to master Excel at an advanced level Those who want to effectively use formulas and functions to solve their problems Those who want to gain new career opportunities with Excel What you will learn Operate reference and array functions: vpr, index, gpr and others. Use functions in combination with each other in practice Operate logical functions: if, error, or, etc. Use functions to create spectacular dashboards, such as a monthly budget tracker. Operate text functions: text, substitute, search, etc. Operate statistical functions: countslice, greatest, median, etc. Perform conditional formatting with formulas Operate mathematical functions: summproduce, sum if, summedmedmed, case-mean, etc. Check any formula and eliminate most errors Check any formula and eliminate common errors Operate date and time functions such as: today, day, daydate, dayday, and others Use an array formula to create a multiplication table, transpose a matrix, and so on. Course content 11 sections - 66 lectures - Total duration 4 h 8 min.
|