- 17
- 2 617
Jason Lucas - Excel Formulas
เข้าร่วมเมื่อ 18 เม.ย. 2024
Join me on my journey as I level up my skills in Excel and share what I learn in quick digestible videos.
Subscribe now for content such as:
-Functions: (vlookup, xlookup, sumifs, countifs, find, date, match, index, filter)
-Features and tools: (pivot table, imbedded formulas, charts, remove duplicates)
And so much more! Watch now and enjoy.
Subscribe now for content such as:
-Functions: (vlookup, xlookup, sumifs, countifs, find, date, match, index, filter)
-Features and tools: (pivot table, imbedded formulas, charts, remove duplicates)
And so much more! Watch now and enjoy.
Excel Sequence Function - Create Dynamic Team Calendar Date Range
It does more than just create a range of numbers. Use the sequence function to create a dynamic calendar range based on the year and month provided. Great for creating a team calendar template. This lesson is step by step tutorial on mastering the art of enhancing functions with other nested functions and formulas.
Check out my video on creating a team calendar:
th-cam.com/video/N7ryntI9SLM/w-d-xo.html
Like and subscribe!
00:00 Intro
00:50 Create Data Validation List
02:53 DATE Function
03:40 EOMONTH Function
05:03 Count Days in Feb
06:40 SEQUENCE Function
08:30 XLOOKUP Function
10:00 Build Dynamic Calendar
14:38 Thanks For Watching
#excel #calendar
Check out my video on creating a team calendar:
th-cam.com/video/N7ryntI9SLM/w-d-xo.html
Like and subscribe!
00:00 Intro
00:50 Create Data Validation List
02:53 DATE Function
03:40 EOMONTH Function
05:03 Count Days in Feb
06:40 SEQUENCE Function
08:30 XLOOKUP Function
10:00 Build Dynamic Calendar
14:38 Thanks For Watching
#excel #calendar
มุมมอง: 233
วีดีโอ
Excel - Multiply Cells With Text Using Flash Fill!
มุมมอง 285วันที่ผ่านมา
Quickly and easily multiply cells with text using Flash Fill in Excel. This is the best feature in Excel in my opinion. Watch this tutorial until the end, this is not just another how-to lesson, it's actually a pretty cool hack. Please like and subscribe if you find this helpful! 00:00 Introduction 00:10 How To Multiply 00:40 Flash Fill 01:38 Flash Fill Trick 02:34 Thanks For Watching #exceltri...
Excel - Create Team Calendar
มุมมอง 413วันที่ผ่านมา
Create a dynamic team tracker calendar in Excel which updates automatically as you specify the month and year. The conditional formatting automatically highlights the weekend columns saving time over doing it manually. This quick tutorial video will show you how to use features and functions such as: -Conditional Formatting based on another cell -Weekday Function -Date Function -Drop Down Lists...
Excel SUMIFS - Quick How To
มุมมอง 8021 วันที่ผ่านมา
Start adding up numbers based on multiple criteria using the sumifs function in Microsoft Excel. I jump straight to the point in this lesson for beginners. Don't forget to like, comment, and subscribe for more Excel tips and tricks! #sumifs #excel #stepbysteptutorial
Excel SUMIF Function: Quick and Easy Tutorial
มุมมอง 6321 วันที่ผ่านมา
Start adding up numbers based on a specific criteria using the sumif function in Microsoft Excel. I jump straight to the point in this lesson for beginners. Don't forget to like, comment, and subscribe for more Excel tips and tricks! #sumifs #excel #step
Excel: Count Ignoring Duplicates!
มุมมอง 7121 วันที่ผ่านมา
In this video, I'll show you a quick and easy method to count the number of non-duplicate values in a range using Excel. I will also cover how to return the number of distance values in a range as well. 00:00 Intro 00:14 Count Ignoring Duplicates 01:22 Count Distinct Values 02:00 Count Duplicates 03:00 Thank for watching Don't forget to like 👍, comment 💬, and subscribe 🔔 for more Excel tips and...
Excel Hack: Easily Find and Count Duplicates!
มุมมอง 30721 วันที่ผ่านมา
How to Count Duplicates in Excel: Step-by-Step Guide 🔍 Welcome back to Jason Lucas - Excel Formulas! In this video, I'll show you how to easily count duplicates and sequence them in Excel using countif and then clean up the data for further analysis. Whether you're managing a large dataset or just want to clean up your spreadsheet, these tips will save you time and effort. 📊✨ 00:00 Intro 00:11 ...
Excel IF Function: Basics, Multiple Criteria, AND, OR Explained!
มุมมอง 104หลายเดือนก่อน
In this video, I'll be diving into the world of the IF function in Excel! 📊 We'll start with the basics of the IF function, then move on to IFS , AND, OR for when there are multiple criteria scenarios.💡 00:00 Intro 00:11 Basic IF 00:51 Multiple Criteria IFS 03:03 AND with IF 04:04 OR with IF 05:17 Thanks for watching 🔔 Don't forget to subscribe to my channel for more Excel tips and tricks: 📈 If...
Excel: Conditional Formatting Based on Another Cell in Minutes!
มุมมอง 133หลายเดือนก่อน
🎉 Master Excel Conditional Formatting Based on Another Cell! 🎉 Welcome back to Jason Lucas - Excel Formulas! In today's video, we're diving deep into one of the most powerful features in Excel: Conditional Formatting Based on Another Cell. Whether you're a beginner or an advanced user, this tutorial will help you make your data more insightful and visually appealing. 📊✨ 🔍 What You'll Learn: - H...
Mastering the Excel FILTER Function: The Ultimate Guide
มุมมอง 105หลายเดือนก่อน
In this video, I dive deep into the Filter Function in Excel. Whether you're a beginner or looking to refine your skills, this tutorial covers everything you need to know: 🔍 Basic Use: Learn how to apply the filter function to streamline your data analysis. 🔍 Multiple Criteria: Discover how to filter data using multiple criteria to get precise results. 🔍 Complementary Functions: Enhance your fi...
How To Quickly Create an Excel Table (2024)
มุมมอง 120หลายเดือนก่อน
Unlock the power of Excel with our quick and easy tutorial on creating tables! In this step-by-step guide, learn how to master Excel tables and essential features to kickstart your productivity. Whether you're a beginner or looking to enhance your skills, this how-to video is your go-to resource for Excel success. Watch now and excel at tables like never before! 00:00 Intro 00:11 Creating a Tab...
The Most Underrated Excel Trick That Will Save You Hours
มุมมอง 90หลายเดือนก่อน
Learn the most underrated Excel trick that can save you hours of work. In this tutorial, you will discover how to use Flash Fill to quickly parse, separate, and extract data, making your data extraction process more efficient. This time hack is a must-know for anyone looking to improve their time management and productivity in Excel. No functions or formulas. Become an Excel wizard with this Fl...
Lilacs In Full Bloom - Don't Miss Out!
มุมมอง 13หลายเดือนก่อน
Experience the breathtaking beauty of blooming lilacs at the Royal Ontario Botanical Garden in Burlington. Join us for a stroll through the lilac farm as we showcase the stunning botanical wonders of springtime magic. Immerse yourself in the fragrant blooms and botanical paradise as you enjoy a peaceful park stroll surrounded by the sweet scents of our lilac garden. Don't miss out on this oppor...
How to Remove Duplicates in Excel Using 4 Simple Methods
มุมมอง 472 หลายเดือนก่อน
Remove duplicates in Excel using 1 of 4 simple ways covered in this how-to tutorial. 0:00 Intro 0:15 From Menu 3:16 Unique Function 7:42 Power Query 9:43 Advanced Filter 10:21 Outro #remove #duplicates #excel
Export iPhone Contacts To Excel - FAST!
มุมมอง 5492 หลายเดือนก่อน
If you have a Google account you can export your iphone contacts to Excel super fast and easy without any 3rd party software. 0:00 Intro 0:18 iCloud Backup Enable 0:51 Export Contacts iCloud 2:09 Import to Google 3:33 Export from Google 4:23 Outro Thanks to 358studios for their helpful video: th-cam.com/video/WtFwbqE4Cjw/w-d-xo.htmlsi=O9KoiLymHne4rbxV #export #iPhone #excel
Unleashing the Power of Wildcards in Excel's XLOOKUP Function
มุมมอง 402 หลายเดือนก่อน
Unleashing the Power of Wildcards in Excel's XLOOKUP Function
Thank you, very helpful video, learned sequence and xlookup formula as well.
Thanks for video, really appreciated. But i have one concern, can it automatically stop at end of the month? Instead of generating next month dates as well.
For this particular calendar you'll need to manually copy to the end of the month leaving out the extra days. Good question though, I'll think about this and make an update if it's not to intense a solution.
Just created video: th-cam.com/video/kNzSRxv_pw0/w-d-xo.html
@@JasonLucasExcel Thank you very much for video
Hope this was helpful? Like and subscribe!
The birds singing are wonderful!
Cute and interesting!
Always informative! Thanks Jason
Thanks Jason! This is very helpful!
Hope this is helpful
Thanks Jason, this is useful!
My first video, please subscribe and like 🙂