Uploaded November 2023 | Updated November 2026, 9 hours ago
๐ฅCheck out Connecteam ๐ connecteam.cc/3QSAjlQ
~
Do you run your own business? Then you need these 4 Excel Skills to SAVE TIME and do things IN STYLE.
These are,
1) Setting up Tables
2) Using with Templates
3) Working with your Data
4) Using Pivots
โฑ Video topics:
==============
0:00 - 4 Essential Excel Skills for Every Entrepreneur
1:04 - Setting up a check list with Excel
3:53 - Using built-in templates to save time
5:25 - Making your OWN templates in Excel
6:07 - Filtering data you need
7:40 - Basic Excel formulas
8:57 - Work faster with Connecteam
10:00 - Using Pivot Reports to answer business questions.
12:08 - But what if Dwight wants a bit more?
~
LEARN MORE
============
๐ฅ CONNECTEAM for Managing your Small Business - connecteam.cc/3QSAjlQ
Top 10 Excel formulas - youtu.be/HgNCvd8IbSc
Top 8 Excel Pivots - youtu.be/aofsdpjvK7w
How to use Excel in 30 minutes - youtu.be/F7aPazuS8QY
Create a beautiful tracker with Excel - youtu.be/e0s9xdx5FF8
Create a project plan with Excel - youtu.be/W7NVKjg56ZY
Full Excel Course - chandoo.org/wp/excel-school-program
~
Have a beautiful day ๐๐ผ๐
๐ฅCheck out Connecteam ๐ connecteam.cc/3QSAjlQ
~
Do you run your own business? Then you need these 4 Excel Skills to SAVE TIME and do things IN STYLE.
These are,
1) Setting up Tables
2) Using with Templates
3) Working with your Data
4) Using Pivots
โฑ Video topics:
==============
0:00 - 4 Essential Excel Skills for Every Entrepreneur
1:04 - Setting up a check list with Excel
3:53 - Using built-in templates to save time
5:25 - Making your OWN templates in Excel
6:07 - Filtering data you need
7:40 - Basic Excel formulas
8:57 - Work faster with Connecteam
10:00 - Using Pivot Reports to answer business questions.
12:08 - But what if Dwight wants a bit more?
~
LEARN MORE
============
๐ฅ CONNECTEAM for Managing your Small Business - connecteam.cc/3QSAjlQ
Top 10 Excel formulas - youtu.be/HgNCvd8IbSc
Top 8 Excel Pivots - youtu.be/aofsdpjvK7w
How to use Excel in 30 minutes - youtu.be/F7aPazuS8QY
Create a beautiful tracker with Excel - youtu.be/e0s9xdx5FF8
Create a project plan with Excel - youtu.be/W7NVKjg56ZY
Full Excel Course - chandoo.org/wp/excel-school-program
~
Have a beautiful day ๐๐ผ๐








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