Miscellaneous lessons from the Expert Skills course.
4.0
(1)
15 learners
What you'll learn
This course includes
- 2.5 hours of video
- Certificate of completion
- Access on mobile and TV
Course content
1 modules • 20 lessons • 2.5 hours of video
Miscellaneous lessons from the Expert Skills course.
20 lessons
• 2.5 hours
Miscellaneous lessons from the Expert Skills course.
20 lessons
• 2.5 hours
- 03-05 Use the Excel IF function 08:41
- Lesson 03-06 Use the Excel SUMIF and COUNTIF functions 06:51
- 03-07 Excel Date and Time - Everything you need to know. 11:11
- 03-22 Use a VLOOKUP function for an exact lookup. 07:37
- 03-24 Use a VLOOKUP function for an inexact lookup 05:37
- Excel Expert Lesson 6-3: Understand OLAP, MDX and Business Intelligence. 10:18
- Excel Expert Lesson 5-8: Filter a pivot table visually using slicers 09:17
- Excel Expert Lesson 6-1: Understand primary and foreign keys 11:28
- Excel Expert Lesson 6-9: Understand many-to-many relationships 11:06
- Excel Expert Lesson 8-10: Understand the three different ways to share a workbook 05:55
- 09-01 Add Group Box and Option Button form controls without VBA 16:40
- 09-02: Add a Combo Box (Drop-Down List) form control without VBA 04:20
- 09-03 Set Cell Links for Excel Combo Box & Group Box (Option Buttons) 08:24
- 09-04 Use the Excel PMT function to create a mortgage calculator 06:33
- 09-05 Add an Excel check box form control to a worksheet without VBA 03:45
- 09-06 Use Excel CheckBox values in formulas without VBA 09:46
- 09-10: Record Your First Excel Macro (Short, Comprehensive Tutorial) 07:20
- 09-12 Understand Macro Security, Trusted Folders and Trusted Documents 05:17
- 09-13: Implement Macro Security 10:54
- 09-17 Run an Excel macro from a button control 10:46
Take this course with you
Download the app to continue lessons from your phone anytime.
