Excel Features

Using Excel AutoComplete

March 21, 2017 0

When you type the first few letter of an entry into a cell Excel can complete the entry automatically using an option known as AutoComplete. It does this by building a list based on the […]

Excel Features

Create A Workbook From A Template

March 14, 2017 0

Creating an Excel workbook from a template helps save you time because you can use a ready made spreadsheet. Most templates can also be customised once downloaded and saved. HOW TO DOWNLOAD A TEMPLATE Step […]

Excel Features

Create Your Own Icons Using Wingdings

March 12, 2017 0

Wingdings & Webdings are symbolic fonts used in most of the Microsoft Office package programs including Excel. Microsoft Wingdings was released in 1992 and there are three versions of it: Wingdings, Wingdings2 and Wingdings3. The […]

Excel Features

Split Panes

March 7, 2017 0

A very handy feature in Excel is the ability to view more than one copy of your worksheet and to be able to scroll through each pane of your worksheet independently. You can do this […]

Excel Features

Using AutoFill In Excel

February 12, 2017 0

Introduction AutoFill can be used to enter text or numbers such as days of the week, dates, months, text or a series of numbers. Excel has some predefined lists like days and months but you […]

Excel Features

Create a Dynamic Data Validation List

May 30, 2015 2

When you create a Data Validation list in Excel it is locked to the range you select when you first create the list. There are couple of ways of making this list dynamic allowing your […]