Handy guide to Excel

Please find our Handy Excel Guide, we hope you find it useful.

As we onboard more and more customers with office 365 we want them to get more productivity from these applications. We now offer Office 365 training and if you are interested in Excel training we are happy to help.

Handy Excel Guide

Excel is an extremely powerful application that can also be connected with Power BI for powerful reports and visuals.

If you’re just starting out with Excel, there are a few basic commands that we suggest you become familiar with. These are things like:

  • Creating a new spreadsheet from scratch.
  • Executing basic computations in a spreadsheet, like adding, subtracting, multiplying, and dividing in a spreadsheet.
  • Writing and formatting column text and titles.
  • Excel’s auto-fill features.
  • Adding or deleting single columns, rows, and spreadsheets.
  • Keeping column and row titles visible as you scroll past them in a spreadsheet, so that you know what data you’re filling as you move further down the document.

You may have heard of Pivot Tables and this is a useful way to reorganize data in a spreadsheet. Pivot tables will not change the data that you have, but they can help sum up values and compare different information in your spreadsheet, depending on what you’d like them to do.

From Wikipedia “Microsoft Excel is a spreadsheet developed by Microsoft for Windows, mac-OS, Android and iOS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. It has been a very widely applied spreadsheet for these platforms, especially since version 5 in 1993, and it has replaced Lotus 1-2-3 as the industry standard for spreadsheets”.

The application forms part of Microsoft Office and the most recent version is 2016.

Excel became the first spreadsheet to allow the user to define the appearance of spreadsheets (fonts, character attributes and cell appearance). It also introduced intelligent cell recomputation, where only cells dependent on the cell being modified are updated (previous spreadsheet programs recomputed everything all the time or waited for a specific user command).