Footnotes are text displayed at the bottom of a page used mainly for references or comments. When footnotes are added to a document in Word they appear in the default font and size. For Word 2010 this is the Times New Roman font and size 10.
The footnote text and reference can be formatted to be consistent with the documents body text or to improve clarity. The footnote separator can also be changed or removed if no longer desired.
A constraint is a restriction on the start or finish date of a task in the project. Setting constraints is useful when external factors affect the start or finish date of a project. For example, vital supplies are not available to begin work on a task until the 10th September.
Every task in a project has a constraint applied to it already – the default As Soon As Possible constraint is applied when scheduling from the project start date, and the As Late As Possible constraint is used when scheduling from the project finish date.
These constraints are often not considered true constraints. They indicate that the task follows the working calendar, duration and task dependencies.
Worksheet protection is used in Excel to protect cells containing formulas, hide sensitive data and much more.
Unfortunately one of the problems that arises from protecting a worksheet is the inability to spell check a worksheet.
To be able to spell check a protected worksheet you need a macro to unprotect the sheet, perform the spell check, and then protect the sheet again. Continue reading
Think you know your Christmas movies? Why not try this Christmas movie quiz.
There are 20 movies to recognise from a picture. Select the film from the list below the picture. A running total is kept at the top of the sheet.
Download the Christmas movie quiz spreadsheet.
Working recently at a large Internet company they needed to find how many words were in a cell. This was because they had imported hundreds of thousands of keywords that customers had used to find their site through search engines.
To analyse this data they wanted to count how many words were in each cell containing keyword searches. Excel provides many text functions for managing and manipulating the text in the cells of your spreadsheet. The following formula did the job.
Blank rows in your Excel spreadsheet are undesirable and can make it difficult to work with. Because of this, Excel provides many ways that we can locate and then delete the blank rows.
These techniques can include sorting the list to group the blank rows together, filtering for blanks and using Go To Special to locate blank cells for deleting.
However these can be time consuming and may not be the best approach for you. For example, sorting the list will change the order of the list. You may not want this.
By creating a macro to delete the blank rows of a spreadsheet this process will be effortless, and can also be performed by anyone when the macro is made available with a button. In this Excel Macros tutorial we show you how.
Last week I received an email regarding a PDF to Excel conversion tool. I’m regularly asked about converting PDF docs to Excel so thought I would check it out.
It works very well and has the following benefits:
- 100% free
- Safe and easy to use
- Unlimited number of conversions
- Hassle-free: no need to buy or install anything on your computer
- Fast and accurate conversion results
You can learn more and test it here http://www.pdfconverter.com/pdf-to-excel-online-free/
I was asked today if it was possible to write an IF function that could insert a happy face if certain criteria was met. This would be used to show good performance. An unhappy face would be inserted for poor performance.
To insert a happy face in Excel we need to enter a capital J and format the cell in a Wingdings font. For an unhappy face, it’s a capital L formatted in the Wingdings font. Continue reading
Following my Excel lottery number generator video I have had frequent requests for a Lotto 6/55 version. So here it is.
This spreadsheet demonstrates some fantastic Excel techniques, and as always the file is unprotected so that it can all be investigated.
The following Excel features are used:
- The RAND function is used to generate the random numbers
- The RANK and COUNTIF functions are used to rank the random numbers from 1 to 55 for retrieval of the balls
- The Vlookup function is used to retrieve the ball numbers
- Some VBA is used to perform the formula calculations when a button is clicked (Manual calculation has been chosen over automatic for the workbook)
Download the Lotto 6/55 number generator spreadsheet.
Many people use Excel to create forms such as invoices, holiday requests and mileage claim forms. Excels’ various tools to enable calculations, powerful formatting and validation rules make it perfect for form creation.
This post provides a mileage claim form template that demonstrates many useful Excel features in all their glory. Please download and check it out.
Excel templates – Download the mileage claim form template.
The spreadsheet has both worksheet and workbook protection applied for improved functionality. It can easily be unprotected and explored though as no password has been used.
This spreadsheet makes use of the following Excel features;
- Data Validation has been used to create a drop down list of offices to select from, and also to select either own car or company car.
- A range name is used so that the Data Validation tool can access the list of office on the hidden sheet.
- The Vlookup function is used to return the distance in miles of the selected office
- If functions are applied to remove the #N/A error message from the Vlookup when the form is blank, and also to control when the calculation of expense is applied.
- Workbook protection is used to prevent the hidden sheet from being shown (however there is no password on the download so you can unhide it)
- Worksheet protection is used to lock the cells containing formulas and to generate a tab order making the form more user friendly to complete.