Excel calendar templates - Microsoft Support
Browse through the calendar templates, choose an Excel calendar template that is best for you. Click the Download button on the template page, open the template file in Excel, and then edit and save your calendar.
Create a calendar by using a template - Microsoft Support
A template provides a basic calendar layout that you can easily adapt for your needs. You can download calendar templates with useful and creative themes when you click File > New in Excel. Select Search for online templates, type calendar, and select the magnifying glass .
Free weekly calendar templates on Microsoft365.com
With Microsoft calendar templates, you can find a weekly calendar in the format you want, and you can personalize it by adding photographs and important dates like birthdays. Here are a few examples of weekly calendars you can find in the Templates gallery:
Download free, pre-built templates - Microsoft Support
Find and download free templates to create documents like calendars, business cards, letters, greeting cards, brochures, newsletters, or resumes.
Create or edit .csv files to import into Outlook - Microsoft Support
For assistance importing a list of calendar entries into Outlook, see Import or export contacts in Outlook. Create a .csv file from another program or email provider. When you export your contacts from another program, for example, from Gmail, …
Create holiday decorations, cards, gift tags, and more
Discover what you can create for your holidays, right within Office. For more tips and tools, see the complete holiday template collection or watch holiday how-to videos. Create your own holiday cards. Make professional-looking, custom seasonal greeting cards.
Look up values with VLOOKUP, INDEX, or MATCH - Microsoft …
The VLOOKUP and HLOOKUP functions, together with INDEX and MATCH, are some of the most useful functions in Excel. Note: The Lookup Wizard feature is no longer available in Excel. Here's an example of how to use VLOOKUP. =VLOOKUP (B2,C2:E7,3,TRUE) In this example, B2 is the first argument —an element of data that the function needs to work.
Insert Julian dates (Functions) - Microsoft Support
Insert Julian dates (Functions) Applies To. A Julian date is sometimes used to refer to a date format that is a combination of the current year and the number of days since the beginning of the year. For example, January 1, 2007 is represented as 2007001 and December 31, 2007 is represented as 2007365. Note that this format is not based on the ...
Create a list of sequential dates - Microsoft Support
Fill data automatically in worksheet cells. Use AutoFill and Flash Fill. You can quickly create a list of dates, in sequential order, by using the Fill Handle or the Fill command.
Import data from data sources (Power Query) - Microsoft Support
Use Power Query in Excel to import data into Excel from a wide variety of popular data sources, including CSV, XML, JSON, PDF, SharePoint, SQL, and more.
Create a timeline - Microsoft Support
Get Microsoft timeline templates. When you want to show a sequence of events, such as project milestones or events, you can use a SmartArt graphic timeline. After you create the timeline, you can add events, move events, change layouts and colors, and apply different styles.