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

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 KZbin 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: kzbin.info...
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial

[@surendrabelavadi]

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]

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]

You are really a super fast talker:D.

[@MusaAbuSbeih]

Clear, simple, and direct to the point. Thanks

[@Ben-Jamming]

Very well explained. Concise and informative. 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.

[@rachaelhutton637]

Amazing Course, very impressive. Thank you 👍🏼

[@vusaleyusifova536]

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

[@eliasgivans7973]

Thanks

[@redhaal-obaidy2217]

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!

[@mahmoodulhasan850]

very well explained.best teacher

[@SrajanMor]

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

[@MOHAMMADASEFHOSSAINIMSC]

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

[@mohanvaze1]

Excellent narration and easy to follow. Thank you :)

[@wayneedmondson1065]

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]

Your welcome

[@mdsaifsakhawate3924]

Best❤

[@mohammadirkanansari671]

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

[@margad-erdeneboldbaatar4704]

Thanks for the this course.

[@riddhibajadeja8395]

It is really helpful sir... Thank you

[@himi1509]

Thanks Sir

[@krishna_bakth1420]

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

[@marcello2051]

obg sr indiano

[@AS-uz2gf]

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.

[@Adi-jk2ef]

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

[@loribechdel4033]

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.

[@supriyachinnam7338]

Good video.. growth trend is not working in excel 2010

[@pruthakswain8813]

How to select multiple options in slicers?

[@hansikasachdeva4719]

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

[@johnhall8298]

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

[@HARSHGUPTA-lj5bi]

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

[@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?

[@zeyadahmed8117]

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

[@poornimas122]

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]

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..

[@WalrusesAreTheOne]

What about if I want to create a list of values that I want Excel to recognize when I begin typing one of those values and autocomplete it for me?

[@anupamsharma8250]

Using proofing in file and then options.

[@preetichauhan3526]

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

[@gamernoob3223]

Hey.. Is custom lists option not available in MS Excel 2007?

[@HealthApkeSaath]

Yes right in 2007 it is not available..

[@gamernoob3223]

Thanks

[@anusatish5837]

I am not having an edit custom list option in general or anywhere else.

[@harishnemade2001]

Go to File --> Options --> Advanced --> Scroll at the bottom and find Edit Custom List.

[@redhaakhund1271]

⭐️⭐️⭐️⭐️⭐️

[@Amankumar-xz2ri]

😂

[@trimurtijambagi8889]

Sir ye excel course ka videos kyu bana ye ho aapka videos ke chakkar me mera payment cut huva he

[@jimbim1623]

kya matlab

[@swapniltiwari8921]

Why are you display text in English Don't do that