Uploaded July 2026 | Updated November 2026, 3 hours ago
Excel's SEQUENCE is a must have P(F)UNCTION for any serious spreadsheet user. In this video, let me share my favourite ways to use this amazing function.
๐ Sample file: chandoo.org/wp/wp-content/uploads/2026/07/sequence.xlsx
Where did the accountant who fudged their numbers go?
To a cell of course ๐
Excel's SEQUENCE is a must have P(F)UNCTION for any serious spreadsheet user. In this video, let me share my favourite ways to use this amazing function.
๐ Sample file: chandoo.org/wp/wp-content/uploads/2026/07/sequence.xlsx
Where did the accountant who fudged their numbers go?
To a cell of course ๐


![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)

![Whats the DIFFERENCE Between Data Engineer, Analyst, and Scientist?
Do you wonder what is the difference between a data analyst, engineer and scientist is? In this video, let me explain what these 3 roles are, what skills you need to get in, how the career path looks like, what is the typical salary and how the work feels. LETS GO!
โฑ IN THIS VIDEO:
0:00 - Data Engineer vs. Data Analyst vs. Data Scientist
0:35 - The rules
1:08 - What they do? DE vs. DA vs. DS
4:07 - Skills you need to be a Data Engineer
5:38 - Skills needed for Data Analyst
6:56 - Skills for Data Scientists
9:01 - Salaries for Data Engineer vs. Data Analyst vs. Data Scientist
11:24 - Career pathways for Data engineer / analyst / scientist
14:11 - People you work and how the work looks like
16:08 - Getting the skills
๐ WANT MORE?
If you want more, consider my paid courses. They are the best in the world when it comes to explaining complex data concepts in lucid and practical terms. Check out the courses using the links below and sign up today.
Essential Data Skills with Excel - https://chandoo.org/wp/excel-school-program/
Essential Data Skills with Power BI - https://chandoo.org/wp/power-bi-course/
๐บ DATA PLAYLISTS
Data Analyst vs. Business Analyst - What is the difference? - https://youtu.be/pIbL4aSUIas
Tech skills needed to be a data analyst: https://youtu.be/R3bZ0LLv3Fk
Data Analyst 3-month roadmap: https://youtu.be/x0Cd4TTOgwI
Day in the life of a Data Analyst: https://youtu.be/Lc55Y7Ai23Q
Top 10 Data Analyst interview questions: https://youtu.be/MX6Ee_ubE1s
7 critical mistakes to avoid in Data Analyst interviews: https://youtu.be/f7lBYh1_9BQ
5 Skills you need to be a GREAT data analyst: https://youtu.be/gVr9f1GJdZc
[Playlist] Data Analyst Skills: https://www.youtube.com/playlist?list=PLmejDGrsgFyDAWOAnEiK0P787q3grsk9R
[Playlist] Data Careers, Interview and Job Prep: https://www.youtube.com/playlist?list=PLmejDGrsgFyAw9Qya6SgrXfcfKCn7Va_D
~
#dataengineer #datascientist #dataanalyst
~
Data analyst: The glass is 50% full ๐ฅ
Data scientist: The glass is over fitting the water ๐
Data Engineer: Somewhere a pipeline must have broken. Only half the water is loaded ๐ค Whats the DIFFERENCE Between Data Engineer, Analyst, and Scientist?](https://i.ytimg.com/vi/ZyRH6FMcVlw/mqdefault.jpg)




