For titles across the top I like to use Center across selection. I would block c3:g3 and choose format Center across selection. That way it doesn't interfere with the automatic column width when you double click on the right side of the top column. I also hide columns or rows using Group rows or Group cells. Then if I need to look at something that is hidden I can either click the plus above the hidden cells to expose them or the 2,3,etc at the top left to expose all hidden cells.
@HowToAnalyst2 жыл бұрын
I typically set the print area (page layout -> print area -> set print area) before sharing. People used to print a lot when everyone was in the office 5 days per week. It's probably still a good idea but I don't think people are printing as often.
@TigerSpreadsheetSolutions2 жыл бұрын
Interesting point Pete. I personally hardly ever print, but I know some people who do. Accountants seem to like printing :-)
@TSSC2 жыл бұрын
For consistent formatting: 1. Change the default font (no need for per cell font selection). 2. Use Excel tables to format tabular data (quick and enables simplified referencing). A custom style can be created if you don’t like the built-in ones and the workbook contains many tables for which you want consistent formatting. 3. Use cell styles (define/redefine if needed). 4. If printing: define print area, header/footer, and related properties.
@TigerSpreadsheetSolutions2 жыл бұрын
Good ideas - personally I think tables complicate rather than simplify references
@stevenlagoe78082 жыл бұрын
Excellent tips, Chris. Using shades of the same colour - I like it! I find when I'm designing a spreadsheet I tend to concentrate on the 'mechanics' of it too much and don't pay enough attention to how the front end looks. After-all, it's my baby, I've built it, I've spent hours staring at the bloody thing, I know what the output looks like and where to look for the data I need. It’s all obvious to me. So, with a spreadsheet to be used solely by me I would pay almost no attention to formatting. WRONG! I’ve tripped myself up so many times by returning to one of my spreadsheets that I’d written ages ago, and…I have to spend half an hour trying to work out where everything is! From now on I’m going to constantly ask myself the question: ‘Is what I’m doing 'visually obvious' to the untrained eye?’ Thanks again. p.s. I’m getting back into keyboard shortcuts, thanks to you. Frustrating to begin with but once you get used to them they’re so much cooler than using the mouse!
@TigerSpreadsheetSolutions2 жыл бұрын
Great comment, Steven! You are your own toughest client
@laramccully327217 күн бұрын
Thank you so much for this video. I LOVED everything you showed here.🙏🏼😊
@alanbosher27282 жыл бұрын
Chris. You talk a lot about keyboard shortcuts. I find right click and context menus a very efficient tool e.g. to insert, delete, hide, unhide rows and columns.
@TigerSpreadsheetSolutions2 жыл бұрын
Alan - it's a personal thing perhaps but I just find using the keyboard is much faster than the mouse ...
@alishainc Жыл бұрын
this is gold, I'm lost on excel
@TigerSpreadsheetSolutions Жыл бұрын
Welcome to the channel, Alisha - we're releasing a follow-up to this video this week or next ...
@brucesagide44922 жыл бұрын
Excellent. Though I personally find it very disappointing how uneasy it is to work with Freezing and Unfreezing. For instance in this case, if the table is created a few rows and columns into the spreadsheet, it removes the ability to freeze the first rows and columns in the table. If Microsoft would develop more flexible freezing capabilities, navigating through large spreadsheet content would be majorly efficient, while at the same time allowing for major formatting possibilities.
@TigerSpreadsheetSolutions2 жыл бұрын
Thanks Bruce - I think you're talking here about a kind of 'layered' freeze pane capability. Sounds cool!
@trustabyss2 ай бұрын
I keep my spreadsheets simple. Printer toner isn't cheap, and to add color, gets expensive. My preference is a simple black and white table with bold headers and bold total row. Everything else is regular font for the data.
@TigerSpreadsheetSolutions2 ай бұрын
Yes - when you factor in printing, the strategy changes. Thanks for watching!
@AhmadKadi102 жыл бұрын
Great tips, I wish you mentioned how to do each action by choosing from the menu not just by shortcuts..
@TigerSpreadsheetSolutions2 жыл бұрын
Hi Ahmad - I tried to include as many explanations as possible, whilst keeping the video short. If it wasn't clear, Google will help you find the answers. Good luck!
@mason87147 ай бұрын
i was about to say the same. great video but far to many short cuts :) am working on the web version and alot of them dont work :) but thanks for all the tips
@henrikijonkoping46942 жыл бұрын
Good, this took me to the next level. Have a nice weekend!
@TigerSpreadsheetSolutions2 жыл бұрын
You too, Henrik!
@orlahastings4563 Жыл бұрын
This video just popped up on my feed. Really helpful tips thank you. Will be checking out your channel!
@TigerSpreadsheetSolutions Жыл бұрын
Thank you Orla and welcome to the channel - we have a whole playlist just on Excel formatting, enjoy!
@annog6673 Жыл бұрын
I adviseagainst hiding columns and instead group them (in the data tab). That makes it more obvious. (Except of course the columns outside the model for ctr + r action).
@TigerSpreadsheetSolutions Жыл бұрын
Interesting - I don't personally like the additional complications on the interface that grouping creates with the buttons etc.
@Belligol_Rma55 ай бұрын
Excellent video learnt a lot and thanks for clearly explaining.
@TigerSpreadsheetSolutions5 ай бұрын
It's a pleasure and welcome to the channel - see you in another video in this series!
@loganpedroza7493 Жыл бұрын
Awesome video! Thank you so much for sharing these tips!
@TigerSpreadsheetSolutions Жыл бұрын
Thanks Logan and welcome to the channel!
@bleuaqua81029 ай бұрын
I needed this, thank you!
@TigerSpreadsheetSolutions8 ай бұрын
You're welcome - don't miss the next video in the series!
@radheshyamthakur2 жыл бұрын
Really nice shortcuts in full action
@TigerSpreadsheetSolutions2 жыл бұрын
Thank you - shortcuts are so important for efficient Excel usage, I highly practising them ...
@saurabh9416Ай бұрын
Thank you so much.
@tyroneashby54202 жыл бұрын
Another brilliant video ,thanks Chris
@TigerSpreadsheetSolutions2 жыл бұрын
Appreciate it, Tyrone!
@dattallfoo Жыл бұрын
Love it, thank you!
@TigerSpreadsheetSolutions Жыл бұрын
Thank you and welcome to the channel!
@Atarian65028 ай бұрын
Q: Which of these spreadsheets would you rather work with? A:The FIRST one. Definitely the first one! The second one looks much nicer, agreed. But that works for the final presentation of the data. Not for working with the data. Absolutely not :) Nice tips by the way. Thank you!
@TigerSpreadsheetSolutions8 ай бұрын
Interesting perspective, thank you! And thanks for watching ...
@Anu-zq8mu2 жыл бұрын
Thanks for this brilliant video sir.
@TigerSpreadsheetSolutions2 жыл бұрын
Welcome to the channel
@TigerSpreadsheetSolutions2 жыл бұрын
🔥WATCH NEXT 🔥14 MORE Excel Formatting Tips kzbin.info/www/bejne/rqnblIKBe62ifKM
@danielhampton48442 жыл бұрын
HOW CAN I ADD A CHARACTER (SPACE OR LETTER) AFTER EVERY NUMBER IN A MIXED JUMBLE OF LETTERS AND NUMBERS IN A SINGLE CELL?
@TigerSpreadsheetSolutions2 жыл бұрын
By 'parsing' out the contents of the cells into single cells, then concatenating them together kzbin.info/www/bejne/eHmbZplomt5riM0
@a.caglar Жыл бұрын
It turned out better than the first one, but it could have been much better.
@TigerSpreadsheetSolutions Жыл бұрын
Great - see the next video in the series for more ideas!
@britt6579 Жыл бұрын
This was incredible! So easy to follow and so informative. Thank you!
@TigerSpreadsheetSolutions Жыл бұрын
It's a pleasure and welcome to the channel!
@jarlathmcardle33598 ай бұрын
The training is way to quick in the explanations as for example the column header description action - " ALT H FS9 " what ?
@TigerSpreadsheetSolutions8 ай бұрын
It's not 'training' as such - it's a KZbin video which is why the pace is fast. Google will give you a list of Excel keyboard shortcuts if you did not pick them up. Thanks for watching and good luck with your Excel learning!
@tommyharris58172 жыл бұрын
I hate Arial; Calibri is more relaxed and just looks more professional
@TigerSpreadsheetSolutions2 жыл бұрын
It's a matter of opinion, I suppose. But, I think changing the default font does show you've made some additional effort.
@laramccully327217 күн бұрын
I hate both of those fonts.😂 On a quest to find the best font to use in Excel! (For my personal taste)😉
@dalpati12 жыл бұрын
good tips to implement
@TigerSpreadsheetSolutions2 жыл бұрын
I hope these help you ...
@peerawatkupatilertpong8793 Жыл бұрын
Nice tips
@TigerSpreadsheetSolutions Жыл бұрын
Thank you and welcome to the channel
@tryme11311 ай бұрын
beautiful
@TigerSpreadsheetSolutions11 ай бұрын
Thank you and welcome!
@ARoseReigns27 күн бұрын
God i hate using excel with a passion and my job requires me to use it for any and everything, this is what i needed. Still hate it though
@VishalChakravartyDevil2 жыл бұрын
Amazing
@TigerSpreadsheetSolutions2 жыл бұрын
Thanks, Vishal!
@s_mblogs2250 Жыл бұрын
Supperrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr video
@TigerSpreadsheetSolutions Жыл бұрын
Weeeeeeeelcome to the channel!
@fitnesstips_Navid2 жыл бұрын
Very confusing when you mention the shortcuts!
@TigerSpreadsheetSolutions2 жыл бұрын
I think shortcuts are an important part of Excel practice because they really speed up your operation of Excel, that's why I mention them
@EverMoreDesign5 ай бұрын
I disagree. I loved learning new shortcuts. To be a power user in ANY software application you must learn keyboard shortcuts.
@VishalChakravartyDevil2 жыл бұрын
Data cleaning please
@TigerSpreadsheetSolutions2 жыл бұрын
We have a series on data cleansing with Excel VBA from 2016
@xenna114310 ай бұрын
Real designers would NEVER use Arial!!! YUCK!!!
@TigerSpreadsheetSolutions10 ай бұрын
I'm a spreadsheet developer ...
@EverMoreDesign5 ай бұрын
Not true I use them all the time. One of my favorite fonts.
@lissilva10 ай бұрын
Too fast! Ugh🙄🤦🏻♀️
@TigerSpreadsheetSolutions10 ай бұрын
0.5 speed?
@EverMoreDesign5 ай бұрын
I disagree, you can play back slower .5 or even .25. Most tutorials are way too slow and I have to run them at 1.75 or even 2.0 speed. Good job!
@ChrisBanda3 ай бұрын
He flies through the keyboard shortcuts because the're second nature to him, most of us beginners and casual users do not have that level of dexterity lol