- 218
- 46 226
Excel and Adam
United States
Приєднався 27 лип 2022
Hello, this is an Excel lover and Microsoft Most Valuable Professional - Adam Kopeć.
This channel will help you learn about Excel and its related programs:
Power Query
VBA
Power BI
Power Pivot
If you have a question, ask them under the video or write to adam (at) ExcelAndAdam.com
This channel will help you learn about Excel and its related programs:
Power Query
VBA
Power BI
Power Pivot
If you have a question, ask them under the video or write to adam (at) ExcelAndAdam.com
Excel - How to Group Dates in Pivot Table | Excel Tips 121
In this Excel tutorial, you will learn how to Group Dates in Pivot Table | Excel Tips 121
Want to get 3 chapters of the Excel SuperHero book? Sing up: ExcelAndAdam.com/book
Used formula:
none
---⏱️Timestamps⏱️---
00:00 | Grouping Dates in Pivot Table
01:48 | Changing Pivot Table raport layout and headers
02:52 | Grouping Pivot Tables options in Excel
03:32 | Remember about years when grouping dates in Pivot Tables
04:11 | The End
================
Files to download in the Eng folder on the website:
exceliadam.pl/youtube
You can also find me on:
📚Blog - excelandadam.com/
🍀Instagram - excelandadam
🌟Tik Tok - www.tiktok.com/@excelandadam
✨Facebook - ExcelAndAdam
🕊Twitter - ExcelandAdam
#ExcelAndAdam #ExcelTips #excel
Want to get 3 chapters of the Excel SuperHero book? Sing up: ExcelAndAdam.com/book
Used formula:
none
---⏱️Timestamps⏱️---
00:00 | Grouping Dates in Pivot Table
01:48 | Changing Pivot Table raport layout and headers
02:52 | Grouping Pivot Tables options in Excel
03:32 | Remember about years when grouping dates in Pivot Tables
04:11 | The End
================
Files to download in the Eng folder on the website:
exceliadam.pl/youtube
You can also find me on:
📚Blog - excelandadam.com/
🍀Instagram - excelandadam
🌟Tik Tok - www.tiktok.com/@excelandadam
✨Facebook - ExcelAndAdam
🕊Twitter - ExcelandAdam
#ExcelAndAdam #ExcelTips #excel
Переглядів: 89
Відео
Excel - How to add Total Row to tables at the bottom and on the top of data | Excel Tips 120
Переглядів 10314 днів тому
In this Excel tutorial, you will learn how to add Total Row to tables at the bottom and on the top of data | Excel Tips 120 Want to get 3 chapters of the Excel SuperHero book? Sing up: ExcelAndAdam.com/book Used formula: =SUBTOTAL(109,[Sales]) =SUBTOTAL(103,tSum_k[Salesman]) ⏱️Timestamps⏱️ 00:00 | Adding Total Row to a table at the bottom 01:02 | Changing funtions in Total Row 02:02 | Adding To...
Excel - How to Sort data based on values from drop down list and checkboxes | Excel Tips 119
Переглядів 27521 день тому
In this Excel tutorial, you will learn how to sort data based on values from drop down list and checkboxes | Excel Tips 119 Want to get 3 chapters of the Excel SuperHero book? Sing up: ExcelAndAdam.com/book Used formula: =SORT(A6:D173,IFERROR(MATCH(G2:I2,A5:D5,0),4),IF(G3:I3,-1,1)) ⏱️Timestamps⏱️ 00:00 | Task description 01:45 | Inserting checkboxes 03:32 | Basics of the SORT function 05:01 | S...
Excel - How to add colors and shapes to number formatting | Excel Tips 118
Переглядів 5428 днів тому
In this Excel tutorial, you will learn how to add colors and shapes to number formatting | Excel Tips 118 Want to get 3 chapters of the Excel SuperHero book? Sing up: ExcelAndAdam.com/book Used formula.number format: [Green]0,00\ ▲;[Red]0,00\ ▼;[Blue] ◄☆▶;[Magenta] @ ⏱️Timestamps⏱️ 00:00 | 4 sections of custom number format 00:38 | Colors in custom number format 01:00 | Special signs in custom ...
Excel - How to show nanometers and other small and large units of measurements | Excel Tips 117
Переглядів 57Місяць тому
In this Excel tutorial, you will learn how to show nanometers and other small and large units of measurements | Excel Tips 117 Want to get 3 chapters of the Excel SuperHero book? Sing up: ExcelAndAdam.com/book Used formula.number format: 0" nm" 0.00" Gm" ⏱️Timestamps⏱️ 00:00 | Scientific number format 00:32 | Custom number format - adding text to numbers 02:08 | The End Files to download in the...
Excel - How to get partial match with FILTER function | Excel Tips 116
Переглядів 35Місяць тому
In this Excel tutorial, you will learn how to get partial match with FILTER function | Excel Tips 116 Want to get 3 chapters of the Excel SuperHero book? Sing up: ExcelAndAdam.com/book Used formula: =FILTER(A5:D172,ISNUMBER(SEARCH(H2,C5:C172))*(B5:B172=G2)) ⏱️Timestamps⏱️ 00:00 | Explanation of the problem and SEARCH function 01:57 | FILTER function with partial match 03:48 | The End Files to d...
Excel - How to Choose function/summary based on value on a drop down list | Excel Tips 115
Переглядів 25Місяць тому
In this Excel tutorial, you will learn how to Choose function/summary based on value on a drop down list | Excel Tips 115 Want to get 3 chapters of the Excel SuperHero book? Sing up: ExcelAndAdam.com/book Used formula: =CHOOSE(3,A2,A3,A4) =CHOOSE(MATCH(E2,G2:G5,0),SUM(C8:C18),AVERAGE(C8:C18),MAX(C8:C18),MIN(C8:C18)) ⏱️Timestamps⏱️ 00:00 | Explanation of the CHOOSE function 01:1 | Choose functio...
Excel - How to Nested IF | Excel Tips 114
Переглядів 522 місяці тому
In this Excel tutorial, you will learn how to nest IF functions to choose from more than 2 values | Excel Tips 114 Want to get 3 chapters of the Excel SuperHero book? Sing up: ExcelAndAdam.com/book Used formula: =IF(B2 greater than or equal $F$4;$G$4;IF(B2 greater than or equal $F$3;$G$3;$G$2)) ⏱️Timestamps⏱️ 00:00 | Explanation of the example 00:54 | Logic behind nested IF functions 02:58 | Ne...
Excel - How to Split text based on its length | Excel Tips 113
Переглядів 3102 місяці тому
In this Excel tutorial, you will learn how to Split text based on its length with text to columns command | Excel Tips 113 Want to get 3 chapters of the Excel SuperHero book? Sing up: ExcelAndAdam.com/book Used formula: none ⏱️Timestamps⏱️ 00:00 | Explanation of the example 00:42 | Text to columns command based on length 01:40 | Columns data format 04:29 | The End Files to download in the Eng f...
Excel - How to use text to columns command | Excel Tips 112
Переглядів 442 місяці тому
In this Excel tutorial, you will learn how to use text to columns command | Excel Tips 112 Want to get 3 chapters of the Excel SuperHero book? Sing up: ExcelAndAdam.com/book Used formula: none ⏱️Timestamps⏱️ 00:00 | Explanation of the example 01:12 | Text to columns command 03:26 | The End Files to download in the Eng folder on the website: exceliadam.pl/youtube You can also find me on: 📚Blog -...
Excel - How to format number as thousands or millions | Excel Tips 111
Переглядів 883 місяці тому
In this Excel tutorial, you will learn how to format number as thousands or millions | Excel Tips 111 Want to get 3 chapters of the Excel SuperHero book? Sing up: ExcelAndAdam.com/book Used formula: none ⏱️Timestamps⏱️ 00:00 | Formatting numbers/currency as thousands 01:52 | Adding more spaces before the number 02:42 | Formatting numbers/currency as millions 03:45 | The End Files to download in...
Excel - How to create a chart based on drop down list | Excel Tips 110
Переглядів 793 місяці тому
In this Excel tutorial, you will learn How to create a chart that will be changed based on the value choosen from a drop down list | Excel Tips 110 Want to get 3 chapters of the Excel SuperHero book? Sing up: ExcelAndAdam.com/book Used formula: =CHOOSE(MATCH($F$1,$E$1:$E$3,0),Chart1,Chart2,Chart3) ⏱️Timestamps⏱️ 00:00 | Creating shape connected to cells 01:49 | Creating formula to choose proper...
Excel - How to Connect shape with value from a cell | Excel Tips 109
Переглядів 343 місяці тому
In this Excel tutorial, you will learn How to Connect shape with value from a cell | Excel Tips 109 Want to get 3 chapters of the Excel SuperHero book? Sing up: ExcelAndAdam.com/book Used formula: none ⏱️Timestamps⏱️ 00:00 | Inserting shape 00:40 | Connecting shape with value from a cell 02:38 | The End Files to download in the Eng folder on the website: exceliadam.pl/youtube You can also find ...
Excel - How to Count Unique Values with condition | Excel Tips 108
Переглядів 2654 місяці тому
In this Excel tutorial, you will learn How to Count Unique Values with condition | Excel Tips 108 Want to get 3 chapters of the Excel SuperHero book? Sing up: ExcelAndAdam.com/book Used formula: =SUMPRODUCT( ($B$2:$B$12=F1)/COUNTIF($C$2:$C$12,$C$2:$C$12)) =ROWS(UNIQUE(FILTER($C$2:$C$12,$B$2:$B$12=F1))) ⏱️Timestamps⏱️ 00:00 | Count Unique Values with condtion in Legacy Excel 04:36 | Count Unique...
Excel - How to Count Unique Values | Excel Tips 107
Переглядів 234 місяці тому
In this Excel tutorial, you will learn How to Count Unique Values | Excel Tips 107 Want to get 3 chapters of the Excel SuperHero book? Sing up: ExcelAndAdam.com/book Used formulas: =SUMPRODUCT(1/COUNTIF(B2:B12;B2:B12)) =ROWS(UNIQUE(B2:B12)) ⏱️Timestamps⏱️ 00:00 | Count Unique Values in Legacy Excel 01:5 | Count Unique Values in Dynamic Array Excel 02:26 | The End Files to download in the Eng fo...
Excel - Last number or text | Excel Tips 106
Переглядів 414 місяці тому
Excel - Last number or text | Excel Tips 106
Excel - Conditional Formatting - Color scales | Excel Tips 105
Переглядів 314 місяці тому
Excel - Conditional Formatting - Color scales | Excel Tips 105
Excel - Conditional Formatting - Data bars | Excel Tips 104
Переглядів 255 місяців тому
Excel - Conditional Formatting - Data bars | Excel Tips 104
Excel - How to Sort by and add custom list | Excel Tips 103
Переглядів 465 місяців тому
Excel - How to Sort by and add custom list | Excel Tips 103
Excel - Box and whisker chart | Excel Tips 102
Переглядів 755 місяців тому
Excel - Box and whisker chart | Excel Tips 102
Excel - The most frequent text - MODE.MULT function | Excel Tips 101
Переглядів 526 місяців тому
Excel - The most frequent text - MODE.MULT function | Excel Tips 101
Excel - The most frequent number - MODE function | Excel Tips 100
Переглядів 456 місяців тому
Excel - The most frequent number - MODE function | Excel Tips 100
Excel - lower, UPPER and Proper letters in words | Excel Tips 99
Переглядів 316 місяців тому
Excel - lower, UPPER and Proper letters in words | Excel Tips 99
Excel - How to insert todays date and time - TODAY and NOW functions and shortcuts | Excel Tips 98
Переглядів 346 місяців тому
Excel - How to insert todays date and time - TODAY and NOW functions and shortcuts | Excel Tips 98
Excel - How to create DATE from Year, Month and Day | Excel Tips 97
Переглядів 576 місяців тому
Excel - How to create DATE from Year, Month and Day | Excel Tips 97
Excel - How to Wrap rows and columns with a function | Excel Tips 96
Переглядів 507 місяців тому
Excel - How to Wrap rows and columns with a function | Excel Tips 96
Excel - How to create links in Excel | Excel Tips 95
Переглядів 457 місяців тому
Excel - How to create links in Excel | Excel Tips 95
Excel - How to Remove duplicates | Excel Tips 94
Переглядів 307 місяців тому
Excel - How to Remove duplicates | Excel Tips 94
Excel - How to remove empty rows | Excel Tips 93
Переглядів 967 місяців тому
Excel - How to remove empty rows | Excel Tips 93
Excel - How to extract Quarter, Year, Month and Day from the date | Excel Tips 92
Переглядів 658 місяців тому
Excel - How to extract Quarter, Year, Month and Day from the date | Excel Tips 92
Thank you for the great filter video. I love that you have example files, and lots of tips to share. Just suscribed to your channel.
Awesome, thank you! 😁
Thanks
No problem
Can you do the otherway around?
The otherway around should work with VBA text box (ActiveX) and proper change event for insert box.
@@ExcelAndAdamDo you ahve any tutorial?
@@MonAlde For now just YT, and blog: excelandadam.com/blog/
So how do you extract the 43 hours from the cell?
Okay I found the solution, for your case you would have to use the following formula: =HOUR(B16)+INT(B16)*24
I would use: =FORMAT(B16,"[h]")+0 +0 to change text to number
@@ExcelAndAdam Okay cool, I changed the formatting in the settings to instruct excel to understand that the amount of hours in hh:mm:ss are allowed to be more that 24 hours in this case. Thank you for responding.
You are great
Thanks 😀
very good
Thank you! Cheers!
Bro Can you make a tutorial for this Like how did you select Date
I just find dates for zodiac and put them into Excel, and a way to format dates is in the video.
Great tutorial!
Glad you think so!
🔥🔥🔥
You have the power
That was useful, thank you!
Glad it was helpful!
👍🔥
You, have the power!
Thank you!
You're welcome!
🔥🔥🔥
👍👍👍
I like your advice the most because you talk about Excel briefly and clearly 👍
Glad it was helpful!
I finally understood it:)
Great!
You are the best 🔥🔥🔥
Thanks 😀
It must have taken you a lot of time to master Excel, thank you for sharing your knowledge with us!
My pleasure!
EXCELLENT VIDEO. CLEARLY UNDERSTAND. THANK YOU.
Great to hear! 👍
Thanks! 👍
Welcome!
Your channel is very helpful 🙂 Keep it going!
Thanks, will do!
Your channel is very helpful, I will show it to my friends! :)
Awesome, thank you!
I admire your mastery of Excel and the fact that you share your knowledge with us:)
Glad to hear that!
very useful trick 👍
Glad you think so!
I can see that you put a lot of work into this channel. Thanks for this 🔥
I appreciate that!
👍👍👍
Thanks
Yay, another great video! Thank you!
You are so welcome!
I’ve looked at a number of flash full videos and you are the first I’ve seen that has shown the trick with having flash full substitute a character for inconsistent records. That is way, way cool, and solved a problem I was having of extracting middle initials from a list where the resent always a middle initial. I did find that the first record needs to have a middle initial or it doesn’t seem to work, but when working with large data sets, I could easily add a fake MI in the first record to invoke FF, then remove it. Thanks for this video!
Glad you like it 😀
🔥🔥🔥
👍👍👍
Great advice!
Glad you think so!
I finally understood how it works 😍
I'm glad to hear that.
Perfect, please share complete dynamic array functions tutorial
Will try
Your videos are fantastic 🙂
Glad you think so!
Perfect, just what I needed, thank you
Glad you think so! 😀
Perfect 🔥
Thanks!
I'm glad I found your channel 🙂
Welcome!
Another one of your good tips!
Glad you think so!
🔥🔥🔥
Glad you like it 😀
Perfect👍
It wasn't perfect, but thanks 😁
😊@@ExcelAndAdam
Good that you are making a video! Excel is easier with you 🙂
Glad you think so!
Another good video on your channel 😀
Thanks for the visit
Done with your help 👍
Glad I could help!
Recently I was wondering how to make a Pareto Chart because I couldn't figure it out and then I decided to check out your channel. And here it is! 😀 The tip I needed 😀
Hope you enjoy!
Thanks for that😉
No problem 😊
Well explained 🙂
Glad you liked it
I hope you don't stop recording such tips 😀
Glad I could help!
🔥🔥🔥
👍👍👍
Clearly explained! Thanks!
You're welcome!
Thank you for your commitment!
My pleasure!
I like your Excel tricks :D
Glad you like them!
I like learning Excel with you 🔥
Happy to hear that!