In this Microsoft Excel tutorial I have a look at the Excel basic formulas and functions, these are the Excel basics for beginners that become essential for people just starting out with Excel.
I cover the Microsoft Excel basic formulas and functions like:
✅ How to use VLOOKUP in Microsoft Excel
✅ How to use HLOOKUP in Microsoft Excel
✅ How to use XLOOKUP in Microsoft Excel
✅ How to use SUM in Microsoft Excel
✅ How to use SUMIF in Microsoft Excel
✅ How to use SUMIFS in Microsoft Excel
✅ How to use COUNT in Microsoft Excel
✅ How to use COUNTIF in Microsoft Excel
✅ How to use COUNTIFS in Microsoft Excel
✅ How to use AVERAGE in Microsoft Excel
✅ How to use AVERAGEA in Microsoft Excel
✅ How to use AVERAGEIF in Microsoft Excel
✅ How to use AVERAGEIFS in Microsoft Excel
✅ How to use IF in Microsoft Excel
✅ How to use IFS in Microsoft Excel
✅ How to use CONCAT / CONCATENATE in Microsoft Excel
✅ How to use DROPDOWN MENUS in Microsoft Excel
All these Microsoft Excel Basic Formulas and Functions are the perfect Microsoft Excel Basics for beginners to ease you into Microsoft Excel. The Microsoft Excel Basics for Beginners formulas and functions are easy to follow functions that help beginners learn the Microsoft Excel basics. To learn more about the Microsoft Excel Basics for Beginners check out my Excel Basics playlist.
Quick Navigation:
00:00 Intro
00:30 How to use VLOOKUP formula in Microsoft Excel
02:28 How to use HLOOKUP formula in Microsoft Excel
04:57 How to use XLOOKUP formula in Microsoft Excel
08:00 How to use SUM formula in Microsoft Excel
08:14 How to use SUMIF formula in Microsoft Excel
08:58 How to use SUMIFS formula in Microsoft Excel
10:35 How to use COUNT formula in Microsoft Excel
11:10 How to use COUNTIF formula in Microsoft Excel
11:45 How to use COUNTIFS formula in Microsoft Excel
13:35 How to use AVERAGE formula in Microsoft Excel
14:00 How to use AVERAGEA formula in Microsoft Excel
15:55 How to use AVERAGEIF formula in Microsoft Excel
17:05 How to use AVERAGEIFS formula in Microsoft Excel
18:04 How to use DAVERAGE formula in Microsoft Excel
20:10 How to use IF formula in Microsoft Excel
22:15 How to use IFS formula in Microsoft Excel
25:10 How to use CONCAT / CONCATENATE formula in Microsoft Excel
27:03 How to use DROPDOWN MENUS in Microsoft Excel
If you found this video useful please click the like button and consider subscribing to the channel, if you click the bell icon you will also be notified of all our latest videos.
/ @thatofficeguy
Playlist Links
Excel • Microsoft Excel
Excel Basic Formulas • Excel Basic Formulas and Functions
Excel Advance Formulas • Excel Advance Formulas & Functions
Teams • Microsoft Teams
Outlook • Microsoft Outlook
OneNote • Microsoft OneNote
Planner • Microsoft Planner
Welcome to the official THAT OFFICE GUY channel where you will learn all about the various Microsoft 365 apps and more! Many of our videos cover the popular Microsoft Excel, Microsoft Teams, Microsoft Planner, Power BI, Power Automate, and all other basics in Microsoft 365.
With the Excel tips and tricks, you get to significantly improve your Excel reports not just in terms of analysis but also visualization & VBA automation.
With Microsoft Teams you'll be able to achieve greater levels of communications with your colleagues and with all the other Microsoft 365 applications you'll learn how to embed processes that cross the apps and increase productivity!
Subscribe if you'd like to improve your skills.
New videos are uploaded each week and live streams coming soon!
Let’s connect!
/ thatofficeguyuk
/ thatofficeguy1
/ thatofficeguy
/ thatofficeguy
#thatofficeguy #Excel #MSExcel #MicrosoftExcel #ExcelTutorial #excelTutorial #excelTutorialForBeginners #excel #excelCompleteCourse #ExcelFormulas