Excel Function Keyboard Shortcuts

Two posts into our run down of Microsoft Excel keyboard shortcuts and we’re getting stuck to the nitty gritty of functions, so now you have your navigation keyboard shortcuts and formatting keyboard shortcuts mastered you are prepared to take on some of Excel’s more specialised functionality and more advanced formatting.

Excel Keyboard

Using these key combinations you will be able to quickly summon functions which will hopefully be able to use to formulate, tabulate and graphically represent your data to give it meaning and context. Read the rest of “Excel Function Keyboard Shortcuts”

Microsoft Excel Formatting Keyboard Shortcuts

Excel Keyboard ShortcutsAfter the popularity of our previous Microsoft Excel shortcut tutorial post we have decided to follow it up so you can be introduced to using keys for performing formatting. Hopefully you are now using your mouse far less after using our navigation shortcut guide. If not, be sure to have a run through of it first.

Many of these shortcuts can be used across many programs within the Microsoft Office suite, so they can be invaluable to learn in order to speed up your regular day to day tasks. Read the rest of “Microsoft Excel Formatting Keyboard Shortcuts”

Joining Cells in Microsoft Excel 2007 Tutorial

This tutorial is compiled using Excel 2007 but should work on all versions of Microsoft Excel.

Often when using Excel you want to keep values in separate columns but also present them together. For example, when compiling a list of names you would want:

  • First Name
  • Surname
  • Full Name

You may also then want to add in numerical data as well. Let’s say this is for a customer list you may want customer ID and date contacted. Now your columns look like this:

Excel-joining-cells-tutorial

  • First Name
  • Surname
  • Full Name
  • Customer ID
  • Date Contacted
  • All Details

Immediately you realise that all the data in the ‘Full Name’ and ‘All Details’ columns is already entered. Instead of typing everything out twice – which often results in mistakes – you can use an Excel function to join multiple cells together. Here is how to join cells containing text and numbers: Read the rest of “Joining Cells in Microsoft Excel 2007 Tutorial”

Page 1 of 212