ReePrime
Blog DMC
MrExcel's Learn Excel #974 - NonContiguous Spearing

Hosted by Dailymotion. For legal issues report at the Copyright Center, report us on DMC, or use the Instant Removal tool.

MrExcel's Learn Excel #974 - NonContiguous Spearing

B
Bill Jelen

180 Views • Mar 19, 2009

Description

You may have seen how to create a spearing or 3-D formula such as =SUM(Jan:Dec!B3). In Episode 974, an amazing way to create a 3D reference to non-contiguous sheets. This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Keywords & Tags

#excel #business #accounting #spreadsheets #tutorial #technology #mrexcel #formula

More from User

02:34

MrExcel's Learn Excel #976 - Default Comment

Bill Jelen

03:19

Learn Excel 2010 - "Date Next to a Yes" #1474

Bill Jelen

07:51

Dueling Excel - "Rank Ties by Weight" #1473

Bill Jelen

03:39

Learn Excel 2010 – “Wrap Cells and Resize" #1472

Bill Jelen

02:08

Learn Excel 2010 - "Random with No Repeats" #1471

Bill Jelen

06:30

Learn Excel - "Copy Total to Weeks Macro": #1470

Bill Jelen

Related Videos

00:05

[PDF] EXCEL: A Beginner's Guide to Microsoft Excel (Excel Microsoft Excel Learn Excel Spreadsheets

Mingdestiny

00:05

Read EXCEL: A Beginner's Guide to Microsoft Excel (Excel Microsoft Excel Learn Excel Spreadsheets

Boziek

09:14

How to Use Vlookup to Merge Spreadsheet Data - Match Data in Google Spreadsheets and Excel

Alonza Darrick

01:26

How to Excel Delete Remove Duplicates and Duplicate Cells Data from Multiple Excel Spreadsheets

HotHotSoftware1

00:28

PDF Excel for Auditors Audit Spreadsheets Using Excel 97 through Excel 2007 Download Full Ebook

Reyna

03:09

How to extract e-mail addresses from Excel Spreadsheets (or multiple excel files)

HotHotSoftware1