Uploaded November 2025 | Updated November 2026, 2 days ago
MAKEARRAY function in Excel enables us to generate multiple values with just one formula. In this video, let me show you how to get stock prices for 5 stocks over a last 30 days using one single formula with MAKEARRAY function.
MAKEARRAY function in Excel enables us to generate multiple values with just one formula. In this video, let me show you how to get stock prices for 5 stocks over a last 30 days using one single formula with MAKEARRAY function.









![How to make an employee time tracker with Excel [Easy setup]
๐ฅCheck out Connecteam ๐ https://connecteam.cc/3QSAjlQ
~
Recently I needed to make a timesheet solution for my clients. I used Excel 365 with forms to create a quick & elegant application. It works on phones, web browsers and PC. You can track shift information and consolidate the data at the end of month for payroll processing.
In this video, let me present you with the solution and approach I took.
For an easier and error proof solution, do check out the sponsor of this video Connecteam here - https://connecteam.cc/3QSAjlQ
~
Timestamps for the video:
0:00 - Demo of my time tracking app
1:06 - Creating the app using Excel on web
1:52 - Setting up the data entry form
3:45 - Adding Branching Logic to show different options based on the data entered.
4:32 - Saving and publishing the form (app)
5:30 - Testing our app
8:12 - The problem with our solution
8:45 - A better time tracking solution (with Connecteam)
~ How to make an employee time tracker with Excel [Easy setup]](https://i.ytimg.com/vi/ZJLYMYhtDRc/mqdefault.jpg)
![This formula changes how you make dashboards [TOPN in One Cell]
TEXTJOIN magic for your next dashboard This formula changes how you make dashboards [TOPN in One Cell]](https://i.ytimg.com/vi/Zj4tQP-Cptc/mqdefault.jpg)