Close
Time left to register for Excel Made Easy class
Mixed relative and absolute references

Mixed Relative and Absolute References Make Powerful Excel Spreadsheets Easy!

Leave a Comment / Intermediate

Mixed relative and absolute references are where you really start to become an Excel Rockstar. In my last video, I explained what relative and absolute references were. In part two, I show how you can mix them together to create large, powerful spreadsheets in seconds. As I explained in the previous video, a relative reference is when […]

Mixed Relative and Absolute References Make Powerful Excel Spreadsheets Easy! Read More »

Excel can do research for you! Find facts and build heatmaps in seconds

1 Comment / In-Depth Explanations, Intermediate

Did you know that Excel can do research? It can automatically find information for you. And it can also display information on maps. All in a matter of seconds. Excel can do research using Data Types Let’s say you want to do research about a country. Simply enter the country’s name in a cell. Then

Excel can do research for you! Find facts and build heatmaps in seconds Read More »