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.
Entering data in a worksheet - Microsoft Excel Tutorial
From the course: Excel 2010 Essential Training
Entering data in a worksheet
What we have in this worksheet is the beginning or maybe close to the ending of a simple basic expense report. And I want to show you few editing techniques before we go and use this. First thing you can see this Column A is not quite wide enough. Now you may know already but if you put your mouse pointer up here in the header in the border between Column A and Column B, when you get that two-headed mouse pointer, you can just sort of click and drag to the right. But how far you are supposed to go. Maybe you went too far, maybe not far enough. I am just going to press Ctrl+Z to undo. A little tip here is when you get that two-headed arrow there between two columns, if you double- click the column auto fits. So it's now as wide as the widest item in the column. That's pretty cool. Now, let's fill in the months. You may know already to auto fill, so if you click on January, put the mouse pointer on that little Auto Fill dot in the lower right corner. Make sure the mouse pointer is a…
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
-
-
-
-
-
-
-
-
-
-
-
-
-