0
0 reviews
Learn to use Microsoft Excel like a Pro - Intermediate Level
- Description
- Curriculum
- Reviews
If you already have some basic knowledge of Microsoft Excel, or just completed the “Learn to use Microsoft Excel like a Pro” at the Beginner Level, take this course “Learn to use Microsoft Excel like a Pro” at the Intermediate Level to:
- Work with DataBase functions
- SumIFs
- Be a master with Pivot Tables
- 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 Intermediate
Lists
-
202. What are Lists?03:01Sorry, this lesson is currently locked. You need to complete "Excel Intermediate" before accessing it.
-
303. Sorting a List01:39Sorry, this lesson is currently locked. You need to complete "Excel Intermediate" before accessing it.
-
404. Sorting multiple Criteria02:18Sorry, this lesson is currently locked. You need to complete "Excel Intermediate" before accessing it.
-
505. Custom Sort02:55Sorry, this lesson is currently locked. You need to complete "Excel Intermediate" before accessing it.
-
606. Format a List as a Table02:16Sorry, this lesson is currently locked. You need to complete "Excel Intermediate" before accessing it.
DataBase Function
-
707. instruction to DataBase Functions03:29This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
-
808. DSum Function – Single Criteria02:51Sorry, this lesson is currently locked. You need to complete "07. instruction to DataBase Functions" before accessing it.
-
909. DAverage02:12Sorry, this lesson is currently locked. You need to complete "07. instruction to DataBase Functions" before accessing it.
-
1010. DCount Function01:48Sorry, this lesson is currently locked. You need to complete "07. instruction to DataBase Functions" before accessing it.
Data Validation
-
1111. Data Validation List05:54This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
-
1212. Data Validation Decimal01:54Sorry, this lesson is currently locked. You need to complete "11. Data Validation List" before accessing it.
-
1313. Input and Error Messages04:17Sorry, this lesson is currently locked. You need to complete "11. Data Validation List" before accessing it.
Creating Basic Charts
Pivot Tables
-
1515. Formatting Pivot Table Data03:44Sorry, this lesson is currently locked. You need to complete "Creating Basic Charts" before accessing it.
-
1616. Drilling down into Pivot Data TableText lessonThis lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
-
1717. Creating Pivot Charts03:16Sorry, this lesson is currently locked. You need to complete "16. Drilling down into Pivot Data Table" before accessing it.
-
1818. Filtering Pivot Table Data02:51Sorry, this lesson is currently locked. You need to complete "16. Drilling down into Pivot Data Table" before accessing it.
-
1919. Filtering using the Slicer02:50Sorry, this lesson is currently locked. You need to complete "16. Drilling down into Pivot Data Table" before accessing it.
Lookup Functions
-
2020. VLookUp02:58This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
-
2121. HILookUP03:02Sorry, this lesson is currently locked. You need to complete "20. VLookUp" before accessing it.
-
2222. Index and Match04:51This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
Advanced Functions
-
2323. FV Function03:38Sorry, this lesson is currently locked. You need to complete "Lookup Functions" before accessing it.
-
2424. PMT Function01:37This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
-
2525. Hyperlinks03:59This lesson is locked because you haven't completed the previous one yet. Finish the previous lesson to unlock this one.
-
2626. Text and Columns01:31This 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
EUR55
One time purchase
EUR55
Buy course
Available with Memberships
Share
30-Day Money-Back Guarantee
Course details
Lectures
27
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 |