Excel Power User Beginner Tutorial

Excel Power User Beginner Tutorial

Learnit Training via YouTube Direct link

Building New Rules and Troubleshooting

19 of 22

19 of 22

Building New Rules and Troubleshooting

Class Central Classrooms beta

YouTube videos curated by Class Central.

Classroom Contents

Excel Power User Beginner Tutorial

Automatically move to the next video in the Classroom when playback concludes

  1. 1 Start
  2. 2 VLOOKUP
  3. 3 Range Lookup
  4. 4 Autofilling Lookup
  5. 5 Defining Names
  6. 6 Using Named Ranges to Retrieve Data
  7. 7 INDEX
  8. 8 MATCH
  9. 9 INDEX & MATCH Part 1
  10. 10 INDEX & MATCH Part 2
  11. 11 INDEX & MATCH Part 3
  12. 12 Introduction to Array Formula
  13. 13 Array Formula
  14. 14 Array Function
  15. 15 Dynamic Named Ranges Offset
  16. 16 OFFSET Function
  17. 17 Name Manager
  18. 18 Basic Conditional Formatting
  19. 19 Building New Rules and Troubleshooting
  20. 20 Expanding Conditional Formatting Fields
  21. 21 Text Search Conditional Formatting
  22. 22 Data Validating Conditional Formatting

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.