Company: Packt Publishing Author: Mumshad Mannambeth Full Title: Fun Excel Learning Year: 2018 Language: English Genre: Educational: Software Skill Level: - Price: €19.99 - Files: MP4 Time: 00:43:16 Video: AVC, 1280 x 720 (1.778) at 30.000 fps, 450 kbps Audio: AAC at 192 Kbps, 2 channels, 48.0 Learn MS Excel formulas in a fun and interesting way by solving puzzles and playing games! In 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! Style and Approach If you are looking for basic formula and function info with very good exercises, then this course is for you! You should have access to to the Microsoft Excel application. Learn: ✓ Use Excel formulas in spreadsheets ✓ Use cell references in Excel Relative, Absolute, cross-sheet referencing ✓ Understand how formulas in Excel can make your day-to-day job easy! Features: ✓ All the topics have associated Excel workbook resources containing sample problems to solve, puzzles, games, and real-world practice questions to practice on. Lessons: 1. Introduction 01. Introduction 2. Formula Basics 02. Introduction to Cell References 03. Introduction to Excel Formula 04. Absolute and Relative Cell Referencing 05. Cell References across Worksheets 3. Functions 06. Introduction to Functions 07. Text Functions 08. Logical Operators 09. Logical Functions 10. vLOOKUP - Lookup and Reference Functions 4. Mini-Project 11. Mini-Project Our members see more. Join us! ------------- Our members see more. Join us!
