Join David Rivers for an in-depth discussion in this video Data referencing tricks in Excel, part of Weekly Office Workshop.
In Microsoft Excel, you typically won't have…every single bit of data sitting on one big sheet.…To stay organized, data should be split up…into separate sheets, but that doesn't mean…it all can't be linked together.…Today's workshop is all about linking data…in Excel, and referencing those cells.…Whether it be in a single workbook or across…multiple worksheets in a workbook,…or even across multiple workbooks.…Alright.…The most important feature of a spreadsheet…is the ability to reference the contents of cells…and their ranges, so let's start here in this…workbook called NOH Profits 2014.…
Notice we're looking at the main tab,…and there are different departments here,…and you can see we're tracking revenues…and expenses, giving us our profits.…We'll go back to the main tab.…Alright.…in the same worksheet, and we're going to do it…using the mouse, which will make it easy…to navigate, so in cell A11, let's go over here…and type in the word total.…I'm going to type it in all caps.…Press enter, and it's locked in.…Now, we're going to go next door to cell B11.…
Author
Updated
1/6/2015Released
7/8/2014Skill Level Appropriate for all
Duration
Views
Related Courses
-
Excel 2013 Essential Training
with Dennis Taylor6h 32m Appropriate for all -
Word 2013 Essential Training
with David Rivers5h 9m Appropriate for all -
Outlook 2013 Essential Training
with Jess Stratton3h 6m Appropriate for all
-
Weekly Office Workshop - New This Week
-
Welcome to the series1m 7s
-
-
Previous Episodes
-
Top 5 Excel shortcuts6m 9s
-
Organizing Outlook email11m 36s
-
Top 5 Word shortcuts10m 45s
-
Top 5 PowerPoint shortcuts10m 17s
-
Top 5 Outlook shortcuts12m 56s
-
Adding video to PowerPoint8m 42s
-
Top 5 Access shortcuts13m 11s
-
Formatting your Excel data9m 36s
-
Using Word templates11m 13s
-
Managing time in Outlook11m 20s
-
Managing projects with Project15m 33s
-
Using Lync11m 11s
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Data referencing tricks in Excel