2016
Udemy
Emre Volkan Gülen
1:30
English
Improving your Excel knowedge; functions, formulas, macro and VBA. Become an Advanced Excel user!
In Functions and Formulas Sections, you will learn how to use Excel skills better and other several ways to reach the result. Macro and VBA will give you totally a new ways to accomplish your tasks. More flexiable, reliable and automated.
This course is for intermediate excel users, who want to improve his knowledge to advanced level. Also, advanced users are welcome to refresh their minds. New Excelers can learn much about what Excel is possible to fulfill, and i am sure that this course will encourage them to learn and use Excel
You have some tasks which takes too much time, work load and possible errors, you will not to worry about those after this course.
Section 1: Intorduction to First Steps to Advanced Excel
Lecture 1
Introduction
03:29
Section 2: Functions of Excel (Useful but less known)
Lecture 2
Edit Links
02:11
Lecture 3
Find the Special Cells
03:00
Lecture 4
Cell Value Restriction
02:59
Lecture 5
Advanced Filter
02:05
Lecture 6
Cleaning the Complete List
01:35
Lecture 7
Conditional Formatting
02:49
Lecture 8
Conclusion Section 1
1 page
Test 1
Quiz for Section 2
4 questions
Section 3: Most commonly used formulas in excel
Lecture 9
If(and
01:43
Lecture 10
Vlookup
02:35
Lecture 11
Index Match
03:01
Lecture 12
More complicated: 5 Formulas in a Row
02:32
Lecture 13
Concatenate
02:12
Lecture 14
Sumproduct
03:13
Lecture 15
IS formulas
01:31
Lecture 16
Conclusion Section 2
00:05
Test 2
Quiz for Section 3
4 questions
Section 4: MACRO for beginners
Lecture 17
Intro and What is the Logic of Macro
03:48
Lecture 18
Record Macro (Intro to VBA)
03:27
Lecture 19
Macro Buttons
01:18
Lecture 20
Visual Basic Editor
02:17
Lecture 21
Conclusion Section 4
00:05
Test 3
Quiz for Section 4
3 questions
Section 5: VBA in Action
Lecture 22
Introduction
02:26
Lecture 23
Copy Paste in VBA & Offset Statement
07:24
Lecture 24
VBA Loops
08:29
Lecture 25
Displaying vba tasks
07:53
Lecture 26
Security
06:40
Lecture 27
Conclusion Section 5
00:10
Test 4
Quiz for Section 5
4 questions
Section 6: Conclusion of the Course
Lecture 28
Conclusion
00:10
udemy.com/first-steps-to-advanced-excel
Download File Size:442.09 MB
|
