Tired of manually tracking your HOURS WORKED? In this video, I'll show you how to take CONTROL of your hours worked and streamline your processes with EXCEL. Learn how to use a Pre-Built TEMPLATE that will allow you to keep track of hours in a SIMPLE and EFFICIENT way.
CHAPTERS:
00:05 INTRO
00:35 Step #1 Write fields COMPANY, STORE and MONTH
01:02 Step #2 Set Grid with Columns
01:30 Step #3 Create MONTH in Dropdown List
02:41 Step #4 Write Year and Period
05:13 Step #5 Apply IF Function to Display the Days of the Month
07:28 Step #6 Apply BORDERS and Write Name of Workers
08:20 Step #7 Apply TEXT Function for Day Name
09:47 Step #8 Dividing Lines, Bottom Border and More...
12:05 Step #9 CONDITIONAL FORMAT for Business Days and Holidays
15:11 Step #10 Add Holidays
15:54 Step #11 Testing the MATCH Function...1 2 3
17:46 Step #12 Apply CONDITIONAL FORMAT with CONDITION
19:11 Step #13 Last-Minute FORMAT Changes
19:57 Step #14 Create Copy and Update Holidays
⬇ Link to Download TEMPLATE:
bit.ly/3YzALG0
📝 FUNCTIONS USED IN THE TUTORIAL...
1.END.MONTH (start_date; months)
Start_date: is the serial date number that represents the start date.
Months: is the number of months before or after the start date.
2.VALUE.NUMBER (text; decimal_separator; group_separator)
Text: It is the string that represents the number you want to convert.
3.TEXT (value; format)
4.MATCH(lookup_value; lookup_array; match_type)
lookup_value: is the value used to find the desired value in the array
lookup_array: is a contiguous range of cells containing possible lookup values
Match_Type: 1 - Less than, 0 - Exact match, and -1 Greater than
📮 VIDEOS YOU MAY BE INTERESTED IN EXCEL:
EPISODE 31:
• How to Make a TABLE in Excel and Apply FORMATS in Cells
→ • Cómo Hacer una TABLA ...
EPISODE 32:
• Learn EASY and from ZERO how to create your first MACRO in EXCEL
→ • Aprende FÁCIL y desde...
EPISODE 33:
• How to Calculate in #Excel the #SALE #PRICE Including the PROFIT MARGIN, either FIXED or VARIABLE
→ • Cómo Calcular en Exce...
EPISODE 34:
• 7 TRICKS TO BE A MASTER IN EXCEL Excellent TIPS that you must LEARN
→ • 7 TRUCOS PARA SER MAST...
Tags
----
excel
tutorial
excel guide
functions
Microsoft Excel
excel tutorial
know programs
tutorials
function if excel
function if
Add
conditional format
highlight
excel function yes
excel conditions
add cells
leaves
excel tutorials
yes in excel
format cells excel
FORMULA
template
hours worked
calculation of hours worked
hours worked format excel
hours
worked
Time control
control
🎹 Background Music from RU-vid Library:
Vibes Track - Beat Your Competition
Airborne - Quincas Moreira
Liquid_Time
🎶 Background Music Taken from FilmoraX:
natural way
Too Far From Home
I was Born Ready
amazed
#Template #CalculationOfHoursWorked #Excel2016
8 сен 2024