Explore

Build Excel Spreadsheet for Work From Home Business Accounts

2.5 hours on-demand video

$ 12.99

Save Course

Go to Course

Brief Introduction

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

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.

Requirements

Requirements
Microsoft Excel (2010 or newer)

Knowledge

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

Recommended for you

Accounting–Financial Accounting Total-Beginners to Advanced

Including well over 100 hours of content, e-book (EPUB, MOBI, PDF) ,Excel worksheet, & PDF files, this is comprehensive Recently updated with A LOT of added content....

Save Course