Quick Start Excel: Creating An Accountancy Spreadsheet

Take Excel Further - Create a fully functioning Accountancy Spreadsheet and Improve Your Excel Skills
4.8 (4 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
49 students enrolled
$19
$30
37% off
Take This Course
  • Lectures 29
  • Length 2 hours
  • Skill Level Intermediate Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 3/2016 English

Course Description

Microsoft's Excel 2016 for Windows is a very useful and powerful piece of software - but it can appear daunting if you have never used it before. Jennifer will teach you step-by-step how to create a detailed Accountancy spreadsheet which is suitable for anyone who wants to take control of their finances. She covers how to create and format Excel tables, enter data, create drop-down lists, formulas (such as IF and SUMIF Statements), use data from different tables and worksheets, absolute referencing and conditional formatting - which will get you started quickly.

By the end of this intermediate course, Jennifer gets you feeling confident about creating your a detailed Excel spreadsheet.

What are the requirements?

  • Microsoft Excel (2010 or newer)

What am I going to get from this course?

  • Creating and Re-naming Worksheets
  • Grouping Worksheets (Copying Formula Across)
  • Inserting Tables
  • Creating Drop-down Lists Populated With Data
  • Creating 'If Statements' (Formula)
  • Creating 'SumIf Statements' (Formula)
  • Using AutoSum
  • Using Absolute Referencing
  • Formatting a Worksheets Using Colours/ Borders/ Fonts
  • Assigning Cell Formats
  • Using Conditional Formatting
  • Filtering and Sorting Information
  • Using Shortcut Keys

What is the target audience?

  • Beginner
  • Intermediate

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction To The Course
Navigating The Udemy Dashboard and Viewing Settings
Preview
01:52
Introduce Yourself
01:15
Overview of the Spreadsheet
Preview
02:48
Naming and Saving an Excel Workbook
Preview
03:08
Section 2: Creating The Business Setup Worksheet
Creating Business Yearly Set Up Worksheet
Preview
07:17
Business Yearly Set Up Worksheet (Image)
Article
Section 3: Creating The First Calendar Month Worksheet
04:25

Lecture Objective: To set up the first month of your spreadsheet

I will show you how to: Creating a new worksheet (tab), rename the tab, create a title for the worksheet using a formula (referencing information from another worksheet) 

Creating and Formatting an Excel Table With Monthly Accountancy Headings
Preview
07:02
Creating the 'Totals' and 'Balances' Section
06:30
Creating a Reference Sheet for Drop-down Lists
05:07
Reference Sheet (Image)
Article
Data Validation - Populating Cells To Create Drop-down Lists
03:30
Inserting Formula - Bank Account Transactions (Nested If Statements)
07:16
Inserting Formula - Setting Up The Other Transactions'
04:42
Transaction Formula - For your reference
Article
Naming a Excel Table
01:34
Inserting Formula - Monthly Balances (Totals)
04:25
Inserting Formula - Running Balances (Using Data From Another Worksheet)
05:48
Inserting Formula - Total Monthly Incoming and Outgoing (SUMIF)
06:17
Tidying Up The Worksheet Before Duplication
05:03
Conditional Formatting - Changing Colour For Negative Numbers
02:55
Section 4: Creating Months 2-12
How To Duplicate a Worksheet
03:29
Amending Formula - Month-Year and Running Balances (Months 2)
06:54
Creating The Other Months and Tweaking Formula
06:30
Section 5: Setting Up The Mileage Worksheet
Setting up the Mileage Worksheet
08:01
Section 6: Setting Up The End Of Year Worksheet
Setting Up the 'End of Year' Worksheet
13:32
Inserting Formula - Income Table (SUMIF)
05:27
Inserting Formula - Outgoings Table (SUMIF)
03:18
Inserting Formula - Totals Table
04:37

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Jennifer Bailey, Experienced off-line and on-line tutor

I have been creating websites for several years now and have been using WordPress as well as Serif software. I enjoy building websites for other people as well as myself.

I achieved my BSc(Hons) in 1996, and then my Post Graduate Certificate In Education in 2001. I am also a member of the Institute for Learning.

Since qualifying I have worked in education with a spectrum of ages and abilities in colleges, the workplace and though private work.

I am a specialist in teaching English, Maths, ICT and Food Studies, both off and on-line. I also have experience in curriculum design, e-Learning and assessing.

I use technology wherever possible in my courses and I try and cater for all learning styles.I have tailored my on-line courses to promote learning using small bite-sized steps so that the learner can work at their own pace and not to be baffled by terminology, nor bored by waffle!

When selecting FREE video tutorials within each course

1. Select video

2. Hit play button

3. Go to bottom right corner of each video player and change resolution from 320 to 720HD for best viewing.

Ready to start learning?
Take This Course