0
0 reviews
Learn to use Microsoft Excel like a Pro – Advanced Level
- Description
- Curriculum
- Reviews
I you already have some intermediate knowledge of Microsoft Excel, or just completed the “Learn to use Microsoft Excel like a Pro” at the Intermediate Level, take this course “Learn to use Microsoft Excel like a Pro” at the Advanced Level to:
- Learn To Use Excel Like The Professionals
- VLookUp and Advanced VLookUps.
- Index and Match and Advanced Index and Match
- Track workbooks between teams
- Automate, streamline, and completely revolutionize your workflow with Excel
Who this course is for:
- Students and Corporate employees wanting to improve their Excel skills
Course materials
Excel Advanced
Working with Multiple Workbooks
-
303.Tracing Precedents02:31This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
-
404. Tracing Dependants01:18Sorry, this lesson is currently locked. You need to complete "03.Tracing Precedents" before accessing it.
-
505. Watch Window02:19Sorry, this lesson is currently locked. You need to complete "03.Tracing Precedents" before accessing it.
-
606. Show Formula03:11Sorry, this lesson is currently locked. You need to complete "03.Tracing Precedents" before accessing it.
Protecting Worksheets and Workbooks
-
707. Protecting Cells in Worksheets04:37This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
-
808. Protecting the Workbook Structure02:34Sorry, this lesson is currently locked. You need to complete "07. Protecting Cells in Worksheets" before accessing it.
-
909. Encryption with Passwords02:52Sorry, this lesson is currently locked. You need to complete "07. Protecting Cells in Worksheets" before accessing it.
Conditional Formulas
-
1010. Name Ranges05:56This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
-
1111. Simple IF Function05:44Sorry, this lesson is currently locked. You need to complete "10. Name Ranges" before accessing it.
-
1212. IF, AND03:31Sorry, this lesson is currently locked. You need to complete "10. Name Ranges" before accessing it.
-
1313. IF, OR03:30Sorry, this lesson is currently locked. You need to complete "10. Name Ranges" before accessing it.
-
1414. Nested Formula04:03Sorry, this lesson is currently locked. You need to complete "10. Name Ranges" before accessing it.
-
1515. CountIF and CountIF's05:34Sorry, this lesson is currently locked. You need to complete "10. Name Ranges" before accessing it.
-
1616. SumIF and SumIF's03:15Sorry, this lesson is currently locked. You need to complete "10. Name Ranges" before accessing it.
Advanced Function
-
1717. Advanced VLookUp04:16This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
-
1818. IF and IS Error part. 103:10Sorry, this lesson is currently locked. You need to complete "17. Advanced VLookUp" before accessing it.
-
1919. IF and IS Error part.204:07Sorry, this lesson is currently locked. You need to complete "17. Advanced VLookUp" before accessing it.
-
2020. Advanced Index Match02:39Sorry, this lesson is currently locked. You need to complete "17. Advanced VLookUp" before accessing it.
-
2121. Dates part. 105:20Sorry, this lesson is currently locked. You need to complete "17. Advanced VLookUp" before accessing it.
-
2222. Dates part. 203:34Sorry, this lesson is currently locked. You need to complete "17. Advanced VLookUp" before accessing it.
-
2323. Replace and Substitute part. 103:23This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
-
2424. Replace and Substitute part. 204:51This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
Text and Based Functions
-
2525. Left, Right and Mid Function02:30This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
-
2626. Search Function02:43This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
-
2727. Concatenate and Search03:52This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
-
2828. Indirect - Static02:31This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
-
2929. Indirect- Dynamic04:36This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
What IF Tools
-
3030. Goal Seek02:41This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
-
3131. Data Tables01:59This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
-
3232. Scenarios04:47This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
-
3333. Solver04:25This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
Please, login to leave a review
Get course
EUR65
One time purchase
Available with Memberships
Share
Course details
Lectures
34
Level
Fortgeschritten
Full lifetime access
Access on mobile and TV
Popular courses
Popular Courses
Archive
Working hours
| Monday | 9:30 am - 6.00 pm |
| Tuesday | 9:30 am - 6.00 pm |
| Wednesday | 9:30 am - 6.00 pm |
| Thursday | 9:30 am - 6.00 pm |
| Friday | 9:30 am - 5.00 pm |
| Saturday | Closed |
| Sunday | Closed |