Creating Excel-Based Financial Statements
- General Troubleshooting
- Important: Make Note of Spreadsheet ID
- Microsoft 365 Is Required for This Assignment
- Step 01 of 40: Save Your Workbook
- Step 02 of 40: Go To Command
- Step 03 of 40: SUM and IF Functions
- Step 04 of 40: Conditional Formatting
- Step 05 of 40: Center/Increase Indent
- Step 06 of 40: Freeze Panes Feature
- Step 07 of 40: Format Column Headings
- Step 08 of 40: Adjust Row Height/Create Thick Outside Border
- Step 09 of 40: Center/Border/Underline Text
- Step 10 of 40: Comma Style Number Format & Setting Column Width
- Step 11 of 40: Inserting a New Row
- Step 12 of 40: SUM Function
- Step 13 of 40: SUMIF Function
- Step 14 of 40: Fill Without Formatting
- Step 15 of 40: Insert/Move New Worksheet
- Step 16 of 40: Transpose Account Listing
- Step 17 of 40: Remove Duplicates