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.

Figure B How to use the UNIQUE () function in Excel If you’re using Microsoft 365 or one of the 2019 standalone versions of Excel, you can quickly create a dynamic list using the UNIQUE () function.

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 ...

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.

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

Here's a quick tip for creating a Microsoft Excel drop down list from another tab.

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