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...
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
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...
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.
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;
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.
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!
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.
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. 😅
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.
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
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
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!
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.
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 🧘♂️ . 🙂
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.
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
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.
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.
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.
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.
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.
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.
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.
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 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?
Are there any color pallets that are more suitable for people who are colorblind? I don't want to color code two groups different colors and have them look the same to someone who cannot differentiate. Any recommendations?
Tableau has a good article on this: www.tableau.com/about/blog/2016/4/examining-data-viz-rules-dont-use-red-green-together-53463 Also Excel's Accessibility feature checks color choice has well. You can find more information on that here: support.office.com/en-us/article/make-your-excel-documents-accessible-to-people-with-disabilities-6cc05fc5-1314-48b5-8eb3-683e49b3e593
I didn't really think about this until a few years ago I produced (what I thought) was an amazingly easy to use set of worksheets despite their complexity because of the intuitive and totally consistent colouring on both input and output tabs. Then I found the department head of the company was totally colour-blind. My tip for this, now is to add a step in production which turns all the colour off on my monitor and see how it looks - then print in all in grey scale and see how readable it is. If either fails that test, look for other colours. Printing all output in greyscale as a test is helpful any any event, there are still people who don't have colour printers or simply don't want to use expensive colour inks unnecessarily. So my additional tip would be ... make sure it looks OK in black and white.
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.
How do I use a math calculation within a dropbox. For example when I click on a dropdown list, then I choose a product name, (Tropical) I want that product name for (Tropical) to multiply =B14*19 and show this in a different cell. Know what I mean?
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.
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.
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 :)
Dear Leila, Once again may the Good Lord richly bless you
Thank you very much Robert!
The best tutor ever !
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.
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 :)
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...
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!
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.
Thank you Leila ... Definately valuable piece of information which should always be used used.
Glad you agree. Thanks for the feedback.
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 :)
Stunning presentation.
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.
you're the best teacher, nice tone and pacing
Thank you. I'm glad to hear that.
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!
WISH YOU HAPPY NEW YEAR 2021
Thanks for reminding for basic hygiene check. It is really helpful.
Glad to help with basic hygiene :)
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 💞
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.
Very helpful tips Leila, it’s always useful for the finishing touch, thanks!
Sometimes these last touches make all the difference.
Thanks Leila! I like the creative food stuff too :)
The built-up is very logic and looks professional!
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 😀
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.
Thank you for sharing your tips
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 😋
Really enjoyed these tips Leila.
Glad you like it Graham.
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 # 2,3,8 are awesome tip...
I am in love with her brain...…...very talented and articulate mind.
Props Leila! Very nice!
Leila is the best youtube excel teacher, ever! Also v pretty :)
Great tips. Thanks Leila.
Love 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.
Great advices. Thank you
Just made Excel interesting, Thank you!
Very helpfull your video mam 🙏🏻
Pleased make more video about its topic please
Highly requested 🙏🏻
Great tips! Thanks for the video
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.
Excellente comme toujours
I learned a lot from you Leila, thank you so much indeed
My pleasure. Glad it's useful.
Great tips. Thanks Leila!
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.
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!
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!
Thank you !
Good tips, as always!
Very useful information nice video
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 :)
#2 is my favorite. I wasn't thinking about things this way. Thank you :)
Glad you found something useful.
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!
Nice tutorial mam, thank you, god bless you
My pleasure. Glad you like it.
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.
Thanks for video!
Good reminders
I like it , excel lady and thanks for sharing .
Glad to hear that :)
any video for creating excel for selling to customers with password protection and serial key?
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
Great value able info, as always. Good job!
Thank you. Glad you like it.
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!
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.
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).
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
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
can you please have a video on how to create racing bar graph in excel
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.
So smart thanks
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!
What content do you recommend to be tracked on the control sheet?
Thanks you. See you everyday.
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.
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.
I recommend learning Python and replacing all the spreadsheets (and coworkers) with a few lines of code
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.
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.
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
Mam how to cop with one or more circular errors in formulas?
Is it possible to create a work sheet that cannot be copy and email?
Lella .please make video about price comparison
in excel
Leila, what do you think about data science using Python? I think you can do amazing things combining your skills with Python.
Please madam Leila, how can I get videos about ACCA f1, 2 and 3?? Thanks
Vc é ótima Leila!
Thanks girl!
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?
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?
Are there any color pallets that are more suitable for people who are colorblind? I don't want to color code two groups different colors and have them look the same to someone who cannot differentiate. Any recommendations?
Tableau has a good article on this: www.tableau.com/about/blog/2016/4/examining-data-viz-rules-dont-use-red-green-together-53463
Also Excel's Accessibility feature checks color choice has well. You can find more information on that here: support.office.com/en-us/article/make-your-excel-documents-accessible-to-people-with-disabilities-6cc05fc5-1314-48b5-8eb3-683e49b3e593
I didn't really think about this until a few years ago I produced (what I thought) was an amazingly easy to use set of worksheets despite their complexity because of the intuitive and totally consistent colouring on both input and output tabs. Then I found the department head of the company was totally colour-blind. My tip for this, now is to add a step in production which turns all the colour off on my monitor and see how it looks - then print in all in grey scale and see how readable it is. If either fails that test, look for other colours. Printing all output in greyscale as a test is helpful any any event, there are still people who don't have colour printers or simply don't want to use expensive colour inks unnecessarily. So my additional tip would be ... make sure it looks OK in black and white.
Just professional lovely
Thanks
Kindly explain how we can connect multiple sheets to use in one Pivot table.
You need to check power query and power pivot functionalities
There’s a video on that topic on UA-cam.
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 need help in creating a worksheet
How do I use a math calculation within a dropbox. For example when I click on a dropdown list, then I choose a product name, (Tropical) I want that product name for (Tropical) to multiply =B14*19 and show this in a different cell. Know what I mean?
kindly tell some professional tips for making designs in excel sheet.
thanks...