Accounting Course for Students – Building a Basic Balance Sheet

Instructor:  Jed Guinto
Course Dates: Open-ended
Enrollment Dates: Enroll Anytime
Who can Enroll: Anyone
Course Language: English
Price:  FREE

About the Course

DESCRIPTION
I feel not enough people know how to balance their finances. They go day by day, living paycheck to paycheck not knowing where there money is going or coming from. In this course we go from the absolute basics of Excel (mostly for beginners) to doing more advance topics and functions. I won’t be leaving anything out! Most importantly, you’ll learn how to analyze basic trends to see whether your accounts are growing or declining. I've divided this course into 4 parts, 1 of which is still under production.

TARGET AUDIENCE
This was designed primarily for Accounting students but anyone looking to manage there finances better such as business owners, parents or the like are welcome to join in on the fun!

STRUCTURE
This is a very detailed course with almost 40 videos and over 1 hour of content.

DIFFICULTY
This is for all levels as I start with the fundamentals and move on to more advance topics. 

COURSE OUTCOMES

  • Excel fundamentals – control, font and formulas
  • Fill Handle
  • Freeze panes
  • Filtering
  • Formula names
  • SUM function
  • Graphs and charts
  • Indexing functions
  • Dynamic dates
  • Trend lines
  • Legends
  • Shape Effects

Course Structure

  • Part 1 - Getting Started
    • Introduction
      00:00:00
    • Creating, opening and closing a file
      00:00:00
    • Excel Navigation Basics - Scrolling and Zooming
      00:00:00
    • Case Study Introduction
      00:00:00
    • Typing Data into Excel
      00:00:00
    • Building a Table - Borders
      00:00:00
    • Building a Table - Fonts
      00:00:00
    • Column Adjustment
      00:00:00
    • Cell Colouring
      00:00:00
    • Text Justification
      00:00:00
    • Currency Text Format
      00:00:00
    • Introduction to Formulas
      00:00:00
    • Sum Function
      00:00:00
    • Saving the Changes
      00:00:00
    • Printing Setup
      00:00:00
    • Congratulations
      00:00:00
  • Part 2 - Filtered Projection
    • Introduction
      00:00:00
    • Building the Date Table using Fill Handle
      00:00:00
    • Defining Formula Names
      00:00:00
    • Freeze Pane
      00:00:00
    • Filtering Function
      00:00:00
    • Adding the Defined Formula Names using Filter
      00:00:00
    • Generating a compounding SUM function
      00:00:00
    • Basic Column Graph for Summary
      00:00:00
    • Basic Line Graph for Timeline
      00:00:00
    • Graph Instant Formatting
      00:00:00
    • Headings and Axis Labels
      00:00:00
    • Congratulations
      00:00:00
  • Part 3 - Advanced Graphs and Plots
    • Introduction
      00:00:00
    • Building a ‘Today’ table
      00:00:00
    • Using VLOOKUP
      00:00:00
    • Plotting the Today Date
      00:00:00
    • Today Date Plot Marker Properties
      00:00:00
    • Adding a Trendline
      00:00:00
    • Adding a Legend
      00:00:00
    • Changing Bar Chart Colour (Individual and Collection)
      00:00:00
    • Shape Effects
      00:00:00
    • Congratulations
      00:00:00

Instructors

Jed Guinto
Jed Guinto
Jed Guinto is the Co-Founder of Paperclip Learning. Currently pursuing his Ph.D. in Aerospace Engineering, he is also an avid educator with experience teaching primary students, high school students and undergraduate Aerospace, Civil and Mechanical Engineers. Over 44,000 students from over 170 countries have signed up for his courses.

This entry was posted in . Bookmark the permalink.