So You’ve Bought Microsoft Excel Training … Now What?
Is what was sitting in the cell down here to alt to now I’m gonna actually highlight all this in all notice.
I’m seeing a that’s the surface that’s the facade you can Microsoft Excel Training look for some with some number formats you can look up into the formula bar and see what’s actually in.
The cell absolutely important if you’re going to be able to track down errors and not get tricked by number
Formatting and one of the most important Microsoft Excel Training types of number formatting to understand is date number formatting now let’s learn an important keyboard shortcut if you’re hard-coding dates into Excel say you’re doing transactions instead of typing out today’s date how about the keyboard Ctrl semicolon.
How to Outsmart Your Peers on Microsoft Excel Training
I absolutely love that now let’s do that again control semicolon I’m in a Ctrl-enter now look there that’s what it looks like I see on the surface of the spreadsheet an Microsoft Excel Training a slash of and.
If you look up to the formula bar hey it looks like that’s what’s in the cell but now the trick is is we can wipe away all number formatting apply general and you’ll see what’s in the cell what fully you’ve gotta be kidding.
Me what’s and I’m going to control Z because this is so important to know about general number formatting especially if you’re working with dates and Microsoft Excel Training times because number formatting gets applied when you don’t like it.
The keyboard shortcut is Ctrl shift grave accents or tildes of Ctrl shift grave accents or tilde and that applies the general format now that’s pretty weird but this is convenient when they first started making spreadsheets.