how do I make a year end worksheet in excel? are there formulas involved?

I'm so confused, please help

Downtown Cabinet Company of 1 + Q Y Draw V Erase Trial Balance Instructions: 11/30/20XX Cumulative for 20XX Client uses Accrual Method of Accounting. DR. CR. 1. Enter the trial balance into an Excel Spreadsheet. Cash 1140 2. Record adjustments through a General ledger. Create adjusting entry journals and T-Bar Notes Receivable 16000 accounts. Accounts Receivable 41000 3. Make an adjusting trial balance worksheet including the changes affecting the Balance Sheet and Income Statement. Merchandise Inventory 40000 4. Create a final Income Statement, Balance Sheet, and Statement of Retained Earnings for the Prepaid Insurance 960 month ended. Furniture and Equipment 67000 5. Extra Credit (5 points)- Create and Administration Page to organize all sheets of the Excel File. Accumulated Dep. - furniture and Equp. 12000 Administration page should link to sheet in Excel File. In addition, sheet should link back to Notes Payable 20000 Administration page. Accounts Payable 17500 6. Upload the Excel File on Blackboard Bonds Payable 30000 Note: Adjusted amounts should be linked to their corresponding financial statement. The idea is to Common Stock 50000 make all your changes and adjustments on the trial balance worksheet so that the financial statement . .. Retained Earnings 1/1/2016 16200 will automatically change accordingly. Dividends 2000 Sales 400000 Adjustments to the Trial Balance at 11/30/20XX Cost of Goods Sold 316000 Sales Salaries Expense 20000 1. Estimated bad debts is one-half of 1 percent of sales Advertising Expense 2200 2. Insurance expired for the month of November - $480 3. Interest accrued on notes receivable for the month of November - $725 Traveling Expense 8000 4. Downtown Cabinet Company purchased 10 computers for $15,000 on a no interest 5 year loan. Salaries, office and general 19000 Record this purchase and one loan payment was paid in the month of November. Telephone and Internet Expense 2600 5. The accounting department discovered an overpayment of rent in the amount of $1,000 Rent Expense 4800 6. Property taxes accrued for the month of November should be at $5,000 3300 7. Income taxes are estimated to be 22% of net income. Property Tax Expense Interest Expense 1700 Totals 545700 545700