Skip to content

Excel for Engineers

  • Excel for Engineers – Home
  • Training
  • Blog
  • About
  • Contact
Excel for Engineers

Range Names with Formulas

Tips and Techniques

How to use Range Names Containing Formulas

ByRick May 9, 2023May 9, 2023

We’ve seen in our earlier post on Range Naming how you can give a cell or range of cells a range name, and then use that in formulas. However, there is a powerful yet little-known feature (little-known to me until recently, at least!) that you can create a range name that instead uses a formula….

Read More How to use Range Names Containing FormulasContinue

Project Planner: An Excel Gantt Chart using Conditional Formatting
Tips and Techniques

Project Planner: An Excel Gantt Chart using Conditional Formatting

ByRick May 3, 2023May 3, 2023

For this Project Planner, you will learn how to build an Excel Gantt Chart using Data Validation Message Help and Cell Shading using Conditional Formatting based on clever Range Name Formulas. Free Gantt Chart included.

Read More Project Planner: An Excel Gantt Chart using Conditional FormattingContinue

© 2025 Excel for Engineers - WordPress Theme by Kadence WP

  • Excel for Engineers – Home
  • Training
  • Blog
  • About
  • Contact