From the course: Excel 2010 Essential Training
Unlock the full course today
Join today to access over 22,400 courses taught by industry experts or purchase this course individually.
Working with times and dates - Microsoft Excel Tutorial
From the course: Excel 2010 Essential Training
Working with times and dates
Now if you've completed the movie on absolute references, you should have a worksheet expense report that looks kind of like this. And what we want to do here is put in some dates and some time, so that if you open this up later you can see the date. So let's go down here to Cell A20. Now there's sort of two basic ways of putting in the date. One way is you could put it in so that it's permanent. It doesn't change, kind of like typing it in. The second way is putting it in as a function so that it will change depending upon when you open it. Now I really shouldn't say a function. There are two functions that will let you put in the date. So let's take a look at the first way just manually. All you have to do is press Ctrl+Semicolon. Semicolon is just right to the letter L on your keyboard. And you see it simply puts in the date. Now I'll just press Enter. Now that's just a timesaving step. So you don't have to type it in manually, which means that if you open it up tomorrow, next…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
Understanding formulas and functions4m 41s
-
Entering data in a worksheet3m 22s
-
Adding numbers manually5m 1s
-
Adding numbers using Sum and AutoSum6m 11s
-
Adding a whole worksheet1m 48s
-
Working with numbers in columns4m 53s
-
Preventing errors using absolute references5m 57s
-
Working with times and dates3m 7s
-
Using IF4m 49s
-
Using SUMIF and AVERAGEIF4m 15s
-
Naming and using cell ranges3m 45s
-
-
-
-
-
-
-
-
-
-
-
-
-