Mastering MS Excel: Formatting
1. Basic Formatting Options:
Font Styles: Bold, italicize, underline.
Cell Alignment: Align text left, center, or right.
Text Color and Fill Color: Enhance visibility.
2. Number Formatting:
Currency Format:
$#,##0.00
Percentage Format:
0.00%
Date Format:
mm/dd/yyyy
3. Conditional Formatting:
Highlight Cells Rules: Set conditions for highlighting cells.
Data Bars: Visualize values with bars.
Color Scales: Apply color gradients based on values.
Icon Sets: Use icons to represent data ranges.
4. Cell Styles:
Predefined styles for titles, headings, etc.
Easy application for a consistent look.
5. Freeze Panes:
Keeps rows or columns visible while scrolling.
6. Data Validation:
Set rules to control data entered in cells.
Allow: List
Source: $A$1:$A$5
7. Tables:
Easily sort and filter data.
Apply predefined table styles.
8. PivotTables:
Summarize and analyze large datasets.
Drag and drop fields for quick insights.
9. Charts:
Visualize data with various chart types.
Customize charts for clarity.
=CHART(A1:B10, “Column”, “Sales Data”, “Month”, “Amount”)
10. Protecting Sheets and Workbooks:
– Password protect to restrict editing.
– Allow specific permissions to users.
