9 Must Know EXCEL DESIGN Tips & Tricks

This video will show you how to properly design your Excel spreadsheets.
💡 THE DIGITAL ARCHITECT - My guide to reclaim your time, energy, and headspace by simply building order in your digital world.
leadavid.com/the-digital-arch...
💌 FREE TEMPLATES & BI-WEEKLY NEWSLETTER with practical tips on office organization, productivity, time management, and communication.
leadavid.com/?...
In this Excel tutorial, you will learn how to properly design your Excel spreadsheets to make a perfect impression!
The video will cover both, the structure and set-up of the Excel workboot to ease navigation and the design of the individual sheets, to make the best out of your data and analyses.

[@dusty975]

I just discovered your channel and have watched three of your videos -- all very useful! You have the gift of great "common sense", which is my highest compliment. I've used Excel daily for eons and thought I knew it all, but I picked up some very useful ideas from you. You have confirmed and enhanced some tips I've already used. For example, I will be using Conditional Formatting and hiding rows/columns even more. Thank you Lea!

[@LeaDavid]

Hi Dusty, thank you very much for your feedback and the compliment - makes me feel very honored! Glad you liked my videos. Make sure to subscribe because there will be much more in the future! All the best, Lea

[@darcyw156]

I have, consistently been impressed by the sheer amount of info you provide... for free... in your videos. Thanks Lea! You have upped my game in the office.

[@LeaDavid]

Hi Darcy, thank you very much for your feedback! Glad you could learn something new :) All the best, Lea

[@PatrickBijvoet]

Excel is one of my favorite programs. I followed an internal course and agree with your approach 100%. Sometimes I see presentations with excel which are so boring or confusing. I also see people who make screenshots of their excel and copy paste them in a powerpoint. I love to work with Pivot tables indeed on other tabs and color code them. The presentation I remove the gridlines and not used cells like you showed, but indeed keep the gridlines in the information when needed. I don't need powerpoint in that way. For me every presentation tab in Excel is like a slide in Powerpoint. A free tip for long term planning. I plan the exams for the college where I am a teacher now. I always begin at the end with the last crusial part of the planning and plan backwards to the present. So you better know how much time you need or have. Excel is so handy with those plannings. Besides the easy way to move parts of the planning, I can colorcode the different types of exams. I did not use the conditional formating to the extend it can. I learned that form you tonight. Thank you for that. Thank you Lea, for again an informative video. Grtz, Patrick.

[@LeaDavid]

Hi Patrick! Again, I really like how you always relate my tips or tricks to your daily work as a teacher. In particular, I liked when you said you treat each tab like a PowerPoint slide - that's truly how it should be done :) Well said and thanks for sharing, Lea

[@PatrickBijvoet]

@@LeaDavid I like sharing with you. Also because you always reply.

[@chinnababu9327]

Thanks for sharing Lea. It helps.

[@LeaDavid]

You are welcome, Chinna! Glad you could learn something new :)

[@line13sh]

Great video! You explain so well and your content is so useful! Im sure will chanel will grow!

[@LeaDavid]

Thank you so much, Carolina!

[@HuyTran-fv5gv]

Very helpful! Thank you so much!!

[@LeaDavid]

Glad it was helpful! :)

[@Michael.The.Money.Coach.]

Great post. Lots of great information. I’ll need to watch this again with lots of pauses. Ha. Thank you

[@LeaDavid]

Thanks, Michael! Much appreciated.

[@shadowandbosco]

Very helpful - I learned a lot - thanks for posting

[@LeaDavid]

You are welcome - thanks for your feedback and support!

[@gerbherb8215]

Instead of changing the number format, you can hide your numbers with Conditional formatting > Manage rules > Show bar only. This is easier, better understandable and quicker for most users.

[@LeaDavid]

Indeed, that's another option. Thanks for sharing!

[@shannonsmith8135]

How do you put cells in week/ month order on excell one drive?

[@LeaDavid]

Hi Shannon, not sure what you mean exactly. But one solution could be to start the week/month with a number and then sort the respective column in ascending/descening order.

[@brendamartinezgomez2297]

👏🏻👏🏻👏🏻👏🏻

[@LeaDavid]

Thanks, Brenda :)

[@BlackThyme]

hi, thanks for your useful videos. I have a question for this one though. I'm about to embark on a research project, my first, and I'll be using excel to store data (text) that I will subsequently upload into Nvivi or MAXQDA. Would all your tips on making an excel sheet look better for a human, make it impossible for software to read?

[@LeaDavid]

Hi Michelle, thanks for your feedback! Regarding your question: as so often, it depends. Unfortunatley, I do not know the programs you have mentioned but I assume, it might be difficult for the software to read the data, e.g., if you use the ability to show bar charts / other graphics instead of numbers. However, it shouldn't be a problem if you just name and color your sheets properly. I would suggest to do a super simple dummy spreadsheet and try out what you want to do and achieve to see if it works before you redo your entire data set. All the best with your project, Lea

[@BlackThyme]

@@LeaDavid thanks heaps, again for your great advice

[@hoperules8874]

sub'd & shared #WorthIt

[@LeaDavid]

Thank you so much!

[@gerbherb8215]

Please use the word sheets when you are talking about worksheets. Tabs are other things that should not be confused with them. Nice tip about section deviders, though 🙂.

[@LeaDavid]

Sure, next time :)

[@gerbherb8215]

Top rows for a titel is good, don't leave column A empty, that is just a girly thing to do and a waste of space (especialy when printing).

[@LeaDavid]

Individual style and preference I would say

[@tpmedzius]

Nobody has ever made a brain so hot 🔥 🥵 i love it . With all due respect 🙏

[@LeaDavid]

Thanks, Tommy!