How would you like to MASTER graphic design by next week?
Click here to find out how
Featured Photoshop templates - professional ready to use designs for your next project
View all templates
Excel Time Tutorials
Excel Date & Time Functions
Dates and times are stored as numbers in Excel and count the number of days since January 1st, 1900.
Excel VBA Date and Time
This chapter explains how to get the year, month and day of an Excel VBA date, how to get the number of days between two dates, how to add a number of days to a date, how to get the current date and time, how to get the hour, minute and second of the current time and how to convert a string to a time serial number.
Excel 2003 Using Range Names
In this tutorial, you find out how to use all three of these procedures to save time in a worksheet that you access and edit on a somewhat regular basis.
Long Data Entries with AutoCorrect
AutoCorrect is Excel's attempt to save you time when doing data entry in a spreadsheet. It anticipates what you enter and, if necessary, corrects it or converts it into special types of data such as live hyperlinks and smart tags
Data Entries with Data Validation
This tutorial acquaints you with a very versatile and, in the long run, great timesaving feature that Excel calls data validation.
Sharing Workbooks on a Network
This technique covers the different ways you can share a workbook so that different people can edit its contents at the same time.
How to make True Time Scale Line Chart Using Scatter Graph
Adjusting time scale on x-axis in standard line chart could be a headache. It is kind of a trial and error process to make the time scale fit in, distribute the labels properly and last date being shown correctly at the end of x-axis.
Instant Range Formatting
Right after data entry comes formatting. When building a new spreadsheet, you don't stop to take the time to assign formats to the data entries you make (by typing dollar signs, commas, and the like).
Set your Spreadsheet Workspace
An Excel workspace (sometimes known as an arranged workspace) is really just a special file that keeps a record of all the workbooks open at the time you save the workspace.
Saving Time with Excel Add-ins
Excel add-in programs provide a quick-and-easy way to extend the basic features of Excel. Most of the add-in programs created for Excel offer you some kind of specialized function or group of functions that extend Excel's computational abilities.
Run Procedures on Protected Worksheets
Excel macros are a great way to save time and eliminate errors. However, sooner or later you might try to run your favorite Excel macro on a worksheet that has been protected, with or without a password, resulting in a runtime error. Avoid that problem with the following tutorial.
Automatically Add Date/Time to a Cell upon Entry
Enter a static date, or date and time, into a corresponding cell after data is entered into other cells.
Run a Macro at a Set Time
Many times it would be great to run a macro at a predetermined time or at specified intervals. Fortunately, Excel provides a VBA method that makes this possible.
Use CodeNames to Reference Sheets in Excel Workbooks
Sometimes you need to create a macro that will work even if the sheet names that it references change.
Connect Buttons to Macros Easily
Instead of giving every button its own macro, it's sometimes more convenient to create a single macro that manages all the buttons.