Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
2 Hour(s) 34 Minute(s)
Language
English
Taught by
Jennifer Bailey
Certificate
- Available
- *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
Rating
1 views
Course Overview
Create fully functioning Accountancy/ Bookkeeping Spreadsheet and Improve Your Microsoft Excel Skills
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.
Course Content
- 9 section(s)
- 39 lecture(s)
- Section 1 Introduction To The Course
- Section 2 Creating The Business Setup Worksheet
- Section 3 Creating The First Calendar Month Worksheet
- Section 4 Creating Months 2-12
- Section 5 Setting Up The Mileage Worksheet
- Section 6 Setting Up The End Of Year Worksheet
- Section 7 Trouble Shooting/ Student's Questions
- Section 8 Quick Start Tips and Shortcuts
- Section 9 Extra Support, Tutorials and Tips
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
Skills covered in this course
Reviews
-
SSteven McMillan
Great basic level accounting and formulas.
-
VVal Beaumont
yes
-
DDakota P.
Great course. Jennifer is very knowledgeable in Excel, and explained thoroughly exactly what I needed.
-
PPaige Loggie
Loved the course, it was super helpful to be shown how to do the complicated formulas specific to my needs!!
