Microsoft Office

Flash Fill can recognize a pattern from your example and complete the remaining values automatically.

• Enter the first example.
• Press Ctrl + E.
• Review the generated values before accepting.

Tip: Keep the examples clear so Excel can detect the pattern correctly.

COUNTIFS counts rows that meet multiple conditions at the same time.

• Select the range to count.
• Add each criteria range and criterion pair.
• Use absolute references when building reusable reports.

Select your data and press Ctrl + T to create a structured Excel Table.

Tables make filtering, formulas and future data expansion much easier.

Use built-in heading styles instead of manually formatting every heading.

• Apply Heading 1 to major sections.
• Use Heading 2 for subsections.
• Generate a Table of Contents from the styles.