Archive for 'Tutorials'
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 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 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 StoryExcel Count
The Excel COUNT function counts the number of cells in a range that contain numbers. This function will not include blank cells or cells that contain non-numeric values (like words). To use the count function, type “=COUNT(A1:A10)” into the cell you want to hold the result. A1 to A10 is the range I chose, so you should substitute that with your own range.
Full StoryExcel Keyboard Shortcuts
Excel shortcuts can save you time when you are editing your spreadsheets. Keyboard shortcuts like ctrl-o to open a document, ctrl-n to create a new document and ctrl-s to save are common across all Microsoft Office programs, but there are some that are unique to Excel. Their use will help you get things done much quicker and will save you the hassle of searching for commands on the ribbon. It might take a little time to learn these shortcuts, but that time is well spent.
Full Story
