Mastering Microsoft Excel Formulas and Functions

Focused View

Kyle Pew,Office Newb

8:15:03

0 View

1. Excel Formulas and Functions Course Introduction

1. Microsoft Excel Formulas and Functions Course Introduction.mp4

05:06

2. Microsoft Excel Exercise File (DOWNLOAD).mp4

02:38

3. Participate in the Course QA.mp4

02:57

4. Course Announcements.mp4

00:53

5. Microsoft Excel Formulas and Functions Course Certificate.mp4

02:25

2. Introduction to Excel Formulas and Functions

1.1 01-IntroExcelFormulasFunctions.xlsx

2. Overview of Excels Formula Syntax.mp4

03:25

3. Basic Arithmetic Operations.mp4

04:22

4. Introduction to Mathematical Order of Operations.mp4

05:36

5. Mathematical Order of Operations.mp4

03:34

6. Introduction to Cell References (Relative, Absolute, Mixed).mp4

04:02

7. Relative Cell References.mp4

03:37

8. TIP - Excel AutoFill to Copy Formulas.mp4

02:14

9. Absolute Cell References.mp4

05:03

10. Absolute versus Constant Values.mp4

04:08

11. Mixed Cell References.mp4

07:00

12. TIP - Absolute Reference Shortcut Key.mp4

02:51

13. Introduction to Basic Excel Function Syntax.mp4

04:10

14. QUIZ 01 - Introduction to Excel Formulas and Functions.html

3. Microsoft Excel Mathematical Functions

1.1 02-ExcelMathematicalFunctions.xlsx

2. Microsoft Excel SUM() Function.mp4

02:13

3. TIP - Microsoft Excel SUM() Function Shortcut Key.mp4

01:50

4. Microsoft Excel AVERAGE() Function.mp4

02:08

5. TIP - Shortcut Keys to Select Formula Cell References.mp4

01:41

6. Microsoft Excel PRODUCT() Function.mp4

02:13

7. Microsoft Excel MOD() Function.mp4

06:07

8. Microsoft Excel ROUND() Function.mp4

04:06

9. TIP - Round to the Nearest.mp4

02:05

10. Microsoft Excel ROUNDUP() Function.mp4

01:31

11. Microsoft Excel ROUNDDOWN() Function.mp4

01:42

12.1 02-PracticeMathematicalFunctions.xlsx

12. EXERCISE 02 - Microsoft Excel Mathematical Functions.html

13. QUIZ 02 - Microsoft Excel Mathematical Functions.html

4. Nesting Microsoft Excel Functions

1.1 03-ExcelNestingFunctions.xlsx

2. Introduction to Nesting Excel Functions.mp4

03:05

3. Nesting Microsoft Excel Functions Practice.mp4

07:53

4. TIP - Switching Between Nested Excel Function Arguements.mp4

10:11

5.1 03-ExcelNestingFunctions.xlsx

5. EXERCISE 03 - Nesting Excel Functions.html

6. QUIZ 03 - Nesting Excel Functions.html

5. Microsoft Excel Text Functions

1.1 04-ExcelTextFunctions.xlsx

2. Microsoft Excel CONCAT Function.mp4

05:45

3. Microsoft Excel TEXT() Function.mp4

05:00

4. Microsoft Excel LEN() Function.mp4

03:22

5. Microsoft Excel SEARCH() Function.mp4

04:26

6. Microsoft Excel LEFT() Function.mp4

02:14

7. Microsoft Excel RIGHT() Function.mp4

01:08

8. Microsoft Excel MID() Function.mp4

01:55

9. Microsoft Excel TRIM() Function.mp4

04:06

10. Microsoft Excel PROPER() Function.mp4

01:14

11. Microsoft Excel UPPER() Function.mp4

01:03

12. Microsoft Excel LOWER() Function.mp4

01:46

13. Microsoft Excel SUBSTITUTE() Function.mp4

03:37

14. Nesting Microsoft Excel TRIM & PROPER Functions.mp4

03:20

15. Nesting Microsoft Excel SEARCH Function.mp4

07:58

16.1 04-PracticeExcelTextFunctions.xlsx

16. EXERCISE 04 - Microsoft Excel Text Functions.html

17. QUIZ 04 - Microsoft Excel Text Functions.html

6. Microsoft Excel Date and Time Functions

1.1 05-ExcelDateTimeFunctions.xlsx

2. Microsoft Excel TODAY() Function.mp4

02:32

3. Microsoft Excel NOW() Function.mp4

01:31

4. Formatting Microsoft Excels TODAY() & NOW() Functions.mp4

03:57

5. Adding Time to the TODAY and NOW() Functions.mp4

04:11

6. TIP - Date & Time Shortcuts.mp4

02:04

7. Microsoft Excel DATE() Function.mp4

02:33

8. Microsoft Excel DAY() Function.mp4

01:20

9. Microsoft Excel MONTH() Function.mp4

00:50

10. Microsoft Excel YEAR() Function.mp4

01:31

11. Microsoft Excel WEEKDAY() Function.mp4

02:56

12. Microsoft Excel EOMONTH() Function.mp4

04:51

13. Microsoft Excel WORKDAY() Function.mp4

05:22

14. Microsoft Excel NETWORKDAYS() Function.mp4

02:51

15. Microsoft Excel TIME() Function.mp4

01:41

16. Microsoft Excel HOUR() Function.mp4

01:45

17. Microsoft Excel MINUTE() Function.mp4

00:53

18. Microsoft Excel SECOND() Function.mp4

01:25

19. Nesting Microsoft Excel NETWORKDAYS & EOMONTH Functions.mp4

03:46

20. Nesting Microsoft Excel TIME Functions.mp4

03:35

21.1 05-PracticeExcelDataTimeFunctions.xlsx

21. EXERCISE 05 - Microsoft Excel Date and Time Functions.html

22. QUIZ 05 - Microsoft Excel Date and Time Functions.html

7. Microsoft Excel Logical Functions

1.1 06-ExcelLogicalFunctions.xlsx

2. Microsoft Excel IF() Function.mp4

03:34

3. Microsoft Excel IFS() Function.mp4

06:29

4. Microsoft Excel AND() Function.mp4

08:01

5. Microsoft Excel OR() Function.mp4

04:35

6. Microsoft Excel ISNUMBER() Function.mp4

02:49

7. Nested IF() Functions.mp4

05:58

8. Microsoft Excel ISTEXT() Function.mp4

01:13

9. Nesting Microsoft Excel Logical Functions.mp4

10:19

10. QUIZ 06- Microsoft Excel Logical Functions.html

8. Microsoft Excel Lookup and Reference Functions

1.1 08-ExcelLookupFunctions.xlsx

2. Microsoft Excel VLOOKUP() Function.mp4

06:57

3. Microsoft Excel VLOOKUP Function and a Little Math.mp4

02:38

4. Microsoft Excel HLOOKUP() Function.mp4

04:25

5. Microsoft Excel INDEX() Function.mp4

06:53

6. Microsoft Excel MATCH() Function.mp4

05:27

7. Nesting INDEX() and MATCH() Functions.mp4

07:24

8. Nesting Microsoft Excel HLOOKUP and MATCH Functions.mp4

04:32

9. Microsoft Excel INDIRECT() Function.mp4

07:02

10. Microsoft Excel OFFSET() Function.mp4

05:52

11. Microsoft Excel XLOOKUP() Function.mp4

05:45

12. QUIZ 08 - Microsoft Excel Reference Functions.html

9. Microsoft Excel Statistical Functions

1.1 09-ExcelStatisticalFunctions.xlsx

2. Microsoft Excel COUNT() Function.mp4

02:29

3. Microsoft Excel COUNTA() Function.mp4

01:38

4. Microsoft Excel MAX() Function.mp4

01:27

5. Nesting INDEX, MATCH and MAX Functions.mp4

05:38

6. Microsoft Excel MIN() Function.mp4

01:45

7. Microsoft Excel AVERAGEIF() Function.mp4

05:09

8. Microsoft Excel AVERAGEIFS() Function.mp4

04:07

9. TIP - Microsoft Excel AVERAGEIFS() Function with Numeric Conditions.mp4

02:55

10. Microsoft Excel SUMIF() Function.mp4

02:52

11. TIP - Subtotals with an Excel SUMIF() Function.mp4

02:27

12. Microsoft Excel SUMIFS() Function.mp4

02:35

13. Microsoft Excel COUNTIF() Function.mp4

01:52

14. Microsoft Excel COUNTIFS() Function.mp4

03:56

15. QUIZ 09 - Microsoft Excel Statistical Functions.html

10. Microsoft Excel Database Functions

1.1 10-ExcelDatabaseFunctions.xlsx

2. Microsoft Excel DSUM() Function.mp4

07:31

3. Microsoft Excel DSUM() Function Multiple Criteria - OR Statement.mp4

03:07

4. Microsoft Excel DSUM() Function Multiple Criteria - AND Statement.mp4

04:35

5. Microsoft Excel DAVERAGE() Function.mp4

04:35

6. Microsoft Excel DCOUNT() Function.mp4

03:36

7. Microsoft Excel DMIN() Function.mp4

02:26

8. Microsoft Excel DMAX() Function.mp4

02:14

9. QUIZ 10 - Microsoft Excel Database Functions.html

11. Microsoft Excel Financial Functions

1.1 11-ExcelFinancialFunctions.xlsx

2. Microsoft Excel PMT() Function.mp4

02:14

3. Microsoft Excel PV() Function.mp4

01:55

4. Microsoft Excel FV() Function.mp4

02:06

5. Microsoft Excel NPV() Function.mp4

02:53

6. Microsoft Excel IRR() Function.mp4

01:45

7. QUIZ 11 - Microsoft Excel Financial Functions.html

12. Microsoft Excel Array Formulas

1.1 12-ExcelArrayFunctions.xlsx

2. Understanding Arrays.mp4

03:15

3. Microsoft Excel SUMPRODUCT() Function.mp4

04:49

4. Microsoft Excel SUMPRODUCT() with Conditions.mp4

05:34

5. Microsoft Excel FILTER() Function.mp4

06:27

6. Microsoft Excel SORT() Function.mp4

05:58

7. Microsoft Excel GROUPBY() Function.mp4

04:39

8. Microsoft Excel UNIQUE() Function.mp4

03:13

9. Microsoft Excel TEXTAFTER() Function.mp4

03:09

10. Microsoft Excel TEXTBEFORE() Function.mp4

02:12

11. Microsoft Excel TEXTSPLIT() Function.mp4

03:55

12. Microsoft Excel TEXTJOIN() Function.mp4

04:04

13. Microsoft Excel TEXTJOIN() with Condition.mp4

03:53

14. QUIZ 12 - Microsoft Excel Array Functions.html

13. Introduction to Custom Functions with Microsoft Excel VBA

1.1 14-ExcelCustomVBAFunctions.xlsx

2. Introduction to Custom Microsoft Excel VBA Functions.mp4

02:51

3. Our Custom VBA Function Overview.mp4

03:34

4. Microsoft Excel Developer Tab.mp4

03:08

5. Creating a Custom Microsoft Excel VBA Function.mp4

02:43

6. Writing the Excel VBA Function Logic.mp4

08:48

7. Using a Custom Microsoft Excel VBA Function.mp4

02:23

8. Saving Microsoft Excel Files with VBA Code.mp4

01:19

9. QUIZ 14 - Microsoft Excel Custom VBA Functions.html

14. Introduction to Using ChatGPT with Microsoft Excel

1.1 15-ExcelChatGPT.xlsx

2. What is ChatGPT.mp4

04:43

3. Asking ChatGPT Questions.mp4

06:28

4. Quick Intro to ChatGPTs Interface.mp4

07:33

5. ChatGPT Excel Scenario 1.mp4

03:50

6. TIP - Ask Very Specific Questions.mp4

03:56

7. ChatGPT Excel Scenario 2.mp4

03:11

8. ChatGPT Excel Scenario 3.mp4

03:11

15. Microsoft Excel Formulas and Functions Course Conclusion

1. Congratulations on Completing the Microsoft Excel Formulas and Function Course.mp4

01:23

Description

Excel Formulas Unleashed: Master Excel Functions for Data Mastery; includes an introduction to using ChatGPT with Excel

What You'll Learn?

Master Excel's Formula Syntax: Gain proficiency in creating and applying a range of Excel formulas.
Excel in Basic to Advanced Functions: Master basic and advanced functions, including VLOOKUP and INDEX-MATCH.
Error Detection and Troubleshooting: Acquire skills to identify and fix common errors in Excel formulas.
Manipulate Text, Date, and Time: Become adept at using Excel's text, date, and time functions.
Expertise in Nested Functions: Develop the ability to create complex, nested formulas for advanced analysis.
Logical Function Application: Master logical functions like IF, AND, OR for dynamic data evaluation.
Streamline Excel Calculations Using Excel Array Functions like SUMPRODUCT, FILTER, SORT, GROUPBY and more
How to User ChatGPT and Microsoft Excel together

Who is this for?

Beginners with Basic Excel Knowledge: Individuals who have a fundamental understanding of Excel and wish to expand their skills in data analysis and spreadsheet management.

Intermediate Excel Users: Those who are familiar with basic Excel functions and want to deepen their knowledge of more complex formulas, functions, and data manipulation techniques.

Business Professionals: Office workers, managers, and business analysts who rely on Excel for data organization, analysis, and reporting, and are looking to enhance their efficiency and productivity.

Students and Academics: Students and researchers in fields that require data organization and analysis, who want to leverage Excel for their academic projects and research work.

What You Need to Know?

Basic Computer Skills: Familiarity with using a computer, managing files, and navigating software interfaces.

Microsoft Excel Software: Access to a version of Microsoft Excel. It's recommended to have a recent version (like Excel 2016, 2019, or Excel for Microsoft 365) for full compatibility with course content.

Willingness to Learn: An eagerness to learn and patience to practice complex formulas and functions, as the course covers a broad range of topics from basic to advanced levels.

More details

Description
Welcome to "Master Microsoft Excel Formulas and Functions", covering 80+ built-in Excel functions, a comprehensive online course designed to elevate your proficiency in one of the worldâ€™s most widely used spreadsheet applications. Whether you're a professional looking to streamline your workflow, a student aiming to enhance your analytical skills, or a freelancer seeking to expand your toolset, this course offers an in-depth exploration of Excel's powerful formula features.
Mastering Formulas: The Heart of Excel
The core of the course focuses on Excel's formulas â€“ the building blocks that turn a simple spreadsheet into a dynamic data powerhouse. You'll learn to:
Craft Basic and Complex Formulas: Understand the syntax and construct formulas that perform calculations, from basic arithmetic to complex financial analyses.
Leverage Built-In Functions: Excel offers a vast library of functions like SUM, AVERAGE, VLOOKUP, and IF statements. You'll gain hands-on experience in applying these to real-world scenarios, enhancing data interpretation and decision-making skills.
Error Checking and Troubleshooting: Learn to identify and fix common errors in formulas, ensuring accuracy and reliability in your data analysis.
ChatGPT Introduction: Learn to harness the power of AI to streamline your time creating complex formulas in Excel.
Functions for Every Need: Specialized and Custom Solutions
As you become comfortable with standard functions, you'll be introduced to specialized functions tailored to specific needs â€“ financial, statistical, text manipulation, and more. You'll also learn to create custom functions using Excel's built-in programming language, VBA (Visual Basic for Applications), opening a new world of possibilities.
Practical Applications: Real-World Projects
Theory is essential, but practice is key. Throughout the course, you'll engage in hands-on projects, applying what you've learned to real-world data sets. This practical approach solidifies your understanding and prepares you to apply these skills in your daily tasks.
Excel Mastery Awaits: Join Today!
This course is more than just a series of lessons; it's an investment in your future. With an expert instructor, a supportive QA community, and continuous updates, you're joining a program committed to your growth. Enroll in the "Master Microsoft Excel Formulas and Functions" course today and start your journey to becoming an Excel wizard!
Who this course is for:
Beginners with Basic Excel Knowledge: Individuals who have a fundamental understanding of Excel and wish to expand their skills in data analysis and spreadsheet management.
Intermediate Excel Users: Those who are familiar with basic Excel functions and want to deepen their knowledge of more complex formulas, functions, and data manipulation techniques.
Business Professionals: Office workers, managers, and business analysts who rely on Excel for data organization, analysis, and reporting, and are looking to enhance their efficiency and productivity.
Students and Academics: Students and researchers in fields that require data organization and analysis, who want to leverage Excel for their academic projects and research work.

User Reviews

Rating

average 0

Total votes0

Focused display

Excel Formulas and Functions

Kyle Pew

Instructor's Courses

Qualifications: Kyle is a Microsoft Certified Trainer (MCT) and a certified Microsoft Office Master Instructor and has been teaching and consulting for the past 20+ years on various computer applications, including;Microsoft Office Suite 1997, 2000, XP, 2003, 2007, 2010, 2013 Excel, Word, PowerPoint, Outlook, Access and VisioSharePoint End-User 2007, 2010, 2013VBA (Excel and Access)Adobe Suite Photoshop, Illustrator, InDesignMaya (Modeling and Animation)Unity3d (Game Design)HTML, CSS and JavaScriptCrystal ReportsKyle is a graduate of the San Francisco Art Institute in the Media Arts and Animation Program. He has worked as a Game Designer for Electronic Arts, designing on games such as Nerf N-Strike, Nerf N-Strike Elite, both for the Wii, and a Sims 3 Expansion Pack for the PC.Kyle has facilitated courses that range from 1-on-1 interactions to large scale groups of 100+ participants, including; live in person classes, webinar style classes online and live online full courses. He is consistently ranked top in reviews for each of the courses he teaches.Some of the clients Kyle has provided training for include:BrocadeChevronGenentechFacebookLevi StraussPMI Mortgage InsuranceState FundBank of the WestVISAWalmartand many more...What Students have said about Kyle:"Kyle was off the chart "GOOD"""ONE OF THE BEST COURSES THAT I'VE HAD... (IN 12+ YEARS).""Awesome trainer because I'm computer "stupid" and he helped me understand it.""Kyle Pew is very knowledgeable and presented information with exceptional skill."Teaching Philosophy: Kyle believes that student’s best learn through the application of real-life business situations through exercises. Allowing students to guide the class with their specific situations allows for the quickest and easiest adaptation to new technology and skills.In His Spare Time: Kyle enjoys spending time with his family (6 children). When he’s not busy entertaining his kids, you will find him cheering on his favorite hockey team, the San Jose Sharks, this is their year!

Office Newb

Instructor's Courses

Here to support your progress through courses provided by Office Newb, LLC.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.