Introduction Introduction toto

Accounting Accounting 120120

Mr. Binet / Moncton High School

Class #10: Setting up the Balance Sheet in Excel,

1. Brief review from last class: Setting up and formatting the balance sheet.

2. An introduction to Microsoft Excel and it’s basic functions.

3. Reminder to finish Unit II, Assignment 1 + 2 (e-mail it)!

4. A quick balance sheet setup trial in excel.

In Today’s Class…In Today’s Class…

Samantha Palmer’s Balance SheetSamantha Palmer’s Balance Sheet

Notice the balance sheet is a formal representation of the fundamental accounting equation A = L + OE.

The Account Form Balance SheetThe Account Form Balance Sheet

Accounting is particular with formatting details. The following pages outline guidelines for properly preparing an account form balance sheet.

The balance sheet requires a three-line heading. The heading informs:

Who? -The name of the individual, business or organization for which the information is prepared.What? -The name of the financial report.When? -The date the financial report was prepared. The date must be recorded in full (e.g. September 30, 2003).

The heading is written one item per line and always in the same order: Who?-line 1, What?-line 2 and When?-line3.

The sub-headings Assets, Liabilities and Owner's Equity are underlined and centered in the appropriate column and row.

Formatting GuidelinesFormatting Guidelines

Microsoft Excel is the industry standard when it comes to spreadsheet software.

Spreadsheet software replaced hand-written ledgers in the early 1980s.

Excel is great for handling data, analyzing data, setting up specific functions, creating charts, acting as a database and much more.

For the purposes of this course, we will use Excel as a ledger to help record and keep track of our accounting transactions.

It’s important to understand the basics in order to fully be comfortable with the program into the future!

So… go ahead and open Excel by going to START > PROGRAMS > MICROSOFT OFFICE > EXCEL

Now follow along!

What is Microsoft Excel?What is Microsoft Excel?

Go to the O: drive and in the “BINET” folder find Unit II, Assignment #3. Open it, and immediately “SAVE AS” on to your “U” drive. Go ahead and complete (individually) the assignment.

Take your time and go over it slowly, this is a basis for the rest of the course! See if you can recreate the spreadsheet which is pictured in the file!

Login to your email (https://exchange.nbss.nbed.nb.ca). When you are finished, submit the assignment to me via e-

mail (adam.binet@nbed.nb.ca) with the subject “Unit II, Assignment 2”.

Your Turn! Excel Fun!Your Turn! Excel Fun!

Go to the O: drive and in the “BINET” folder find Unit II, Assignment #2. Open it, and immediately “SAVE AS” on to your “U” drive. Assignment #1 should be done by now too!

Go ahead and complete (individually) the assignment. Take your time and go over it slowly, this is a basis for the

rest of the course! Login to your email (https://exchange.nbss.nbed.nb.ca). When you are finished, submit the assignment to me via e-

mail (adam.binet@nbed.nb.ca) with the subject “Unit II, Assignment 2”.

Assignment Time!Assignment Time!