[FREE EXCEL COURSE] Lesson 7 - Auto-fill, Custom Lists, and Flash Fill

Рет қаралды 139,401

Күн бұрын

In this video of this free Excel course, you will learn about tools that can help you when working with data in Excel.
In this lesson, I cover the following topics:
-- AUTOFILL: This allows you to quickly fill data in contiguous cells. For example, you can have 'Jan' and 'Feb' in two adjacent cells and then you can use Autofill to get the other month names
-- CUSTOM LISTS: Custom lists allows you to create your own lists that you can use in Autofill. For example, if you have 20 names, you can create a custom list and then use Autofill to get all the names by just dragging the mouse
-- FLASH FILL: Flash fill is a new feature in Excel 2013 and allows you to identify a pattern in data and perform data slice and dice based on the pattern.
☕ If you're the videos useful and would like to support me, you can buy me a coffee - www.buymeacoffee.com/SumitB
This video is a part of my Free Online Excel Training where I show you how to use Excel from the basics and also cover a lot of advanced topics.
You can find more details about this Free Excel Training + the download files here: trumpexcel.com/learn-excel/
You can also access the Full Excel Training on KZfaq here: • Getting Started with E...
Free Excel Course - trumpexcel.com/learn-excel/
Paid Online Training - trumpexcel.com/excel-training/
Best Excel Books: trumpexcel.com/best-excel-books/
⚙️ Gear I Recommend:
Camera - amzn.to/3bmHko7
Screen Recorder - techsmith.z6rjha.net/26D9Q
USB Mic - amzn.to/2uzhVHd
Wireless Mic: amzn.to/3blQ8uk
Lighting - amzn.to/2uxOxRv
Subscribe to get awesome Excel Tips every week: kzfaq.info...
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial

Пікірлер: 50

@surendrabelavadi 4 жыл бұрын

Sumit you are the best. I have never come across any Excel tution as good as as you. You have explained in detail every steo. Thank you very much keep it up.

@supriyachinnam7338 4 жыл бұрын

This is very informative and you are crisp and clear. Best tuitor.

@lky0929 Жыл бұрын

You are teaching so well and really learnt alot from the videos. Having been using Excel for many years but just got to know it MORE now. Thanks Sumit!

@architgoswami7037 3 жыл бұрын

You are really a super fast talker:D.

@MusaAbuSbeih 3 жыл бұрын

Clear, simple, and direct to the point. Thanks

@Ben-Jamming 5 жыл бұрын

Very well explained. Concise and informative. Thank you.

@rachaelhutton637 4 жыл бұрын

Amazing Course, very impressive. Thank you 👍🏼

@varunakarniya Жыл бұрын

Thank you very much. I was searching for custom lists for a while. It helped a lot. Actually i am working with large number of teammates and don't wanna copy paste their name always, so used this and made a custom list of their names. Thank you again. It saved a lot of time.

@redhaal-obaidy2217 2 жыл бұрын

Actually I was amazed on the details regarding the Edit custom lists, it helped me in adding a list of the days in Arabic, so thank you a lot! keep up the good work!

@vusaleyusifova536 2 жыл бұрын

thank you so much! you explain everything so clearly and neatly! advised your course to my friend as well

@SrajanMor 5 жыл бұрын

Very detailed and nice explanation. Keep up the good work.

@MOHAMMADASEFHOSSAINIMSC 3 жыл бұрын

Awesome, thank you so much for your useful and free videos.

@mohanvaze1 3 жыл бұрын

Excellent narration and easy to follow. Thank you :)

@jitendratiwari6301 Ай бұрын

Watching this video in 2024, this playlist is still so relevant.

@wayneedmondson1065 5 жыл бұрын

Hi Sumit.. thanks for this video on Auto-Fill, Custom Lists and Flash Fill. I'm learning many things I missed along the way when teaching myself EXCEL by trial and error. Thanks for sharing this video series for free. Thumbs up!

@Kartikeycool 11 ай бұрын

Your welcome

@margad-erdeneboldbaatar4704 2 жыл бұрын

Thanks for the this course.

@user-rv5vy4vj4d Жыл бұрын

Hej, I have a question related auto fill. When I tried to drag pattern excel didn't identify. Can you tell me how can I fix?

@riddhibajadeja8395 3 жыл бұрын

It is really helpful sir... Thank you

@mahmoodulhasan850 4 ай бұрын

very well explained.best teacher

@krishna_bakth1420 3 жыл бұрын

Good very Good Job .I have learned alot from these vedio .

@himi1509 2 жыл бұрын

Thanks Sir

@AS-uz2gf 4 жыл бұрын

Hi sumit. Excellent video. No words to describe for your yeoman service to office-goers/community / novice learners. I had a doubt in customs List. the List you have created will only be available (high, Medium, Low - for eg) for that particular workbook or that it will be available whenever I create new one. My version is Office 2010.

@marcello2051 4 жыл бұрын

obg sr indiano

@mohammadirkanansari671 2 жыл бұрын

SIR THIS VERY HELPFUL TO ME BECOUASE I AM NOT KNOW FEATURE OF CUSTOM LIST

@loribechdel4033 2 жыл бұрын

Can you please tell me the best way to use the average formula when there is data on 2 different sheets? I have 4 values on sheet 1 and 4 values on sheet 2 that I need to average.

@eliasgivans7973 10 ай бұрын

Thanks

@Adi-jk2ef 3 жыл бұрын

Hi Sumit ! Is there any option to add a customised list in all systems across an org ?

@mdsaifsakhawate3924 5 ай бұрын

Best❤

@johnhall8298 3 жыл бұрын

How would I generate a date that incraments after every 20 cells?

@hansikasachdeva4719 9 ай бұрын

Sir, how can i select the flash fill option, under which option it'll display?

@HARSHGUPTA-lj5bi Жыл бұрын

I think on 13:12 you should write obama II then may it take last words???

@zeyadahmed8117 10 ай бұрын

how to activate growth trend and linear trend? icant use them'

@preetichauhan3526 Жыл бұрын

Instead of custome fill , we could sinply do copy and paste what is the relevance of custom fill

@pruthakswain8813 5 ай бұрын

How to select multiple options in slicers?

@poornimas122 4 жыл бұрын

Hi sir, Where we get file options in 2007 version and also how to add Ribbons in 2007.I want to add Developer,Tool options.

@snehak2406 4 жыл бұрын

in 2007 click on office button then click on excel option -> Popular -> under tab option working with excel, click show developer tab in the ribbon -> Ok. hope it helps..