MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Can Word Hyperlink to a Specific Sheet and Cell in Excel?


January 19, 2018 - by Bill Jelen

Can Word Hyperlink to a Specific Sheet and Cell in Excel?

Great question today from Selina:

Can a hyperlink in Word open a specific Excel file, jump to a sheet and jump to a cell?

Selina

The syntax is fairly tricky, but it seems to work.

Well, it may not work like you want it to work, but it nominally works.

continue reading »

More Reading


How to Pass Your Interview Excel Test

How to Pass Your Interview Excel Test »

January 17, 2018 - by Jennifer Feldman


Many job positions require candidates to have a mastery of Excel. Therefore, employers would like to test potential candidates during the interview process to ensure they can complete the Excel tasks that are required for the job. It is important to score high on your Pre-Employment Excel test and prove to you employer that you have what it takes to excel at the job.

VLOOKUP with Multiple Results

VLOOKUP with Multiple Results »

January 15, 2018 - by Bob Umlas


Suppose you want to produce a report from a set of data as if you filtered on a column. But what if you wanted a formula-based version of the same thing?

read more news »

Featured Products


Supercharge Power BI

Supercharge Power BI »


If you want to be able to supercharge Power BI, you need to learn to write DAX. Data Analysis Expressions (DAX) is the formula language of Power BI and Power Pivot for Excel. This book prompts the reader to put your new skills to the test. Written to give you hands-on practice using Power BI Desktop and writing DAX.

Power Excel With MrExcel - 2017 Edition

Power Excel With MrExcel - 2017 Edition »


This is the print book edition of "Power Excel with MrExcel - 2017 Edition" - by Bill Jelen. Master Pivot Tables, Subtotals, Visualizations, VLOOKUP, Power BI and Data Analysis.

100 Excel Simulations

100 Excel Simulations »


Covering a variety of Excel simulations, from gambling to genetics, this introduction is for people interested in modeling future events, without the cost of an expensive textbook.

Your Excel Survival Kit

Your Excel Survival Kit »


This book helps you realize that Excel is on your side. It can be your friend, not your enemy. If and when you upgrade your Excel skills you will experience many positives: you will learn to love Excel, you will learn how to use Excel to become an invaluable asset in your workplace.

Excel Video Medley

Excel Video Medley »


Excel Video Medley covers everything from Pivot Tables to VLOOKUP to VBA. Learn how to create scientific graphs. Use Excel for statistics.

Power Pivot and Power BI

Power Pivot and Power BI »


Power Pivot for Excel and its close cousin Power BI Desktop are Microsoft’s tightly-related pair of revolutionary analytical tools – tools that are fundamentally changing the way organizations work with data.

see more products »