Description
Master Excel and Solve 500 Problems (Beginner – Advanced), the Excel and Solve 500 Problems training course has been published by Udemy Academy. This Excel course covers all levels – from beginner to advanced. This course consists of 500 time-structured video tutorials where the student can learn how to solve problems of various levels of complexity using various functions and tools. Each video tutorial has its own worksheet where the problem definition is explained in detail. This course focuses heavily on formulas and functions. We start with the most basic math formulas, like how to write 2+2=4 in a cell. In later video tutorials, as the problems become more complex, students will learn how to write nested functions, and some solutions even require nesting up to 10 different functions inside each other. We cover up to 20 different Excel tools that help clean and organize data, create user templates, visualize data, and more. This course includes creating different types of charts and dashboards to visualize data using Power Query, Power Pivot and Pivot tables. Videos on how to record macros, write VBA code by hand, build user forms, build code that runs on specific triggers, and create user-defined functions using VBA.
What you will learn
- solving easy, medium and difficult problems using functions;
- Use different tools to clean and organize data.
- Creating automated dashboards using Power Pivot, Power Query and Pivot tables;
- Record and write VBA codes to automate operations
- Main shortcuts.
Who is this course suitable for?
- Beginner user – if you want to know basic tools and formulas;
- Intermediate user – if you know the basics and want to increase the information;
Advanced user – if you want to learn VBA, Power Pivot, Power Query and be able to write complex nested functions; - If you want to practice, because practice is the best way to improve!
Details of Master Excel and Solve 500 Problems (Beginner – Advanced) course
- Publisher: Udemy
- teacher: Nikoloz Glonti
- English language
- Education level: all levels
- Number of courses: 518
- Training duration: 70 hours and 24 minutes
Head of the seasons
Course prerequisites
- No technical experience needed. You will learn everything you need in this course.
Pictures
Sample video
Installation guide
After Extract, view with your favorite Player.
English subtitle
Quality: 720p
Changes:
The version of 2023/11 has increased by 1 lesson and the duration of 5 minutes compared to 2023/5. English subtitles have also been added to the course.
download link
File(s) password: www.downloadly.ir
Size
74.03 GB
Be the first to comment