Formatting data is important in Excel as it allows you to apply emphasis to information as well as clearly mark any headings and totals.
[ Video tutorial produced by Activia Training and purchased by ZandaX ]
The useful ones for your data are things like Control + B for Bold, Control + I for italic. Control + U for Underline. Alignment shortcuts don't work in Excel but work in any other programme. Centre your text with the use of Control + L for left, Control + E for Centre and Control + R for right aligned.
You can use Control + A to select your entire database and double click or press F2 to edit a cell's contents, this will also allow you to edit a formula.
To add a fill colour, click on the Home Ribbon and select the Paint Can icon. The Font group on the Home ribbon will allow you alter the Font type and the big A / smaller A icon allows you to adjust the size of your text.
Select a Cell and press Ctrl +1 to bring up the Format Cells dialogue box. This gives you access to a large range of formatting options broken down into the tabs covering Number, Alignment, Font, Border, Fill and Protection.
Quickly change Font in the font box via its drop down option and then use big A / smaller A icon to alter font size, or directly change the size. Ctrl B, I and U are Bold, Italic and Underline respectively.
Add Border lines via the Border box. You can click the little Font "break out" arrow to see more Font formatting options.
Use Ctrl Shift and F to bring up the Format Cells window and then you can see more format options like Strikethrough and Superscript or subscript options.
Want Better Excel Skills?
We have online courses with full 12-months' access. RRP from $49 limited time offer just $12.00
Get a solid foundation in Project software to create solid, resilient project plans.
You don't need prior experience with Project: just be able to use a PC with Microsoft Windows.
Microsoft Project Advanced
The Advanced course takes you to a level that will put you in complete control of your projects.
You should, of course, be fully conversant with the skills and concepts taught in the Introduction course.
Become a Visio master with our two intensive but very easy-to-follow CPD certified Microsoft Visio courses.