How to make a calendar in Excel 2010
Loading...
Uploaded by pegones1 on May 7, 2010
How to make a calendar in Excel adding color using conditional formatting.
Download the calendar Excel 2007 and 2010 template here:
http://cid-6b219f16da7128e3.skydrive.live.com/self.aspx/.Public/How%20to%20ma...
Download the calendar for Excel 2003 here:
http://cid-6b219f16da7128e3.office.live.com/view.aspx/.Public/How%20to%20make...
If you're interested about making a perpetual calendar, you could read my blog:
http://pedrowave.blogspot.com
Thanks for watching!
Link to this comment:
Uploader Comments (pegones1)
All Comments (25)
-
This is exactly what I'm looking for! Thank you so much!
-
Nice job and well done. But please make use of absolute and relative reference.
-
You have to use too many step to do that. Check my solution. Only one formula.
youtube.com/watch?v=n-_HXoWmuQ
E&feature=feedu -
Muy bueno, lo voy a intentar...!
-
Thx! awsome tutorial :)
-
OMG!! this is too fast
-
Its awsum .. :P thankyu .. Great job
-
Thank you very much.^.<
The frist time I did but it start date = 0 but now i get it, i can use for my job.
-
watch?v=V3Y-Rslmrz0 - Windows 7 Calendar
-
OR JUST DOWNLOAD THE FRIGGIN TEMPLATE
- Loading comment...
6:51
Part 2 - Fundamentals of Excel 2010by learnexcelfunctions24,036 views- 6:32
Part 1 - Fundamentals of Excel 2010by learnexcelfunctions37,882 views
- 9:56
How to Use VLOOKUP in Microsoft Excel 2010by QuePublishing69,110 views
- 4:25
How to Record a Macro in Excel 2007 For Dummiesby fordummies46,428 views
- 9:28
Excel Spread Sheet Basics - Using a Formulaby vhyndman562,822 views
- 8:14
Excel Basics #23: VLOOKUP function formulaby ExcelIsFun145,887 views
- 5:23
EXCEL perpetual calendarby BobZwick13,141 views
- 9:57
Create a Gantt Chart in Excelby COPADEGO12386,446 views
- 2:34
Automatically Copy Excel Data to Other Sheetby contextures40,753 views
- 8:33
Excel Magic Trick 564: Daily Gantt Chartby ExcelIsFun16,579 views
- 5:39
COMO HACER UN CALENDARIO EN EXCELby alexander285231,080 views
- 2:16
Excel Calendar Maker - Download for free at www.everydayexcelstuff.comby everydayexcelstuff23,457 views
- 10:55
Excel 2007: Working with Formulasby gcflearnfree174,219 views
- 10:40
How to Create a Master Schedule with MS Projectby dtarver285,873 views
- 8:52
Construction Schedule using Excel Templateby Queegebo07195,798 views
- 6:00
How To...Create a Basic Gantt Chart in Excel 2010by eoloughlin85,816 views
- 4:13
Excel Calendar Tutorialby magictama721,394 views
- 9:04
Creating a simple macro in Excel 2010 - Part 2by learnexcelfunctions17,953 views
- 4:40
How to Lock and Unlock cells in Excelby excelteacher56,672 views
- 9:29
Cómo hacer un mini calendario con festivos en Excelby pegones16,492 views
yea i knw that but like when im doing the B7 one, nothing comes up
carla90124cs 1 year ago
@carla90124cs
Write 2011 in B1 cell for this Happy New Year.
pegones1 1 year ago
@carla90124cs
What is your Excel version?
Download Excel file version and you could check your problem.
pegones1 1 year ago
@pegones1 mine is 2007
carla90124cs 1 year ago
@carla90124cs download this calendar in Excel 2007 following the links into the description of this video.
pegones1 1 year ago
Its good, but... Is it there another way to make it more easy?
kychico 1 year ago
@kychico yeah sure.
It's easier if don't use conditional formatting but the appearance is poor.
pegones1 1 year ago