Archive by Author
Count The Number Of Cells With Text In Excel
If you ever need to count the number of cells that contain text in Excel, there is a very easy way to do it. You will need two basic functions:
Full StoryExcel Resources
There are a great many Microsoft Excel resources on the internet, and some are of a really high quality. Some even cater to Excel 2010 – the most recent version of Excel. To help you get to grips with this ubiquitous spreadsheet program, we’ve listed some of the better Excel resources here.
Full StoryMake A 2011 Calendar In Excel
Making a 2011 calendar in Excel 2010 is probably easier than you think. You don’t have to spend time getting the cell formatting right and you don’t have to figure out what Excel formulas to use. All you need to do is use an Excel Template.
Full StoryExcel Drop Down Lists
A drop down list in Excel presents a number of options for the user to select from. The advantages of eliciting a response from the user in this way are that:
Full StoryThe Quick Access Toolbar In Excel 2010
The quick access toolbar in Excel provides a selection of the more commonly used commands in one convenient place – the top left corner of the workspace (above the file tab).
Full StoryNumber Formatting In Excel
Number formatting in Excel is the process of controlling the appearance of numbers in your spreadsheets. Formatting numbers appropriately will help your readers to read and understand them better. Questions you need to ask yourself when dealing with numbers in Excel include:
Full StoryMicrosoft Excel Training
Lynda.com offer a range of high quality and professionaly produced Microsoft Excel Training videos. You can sign up in a matter of minutes and take advantage of the following benefits:
Full StoryExcel Save As PDF
Many people prefer the way that an Adobe PDF (Portable Document Format) document presents information to the way that a standard spreadsheet looks. Whereas in the past you needed to download and install a special add in to save a spreadsheet as a PDF (for example, the Microsoft Office 2007 Save as PDF Add-in), Excel 2010 comes with this facility by default.
Full StoryExcel DATEDIF
The DATEDIF function in Microsoft Excel calculates the difference, or interval, between two dates. This difference can be expressed in a variety of ways. The function takes the form
=DATEDIF(Date1, Date2, Interval)
where Date1 and Date2 are the two dates and Interval defines how the date difference should be returned. Interval must be nclosed in quotes like this:
Excel Offset
The Excel offset function is designed to return the contents of a range of cells that is offset from an initial range. The function takes the following arguments:
Full Story
