Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
0 Hour(s) 45 Minute(s)
Language
English
Taught by
Viliam Gregus
Rating
Course Overview
VLOOKUP, Pivot Tables, Charts, IF, Autofill, Conditional formating and much more with real-life examples.
In this course you will learn the most-used Excel skills which are most commonly required from top companies:
- VLOOKUP
- Pivot Tables
- IF function
- Charts
- Autofill
- SUM,MIN,MAX,AVERAGE and other basic formulas
- Sorting and filtering
- Conditional formatting and more.
Everything is presented on real-life examples and in a timely manner. All videos are 5 minutes or shorter, ensuring you wont loose focus and stay motivated during the course. You will get a file with 25 tasks where you can exercise your newly aquired knowledge, all tasks are solved in the videos by the Lector.
This course is for:
- Excel beginners and intermediate users with elementary knowledge of Excel (knowing how to input data, copy cell etc.)
Course Content
- 1 section(s)
- 10 lecture(s)
- Section 1 Lectures
What You’ll Learn
- Basic, most-commonly used Excel skills: VLOOKUP, Pivot Tables, Charts, IF function, Conditional formatting, Autofill, Sorting, Filtering, Table Trnsformation etc.
Skills covered in this course
Reviews
-
DDonna Goss
He is very concise an easy to follow in his directions. Found this class very informative.
-
MMorgan Klaif
I needed a refresher on some Excel functionality, and this provided it. I would have liked to see some further explanations or a larger dive into some extra capabilities, such as being able to use "add to data model" in the pivot tables to count distinct.
-
HHaruki Uike
It is concise but it included key functions/techniques. It is suitable for those who want to have overview of various Excel skills and what we can do with Excel.
-
AAbdulaziz
very useful information on analyzing data
