ASK MAVEN: Creating Timestamps in Excel
Learn from Maven Analytics instructors as we explore some of the most interesting analytics & business intelligence questions our students have asked!
In this video, Maven Instructor Enrique Ruiz Tapia shows you how to create static timestamps in Excel using the NOW() function with logical operators and circular references. Buckle up -- this is a tricky one!
★★★★★ Looking for our best-selling Excel, Power BI, Tableau, and SQL courses?
Explore our top-rated Excel Specialist Path:
👉 https://bit.ly/3opcZw8
Sign up for a 100% FREE account at Maven Analytics (no cc required), and start learning today:
👉 https://www.mavenanalytics.io/
Follow Maven Analytics on LinkedIn for monthly challenges, free data sets, blog posts, and more:
👉 / 3551. .
Video Timestamps:
0:18 - Introducing the question
0:45 - The NOW() function
1:45 - The CTRL+; shortcut
2:13 - Intro to circular references
4:29 - Enabling iterative calculations
4:40 - Excel solution
