Once the basics are set in your Excel workbook, its time to add expense categories that you are anticipating during holidays. For myself, I have added Gifts, Travel, Entertainment, and Holiday Meals.

Susan Harkins shows you how to combine a function and conditional formatting to highlight weekends and holidays using Excel.

In this tutorial, we will explain how to create a bulleted list using the CHAR function in Microsoft Excel. Bullets are black circle points but can also be any symbol.

Learn how to create date lists in Excel using autofill, formulas, and advanced techniques. Save time and boost efficiency with these tips ...

Susan Harkins shows you how to visually identify holidays using Excel's conditional formatting feature.

You’ll need to create what Excel calls a named range of those holiday dates. Select the dates, then go to the Formula ribbon and pick Define Name (Excel 2010) or Defined Names > Define Name ...

How to return a sequence of dates in Excel Excel’s fill handle can generate a quick list of dates for you, but the list is static; you must create a new list if your needs change.

Drop-down lists in Excel let you create a list of valid choices that you can select for a given field. We'll show you how to use tables, named ranges, formulas, data validation, and table styles.

How to Create a Formula for Income & Expenses in Excel. Income and expense spreadsheets can be useful tools to help you see where your personal or business finances stand.