LearnNowOnline

Microsoft Excel 365 Data Analysis, Part 1 of 4: Functions and Formulas

Course at a glance

 Release date 10/21/2020 Level Intermediate Runtime 1h 0m Closed captioning Included Transcript Included eBooks / courseware N/A Hands-on labs N/A Sample code Included Exams Included

Course description

Understanding when and how to use advanced functions and arrays is an important step in mastering data analyzation in Excel. Discover the importance of multiple functions including logical and conditional functions, financial and statistical functions, and DateTime functions, as well as examine Arrays, in this overview of advanced functions and formulas.

Prerequisites

This course is designed for students with a base knowledge of Excel and want to learn higher-level skills to display data and perform functions. Students should know how to perform calculations, modify worksheets, format worksheets, print workbooks and manage workbooks.

Meet the experts

I’m Kari Hoien. I have a Bachelors degree in Business and Accounting from Concordia College in Moorhead, I was a CPA and went on to get my Masters in Education Technology from Pepperdine in Malibu, California. I have been working as a trainer and consultant for Microsoft Office products for more than 20 years and I’ve helped clients in almost every industry in a wide range of different capacities and applications. I have taught thousands of people how to use Microsoft Office apps (Excel, Access, Outlook, PowerPoint etc). I have done stand-up classroom style training, virtual training, on-demand training, self-paced training, executive training, one-on-one training – you name it – I've probably done it. I LOVE teaching people how to use these everyday programs better, ways to save time so you can work SMARTER and have more time for the things that you love. Thanks so much for allowing me to help you learn.

Sondra Nelson is a Microsoft Certified Trainer and has been teaching Microsoft Office for over 15 years. She has teaching and consulting experience with high school students, college students and corporate employees.

Functions and Formulas

Logical and Conditional Functions (27:43)
• Introduction (00:33)
• Logical Functions (00:55)
• IF and AND Functions (03:31)
• Demo: IF and AND (04:43)
• Demo: Using IF and AND Together (03:34)
• Conditional Functions (01:00)
• SUMIF (02:30)
• Demo: SUMIF and SUMIFS (05:50)
• Logical Functions Continued (00:33)
• ISBLANK and EXACT (01:06)
• Demo: ISBLANK and EXACT (03:03)
• Summary (00:20)
Financial and Statistical Functions (19:19)
• Introduction (00:18)
• Financial Functions (02:05)
• Financial Functions Continued (01:47)
• PMT and IPMT (01:48)
• Demo: PMT (02:43)
• Demo: IPMT (03:42)
• Statistical Functions (00:48)
• AVERAGE, MEDIAN, and MODE.SNGL Functions (01:34)
• Demo: Mean, Median, and Mode (04:13)
• Summary (00:16)
Date/Time and Arrays (13:06)
• Introduction (00:24)
• Date and Time Functions (01:13)
• Date and Time Functions Continued (00:32)
• Time Functions (01:34)
• Demo: Date and Time Functions (03:01)
• Array Formulas (01:45)
• Array Formulas Continued (00:38)
• Array Demo (00:57)
• Demo: Array Formulas (02:37)
• Summary (00:20)