WORKBOOKS & WORKSHEETS

Microsoft Excel Workbook Formats

February 26, 2017 0

In Excel 2007 Microsoft introduced a new file format, Office Open XML which allows other programs to easily work with Excel workbooks. Listed below is a list of the most common file formats you will […]

WORKBOOKS & WORKSHEETS

Pin A Workbook

February 25, 2017 1

A quick way of opening workbooks you use most frequently is to pin them to the Recent list that is displayed when you first start Excel 2013 or when you click FILE from the file […]

WORKBOOKS & WORKSHEETS

Change Excel Default Settings For New Workbook

February 14, 2017 2

Change Excel Default Settings For New Workbook DESCRIPTION When you create a new workbook in Excel the default font type, font size, worksheet view and number of new worksheets to display are all added. In […]

WORKBOOKS & WORKSHEETS

View Multiple Workbooks

January 5, 2017 0

This tutorial will show you how to quickly navigate between active workbooks or display multiple active workbooks on the same screen. In this example we have two active workbooks: Book1 and Book2. View Side by […]

Excel Topics

Recover Workbooks Using Versions

May 24, 2015 0

The Versions feature in Excel 2013 is a very useful tool as it can recover previous versions of a workbook if for example any of these situations occur. Your computer crashes. There‚Äôs a power cut. […]

WORKBOOKS & WORKSHEETS

Excel 2013 Worksheet Views

May 23, 2015 0

Excel 2013 has three main views Normal Page layout Page Break View In this lesson we will look at all three views. To access workbook views click on the View tab and the first group […]

Excel Topics

Excel 2013 Workbooks

May 16, 2015 0

Create A New Workbook The following guide will show you how to create a blank workbook. Click the File tab Select New from the left menu Click Blank workbook Add A New Blank Worksheet When […]

WORKBOOKS & WORKSHEETS

Organising Workbooks

May 5, 2015 0

Excel workbooks can accumulate very quickly and you can very easily start to lose your way so it is always good practice to be organised from the start. In this article we will provide a […]