IS EXCEL 1 NOTES
That’s looking great! Here's a quick checklist and a few suggestions to make sure your Excel
workbook is polished and presentation-ready:
✅ General Formatting Checklist
Item
Description
All sheets ("Customers",
"Sales", "Products")
Sheet Titles
clearly named and
relevant
Worksheet titles merged
across appropriate
Merged & Centered
columns and centered
Title Rows
(e.g., "Customer Details"
over A1:F1)
Column headers are bold
Bold Headers
for visibility
Adjusted Column No clipped text—
Widths columns fit data well
Thin borders around
Borders
tables (use “All Borders”)
Light shading for header
rows or alternating row
Shading
colors (optional but
enhances readability)
Use Calibri, Arial, or
Consistent Fonts another clean font across
the sheets
Numeric values right-
Alignment aligned, text values left-
aligned, titles centered
📊 Functions Used
Worksheet
Function
Example
Avg. quantity sold or
Sales =AVERAGE(...)
revenue
Lowest/highest quantity
Sales =MIN(...) , =MAX(...)
or price
Number of entries in a
Customers =COUNTA(...)
column
Number of numeric
Products =COUNT(...) entries (e.g., quantity in
stock)
💡 Bonus Tips
• Use Conditional Formatting to highlight important values (e.g., top sales).
• Freeze top row for long tables so headers stay visible.
• Use Sheet Protection to avoid accidental editing once finalized.
