Build Excel Spreadsheet for Work From Home Business Accounts

Name: Build Excel Spreadsheet for Work From Home Business Accounts
Rating: 4.7 (57 reviews)

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

Created byJennifer Bailey

Last updated 2/2019

English

What you'll 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

Course content

9 sections • 39 lectures • 2h 34m total length

Navigating The Udemy Dashboard and Viewing Settings5:16
Introduce Yourself1:22
Overview of the Accountancy/ Bookkeeping Spreadsheet2:36
Name and Save a Microsoft Excel Workbook2:57

Inserting Formula - Setting Up a New Excel Worksheet With Titles4:14
Create and Format an Excel Table6:52
Create a Totals and Balances Section6:24
Create a Reference Sheet in Excel (to Populate Dropdown Boxes)4:57
Reference Sheet (Image)0:12
Data Validation - Populating Cells To Create Drop-down Lists3:18
Set Up Bank Account Transaction Formula (Nested IF & Absolute Referencing)7:06
Inserting Formula - Setting Up The Other Transactions4:29
Transaction Formula - For your reference0:14
Name an Excel Table1:24
Set Up Monthly Balances (Insert Total Row into a Excel Table)4:15
Set Up 'Running Balances' in an Excel Worksheet5:38
Total Monthly Incoming and Outgoing (SUMIF)6:07
Tidy Up The Worksheet Before Duplication4:52
Conditional Formatting - Changing Colour For Negative Numbers2:42

#1 Add Up a Column or Row With Shortcut Keys1:08
In this Quick Start Tip video I show you how to total a column or row using keyboard shortcut keys (Insert Sum).

If you are using a Mac then please use Command + Shift + T instead of Alt + =.
#2 Insert Current Date and Time Using Shortcut Keys0:52
In this Quick Start Tip video I show you how to total a column or row using keyboard shortcut keys (Insert Sum).

If you are using a Mac then use Ctrl + SEMICOLON (;) for date (same as in the video) and' Command + SEMICOLON (;) for time.
#3 - Renaming and Changing Colour of Worksheet Tabs2:19
#4 Change The Colour of a Worksheet's Gridlines2:34
#5 Change Colour of Text and Cells In Microsoft Excel Worksheets2:07

Requirements

Microsoft Excel (2010 or newer)

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.

Who this course is for:

Beginner
Intermediate

Build Excel Spreadsheet for Work From Home Business Accounts

What you'll learn

Explore related topics

Course content

Introduction To The Course4 lectures • 12min

Creating The Business Setup Worksheet2 lectures • 7min

Creating The First Calendar Month Worksheet15 lectures • 1hr 3min

Creating Months 2-123 lectures • 16min

Setting Up The Mileage Worksheet1 lecture • 8min

Setting Up The End Of Year Worksheet4 lectures • 26min

Trouble Shooting/ Student's Questions4 lectures • 12min

Quick Start Tips and Shortcuts5 lectures • 9min

Extra Support, Tutorials and Tips1 lecture • 1min

Requirements

Description

Who this course is for: