Learn To Use Excel Like A Pro Within minutes of opening this ebook you’ll be saying, ‘WOW! I didn’t know I could do that in Excel !’ If you’re anything like me, then you are probably pulling your hair out struggling to get your Excel projects finished on time. Your spreadsheets are getting bigger and [...] Read more »

VBA Excel Microsoft VBA (Visual Basic for Applications) is a computer language based on Microsoft Visual Basic. In the Excel VBA context, it allows you to write code that automatically performs actions on a workbook, its worksheets and their columns, rows and individual cells. To write this code you can use a programming environment called [...] Read more »

Templates – A Quick Way Of Creating New Workbooks To create a new workbook based on a template, click the Office button > New, and select a template category on the left of the New Workbook window. Categories to choose from are: Blank and Recent Use the blank template to create a workbook from scratch. [...] Read more »

Formatting In Excel 2007 Styles are used to alter the formatting of individual cells or a range of cells, whereas themes affect the styling of entire worksheets. But why bother styling your worksheet? Formatting is useful for helping the reader to read and understand the data in your workbook. The formatting tools in Excel 2007 [...] Read more »

Why Would You Need To Protect A Workbook? There may be times when you want to keep information out of sight and safe from modification. Imagine, for example, a worksheet that contains static data that is used in calculations. In this situation it’s advisable to hide and/or protect the data (and the formulas used, for [...] Read more »

Making Cells Active Before you can type data into a cell, you need to make it active. You can make a cell active by clicking directly in it or by moving the active cell left, right, up and down with the arrow keys on your keyboard. When you make a cell active, it becomes highlighted [...] Read more »

Assigning Names To Cells Names are far easier to remember than cell addresses, so it makes sense to assign a descriptive name to cells where possible. You can use a cell’s name to reference it in a formula you are creating, or to navigate to that cell by using its name. Also, the use of [...] Read more »

Mail Merge Overview To perform a mail merge you need a letter that will be sent out to different recipients and you need a list of those recipients. The list of recipients is created in Excel, whilst the letter and merge are created in Word. Mail merges are a real time saver if you plan [...] Read more »

Long Tables With Many Columns By default, when you scroll down a table of data, the colun headings you so lovingly crafted will disappear off the screen. If you have a small table with only a few columns, it will probably be easy to remember what data is held in each column and so it [...] Read more »

How To View Spreadsheets Without Excel 2007 If you don’t have Microsoft Excel 2007 installed, but you need to view an Excel spreadsheet, all is not lost. Enter Excel Viewer 2007. With this utility you can open, view and print Excel spreadsheets. Additionally, you can copy data from the excel spreadsheet to other applications. I’ve [...] Read more »