- 185
- 296 963
Dave Sylvester
United Kingdom
Приєднався 24 сер 2022
Welcome to my channel!
I produce content to help those wanting to learn how to increase their knowledge and productivity with Excel.
My background is in business finance as a CIMA qualified accountant, where I have been enjoying learning and developing my systems skills on:
•\tExcel
•\tPower BI
•\tPower Query
•\tPower Point
I hope you’ll find this useful and subscribe to start your journey to learning new skills.
I produce content to help those wanting to learn how to increase their knowledge and productivity with Excel.
My background is in business finance as a CIMA qualified accountant, where I have been enjoying learning and developing my systems skills on:
•\tExcel
•\tPower BI
•\tPower Query
•\tPower Point
I hope you’ll find this useful and subscribe to start your journey to learning new skills.
Properly Combine Multiple Excel Files
Combine multiple Excel files automatically using Power Query.
One key skill any data analyst needs is being able to combine data from multiple sources, and in this video I'll show you how to do this properly from a folder containing multiple excel files. Using this process makes it dynamic, so as more files get added, your data expands.
I'll show you two methods. The second is really powerful as it enables you to combine tables where the names of the tables are not consistent.
Connect with me on my socials:
📷 Instagram: / how.2.excel
🤳 TikTok: www.tiktok.com/@how_2_excel?i..
One key skill any data analyst needs is being able to combine data from multiple sources, and in this video I'll show you how to do this properly from a folder containing multiple excel files. Using this process makes it dynamic, so as more files get added, your data expands.
I'll show you two methods. The second is really powerful as it enables you to combine tables where the names of the tables are not consistent.
Connect with me on my socials:
📷 Instagram: / how.2.excel
🤳 TikTok: www.tiktok.com/@how_2_excel?i..
Переглядів: 37
Відео
Create Powerful Lookups From Web Data
Переглядів 1072 місяці тому
Create Powerful Lookups From Web Data
Automate Importing CSVs in Excel With Power Query
Переглядів 5074 місяці тому
Automate Importing CSVs in Excel With Power Query
Will You Make the SWITCH to This Excel Function?
Переглядів 1005 місяців тому
Will You Make the SWITCH to This Excel Function?
Will This Brand New Function Replace Your Pivot Tables?
Переглядів 1145 місяців тому
Will This Brand New Function Replace Your Pivot Tables?
5 Excel Functions For Finance Professionals
Переглядів 4406 місяців тому
5 Excel Functions For Finance Professionals
LEARN Pivot Tables in Less Than 10 Minutes!
Переглядів 1577 місяців тому
LEARN Pivot Tables in Less Than 10 Minutes!
Excel's NEW Checkboxes! So Much Better Than Before
Переглядів 1,9 тис.7 місяців тому
Excel's NEW Checkboxes! So Much Better Than Before
Transform Your LOOKUPs in Excel with Power Query
Переглядів 4278 місяців тому
Transform Your LOOKUPs in Excel with Power Query
How to Get Excel's Newest Features & Functions
Переглядів 4758 місяців тому
How to Get Excel's Newest Features & Functions
Is this Brand NEW Function Better than Pivot Tables?
Переглядів 36 тис.8 місяців тому
Is this Brand NEW Function Better than Pivot Tables?
PDF to Excel Converter - Free Microsoft Hack
Переглядів 462Рік тому
PDF to Excel Converter - Free Microsoft Hack
How To Use XLOOKUP With Multiple Criteria
Переглядів 6 тис.Рік тому
How To Use XLOOKUP With Multiple Criteria
How To Get Data From The Web Into Excel In Just A Few Clicks!
Переглядів 4,8 тис.Рік тому
How To Get Data From The Web Into Excel In Just A Few Clicks!
Power Query in Excel - 6 Minute Introduction
Переглядів 395Рік тому
Power Query in Excel - 6 Minute Introduction
How to Get Microsoft Excel Completely Free!!!!
Переглядів 164Рік тому
How to Get Microsoft Excel Completely Free!!!!
Excel Formula - 5 Amazing Tips and Tricks!
Переглядів 159Рік тому
Excel Formula - 5 Amazing Tips and Tricks!
Images in Excel Pivot Tables - New Pivot Table Features
Переглядів 636Рік тому
Images in Excel Pivot Tables - New Pivot Table Features
How to Use Excel Advanced Filter For Next Level Data Filtering
Переглядів 374Рік тому
How to Use Excel Advanced Filter For Next Level Data Filtering
Link Excel to PowerPoint - Full Tutorial.
Переглядів 440Рік тому
Link Excel to PowerPoint - Full Tutorial.
Master the Power of VLOOKUP in Google Sheets: A Step-by-Step Guide
Переглядів 150Рік тому
Master the Power of VLOOKUP in Google Sheets: A Step-by-Step Guide
Get ChatGPT to Write Formula in Google Sheets
Переглядів 1,3 тис.Рік тому
Get ChatGPT to Write Formula in Google Sheets
How to Clean Data Using Power Query In Excel - Excel Turotial
Переглядів 415Рік тому
How to Clean Data Using Power Query In Excel - Excel Turotial
How to Create Pivot Tables Using Power Pivot & Power Query
Переглядів 6 тис.Рік тому
How to Create Pivot Tables Using Power Pivot & Power Query
Sum Values Between Dates and for the Whole Year
Переглядів 1092 роки тому
Sum Values Between Dates and for the Whole Year
Excel Image Function: Microsoft's NEW Function to Insert Images Directly into Excel
Переглядів 3432 роки тому
Excel Image Function: Microsoft's NEW Function to Insert Images Directly into Excel
Lovely!!
Glad you like it
Unsubscribing because I had shorts :-(
You dont even need xlookup. Multiply the the value column with true test column.
Lots of various ways to do the same thing 👍🏼
pensight.com/x/how_2_excel
Have you tried this before? Link to my FREE files below
Did you know about this one?
Sir, For separation like month wise any formula is there ..please let me know
Hi, sorry, what do you mean exactly please?
@How_2_Excel how to do the separate sheet wise year calander like Jan -sheet 1 ...Feb sheet 2 ...like this sir
@How_2_Excel and I want to write the formula on first sheet only to entire 12 months calender
🙌🏼🙌🏼🙌🏼
☺️
Awesome
Thank you
Love this!
Thanks ☺️
"Alt+" is really helpfull with routines in general. Using ALT+A, E, R myself for instant pdf creation
👍
Thanks
great boss, so helpful
Awesome, glad to hear it, thank you ☺️
Thank you!
You're welcome! ☺️
👍👍
Thanks ☺️
hello. thanks for the lovely tutorial but you have forgotten to upload the file. Please upload? or send a link to where I can download that? thanks
Hi, thanks for the comment. I’ll pop it in the next comment ☺️
emea01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fpensight.com%2Fx%2Fhow_2_excel%2Fdigital-item-6f0a75c8-c74a-4531-906f-068799abe11c&data=05%7C02%7C%7C8ac1e0dd008b4de8964f08dce7cf377a%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C638640124385585695%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=rlanuv9wEguPixpZQ13%2FGxF9dZ0FOowiIxgSAEFR9PE%3D&reserved=0
i really loved this one
Thank you, appreciate that
Did you know this one?
Hi How are you Sir
I’m very well thank you. Hope you are too
@@How_2_Excel Thank you for the reply.. why don't you come online and give some live classes or you can share your email id I will connect with you to learn Excel from you
Thanks, I’d love to do that. Just trying to find the time at the moment with just doing this on the side of a full time job. Are there any videos you’d specifically like me to do for you on here?
@@How_2_Excel Yes, I would like to learn VBA and macro in excel.. please make it
Brilliant video. Thanks Dave!
You’re welcome, glad you liked it. ☺️
If you think it’s okay to use AI voice, you must also think it’s okay to upload low effort content that is not worth watching
I create very detailed, my own voice videos too which you may not appreciate either. But thank you for the comment
@@How_2_Excel expect to get less watch time when using an Ai voice. People think the video is bad and skip if they hear Ai voice.
@@carlsonbench1827 that’s fair, and would have been a nicer way to have put it to begin with.
@@How_2_Excel you are getting my overflow hatred of Ai voices that are spamming UA-cam
Thank you it also works in word
Awesome, glad to hear it 😀
Nice!
Thank you
I always forget about this tip, so a nice reminder for me too
Well, will you be using this instead of IF?
When I close them and re-open them the links aren't connected anymore
Very clean, but I detest 365, so I just stay with pivot tables.
Thanks. Oh really, what’s the reason for that?
This was so helpful
Great, glad to hear it ☺️
@@How_2_Excel 😆😆
Excellent !
Glad you like it!
Filter Function 🙌🏼🙌🏼
Very useful! I must rewatch and try 👏🏼👏🏼👏🏼👏🏼👏🏼☺️
Thank you, glad you found it helpful. There is a free download I’ve put on my stan store which goes with this video if you want to follow along with that ☺️
I really need this kind of videos
Thanks for the comment!!! I’ll keep making them if people like them ☺️
I knew the button but not the keyboard shortcut that was super helpful!
Ah cool. You’re welcome, thanks for the comment ☺️
But why?
Someone might be doing something in Excel on the Olympics and a visual of the country just makes it more interesting 🤔
Love this
Thank you ☺️
Wow😮😮
Thanks. Glad you like it 😉
My dad was a excell hero... Wish he was still there
🥹
Have you used this?
Does it only work in Excel 2016?
Yes, from 2016
@@How_2_Excel Good to know 👍
@@TheAcmeGuy you’re welcome
Subtotal
This can be used in this instance. AGGREGATE does offer more flexibility on what to ignore if you needed it 😀
Sure, but how do I automate it so that any name in the first column automatically splits?
For any automation I’d now use Power Query. If you had a list of names even in a different file you could automate this process
Which button should i press on my tablet?
Hmm 🤔 I don’t have a tablet to try it on. Had a Quick Look and it seems there are limited keyboard shortcuts on tablets. You may need to use the flash fill button on the data tab
BROOOOOO FORMER SIMPSON GOT ME ROLLIN🤣
Hahaha, best use of ChatGPT I’ve found so far 😉
Lifesaver! I'll be using these tricks
Awesome, you’re welcome! Thanks for commenting ☺️
Amazing excel teacher!! I’m following for my new job lol
Awesome, very kind thank you!! Hopefully you’ll enjoy my channel ☺️
Flash Fill 🥰
You could convert into a table and respective SUM fn would change ya?
If in a table the SUM function would not update when data is filtered. You could add a total row to the table itself but this will always be at the bottom.
@@How_2_Excel oh 🆗
Are you serious
Always
Are you guilty of this?