Next step is, say you want to select the whole bit of data that you've got. Mine's set to £s at the moment, yours might be $s. And that will put it to your default currency. So, 'Control', 'Shift', and hit '4' on your keyboard. Next cheat is, selecting all these, I want them to be currency because pretty much they're always a currency in Excel. If I type in 'Monday', or 'Mon', and I drag it out, it puts in the days of the week as well. That works the same for days of the week. And if I grab the bottom right square, and drag it across, Excel's pretty clever, and knows I mean this string of dates. Next tip, I'm going to type in 'January', or just 'Jan'. It allows me to put in either the rows or the columns. I need to add my headers, so I'm going to click in this top row here, and go 'Control', Shift', and hit '+'. So the first tip from our cheat sheet is to insert a column. Check out my full Excel course on īefore I forget, there's also a printable PDF version that you can print off, and stick next to your desk, and look all awesome. And this is our Microsoft Excel 2016 cheat sheet.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |