Archives

Power Query is a powerful business intelligence tool inbuilt in Excel, that allows you to import data from any number of sources, clean it, transform it, then reshape it accordingly. This once off created query can then be re-used over and over again by simply refreshing it.

If you are a MS Office user you may well have seen the following security message, also known as ‘The Mark of the Web’, appearing on your Excel, Access, Word, Viso and PowerPoint files. If you haven’t already you will likely start seeing them in the near future!

Cell/Range Names In Microsoft Excel, the Name Manager is used to name an individual cell or a range of cells. The Name Manager can be found on the Formulas Tab. These range names can then be used in formulas to make them easier to create and understand. Cell names are treated as absolute references and […]

What is a Style? A style is a set of formatting characteristics that a user can apply to paragraphs, characters, lists and tables. Styles allow users to format large documents quickly. For example, instead of taking three separate steps to format a title as 16 pt, Arial and centre aligned, a user could achieve the […]

Customise the Ribbon In Office 2013 you can tailor and personalise the ribbons so that they will appear exactly the way you want them. You can produce customised tabs and custom groups that will hold frequently used instructions. The user can add a command to an existing group or create a new tab and add […]

PINNING WORKBOOKS AND PLACES More efficient file and folder location is now found in the Recent option in the File ribbon. Each file and location is listed here and has a Pin icon to the right of it. Click on the pin icon (it turns blue) and the file/folder will remain permanently on your list. […]

The New Fluent Interface The arrow at the top of the File tab returns you to your open file.  WHAT IS NEW IN MICROSOFT OFFICE 2013 New features in Microsoft Office 2013, compared to 2003 and earlier versions, include • Live View • Backstage • Collaboration facilities • New Template Library • Improved Graphics and […]

Slicers in Microsoft Excel   Microsoft Excel 2010 and 2013 introduces Slicers which helps the user to quickly and simply filter their data dynamically on a pivot table or chart. Slicers will appear on the users screen as a floating box which can be moved around the screen to suit the user.   • Create or […]

Cell/Range Names In Excel 2010, the Name Manager is used to name cells or cell ranges.The Name Manager can be found on the Formulas Tab. It is possible to name a single cell or range of cells. These names can then be used in formulas to make them easier to create and understand. Cell names […]