Build Excel Spreadsheet for Work From Home Business Accounts

Create fully functioning Accountancy/ Bookkeeping Spreadsheet and Improve Your Microsoft Excel Skills

4.90 (52 reviews)

Udemy

platform

English

language

Microsoft

What you will learn

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

Why take this course?

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.

Screenshots

Build Excel Spreadsheet for Work From Home Business Accounts - Screenshot_01

Build Excel Spreadsheet for Work From Home Business Accounts - Screenshot_02

Build Excel Spreadsheet for Work From Home Business Accounts - Screenshot_03

Build Excel Spreadsheet for Work From Home Business Accounts - Screenshot_04

Reviews

Dakota

April 1, 2024

Great course. Jennifer is very knowledgeable in Excel, and explained thoroughly exactly what I needed.

Paige

December 31, 2022

Loved the course, it was super helpful to be shown how to do the complicated formulas specific to my needs!!

Kevin

June 3, 2022

I found the course very helpful and exactly what I was looking for and expecting. Thank you very much...

Fraser

September 14, 2021

I thoroughly enjoyed this course. Excel being such a huge program I found it difficult to find one on the subject of Book Keeping alone on Udemy. (Book Keeping was all I needed). Mrs Bailey is a very impressive teacher. My only difficulty arose when learning how to drag cells efficiently to make autofill work . Plus also I must keep pressing the return button to make the magic happen. I am so pleased to have chosen this course. Now I am confident enough to adapt it to the needs of our Florist Shop in the UK. Thank you again Mrs Bailey. Fraser, (Very Happy Student).

April

September 2, 2020

My name is April Phillips I reside in Grovetown, GA in the USA this is information needed to setup my home business.

Amit

August 29, 2020

The instructions are very clear but the course was not a good match for me as it was very basic. Moreover, lecture 31 to 38 was not really connected with the course.

Aiga

July 2, 2020

I did enjoy this course and have learned new skills which I will be able to use in my work practice in the future. Thank you

Masrura

February 5, 2019

The instructor helped me to create different tables for a small business such as to calculate profit and losses and to keep track all transactions. Would recommend.

Ellen

December 4, 2018

This course is exactly what I needed. I'm trying to track my personal and small business income and expenses, this seems to be spot on. Jennifer is an excellent teacher.

Vasu

April 9, 2016

An Excellent Course. Just started following. Jeniffer clearly explains every thing. Would recommend to any one, to follow the course.

Charts

Price

Rating

Enrollment distribution

Build Excel Spreadsheet for Work From Home Business Accounts - Distribution chart