Stay ahead with our Weekly Newsletter. Get the latest insights and updates straight to your inbox 👉 link.xelplus.com/yt-c-newsletter
@nanookdan
4 жыл бұрын
Not kidding, I got a promotion after spending all summer developing my excel skills with videos from Leila. If you work with data, watch her videos.
@malithfernando7091
4 жыл бұрын
Indeed ..
@usamabashir3862
2 жыл бұрын
I need help related to Excel please 🥺
@nanookdan
2 жыл бұрын
@@usamabashir3862 This is the place, what are you working on?
@usamabashir3862
2 жыл бұрын
@@nanookdan I started Job last month. My starting work is in Excel..
@lucutes2936
2 жыл бұрын
what's the hardest skill you've learnt about Excel?
@Rajiv2891
4 жыл бұрын
This channel has been a boon for people working in spreadsheets on daily basis to improve their skills and reduce a hell lot of time. So much informative each and every video is. Thanks for sharing such informative knowledge!
@JimFikes
4 жыл бұрын
Another great tutorial, Leila. I have never felt that watching your training materials were a waste of my time. For as many years as I've been teaching and using Excel, you always teach me something new.
@LeilaGharani
4 жыл бұрын
I'm glad to hear that Jim. It's great that I can still surprise you :)
@vipuljindal4584
4 жыл бұрын
REALLY HELPFUL AND QUICK WAY OF PRINTING: Select area to be printed Press Alt P R S (set print area) Now press Ctrl+F2 (print preview) Print!
@SNAPPSociety11
3 ай бұрын
I've watched other tutorials on KZitem and didn't learn anything. Watched yours and GOT IT. Great explanation, THANK YOU!
@LeilaGharani
3 ай бұрын
Happy to hear that!
@scarlettnguyen9627
4 жыл бұрын
OMG I wish I knew you sooner. You are my life saver!! Please release more episodes for us to follow !!
@LeilaGharani
4 жыл бұрын
Will do 😊
@shashaip3977
3 жыл бұрын
I enjoy her explain step by step and have subtitles
@mezianeremila454
4 жыл бұрын
It is frustrating to watch Leila's excel video without having learned anything new, it has taken me years to learn all these things and you summerized it in 10 minutes, that's the genius about you by the way...
@LeilaGharani
4 жыл бұрын
Sorry you didn't find anything new this time.
@pushpajchougule8316
4 жыл бұрын
Did face the printing problem last week, I was able to get it printed with some adjustments but didn't know there's more to it. Thanks again. You actually know what practical problems one could have while using excel. Experience speaks! 😊👏
@LeilaGharani
4 жыл бұрын
Oh yeah! I wasted my fair share of paper in the past :)
@anilkumarnvs8121
3 ай бұрын
You made me fell confident and independently handle my worksheet. thank you for the Amazing content
@LeilaGharani
3 ай бұрын
You're so welcome!
@sunilg9667
2 жыл бұрын
I highly recommend this channel for the one who really want to improve their excel skills..
@ohgasauraus
2 жыл бұрын
Thanks! This fixed my problem of windows scaling that affect how a properly formatted excel misaligned when windows scaling no longer 100% on other PC! By using Print Area and Scale to Fit Width & Height to fix the issue.
@stefwata3461
2 жыл бұрын
SET PRINT AREA DID IT!!!!!! YOU R AWESOME!!!
@darrylmorgan
4 жыл бұрын
The Complete Excel Essentials Course is full of Awesome Tips and Tricks like this!Thank You Leila
@LeilaGharani
4 жыл бұрын
I'm happy to hear that Darryl. Thanks for the kind feedback.
@naqshgarg7625
4 жыл бұрын
I was talking to one of my friend that you may work on many fancy BI tools but excel is and will remain misterious as everyday we learn new things out of it. Thanks To Leila Gharani unlocking this for us. Many thanks👍
@LeilaGharani
4 жыл бұрын
You're very welcome. I'm also unlocking new things all the time with Excel :)
@ozmaorigrl
2 ай бұрын
Thanks .... sorted my work stuff out today!
@LeilaGharani
2 ай бұрын
Glad it helped!
@kadavisweswararao7982
3 жыл бұрын
THANK YOU VERY MUCH MADAM. I LEARNED NEW THINGS FROM YOUR VIDEO.
@LeilaGharani
3 жыл бұрын
Glad to hear that.
@edwardkhatiya4561
3 жыл бұрын
My crush! can't believe this! Every point sinks in!
@thinkdunson
2 жыл бұрын
5:35 don't forget that it's going to include the entire cell even if it only contains a tiny bit of spill-over. so make sure your last cells on the bottom and right are tight to, in this case, the graph. also, if you're printing only text and you want it to be centered correctly, you need to have the cell's text alignment also set as centered vertically and horizontally. because excel is only trying to center the cell itself when you print.
@riverjig
Жыл бұрын
Thanks for this. I couldn't figure out how to get my document centered. You showed me that there is a horizontal center option in margins, which I missed, and it fixed it.
@tjduprey
4 жыл бұрын
As always, you're the best!!
@lejomdavid8538
4 жыл бұрын
great video... an additional useful tip is the shortcut 'Ctrl + F2' for a quick print preview.
@mariostudio7
4 жыл бұрын
Always think before you print people! 🌲🌳 Awesome video! 😊
@LeilaGharani
4 жыл бұрын
Very true. Glad you like the video!
@ronvds4713
4 жыл бұрын
These a the basics that you should know when starting out with excel. Good to see that you don't ignore these points.
@LeilaGharani
4 жыл бұрын
Never forget the basics :)
@akperfumes
4 жыл бұрын
Leila your tutorials are always on point. Thank You😎
@saadsayyed1536
2 жыл бұрын
I was not able to print gridlines and that's the reason I randomly searched on google and found this useful video. Thanks a lot
@wmfield152
4 жыл бұрын
This is one of the most helpful Excel videos. Before watching I was not familiar with all the printing options that are available. Thanks again L!
@LeilaGharani
4 жыл бұрын
You're very welcome!
@NewbieInForeignLand
4 жыл бұрын
Wow !! What would I have done without you!! Thank you so much for such amazing videos
@qismatali4073
3 жыл бұрын
You explain in supper easy way that what i like so much. Thank you Laila.
@LeilaGharani
3 жыл бұрын
Happy to hear that!
@madhupolineni8279
2 жыл бұрын
your video's are Great easy to understand
@AmitChauhan007
4 жыл бұрын
Thanks a lot, Leila, your videos are really helpful, crisp, and clear.
@LeilaGharani
4 жыл бұрын
Glad you like them!
@edmunfania6043
2 жыл бұрын
You save my life with my Boss Today thank you
@joseapar
4 жыл бұрын
I'm surprised you didn't touch on the page layout view. If i'm printing i find it much easier to be in that view and make the adjustments there to how things will look when i print them. You can make many of the adjustments from that view and you get a direct page view of how things will print without having to go back and forth between the sheet and the print preview screen.
@1877Pegasus
4 жыл бұрын
You are so right
@LeilaGharani
4 жыл бұрын
True - that's a good one. We cover that inside the course when we talk about adding headers and footers and I think in the follow up video we have on repeating table header coming out in 2 weeks as well....
@aliibrahim1235-c6i
10 ай бұрын
thank you from Egypte 🌹🌹
@JoaquimParis
3 жыл бұрын
Love your channel, love your work! Recommended to most of my colleagues.
@LeilaGharani
3 жыл бұрын
Thank you very much!
@Me_ThatsWho
4 жыл бұрын
Thank you. The substance starts at: 2:57
@wayneedmondson1065
3 жыл бұрын
Thanks Leila!
@Ashish__Sahu
2 жыл бұрын
I found this video very helpful, it has solved a lot of things , Thank You
@dkb1111
3 жыл бұрын
My big problem solved, Thanks my best teacher
@LeilaGharani
3 жыл бұрын
Happy to help!
@myrsinireid9089
2 жыл бұрын
Love this! Perfect 👍🏻
@divyamsaran
2 жыл бұрын
Excellent and a highly helpful video. Much useful than my college lectures.
@LeilaGharani
2 жыл бұрын
Glad it was helpful!
@josephcoon5809
3 жыл бұрын
Thanks for another excellent video!! 1. I changed my settings to default to View > Page Layout so I’m always formatting my sheets for printing. 2. I think that it is worth noting that if you print to multiple devices, the print area may be different. Printers have slightly different printable areas and OneNote (I send sheets to OneNote on occasion) is usually quite a bit different than a standard printer. It is good to be mindful of the output your Excel Workbook is set to.
@LeilaGharani
3 жыл бұрын
Thanks for sharing your tips, Joseph!
@ananguyen4509
4 жыл бұрын
Thanks Ms Leila for another great video.
@habibsicttutorials6684
4 жыл бұрын
You made it sound so simple and easy! Thanks
@LeilaGharani
4 жыл бұрын
You're welcome!
@romeltborja
4 жыл бұрын
Thank you Leila
@leosmilesu2
4 жыл бұрын
You make learning new things fun and easy with your awesome styles of teaching and presentation. Thank you again
@LeilaGharani
4 жыл бұрын
Thank you for the kind feedback Leonard.
@thetourminator
2 жыл бұрын
I totally LOL'd at that 0:56 "wasting trees" video insert.....NICE. :)
@LeilaGharani
2 жыл бұрын
😁
@girmabogale6376
10 ай бұрын
I love your tutors
@Deependra1991
4 жыл бұрын
Why didn't you made this video years back. Anyway now is better. Thanks for sharing such a wonderful steps of print setup as always you do....
@LeilaGharani
4 жыл бұрын
My pleasure. I hope it will be helpful.
@ismailismaili0071
4 жыл бұрын
That was epic I have never known these info to be honest thank u so so much Ms. Leila
@LeilaGharani
4 жыл бұрын
I'm glad you discovered something new Ismail :)
@mohamedchakroun4973
4 жыл бұрын
Thanks Leila
@theManagementLab
4 жыл бұрын
Thanks Leila! You are a saviour.
@nipunkavinda8254
4 жыл бұрын
Very useful video specially for the finance people work in companies...
@thinktoomuchb4028
2 жыл бұрын
Very helpful! But do you have a video on resolving the problem of shapes being distorted when printing, e.g. circles printing as ovals?
@wahidovich2021
4 жыл бұрын
God bless you Leila, thank you very much!
@yulinliu850
4 жыл бұрын
Very helpful tips. Thanks Leila!
@LeilaGharani
4 жыл бұрын
My pleasure. Hope it will come in handy.
@radhikamishra2130
Жыл бұрын
Hi Leila , i learned a lot from you. I have a doubt , how to increase font size of specific area in excel print. For example in your sheet how to increase font size of first table without change second table.
@katerina6495
4 жыл бұрын
Wirklich fantastisch Leila, diese Drucktricks sind sehr nützlich Viele liebe Grüße 🌞
@LeilaGharani
4 жыл бұрын
Freut mich Katerina :)
@bhagwatimaurya1827
4 жыл бұрын
Your videos are really great, helpful. I needed this one. Thanks a lot
@pollinatorkioplop5790
4 жыл бұрын
Thanks you for your help! You're always useful
@muhammadsohailashraf6059
4 жыл бұрын
Madam you are great teacher for all of us. I am learning a lot of information from you. I have a question about printing ... I have a data in Column A only . but it is more then 10000 rows.. I want to print it all but when i print. it will come one colum only and balance 80% page will be empty. I want when its print like zigzap but in vertically. like column, i can say when it print on page it should come like colum wise.. i hope you understand my means. if you give me i can send you a small diagrame. it is will be easy for you to understand. TIA
@joykomersingh8039
Жыл бұрын
Thank You.
@fragrancekiduniya8905
2 ай бұрын
Beautiful Jacket.
@jasonagresti3069
4 жыл бұрын
You are a great source of inspiration. Thank you very much. In Honor! Jason
@krn14242
4 жыл бұрын
Thanks Leila. Great video as usual.
@LeilaGharani
4 жыл бұрын
Thank you for your comment and dropping by.
@umanggupta4769
3 жыл бұрын
Thank you
@InsideMyWall
4 жыл бұрын
Having problem in a sheet having free forms drawn in separate cells. The free forms seems to jump from its place while selecting print preview. Please make a video on that. Also lessons on how to adjust page breaks while printing sheets will be helpful.
@simoiyahector-morales3781
4 жыл бұрын
Excellent trick, thanks for sharing your exceptional knowledge of excel.
@LeilaGharani
4 жыл бұрын
My pleasure Simoiya. Hope it will come in handy.
@darkshinigami9438
4 жыл бұрын
I'm eagerly waiting for the next videos in the accounting series :)
@LeilaGharani
4 жыл бұрын
They are in the works. We will restart next year :)
@darkshinigami9438
4 жыл бұрын
@@LeilaGharani Amazing, I can't wait for the LIFO FIFO video and much more others :D
@MsFlaca5
2 жыл бұрын
Thank you for this video I just have a question I’m trying to print my worksheet out but how do I get rid of the letters on top and the numbers on the side??
@khantravelguide
4 жыл бұрын
Addicted to your vids xxx
@shrawankumargupta4407
2 жыл бұрын
Thanks for this video's
@nindajuka8427
4 жыл бұрын
Very helpful tips! Would you make video about putting color in excel? I mean, in table header and its values. What we should do and dont when mix match color to make it more comfy to read
@raoahmed4139
4 жыл бұрын
Hi, Its good question, i could solve it if you wana to auto change color or row cell etc
@sonamtseringsherpa
4 жыл бұрын
very helpful
@richardhay645
4 жыл бұрын
Great summary.
@ryanashby2459
11 ай бұрын
Great tut! I was trying to print to PDF with a full bleed and no matter what setting and margins set there is always a strip of white at the bottom and right side... Help! haha
@shakiraasfoor7599
4 жыл бұрын
شكرا
@markzalavari1780
4 жыл бұрын
Hey, I was expecting the other important feature: how to put the fixed headings onto all of the pages: PAGE LAYOUT > Printing addresses > top sequent lines > full of more options!
@LeilaGharani
4 жыл бұрын
That's the topic of the next video on printing coming in 2 weeks :)
@thinkdunson
2 жыл бұрын
sometimes i want to print a full sheet placard with just a few words in a very large font. but when i do that, the text does not print. the print preview looks fine. sometimes i might have an image and the large text, but only the image prints. it does this in excel and in word. the only way i can get it to print correctly is to print to pdf and then print the pdf.
@tomjun8945
4 жыл бұрын
Thank you for the amazing training !!
@LeilaGharani
4 жыл бұрын
Glad you liked it!
@dogwoodtales
Жыл бұрын
So I need to print an Excel doc in PDF format in landscape, but in the final PDF I want that landscape to be rotated onto a portrait page view so that the top margin of the landscape view is at the left margin of the portrait page and the bottom of the landscape PDF is along the right margin of the portrait page (I hope that is clear enough). The reason is because I need to then attach that page to a report in PDF in which all of the other pages are in portrait orientation. I know that after printing to PDF landscape I can then rotate that PDF page in Adobe, but that's an extra step and there are several such reports to attach to the final report and therefore rotating the pages after printed to PDF is not as lean if I can just print to PDF from Excel as described above.
@TejasCandade1978
4 жыл бұрын
Amazing, i learnt something new from you.
@ExcelExciting
4 жыл бұрын
Thanks for sharing... !! Great Tip
@LeilaGharani
4 жыл бұрын
You're welcome Faraz :)
@HarjinderKaur-hg7ki
14 күн бұрын
Nice sis
@MrEms333
4 жыл бұрын
Very Nice Leila My Teacher in Primary School Has Your Name
@shanesmohammed
4 жыл бұрын
Marvelous LG!!
@sulaimansait864
4 жыл бұрын
You are explain very super mam so more update video tell about outlooks
@sv6856
4 жыл бұрын
Can we get pivot table learning?
@Devagrace
2 жыл бұрын
Thank you :)
@darrengodkin
4 жыл бұрын
Brill tips! Must insist that my boss watches this video at least 4 times 😀
@LeilaGharani
4 жыл бұрын
Haha. Better not disappoint him then :)
@janikhan4517
3 жыл бұрын
Love This
@hosseinhosseinpoor4845
3 жыл бұрын
thanks....
@anitahuron7462
4 жыл бұрын
Thank you!
@MrSupernova111
4 жыл бұрын
Hi Leila, this was a good overview of the Excel print features. Question: I'm rebuilding a complicated Excel file at work to automate some of the functions. This file is a multi tab file so rebuilding it was the best option. Whoever made the original file was able to create dynamic "print areas" meaning that the page auto adjust the print area depending on the number of rows with data. Can you make a video showing how this is done or point me in the right direction? Thanks!
@LeilaGharani
4 жыл бұрын
Good idea. I'll add it to my list for future videos. Thanks for the suggestion!
@sarfarajkureshi6569
4 жыл бұрын
thanks mam it is very helpful for me.
@MrBhopinderkumar
4 жыл бұрын
Very good explain madam Thank you,💐
@AbdulRahman-lv6sy
4 жыл бұрын
Hi Amazin am a great admirer of your videos which gives immnese help in managing basic functions in excel. Can you make a video on time excel chartsThanks
@thinkdunson
2 жыл бұрын
i think most printers can set their own minimum margins... just set all margins to zero and it'll take care of itself. it may warn you that it's outside the minimums, so just tell it to print anyway. obviously you need to test it before sending it to someone else, but it works perfectly with the few HP printers that i've used (the M605 all the way through M611).
@bogaramesh3955
4 жыл бұрын
How to print multiple pages at a time in Excel...? Any shortcut keys
Пікірлер: 345