Рет қаралды 108,038
In this tip we will see the step by step to create a CALENDAR in an easy and fast way, once finished we will only have to ENTER the Year and then select the MONTH and READY
We will have every day of the chosen MONTH...
CHAPTERS:
00:07 Intro
00:44 Step #1 Change Cell Size
02:27 Step #2 Write Name of the Days
02:59 Step #3 Cells Year and Month
04:11 Step #4 Function Enter DATE and MATCH
05:44 Step #5 Enter Function WEEKDAY
07:00 Step #6 Show in Calendar the DAY
08:59 Step #7 Aesthetic Changes to the Calendar
11:26 Step #8 Apply CONDITIONAL FORMAT
13:54 Step #9 Hide Help Cells
***** ***** ***** ***** ***** **
📮 PREVIOUS VIDEOS:
EPISODE 21
• 8 ADVANTAGES of Using PIVOT TABLES vs "NORMAL" TABLES with EXAMPLE in |EXCEL 2016-E21|
→ • 8 VENTAJAS de Utilizar...
EPISODE 22:
• IF FUNCTION with Several Conditions Tutorial in Spanish in |EXCEL 2016-E22|
→ • FUNCIÓN SI con Varias...
EPISODE 23:
• CROSS INFORMATION from Different SHEETS Almost Automatically in |EXCEL 2016-E23|
→ • CRUZAR INFORMACIÓN de...
EPISODE 24:
• 6 Simple Conditional Formats EVERYONE SHOULD KNOW in |EXCEL 2016-E24|
→ • 6 Formatos Condicional...
EPISODE 25:
• GANTT Chart MADE EASY in |EXCEL 2016-E25|
→ • Diagrama de GANTT HECH...
EPISODE 26:
• LOCK Cells and HIDE Formulas in |EXCEL 2016-E26|
→ • BLOQUEAR Celdas y OCUL...
***** ***** ***** ***** ***** **
Tags
----
excel
excel guide
excel formulas and functions
microsoft excel tutorial
how to use excel
Microsoft Excel
excel for beginners
learn excel
conditional format in excel
excel basics for beginners
how to use microsoft excel
excel tutorial for beginners
excel 2016
basic excel tutorial
excel formulas
excel tips
how to block
***** ***** ***** ***** ***** **
🎶 Background Music from KZbin Library:
When We Found The Horizon - Late Night Feeler
Airborne - Quincas Moreira
Space Lady - Slynk
Vibes Track - Beat Your Competition
Hot Coffee - Patrick Patrikios
***** ***** ***** ***** ***** **
🖐🏻 Click the LIKE button...
***** ***** ***** ***** ***** **
#Calendar #TutorialExcel #ExcelWithoutMacros