🔥 Learn Excel in just 2 hours: https://kevinstratvert.thinkific.com

In this step-by-step Microsoft Excel tutorial, learn how to use Formulas and Functions. We start with the fundamentals of entering formulas into Excel. Then we advance to the most common formulas and functions that you'll encounter in Excel. This video is perfect for beginners who are new to formulas and functions, and even more advanced users who want to pick up a new trick or two.

📚 RESOURCES
- Excel Workbook without formulas to follow along: https://1drv.ms/x/s!AmxrofZZlZ....-whN9F9EUuTyuaf_kIbQ
- Completed Workbook with all formulas and Functions: https://1drv.ms/x/s!AmxrofZZlZ....-whN9QhwPmlmuTzwgZBg
- Learn the fundamentals of Excel in just 2 hours: https://kevinstratvert.thinkific.com

⌚ TIMESTAMPS
00:00 Introduction
00:45 Status bar metrics
02:03 Enter formula to add
02:50 Edit formulas
03:06 Relative references
05:29 Fill handle
06:13 Subtract
06:57 Multiply
07:40 Absolute reference
09:46 Reference cells on other sheets
10:45 Name manager
12:03 Divide
12:44 Order of operations
14:40 Basic functions
15:04 Sum function
17:46 Formula text function
18:13 Discovering functions
18:37 Auto sum
19:37 Max function
20:15 Min function
20:48 Large function
21:54 Small function
22:35 Count function
23:00 Counta function
23:49 Countblank function
24:08 Average function
24:44 Median function
25:00 Mode function
25:23 Sumif function
27:29 Wildcards
28:36 Sumifs function
31:26 Proper function
32:00 Trim function
32:25 Concat function
33:39 & function
34:05 Textjoin function
34:52 Right, left and mid functions
35:27 Len function
35:46 Find and search functions
36:40 Left together with find
38:23 Logical functions
39:21 And function
39:53 Or function
40:14 If function
41:27 If together with and
42:23 If together with or
43:00 Nested if
44:41 Ifs function
45:32 Vlookup function
47:18 Xlookup function
49:24 Today and now functions
49:51 Bonus
52:04 Wrap up

📺 RELATED VIDEOS
- Playlist with all my videos on Excel: https://youtube.com/playlist?l....ist=PLlKpQrBME6xLYou

🙌 SUPPORT THE CHANNEL
- Hit the THANKS button in any video!
- Amazon affiliate link: https://amzn.to/3kCP2yz (Purchasing through this link gives me a small commission to support videos on this channel -- the price to you is the same)

🔽 CONNECT WITH ME
- Official web site: http://www.kevinstratvert.com
- LinkedIn: https://www.linkedin.com/in/kevinstratvert/
- Discord: https://bit.ly/KevinStratvertDiscord
- Twitter: https://twitter.com/kevstrat
- Facebook: https://www.facebook.com/Kevin....-Stratvert-101912218
- TikTok: https://www.tiktok.com/@kevinstratvert
- Instagram: https://www.instagram.com/kevinstratvert/

🎒 MY COURSES
- Excel for Beginners in under 2 hours: https://kevinstratvert.thinkific.com/

🙏 REQUEST VIDEOS
https://forms.gle/BDrTNUoxheEoMLGt5

🔔 SUBSCRIBE ON YOUTUBE
https://www.youtube.com/user/k....evlers?sub_confirmat

#stratvert #microsoftambassador

Learn Excel VBA essentials in 15 minutes to automate excel tasks.
🔥 Get 20% OFF our Excel VBA & Macros Course just for the next 7 days! https://www.careerprinciples.c....om/courses/vba-macro

🆓 DOWNLOAD Free Excel file for this video: https://view.flodesk.com/pages..../64679d3c76364508a70

In this video, you'll learn VBA essentials in just 15 minutes. First, you'll learn to set up the visual basic editor using the developer tab, and insert a new module to start coding. As a first scenario, we'll create a custom function to calculate discount percentages if a certain condition is true. Second, we'll create a sub procedure to clear the contents from a dataset in one click. We'll also add a message box and a button to confirm we want to clear the data. Finally, we'll learn to automate how to send an email from Excel containing a subject, a body, and the Excel file attached. Overall, learning VBA will boost your office productivity as you'll be able to autoamte any repetitive task.

LEARN:
🔥Power BI for Business Analytics: https://www.careerprinciples.c....om/courses/power-bi-
📈 The Complete Finance & Valuation Course: https://www.careerprinciples.c....om/courses/finance-v
👉 Excel for Business & Finance Course: https://www.careerprinciples.c....om/courses/excel-for
🚀 All our courses: https://www.careerprinciples.com/courses

SOCIALS:
🎬 My Company YouTube Channel: https://www.youtube.com/@careerprinciples
📸 Instagram - https://www.instagram.com/careerprinciples/?hl=en
🤳 TikTok - https://www.tiktok.com/@career_principles
🧑‍💻 LinkedIn - https://www.linkedin.com/company/careerprinciples/

▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

Chapters:
0:00​ -​ Excel VBA Introduction
1:50​ - Building Custom Functions
4:40​ - Automating Clearing Data
6:46​ - Creating Message Box & Button
10:53​ - Sending an email from Excel in 1 click

Disclaimer: I may receive a small commission on some of the links provided at no extra cost to you.

Power BI Full Course Tutorial (8+ Hours)

Get Ad-Free Training by becoming a member today!
https://www.youtube.com/channe....l/UCqyBfm_H9ugGirk1u

Exercise Files: https://learnitanytime.com/p/e....xercise-files-power-

Who it's for: Business Analysts, Data Analysts, and everyone in between looking to take the next step in data processing and visualization.

What it is: Power BI is Microsoft’s business analytics platform. It’s designed from the ground up to take mass sets of data and organize, analyze, and visualize it using live dashboards and interactive reports.

What you'll learn: In this series, users will be introduced to the foundational concepts of building queries and prepping data for analysis. Users will learn to build relationships across multiple databases using Power Pivot, all the while learning useful functions to help take data to the next level. Become familiar with building and navigating live dashboards and interactive reports, and much more.

Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content:
https://www.learnitanytime.com

Enroll in our live, instructor-led Power BI class:
https://bit.ly/3I4voXJ

For Private Group Trainings please visit:
https://www.learnit.com/privat....e-group-classes-work

Start 0:00
Introduction 0:03
Introduction to Data Analytics and Power BI 5:16
Data Shaping 1:35:53
Enhancing Data Structure 1:49:49
Designing Data Model 2:02:01
DAX 2:38:38
Optimizing Model Performance 3:33:18
Reports and Accessibility 4:01:14
Dashboards 5:15:49
Paginated Reports 6:20:21
Performing Advanced Analytics 6:54:54
Managing Workspaces 7:44:48
Managing Datasets 8:03:06
Conclusion 8:18:20

Manuals: https://bit.ly/30xZb59
Username: manuals
Password: password

#powerbi #powerbitutorial

(C) 2023 Learnit, Inc.

Any illegal reproduction of this content will result in immediate legal action.

Microsoft 365 Basics Full Course Tutorial (3+ Hours)

Get Ad-Free Training by becoming a member today!
https://www.youtube.com/channe....l/UCqyBfm_H9ugGirk1u

Exercise Files: https://learnitanytime.com/p/e....xercise-files-micros

Who it's for: This course is for Microsoft 365 beginners and anyone else who wants to learn the essential tools Microsoft 365 offers.

What it is: Microsoft 365 is the new Office 365, their full-featured cloud platform for productivity, collaboration, and popular apps like Excel, Outlook, PowerPoint, and more.

What you’ll learn: In this 2-part course, we'll give you a tour of Microsoft 365, a convenient online portal for launching apps and getting work done directly in a browser. In Part 1, we'll jump into Excel, covering essentials like formulas, functions, and calculations. Moving on to PowerPoint, we'll cover the basics like slides, objects, and animations. In Part 2, we'll talk about Outlook and show you how to send messages, manage your mail, and use a calendar. Finally, we'll go over Teams, an all-in-one app used for chat, collaboration, and so much more. By the end of this course, you'll be able to use all four of these essential Microsoft apps confidently.

Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content:
https://www.learnitanytime.com

For Private Group Trainings please visit:
https://www.learnit.com/privat....e-group-classes-work

Manuals: https://bit.ly/30xZb59
Username: manuals
Password: password

Start 0:00
Introduction 0:09
Overview 1:28
Getting Started with Excel 2:57
Excel Interface 9:27
Excel Shortcuts 18:55
Data and Lists 21:15
Basic Formulas and Calculations 27:11
Relative Referencing 36:09
Absolute Referencing 45:58
Basic Functions 52:33
Saving and Printing 1:00:47
PowerPoint Interface and Themes 1:08:18
Slides, Text, and Objects 1:13:38
Editing Text 1:20:12
PowerPoint Shortcuts 1:26:31
Inserting and Formatting Images 1:28:59
Inserting Multiple Objects 1:36:07
Object Format and Layout 1:40:59
Animations, Spell Check, and Accessibility 1:50:32
Getting Started with Outlook 1:59:36
Outlook Interface 2:00:35
Composing Messages 2:06:24
Managing Mailboxes 2:15:37
Message Tracking and Unsending 2:25:14
Scheduling Meetings 2:28:03
Printing Calendars 2:34:33
What is Teams? 2:37:22
Teams Interface and Shortcuts 2:40:35
Chat 2:45:57
Calls and Screen Sharing 2:51:24
Creating Teams 2:57:49
Creating Channels 3:04:39
Scheduling Meetings 3:13:53
Notifications 3:19:36
Conclusion 3:22:45

#microsoft365 #office365 #exceltips #excel #powerpoint #outlook #teams #msteams #microsoftteams

(C) 2023 Learnit, Inc.

Any illegal reproduction of this content will result in immediate legal action.