![Excel Up North](/img/default-banner.jpg)
- Видео 57
- Просмотров 306 583
Excel Up North
Канада
Добавлен 15 сен 2020
Hi! This is my channel about using Microsoft Excel so that you can increase your productivity in whatever business you are in.
If you're interested learning how to take advantage of these programs and gaining confidence, subscribe to my channel.
My channel publishes videos that focus on tutorial type content that connects the programs with real-life examples.
If this sounds like it could be helpful for you, come hang out! Thanks!
If you're interested learning how to take advantage of these programs and gaining confidence, subscribe to my channel.
My channel publishes videos that focus on tutorial type content that connects the programs with real-life examples.
If this sounds like it could be helpful for you, come hang out! Thanks!
NEW Excel Checkboxes: Discover Its Hidden Potential
👇 LET'S CONNECT 👇
linktr.ee/excelupnorth
---------------------
⏰ Timestamps ⏰
00:00 Intro
00:16 The OLD Checkbox
00:28 The NEW Checkbox
02:04 Formatting Checkboxes
04:40 Using Checkboxes In Formulas
07:35 Using Checkboxes To Create Interactive Charts
10:55 Wrap Up
---------------------
🎥 Related Videos 🎥
ruclips.net/video/dMIRmFyydq0/видео.html
ruclips.net/video/zZCgZx8FrGs/видео.html
ruclips.net/video/hbF7j_mQvIM/видео.html
ruclips.net/video/YifzigD-Kc0/видео.html
---------------------
Ever wished you could easily add a #checkbox to your #Excel spreadsheets? Well, now you can! In this tutorial, we'll showcase the new checkboxes feature in Excel, exploring everything from basic usage to advanced techniques...
linktr.ee/excelupnorth
---------------------
⏰ Timestamps ⏰
00:00 Intro
00:16 The OLD Checkbox
00:28 The NEW Checkbox
02:04 Formatting Checkboxes
04:40 Using Checkboxes In Formulas
07:35 Using Checkboxes To Create Interactive Charts
10:55 Wrap Up
---------------------
🎥 Related Videos 🎥
ruclips.net/video/dMIRmFyydq0/видео.html
ruclips.net/video/zZCgZx8FrGs/видео.html
ruclips.net/video/hbF7j_mQvIM/видео.html
ruclips.net/video/YifzigD-Kc0/видео.html
---------------------
Ever wished you could easily add a #checkbox to your #Excel spreadsheets? Well, now you can! In this tutorial, we'll showcase the new checkboxes feature in Excel, exploring everything from basic usage to advanced techniques...
Просмотров: 102
Видео
Remove Duplicates In Excel With Four EASY Methods
Просмотров 4421 день назад
•👇 LET'S CONNECT 👇 linktr.ee/excelupnorth ⏰ Timestamps ⏰ 0:00 Intro 0:23 Remove Duplicates Command 1:18 Advanced Filter 2:11 #UNIQUE Function 3:24 #PowerQuery 5:14 Recap and Outro In this video, we'll explore four ways to remove duplicates in Microsoft #Excel. Whether you're dealing with small or large datasets, knowing how to eliminate duplicates is crucial for accurate data analysis. Plus, I’...
How To Import And Extract Data From A Website To Excel
Просмотров 100Месяц назад
👇 LET'S CONNECT 👇 linktr.ee/excelupnorth ⏰ Timestamps ⏰ 00:00 Intro 00:21 Getting Started Importing From A Website 02:11 Using #PowerQuery To Transform Data 03:11 Importing More Data 04:07 Additional Options For Refreshing Data 04:48 Refreshing To Import New Data In this video, we'll go through importing data from a website into #Excel, creating a dynamic connection that allows the data to auto...
Excel PowerQuery Tutorial: Organizing Business Expenses
Просмотров 309Месяц назад
👇 LET'S CONNECT 👇 linktr.ee/excelupnorth ⏰ Timestamps ⏰ 00:00 Intro 00:16 Storytime 01:10 Import & Transform Data In Power Query 05:48 Adding more data 06:10 Outro I'm excited to share a story about a recent challenge I solved using #Excel and #PowerQuery. A friend reached out with an interesting problem: they had an Excel file with a single column of business expenses. Each cell contained a tr...
Two EASY Ways To Combine Multiple Sheets Into One In Excel | 1000 Sheets
Просмотров 4532 месяца назад
👇 LET'S CONNECT 👇 linktr.ee/excelupnorth ⏰ Timestamps ⏰ 00:00 Intro 00:25 Using #PowerQuery 05:33 Using the VSTACK #ExcelFormula 07:21 Which method is best? 08:24 Wrap-Up In this video, we'll go through how to combine and consolidate multiple #Excel worksheets into one, dealing with not just a few, but up to 1,000 different excel sheets! We'll use two powerful methods to achieve this, depending...
Make Dynamic Dependent Drop Down Lists In Excel | Office 365
Просмотров 3773 месяца назад
👇 LET'S CONNECT 👇 linktr.ee/excelupnorth ⏰ Timestamps ⏰ 00:00 Intro 00:27 Overview Of Data 00:42 How The Dependent #Dropdown Lists Will Work 01:17 Simulating A Dependent Dropdown List 01:50 Creating A Staging Area for Dynamic Dependent Dropdown List Data 02:13 Populating Options For The First Dropdown List 03:09 Populating Options For The Second Dropdown List 04:40 Creating The First Dropdown L...
How To Use The TAKE Function To Extract Rows & Columns In Excel | Office 365
Просмотров 4563 месяца назад
How To Use The TAKE Function To Extract Rows & Columns In Excel | Office 365
How To Use The FILTER Function In Excel | Office 365
Просмотров 2775 месяцев назад
How To Use The FILTER Function In Excel | Office 365
3 AMAZING Ways To Use Conditional Formatting ln Excel | Office 365
Просмотров 3715 месяцев назад
3 AMAZING Ways To Use Conditional Formatting ln Excel | Office 365
10x Your Productivity With These Excel Shortcuts In 2024 (Office 365)
Просмотров 3947 месяцев назад
10x Your Productivity With These Excel Shortcuts In 2024 (Office 365)
TOP 5 Excel Formulas To Use In 2024! (Office 365)
Просмотров 2,2 тыс.8 месяцев назад
TOP 5 Excel Formulas To Use In 2024! (Office 365)
How to Insert Checkboxes THE NEW WAY | Office 365
Просмотров 9 тыс.8 месяцев назад
How to Insert Checkboxes THE NEW WAY | Office 365
Learn How To Use COUNTIFS In Excel | Office 365
Просмотров 2819 месяцев назад
Learn How To Use COUNTIFS In Excel | Office 365
Learn XLOOKUP Like A Pro In Just Minutes! | Office 365 Excel Tutorial
Просмотров 41310 месяцев назад
Learn XLOOKUP Like A Pro In Just Minutes! | Office 365 Excel Tutorial
How To Use Power Query To Turn Columns Into Rows | Unpivot Columns | Office 365
Просмотров 2,6 тыс.10 месяцев назад
How To Use Power Query To Turn Columns Into Rows | Unpivot Columns | Office 365
How To Use Excel's IF & IFS Functions To Make Your Life Easier
Просмотров 1,4 тыс.11 месяцев назад
How To Use Excel's IF & IFS Functions To Make Your Life Easier
A Quick And Easy Guide To Using Python In Excel | Office 365
Просмотров 1,9 тыс.11 месяцев назад
A Quick And Easy Guide To Using Python In Excel | Office 365
How to Convert a PDF to Excel THE RIGHT WAY (Q&A) | Office 365
Просмотров 3,8 тыс.Год назад
How to Convert a PDF to Excel THE RIGHT WAY (Q&A) | Office 365
Sparklines In Excel | Step-By-Step Tutorial | Office 365
Просмотров 3 тыс.Год назад
Sparklines In Excel | Step-By-Step Tutorial | Office 365
How To Make S-Curve Charts In Excel | Project Management | Office 365
Просмотров 19 тыс.Год назад
How To Make S-Curve Charts In Excel | Project Management | Office 365
How To Create Excel Column Charts In Minutes! | Office 365
Просмотров 930Год назад
How To Create Excel Column Charts In Minutes! | Office 365
5 Mistakes You’re Making In Excel (And How To Avoid Them) | Office 365
Просмотров 239Год назад
5 Mistakes You’re Making In Excel (And How To Avoid Them) | Office 365
How ChatGPT works with Excel | Office 365
Просмотров 641Год назад
How ChatGPT works with Excel | Office 365
How to Combine and Merge Multiple Excel Files | Power Query | Office 365
Просмотров 4,2 тыс.Год назад
How to Combine and Merge Multiple Excel Files | Power Query | Office 365
SUPER SIMPLE Dropdown Lists In Excel! (Office 365)
Просмотров 2 тыс.Год назад
SUPER SIMPLE Dropdown Lists In Excel! (Office 365)
How To Create Pivot Tables In Excel | Beginner Tutorial | Office 365
Просмотров 2 тыс.Год назад
How To Create Pivot Tables In Excel | Beginner Tutorial | Office 365
How to use Freeze Panes in Excel | Office 365
Просмотров 1,4 тыс.Год назад
How to use Freeze Panes in Excel | Office 365
Excel For Project Management: 5 Functions You NEED To Know | Office 365
Просмотров 4,7 тыс.2 года назад
Excel For Project Management: 5 Functions You NEED To Know | Office 365
How to Convert a PDF to Excel THE RIGHT WAY (Office 365)
Просмотров 159 тыс.2 года назад
How to Convert a PDF to Excel THE RIGHT WAY (Office 365)
Hi bro how to contact you..i have a pdf file with a lot of data and i want some value from it....Thanks for your help in advance 😊
Hey, thank you for your comment! I actually have a video on how to import a PDF to Excel here: ruclips.net/video/z-z59CvbKCU/видео.html
Interested in learning how to add layers of dependancy. Basically I am interested in making the menu options available in "Job Titles" to be dependent on BOTH the selection in Department AND Roles. Thanks so much, this video was very helpful.
Thanks for stopping by and leaving a comment! I’m glad you found it helpful! 😁 That is a very interesting concept. I’d say it would involve modifying the FILTER function in cell E11 to check against the Department and Role columns, rather than the Role column by itself, leaving everything else the same.
How about more than one check box in a cell? I need two check boxes in one cell and can't figure it out.
Unfortunately not as there’s an underlying TRUE or FALSE value behind each checkbox that occupies the entire cell.
Excellent - just what i needed.
That’s great. Thank you for stopping by!
Thank you for the short and valuable video
You’re welcome! I’m glad that you found it helpful! 😁
What about if the table in the new PDF moved to let say another page? How to update those setting please?
Interesting question! Assuming that the name of the table remains the same then it can exist on any page and this method will work just fine. If the name ends up changing however, then that’s a different story!
Thanks this is exactly what I needed 👍
You’re welcome! Thank you for your comment!
Great video, but you can use the Sum function. Use =SUM((B2:M2)*1). Multiplying the range by 1 turns TRUE and FALSE to 1 and 0.
That’s a very neat solution! Converting it to 1s and 0s then adding them that way!
Thanks for the video, is there a way to format the check box? I don't want the black infill in the box, I'd rather the old version of a clear box and black tick. Thanks
Thanks for stopping by and leaving a comment! Sadly, it doesn’t look like there’s a way to control the fill of the checkbox at the moment. It’s pretty much limited to only changing the color of the checkbox. Maybe they’ll have different types of checkboxes available in the future!
Really useful, thanks for saving me time.
Awesome to hear! You’re welcome!
Hey Everyone! If you want to follow along with the example in this video, here is a link to download the Excel workbook: 1drv.ms/x/s!Aji43nEceyYjhJ41fB_Vz9ywWqAa7g?e=SrAZae
What will happen if there are 2 conditional formatting in a row? like for example, the priority is High but it the status is Completed. Which conditional formatting will it follow?
Great question! Conditional Formatting rules can be applied in a certain order. In this example, the rule that checks for Completed tasks happens first and so it applies the Conditional Formatting first, even though the Priority is High. If we reversed the order of the rules so that the check for High Priority tasks happens first, then the High Priority Completed tasks would have been highlighted yellow with bolded red text.
Thanks a lot😊 clean explanation, Would be nice if theres a raw file to be able to practice with.
Thank you for your kind comment and helpful feedback! I've placed a link to the file in the pinned comment.
I don’t have the checkbox button on my insert ribbon, do you have any solutions?
Hey it should be available to everyone on the Office 365 version. It happened quite recently so it might take time to show up.
T H A N K Y O U !!!!!!!
Thank you for your comment! I’m glad that you found it helpful! 😁
good job
@@wonderlandyen3839 thank you! 🙏
The title of your video says Office 365 which, from my understanding, is the online version. There is not a developer tab in the online version of Excel.
Hey! This is the Office 365 Desktop App, and this is the newest version of the checkbox so that you don’t need to use the one in the developer tab anymore.
You can also try Table2XL, it's faster as you don't have to go through all these steps.
One of the best ans up to the point Videos I hav seen in this topic !...Too Good 👌..Thank u sir 😊
Thank you so much for your kind words! I really appreciate it! 😁
tks so much! you helped me to save a lot of time ;)
Glad I could help! Thank you for your wonderful comment! 😁
Interesting! Will definitely practice & prefer to use this. Thank you!
I’m glad you enjoyed it! 😁
Interesting! Very helpful! Thank you!
This is great! Good to know… Thank you!
This is so helpful to know! Thank you!!
So good to know! Thank you!
Enjoyed! Thanks!
Thank you!
Thank you!!! Very helpful! 😻
It is giving me gibberish text.
It’s possible that the data within the PDF isn’t in the best format. These can be a bit finicky.
Wow thanks for the very clear explanation. I am trying to convert my credit card statement which is password protected into excel using your method but it gives me an error because of the password. Is there anyway I can by pass the password or enter the password?
Thanks for stopping by and leaving a comment! I’m afraid I don’t know of a way to bypass the password to connect to PDF.
The resume master
🙏🙏🙏
Great video! 🎉
I’m glad that you liked it!!!
Nice job
Thanks for your comment!
STRG + G🤨
Love it, let’s gooo 💪
Informative and intuitive video, thanks. If the excel needs data from different excel templates then how does it work?
Appreciate your kind words! 😁 do you mind expanding a little more on your question?
Typical Microsoft, making something easy, really hard. No Developer Tab available, so no Check Box available, something that every spreadsheet going back 20+ years has. Well done Microsoft for continuing to make easy things harder than they need to be.
Big, thank you.
Thanks for leaving a comment! Glad you enjoyed it!
I keep running updates to my 365 subscription, and i am NOT getting t his badly needed checkbox feature. I see I'm not alone.....does it really exist? What do I have to do to get it? I have the latest build, 2405 176... thank you
Currently, this feature is only available for a portion of the Beta channel of Microsoft 365. Hopefully, it will roll out to everyone else soon!
Very useful. Thanks for simple explanation
Thank you for your kind comment! I am glad that you found it useful! 😁
Helpful video! Thank you!!
Thank you for leaving a comment! I’m glad that you found it helpful! 😁
why can't I find the insert checkbox option?
It’s currently available through the Beta Channel as part of the Microsoft 365 Insider program.
AAAAARRRRGGGGHHHH! Not on the iOs version.
Totally agree...but with more GGGGGGGG
It got added to the Mac version back in July!
thanks!! @@ExcelUpNorth
No worries, I’ve been having fun with it so far!
If PDf file created by scan then how we converting ?
It might work if you use the scanned document used an Optical Character Recognition (OCR) scanner. I haven’t tried it though.
What version of Excel are you using because mine doesn't have this option.
Appreciate the comment! This is the Windows Office 365 version of Excel.
your video is as useless as you since u started telling in between, and didn't provide full info at all.
Will this be made available for other versions of MS Office? I have the 2021 version.
It’s currently available to those on the Office 365 Insider Program so I imagine it will be available on Office 365.
Very nice tutorial, could you please tell why need cumulative, what is the purpose to use that?
Thank you for your kind comment! The cumulative calculation is useful as that’s what allows us to create the S-Curve. S-Curves are useful in industries like Project Management where it’s important to see how work is scheduled to be performed over a Project’s lifecycle.
@@ExcelUpNorth ITS POSSIBLE TO MAKE S-CURVE WITHOUT CUMULATIVE ?
Hey thanks man, saved me a lot of time. Could you pls let me know if there is a way to combine all the tables together. during the load it split them into separate tabs:/
There’s a way to combine the tables by using the ‘Append’ command in PowerQuery. It can be tricky as you’ll need to have the same column headers in each of the tables for it to work properly.
This is a "work smarter, not harder" solution. Thank you.
Thank you for your kind comment! Cheers!
How did you arrive to the budget figures?
Hey! Thank you for your question. The numbers in this video, including the budget, are fictitious and are meant to illustrate what a project's lifecycle costs would typically look like.
KING!!! saving my fuckin life rn bro
That is amazing to hear! Cheers! 😀