Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/

In this video I share 5 tips and shortcuts to help you read and write formulas in Excel.
Read full article: https://www.excelcampus.com/functions/formula-editing-tips

These tips will help save you time when writing or editing formulas.
Especially longer and more complex formulas with nested functions. This includes keyboard shortcuts and formula auditing techniques.

0:00 Intro
0:07 1. Enter & Edit Modes with F2
1:46 2. Absolute & Relative Reference with F4
3:14 3. Select Argument Text with Screentip Hyperlinks
4:44 4. Evaluate Formula Components with F9
5:58 5. The Evaluate Formula Window

At the end of the video I also explain why the function keys (F1-F12) might not be working for you, and how to fix it.

Please leave a comment below with any additional tips or shortcuts you use for working with formulas. Thank you!

Additional Resources:

Best Keyboards for Excel - https://www.excelcampus.com/keyboard-shortcuts/best-keyboards-for-excel-keyboard-shortcuts/

3 Tips for Writing Formulas with VBA Macros - https://youtu.be/ztj997dZl9k

Data Cleansing Challenge - https://youtu.be/uhzLYTupl9I

Convert Text to Time with Formulas - https://youtu.be/rqypEnQszPk