Making spreadsheets “dynamic” with cell referencing in Excel

By Enrique

Excel cell refrencingWhat is a cell reference? In Excel, it is when a cell derives its value based on the value of another cell. The below is a simple example of a cell reference. Note that the value in cell A3 is derived from the value in cell A1. How do you create a reference to another cell? In the cell that you want to create a cell reference, press the '=' key on your keyboard and then click on the cell that you want to reference.

Screen Shot 2020-02-06 at 4.01.36 PM

Why is cell referencing useful? Cell referencing makes your spreadsheet more dynamic. What does “making a spreadsheet dynamic” mean? In our above example, whenever you change the value in cell A1, the value in cell A3 also changes because of the cell reference that we've created. As an example, if we changed cell A1 to say "Hello", then the value in cell A3 will automatically update to "Hello". This example doesn't do the usefulness of cell referencing any justice, so let's use a more practical example.

Let's say we are calculating the total revenue (price per product multiplied by # of units sold) from selling a product. In our example below, instead of typing =3*200 in the total revenue column (Cell C8), use cell referencing instead. When you use cell referencing, the formula should reference the cell where the price is and then multiplied by the cell where the # of units sold is (see Cell C10 for the formula).

Screen Shot 2020-02-06 at 4.02.42 PM

Now that you've used cell referencing to calculate 'Total Revenue,' whenever you change 'Price per product' and/or ‘# of units sold’ (i.e. cell A10 and/or cell B10), the 'Total Revenue' cell automatically gets updated (see GIF below). The next time you hear a classmate, boss, co-worker, etc. to make a spreadsheet more dynamic, this is exactly what they are referencing (pun intended). The opposite of cell referencing is what you call "hardcoding" the values (i.e. how we calculated revenue in cell C8 above). I would stray away from hardcoding values unless absolutely necessary.


My challenge to you is to make an existing spreadsheet or an assignment that you have to complete dynamic (i.e. use cell references)!

Our team of business tutors is drawn from Harvard Business School, MIT’s Sloan School of Management, and Columbia Business School. We also hire Economics doctoral candidates at Harvard, MIT, Columbia, NYU, and Princeton. Some of our tutors have studied business concepts at the graduate level, top-tier financial institutions and management consulting firms.

Our tutors provide tutoring for all undergraduate business and MBA courses. Many of our business students use tutoring to address academic coursework, while others use it to prepare for the GMAT or for a challenging job.

Whether you are a college student, an MBA candidate or a business professional, we know that our students our busy, so in all tutoring, we take a highly structured and customized approach that will provide the most efficient and comprehensive service available.

Work with Enrique!

Check out some of Enrique's previous blog posts below!

4 Excel Quick Tips to Navigate Data Faster

Solving tough algebra problems with Excel’s Goal Seek feature




academics study skills MCAT medical school admissions SAT expository writing English college admissions GRE MD/PhD admissions GMAT LSAT chemistry math strategy writing physics ACT biology language learning graduate admissions law school admissions test anxiety MBA admissions homework help creative writing AP exams MD interview prep summer activities history academic advice philosophy study schedules career advice premed personal statements secondary applications ESL PSAT economics grammar law organic chemistry statistics & probability admissions coaching computer science psychology SSAT covid-19 legal studies 1L CARS logic games USMLE calculus dental admissions parents reading comprehension Latin Spanish engineering research DAT excel political science verbal reasoning French Linguistics Tutoring Approaches chinese DO MBA coursework Social Advocacy academic integrity case coaching classics diversity statement genetics kinematics medical school skills ISEE MD/PhD programs algebra athletics business business skills careers geometry mental health social sciences trigonometry work and activities 2L 3L Anki EMT English literature FlexMed Fourier Series Greek IB exams Italian PhD admissions STEM Sentence Correction Zoom amino acids analysis essay architecture art history artificial intelligence astrophysics biochemistry capital markets cell biology central limit theorem chemical engineering chromatography climate change clinical experience constitutional law curriculum data science dental school distance learning enrichment european history finance first generation student fun facts functions gap year harmonics health policy history of medicine history of science information sessions institutional actions integrated reasoning intern international students investing investment banking mathematics mba meiosis mentorship mitosis music music theory neurology phrase structure rules plagiarism poetry presentations pseudocode quantitative reasoning school selection sociology software software engineering teaching tech industry transfer typology units virtual interviews writing circles