Excel has three dimensions: rows, columns and worksheets. Most of us are familiar with how to use the powerful and indispensable Copy command to “copy” a formula across columns and down rows. In this article, we explore three tricks that can help you work across worksheets.
by Wayne Winston
When navigating the web, we have all clicked on blue hyperlinks that send us to another web page. In this article, we will show you how to use hyperlinks in Excel to create links in your workbook to web pages or locations in your current workbook. Our work is in the file...
Office 365’s new stock data types allow you to type a company name or stock ticker symbol in Excel and write formulas that extract information about the company to a different cell. The file Stockdatatypes.xlsx contains our work.
To begin we typed in the company names and ticker symbols shown...
Office 365’s new geographic data types allow you to type a location in Excel and write formulas that extract information about the location to a different cell. For example, if you enter “Paris” in cell E4, entering the formula “E4.Population” in a different cell will...
In our January and February 2019 newsletters we discussed
the OFFSET function. Recall that the syntax of the OFFSET function is
OFFSET(cell reference, rows moved, columns
As we explained in our last two
articles, we begin in the cell reference and based on the rows...
Forgot your password?
Username or E-mail: