Exceljet

Use the SEQUENCE function to generate a list of dates for the project duration.

Apply conditional formatting to highlight key milestones.

Link tasks to specific dates for automated scheduling.

Use the SEQUENCE function to list all dates in a given month.

Format the dates to create a calendar layout.

Add events and appointments to the calendar.

Implement conditional formatting to highlight specific dates or events.

Create a table with columns for date, data type, and value.

Use the SEQUENCE function to generate a list of dates.

Enter daily data into the table.

Use formulas to calculate daily, weekly, and monthly totals.

Use the PIVOTBY function to group sales data by region.

Calculate total sales, average sales, and other key metrics for each region.

Create a dynamic summary table to visualize the data.

Analyze trends and patterns in regional sales performance.

Use the Extract all partial matches guide.

Hook it up to some vlookups.

Create a partial name search function.