by Mumshad Mannambeth | Publisher: Packt Publishing | Release Date: April 2018 | ISBN: 9781788998109

Learn MS Excel formulas in a fun and interesting way by solving puzzles and playing games!About This VideoAll the topics have associated Excel workbook resources containing sample problems to solve, puzzles, games, and real-world practice questions to practice on.In DetailIn this course we'll be learning about Excel formulas and having a lot of fun while we are at it. This course is for beginners who are just starting with Excel formulas and hopefully, by the end of the course,will have gained enough knowledge to be able to use formulas in their day-to-day activities. We will start with cell references, and then move on to different types of formulas, functions such as logical functions, text functions, and lookup functions. All the topics have associated Excel workbook resources containing sample problems to solve, puzzles, games, and real-world practice questions to practice on. To conclude, work on a mini-project to build a dashboard for an imaginary software development firm. Happy learning!

1. Chapter 1 : Introduction
   • Introduction 00:02:56
2. Chapter 2 : Formula Basics
   • Introduction to Cell References 00:02:18
   • Introduction to Excel Formula 00:03:16
   • Absolute and Relative Cell Referencing 00:07:57
   • Cell References across Worksheets 00:01:48
3. Chapter 3 : Functions
   • Introduction to Functions 00:01:46
   • Text Functions 00:02:32
   • Logical Operators 00:00:37
   • Logical Functions 00:02:50
   • vLOOKUP - Lookup and Reference Functions 00:03:43
4. Chapter 4 : Mini-Project
   • Mini-Project 00:00:56