Accounting Spreadsheet Lab: Application of fundamental spreadsheet concepts, principles, and commands in working with templates and modeling problems in accounting principles. CSU/UC Transferable. 2 units.
This lab requires computer time, and the amount of computer time necessary will be dependent on the previous MS Excel skill level of each individual student. My section of Acct 104 does not require a textbook. Concepts will be taught via lecture and handouts.
Course Syllabus & Calendar will be posted on Blackboard when the course opens. Lectures are linked below.
NOTE: Videos are either published to YouTube or Screencast. To view video, select the play arrow in the middle of the video frame (YouTube) or select the hyperlink (Screencast) below the video title.
Acct 104 - Summer 2022Course Overview
FILE & SHEET NAMING
R. Agatha Acct 104 - File and Sheet naming lectureFILE & SHEET NAMING
ABOSULTE CELL REFERENCES
R. Agatha Instructor - Absolute Cell ReferencesABOSULTE CELL REFERENCES
EXCEL BASICS A
Excel Basics Part A - Recorded June 2022EXCEL BASICS A
EXCEL BASICS B
Excel Basics Part B - Recorded June 2022EXCEL BASICS B
EXCEL BASICS C
Excel Basics C - Recorded June 2022EXCEL BASICS C
Basic Chart Lecture - Recorded June 2022CHARTS
Excel math basics lectureMATH BASICS
Conditional Formatting - Recorded June 2022CONDITIONAL FORMAT
Basic workbook creation and the use of the sort and filter features - Recorded June 2022WORKBOOK
Linking Sheets & FilesLINKING