Totally #8. And that works with Powerpoint too. Everytime you make a very good work and presents it messy and ugly, it loses many of its value... Thank you for your tips, I really love your videos!
All are my favorites and things I always strive to achieve...I take pride in a well structured workbook such as these suggestions. Nothing peeves me more than receiving a file not already prepared for printing or not well organized for me as a consumer...
One of my 'must do(s)' when distributing a workbook - LOCK DOWN your formulas to prevent changes. Also, I regularly use the 'hide formula' function & lock the cell. Learned the hard way - ppl really do like to fiddle with the calculations, etc...
An amazing tutorial. It is truly important to aesthetically present your data. Your tutorial teach us both make complex data calculations and also how to present and showcase them. I have learnt so many concepts from all your tutorials. Thank you and God bless you.
Always look forward to your Thursday youtube postings 😃. I have recently started this course and I am really enjoying it. Professional, detailed and methodical and most importantly, easy to follow. Numerous tips, really great! Thank you Leila!
I’ll add to the list: #9. Freeze panels for large set of data.#10. Save file with active cell where your relevant data starts (begining of the document, usually the top left corner sheet) on EACH SHEET. Under #8 my must does are:. (a) For data pivoted, I spend time removing the default pivot format; (b) I remove the grid lines for any data summaries, but do leave it on on sheets with raw data;
nice Leila. defintely agree with you on all points. One i like to add is that I try to anticipate what the questions might be when presenting my work, having the ablity to quickly change the file by making on and off switches and selection menu's helps to answer questions of my co workers quicly. also your last point is key.. I try always to mkae my files clean and well structured.. takes a bit of time but it helps to present your work.
7 & 8 is a critical one, many times we just send the report as soon as we finish before make it more readable and easy way to undestand. Thank you for these tips
Very good tips. And yes, I like tip#8 the most as well. It reminds me of "Do good and talk about it!" :) And very well presented. Keep up the good work! Thank you very much.
Tip Number 1: Dont use Excel for internal reporting if you deal with important data. Excel templates are very vulnerable and tend to be misused by the reporters. Use web-based templates created by professionals. Tip Number 2: Master Pivot Tables, Power Query and Database connections. Those are your best friends for every imaginable real-world task. If you don't use these techniques, then every singe change in your template becomes a tedious and irreversable manual process. Tip Number 3: Cook in the kitchen and eat in the dining room. If your goal is to analyse some figures, then dont try to improve the looks of your raw data. Design it as an efficient fact table instead. If your goal to make a good looking report, then nly polish the outcome table. Conceal or totally remove your raw data from the file, before presenting it to the end-consumer. Tip Number 4: Those who practice hiding columns and/or merging cells are sinners, who land in their own circle in Excel-hell. These practices breach the file structure and turn both error search and automated file processing to a nightmare. Tip Number 5: Colors are fine, but values are better. If you highlight something important using a color, your message can be missed if there is a lot data to look at. Why not build a column with your points of interest and add a nice pivot slicer or a filter to it instead? This way the important items can be found easily. Tip Number 6: Define your own tips.
Hi Leila, Here's a tip for you: don't use the word tab instead of sheet. You can find tabs in the ribbon and in dialog windows, sheets are, of course, the worksheets in which you put your data. Besides general confusement, I heard you talking about the data tab, which is of course one of the tabs in the ribbon, but you meant a worksheet. Keep up the good work, Gerben.
Point 8 is so true! I can’t agree more! And that’s absolutely for real business world. Having said that, the content itself is of equal importance. But appearance comes first. 😅
Those are really great tips! I really love this video, I can assure you all that what Ms Leila said is very crucial. I actually found those in my work experience, and I wish i got those tips earlier in my career because to know this I had to pay with my time and energy A LOT. And of course those experiences are not adequate enough, so I still have to learn so many things. Very good video and fully packed with useful knowledge
Hi Leila.. great tips.. especially "Prepare For Print". I constantly get workbooks without print settings and have to do the setup myself each time.. VBA to the rescue.. haha! Content creators should always consider the next person using the workbook. Your tips are excellent. Another one might be to highlight or in some way make an annotation if there are links in the workbook to external sources.. makes it easier for the recipient to understand what is self contained within the workbook vs. external to it. Thanks for sharing. Thumbs up!
You are just amazing.. I always learn something new in every video that you raised.. note that, I aleady takes 2 Cources in udemy done by you Teacher and my skills has been upgraed to next level. Thank you a lot 🧘♂️ . 🙂
Thank you very nice tips!! I will add a few: do not center numbers (how ugly is it then when to compare 1000,897 with 1,9 ?, so always comma's lined up, or even better: not decimals and a thousand seperator. If you want to present a small calculation to people who understand Excel, use FORMULATEXT. Use data validation and build controls (for example when was the data last refreshed?). Keep your good work!! thanks again.
Very VERY good video, i basically build spreadsheets as part of my job , and every remark she makes is true, just adding further you can hide your calculation sheet/s, and i have a navigation screen with hyperlinked or macro linked navigation buttons instead of using tabs, and the comment about saving the file, thats so very very true, when i build i rename my file about every 10 minutes while building, starting as file 1, if you build a sheet and the file becomes heavy then save it as a binary file to bring the file size down, and be wary of using pictures, check the file size of the picture first
Excellent advice as always! I do almost all that, including the change log with timestamps. It saves you big time when you come months later! My Achilles's hells are the instructions.. I need to do then more and much better. I can't find the right style and size for the instructions wording.. -- hey, this could be a different topic idea for you! ;-) --
Great that you're doing these! For me too - the instructions where the most problematic part. Once I discovered "Justify" I actually started to enjoy the process. In case you missed that video - check it out here: ua-cam.com/video/vviFux8qelU/v-deo.html. Short animated images sound really good. Maybe we get some type of Excel/PowerPoint/SC integration so we can do that.
@@LeilaGharani I saw your justify video. It's neat but I'm a Google sheets user and we don't have that yet. I'll try a proof of concept for the short animated gifs to see if they even play from within the spreadsheet.
@@lpanebr I use textboxes with a button to show/hide the text box so that you can remain on the same sheet as the instructions, which is useful if the user is trying to read the instruction at the same time as using the report/process. I sometimes use comments and message box validation too if it is cell based instruction.
Hi Leila, I have been watching your videos lately and they are very helpful. A question for you, I have tried to find an answer googling but I haven't been able to find out an answer or fix. I have a custom sorting list and it works fine if a create a pivot table in the same workbook. But if I import or connect data using New Query From File option under Data ribbon to another workbook and try to create a pivot table, it sorts the data alphabetically. I want to keep the data and dashboard separately i.e. in two different workbooks. Any suggestion.
Hi Leila, Nice posts on excel, can you help me out by showing some tricks on adding rows and column dynamically once the previous once are filled Thanks in advance
Leila, Thank you for the tips. Question: Do you have a session on designing a form in excel that feeds a spreadsheet? I want to do this so that a few nursing staff can enter information because some are afraid of using Excel.
Define a purpose - mandatory for all my reports. Extra tip if possible create a visual walk thru of the report in PowerPoint and attach within the report.
plz make a video for fetching various results from a webpage by providing various inputs to the cells from excel and putting it into respective values into the cell of the excel. e.g I have two columns (A1 and B1) whose value are 5 & 10 respectively, now in te website I have to put the values to resptive field say 1st Number and 2nd Number and the result in the page says 15 and now I want to put the value "15" to my excel cell no C1. And this should be repeated till my last row.
One thing I do which may or may not help others, is to put a header row Title that matches the tab sheet name, so that when you click between tabs you have an additional reference to identify where you are.
I see those adverts for team management software, one 'user' claimed that trying to use spreadsheets was a nightmare... I really think that if you understand the data, and understand spreadsheets, you can achieve similar results
I think so too. There may be some special instances where it does not work but for most requirements you can get efficient and effective solutions with spreadsheets.
@@LeilaGharani Spreadsheets are great until other people start using them! I'm constantly surprised at how many people don't really understand the basics of Excel and data despite the fact that they use it every single day. The number of times I see a 5 million tab workbook that could be replaced with a slicer and a data tab. I think some people think it's a competition to see how many "hops" they can have from one formula to its first precedent.
Hi Leila, I have an Excel problem I can't solve. I have 2 groups in my excel spreadsheet. Group 1 ranges from B1 to B8 (with info either 1 or a blank), the spreadsheet is looking at A1 to A8 for the info (info is specific names) Group 2 ranges from B9 to B12 (same info, 1's or blanks) Group 1 gets priority, so if the're in, they get there same desk as always. But where I can't solve this, is when a person from group 1 is away for the day, I need a person from group 2 to take the blank space without any duplication's. I'm having to do this manually, as I can't solve this formula. Hopefully you can help. Kind regards. Colin.
Dear Leila, I wonder if you can make a video about extract data consisting of more 300.000 records with formulas based on multiple criteria. Not solved easily from my side.
what if i have a databook with 100 sheets, and i need a worksheet divider that separates each 10 sheet. how can i go on about that. i need a design idea for it
I'm trying to convert my excel spreadsheet into a csv format. When I click on files it doesn't give me an option to SAVE. I don't see the save option to click on.
Is there any way that Excel take the last entry and sum it in a formula? I mean, if there's a formula I can use to calculate something using the last cell typed?
Stay ahead with our Weekly Newsletter. Get the latest insights and updates straight to your inbox 👉 link.xelplus.com/yt-c-newsletter
Leila Gharani
Question- for the training you just put out, I’m a little unclear as to when I will be able to get the ebook. Was it 30 days later
Hi Joe. Yes - 30 days after enrollment :)
Totally #8. And that works with Powerpoint too. Everytime you make a very good work and presents it messy and ugly, it loses many of its value... Thank you for your tips, I really love your videos!
Love how you break it down and catagorize each segment to its own work sheet. A true time saving shortcut. Thank you Leila.
ua-cam.com/video/I3G-bnJHKV0/v-deo.html he praise you a lot. Thanks for every video you make.
Dear Leila, Once again may the Good Lord richly bless you
Thank you very much Robert!
Thanks Liela . liked the saying 'You eat with your eyes first' very well goes with the context of the video.
All are my favorites and things I always strive to achieve...I take pride in a well structured workbook such as these suggestions. Nothing peeves me more than receiving a file not already prepared for printing or not well organized for me as a consumer...
Exactly! Makes me want to close them and return to sender :)
You have no idea how even in a short video, the lessons are ever elevating. I wish i could thank you in person
You're very welcome Mike. I'm happy when the tutorials are helpful.
One of my 'must do(s)' when distributing a workbook - LOCK DOWN your formulas to prevent changes. Also, I regularly use the 'hide formula' function & lock the cell.
Learned the hard way - ppl really do like to fiddle with the calculations, etc...
Thank you Leila ... Definately valuable piece of information which should always be used used.
Glad you agree. Thanks for the feedback.
This is one of the best UA-cam learning channels, and it is for free!, it helped me a lot with preparing my works, thank you very much.
You're very welcome Amir. Glad the tutorials are helpful for your work.
An amazing tutorial. It is truly important to aesthetically present your data. Your tutorial teach us both make complex data calculations and also how to present and showcase them.
I have learnt so many concepts from all your tutorials. Thank you and God bless you.
I'm happy the tutorial is helpful for you.
I have just completed course and tested myself.
Great work Leila for preparation&presentation.!
Thank you
Hi Emre. Great to see you here too! Thank you for dropping by and good job completing the course :)
The best tutor ever !
Always look forward to your Thursday youtube postings 😃. I have recently started this course and I am really enjoying it. Professional, detailed and methodical and most importantly, easy to follow. Numerous tips, really great! Thank you Leila!
Hi Roberto. Thank you! I'm really happy to hear you're enjoying the course 😀
I’ll add to the list: #9. Freeze panels for large set of data.#10. Save file with active cell where your relevant data starts (begining of the document, usually the top left corner sheet) on EACH SHEET.
Under #8 my must does are:. (a) For data pivoted, I spend time removing the default pivot format; (b) I remove the grid lines for any data summaries, but do leave it on on sheets with raw data;
Excellent tips. Thanks for your input!
Very helpful tips Leila, it’s always useful for the finishing touch, thanks!
Sometimes these last touches make all the difference.
nice Leila. defintely agree with you on all points. One i like to add is that I try to anticipate what the questions might be when presenting my work, having the ablity to quickly change the file by making on and off switches and selection menu's helps to answer questions of my co workers quicly. also your last point is key.. I try always to mkae my files clean and well structured.. takes a bit of time but it helps to present your work.
Absolutely agree. Thanks for the feedback Martijn!
Thanks for reminding for basic hygiene check. It is really helpful.
Glad to help with basic hygiene :)
7 & 8 is a critical one, many times we just send the report as soon as we finish before make it more readable and easy way to undestand. Thank you for these tips
So true. I made that mistake myself so many times :)
Yet another nice video! Keep them coming Leila! You are doing a great job helping thousands of Excel fans like me discover and learn so much more! :-)
Thank you for the kind words. I'm happy when the videos are helpful.
The built-up is very logic and looks professional!
Very good tips. And yes, I like tip#8 the most as well. It reminds me of "Do good and talk about it!" :) And very well presented. Keep up the good work! Thank you very much.
Once again. U fail not to impress us. I’m gonna take your excel course. Hopefully, it should have more than your UA-cam playlist. ;)
It sure does. Let me know how you like it.
Tip Number 1: Dont use Excel for internal reporting if you deal with important data. Excel templates are very vulnerable and tend to be misused by the reporters. Use web-based templates created by professionals.
Tip Number 2: Master Pivot Tables, Power Query and Database connections. Those are your best friends for every imaginable real-world task. If you don't use these techniques, then every singe change in your template becomes a tedious and irreversable manual process.
Tip Number 3: Cook in the kitchen and eat in the dining room. If your goal is to analyse some figures, then dont try to improve the looks of your raw data. Design it as an efficient fact table instead. If your goal to make a good looking report, then nly polish the outcome table. Conceal or totally remove your raw data from the file, before presenting it to the end-consumer.
Tip Number 4: Those who practice hiding columns and/or merging cells are sinners, who land in their own circle in Excel-hell. These practices breach the file structure and turn both error search and automated file processing to a nightmare.
Tip Number 5: Colors are fine, but values are better. If you highlight something important using a color, your message can be missed if there is a lot data to look at. Why not build a column with your points of interest and add a nice pivot slicer or a filter to it instead? This way the important items can be found easily.
Tip Number 6: Define your own tips.
I am in love with her brain...…...very talented and articulate mind.
Hi Leila,
Here's a tip for you: don't use the word tab instead of sheet. You can find tabs in the ribbon and in dialog windows, sheets are, of course, the worksheets in which you put your data. Besides general confusement, I heard you talking about the data tab, which is of course one of the tabs in the ribbon, but you meant a worksheet.
Keep up the good work, Gerben.
WISH YOU HAPPY NEW YEAR 2021
you're the best teacher, nice tone and pacing
Thank you. I'm glad to hear that.
Thank you for sharing your tips
Stunning presentation.
Thanks Leila! I like the creative food stuff too :)
Point 8 is so true! I can’t agree more! And that’s absolutely for real business world. Having said that, the content itself is of equal importance. But appearance comes first. 😅
Just to spend a little bit of time to make it look digestible :)
Leila Gharani and delicious 😋
Great tips! Thanks for the video
Leila is the best youtube excel teacher, ever! Also v pretty :)
Tip # 2,3,8 are awesome tip...
Vielen Dank Liebe Leila, there is so much elegance in your excel work, much appreciated
Viele liebe Grüsse 🤗 🌞
Thank you Katerina. I'm always happy to see your comments 😘
Thank you Leila, I am always happy to see your videos. I run the old ones and the Charting techniques are so elegant, so enjoyable making them 💞
Those are really great tips! I really love this video, I can assure you all that what Ms Leila said is very crucial. I actually found those in my work experience, and I wish i got those tips earlier in my career because to know this I had to pay with my time and energy A LOT. And of course those experiences are not adequate enough, so I still have to learn so many things. Very good video and fully packed with useful knowledge
Many thanks for the kind feedback. I'm glad you agree with my design tips.
Just made Excel interesting, Thank you!
Great advices. Thank you
Great tips. Thanks Leila.
Love it!
Hi Leila.. great tips.. especially "Prepare For Print". I constantly get workbooks without print settings and have to do the setup myself each time.. VBA to the rescue.. haha! Content creators should always consider the next person using the workbook. Your tips are excellent. Another one might be to highlight or in some way make an annotation if there are links in the workbook to external sources.. makes it easier for the recipient to understand what is self contained within the workbook vs. external to it. Thanks for sharing. Thumbs up!
So true Wayne. Thanks for your input!
Really enjoyed these tips Leila.
Glad you like it Graham.
Props Leila! Very nice!
Great tips. Thanks Leila!
Very useful information nice video
Great value able info, as always. Good job!
Thank you. Glad you like it.
Thank you it helps me with my Technology information literacy class, we have to do certain pages for our project s
Glad I could help, Tracy.
I learned a lot from you Leila, thank you so much indeed
My pleasure. Glad it's useful.
Excellente comme toujours
Nice tutorial mam, thank you, god bless you
My pleasure. Glad you like it.
Very helpfull your video mam 🙏🏻
Pleased make more video about its topic please
Highly requested 🙏🏻
You are just amazing..
I always learn something new in every video that you raised..
note that, I aleady takes 2 Cources in udemy done by you Teacher and my skills has been upgraed to next level.
Thank you a lot 🧘♂️ . 🙂
I'm happy to hear that. Thank you for the support of my courses.
Calculate everything! I had a team member who calculated in her head or calculator then hard entered the resu!
May as well have been a word document
Haha, that's funny :)
Thank you very nice tips!! I will add a few: do not center numbers (how ugly is it then when to compare 1000,897 with 1,9 ?, so always comma's lined up, or even better: not decimals and a thousand seperator. If you want to present a small calculation to people who understand Excel, use FORMULATEXT. Use data validation and build controls (for example when was the data last refreshed?). Keep your good work!! thanks again.
Great tips Bart. Thank you for the input!
Good tips, as always!
Good reminders
Thanks for video!
I can write VBA code, but absolutely stupid when it comes to visual design.
Thank you, Leila, the video is very helpful.
You're very welcome!
#2 is my favorite. I wasn't thinking about things this way. Thank you :)
Glad you found something useful.
I like it , excel lady and thanks for sharing .
Glad to hear that :)
Thanks you. See you everyday.
Thank you !
Very VERY good video, i basically build spreadsheets as part of my job , and every remark she makes is true, just adding further you can hide your calculation sheet/s, and i have a navigation screen with hyperlinked or macro linked navigation buttons instead of using tabs, and the comment about saving the file, thats so very very true, when i build i rename my file about every 10 minutes while building, starting as file 1, if you build a sheet and the file becomes heavy then save it as a binary file to bring the file size down, and be wary of using pictures, check the file size of the picture first
Thanks Tim. I appreciate the feedback and your input.
Thanks
Happy Thursday your highness
Sooner i'll join
Excel real life course
Just busy finishing Chris dutton's power bi course
Thanks a lot
C u there
Wow, you are busy learning. That's great!
@@LeilaGharani keeping on the track
I don't want to miss any updates
Excellent advice as always! I do almost all that, including the change log with timestamps. It saves you big time when you come months later! My Achilles's hells are the instructions.. I need to do then more and much better. I can't find the right style and size for the instructions wording.. -- hey, this could be a different topic idea for you! ;-) --
Wow, it just came to me as I sent the comment: what if the instructions were short animated images actually showing stuff!?
Great that you're doing these! For me too - the instructions where the most problematic part. Once I discovered "Justify" I actually started to enjoy the process. In case you missed that video - check it out here: ua-cam.com/video/vviFux8qelU/v-deo.html. Short animated images sound really good. Maybe we get some type of Excel/PowerPoint/SC integration so we can do that.
@@LeilaGharani I saw your justify video. It's neat but I'm a Google sheets user and we don't have that yet. I'll try a proof of concept for the short animated gifs to see if they even play from within the spreadsheet.
@@lpanebr I use textboxes with a button to show/hide the text box so that you can remain on the same sheet as the instructions, which is useful if the user is trying to read the instruction at the same time as using the report/process. I sometimes use comments and message box validation too if it is cell based instruction.
@@ricos1497 that's interesting. I'll give these a try! Thanks!
very useful
I recommend learning Python and replacing all the spreadsheets (and coworkers) with a few lines of code
So smart thanks
Hi Leila, I have been watching your videos lately and they are very helpful. A question for you, I have tried to find an answer googling but I haven't been able to find out an answer or fix. I have a custom sorting list and it works fine if a create a pivot table in the same workbook. But if I import or connect data using New Query From File option under Data ribbon to another workbook and try to create a pivot table, it sorts the data alphabetically. I want to keep the data and dashboard separately i.e. in two different workbooks. Any suggestion.
Hi Leila,
Nice posts on excel, can you help me out by showing some tricks on adding rows and column dynamically once the previous once are filled
Thanks in advance
thanks
The title of this item is Do's & Don'ts of Excel Spreadsheet Design.
Don'ts is correct. Do's should be Dos (no apostrophe).
thanks...
Thank you!!!
Leila, Thank you for the tips. Question: Do you have a session on designing a form in excel that feeds a spreadsheet? I want to do this so that a few nursing staff can enter information because some are afraid of using Excel.
any video for creating excel for selling to customers with password protection and serial key?
Vc é ótima Leila!
Thanks girl!
Define a purpose - mandatory for all my reports. Extra tip if possible create a visual walk thru of the report in PowerPoint and attach within the report.
Excellent input. Thanks for the feedback Joe!
plz make a video for fetching various results from a webpage by providing various inputs to the cells from excel and putting it into respective values into the cell of the excel. e.g I have two columns (A1 and B1) whose value are 5 & 10 respectively, now in te website I have to put the values to resptive field say 1st Number and 2nd Number and the result in the page says 15 and now I want to put the value "15" to my excel cell no C1. And this should be repeated till my last row.
Leila, what do you think about data science using Python? I think you can do amazing things combining your skills with Python.
One thing I do which may or may not help others, is to put a header row Title that matches the tab sheet name, so that when you click between tabs you have an additional reference to identify where you are.
Good point Russ. Thanks for your input!
can you please have a video on how to create racing bar graph in excel
Just professional lovely
I see those adverts for team management software, one 'user' claimed that trying to use spreadsheets was a nightmare... I really think that if you understand the data, and understand spreadsheets, you can achieve similar results
I think so too. There may be some special instances where it does not work but for most requirements you can get efficient and effective solutions with spreadsheets.
@@LeilaGharani Spreadsheets are great until other people start using them!
I'm constantly surprised at how many people don't really understand the basics of Excel and data despite the fact that they use it every single day. The number of times I see a 5 million tab workbook that could be replaced with a slicer and a data tab. I think some people think it's a competition to see how many "hops" they can have from one formula to its first precedent.
Lella .please make video about price comparison
in excel
Hi Leila,
I have an Excel problem I can't solve.
I have 2 groups in my excel spreadsheet.
Group 1 ranges from B1 to B8 (with info either 1 or a blank), the spreadsheet is looking at A1 to A8 for the info (info is specific names)
Group 2 ranges from B9 to B12 (same info, 1's or blanks)
Group 1 gets priority, so if the're in, they get there same desk as always.
But where I can't solve this, is when a person from group 1 is away for the day,
I need a person from group 2 to take the blank space without any duplication's. I'm having to do this manually, as I can't solve this formula.
Hopefully you can help.
Kind regards.
Colin.
Mam how to cop with one or more circular errors in formulas?
Dear Leila, I wonder if you can make a video about extract data consisting of more 300.000 records with formulas based on multiple criteria. Not solved easily from my side.
What content do you recommend to be tracked on the control sheet?
what if i have a databook with 100 sheets, and i need a worksheet divider that separates each 10 sheet. how can i go on about that. i need a design idea for it
Is it possible to create a work sheet that cannot be copy and email?
Thanks *clap*clap*clap*
Please madam Leila, how can I get videos about ACCA f1, 2 and 3?? Thanks
I'm trying to convert my excel spreadsheet into a csv format. When I click on files it doesn't give me an option to SAVE. I don't see the save option to click on.
I want it to just ADD the digits to the right of the decimal ONLY, if the integer begins with a negative sign. Is this possible?
kindly tell some professional tips for making designs in excel sheet.
Is there any way that Excel take the last entry and sum it in a formula? I mean, if there's a formula I can use to calculate something using the last cell typed?
1. ✔️
2. ✔️
3. 🤯
4. ✔️
5. ✔️
6. ✔️
7. ✔️
8. ❤️
I need help in creating a worksheet