- Introduction
- SUM()
- AVERAGE()
- COUNT()
- MIN() & MAX()
- CONCAT(), LEN(), & REPLACE()
- Vlookup(): Example 1
- Vlookup(): Example 2
- Vlookup(): Example 3
- IF() Statement: Example 1
- IF() Statement: Example 2
- IF() Statement: Example 3
- IF() Statement: Example 4
Requirements
· No Prior Excel Knowledge Required
· Microsoft Excel 2007, 2010, 2013, 2013, 2019 or Microsoft 365 Excel Loaded on Computer to Follow Along with Instructor Lectures is Recommended
Description
Microsoft Excel: Formulas for Beginners
This Microsoft Excel course will teach you the foundational excel formulas in record time! Below are the formulas that you will learn:
· VLOOKUP
· IF
· SUM
· AVERAGE
· COUNT
· MIN
· MAX
· CONCAT (Replaced CONCATENATE in 2016)
· LEN
· REPLACE
Topics covered in this course apply to Excel 2007, 2010, 2013, 2016, 2019 (Microsoft/Office 365)
Whether you have been struggling with a specific formula or you have just started your excel journey, this course will walk you through the basic excel formulas in an easily to understand and approachable format. I've designed this course to be as short as possible to cut the fluff and to allow you to ingest the information quickly and effectively. My goal is to have you fluent in these formulas and use this as a booster to your excel learning expedition.
Who this course is for:
· This Microsoft Excel courses will take you through all of the most common formulas that you need to be successful in excel.
· This course is designed for the beginner, but the intermediate user will still benefit from the content.
Learn to develop and back-test sentiment and technical models to forecast the trend of assets with real applications.
Learn the basics circuit design and build your own autonomous car
Introduction to the basics of banking and credit scores.
Lecture 6 has fallen out; please read my Instructor bio for a solution. Thank you. (My bio is on my Course Landing page)
Hi, I'm Jeremy. I have been in the working world for almost 7 years and all of that time has been spent in excel. From my time in college, to my current role today, excel has been a part of my daily toolkit. I’ve developed a passion for analytics, an interest in figuring out the most efficient solutions, and a love for automation.