Learn to create a comprehensive Accountancy spreadsheet in Excel 2016 to manage your finances effectively while enhancing your Excel skills in this step-by-step course.
This course is all about mastering Microsoft Excel to create a super detailed bookkeeping spreadsheet. Jennifer guides you through the essential skills step-by-step, making sure you're locked in and ready to take charge of your finances with confidence and ease.
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.
Creating and Re-naming Worksheets
Grouping Worksheets (Copying Formula Across)
Inserting Tables
4 Lectures
2 Lectures
15 Lectures
3 Lectures
1 Lectures
4 Lectures
4 Lectures
5 Lectures
1 Lectures
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 have been a Premium Instructor on Udemy for 5 years and have with...
Amazing!
Loved the course, it was super helpful to be shown how to do the complicated formulas specific to my needs!!
Very clear; great for Excel beginners.
I found the course very helpful and exactly what I was looking for and expecting. Thank you very much...
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).
My name is April Phillips I reside in Grovetown, GA in the USA this is information needed to setup my home business.
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.
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
I really loved working through this course, Jennifer explains everything really well, brilliant...
Your email address will not be published. Required fields are marked *
Dakota P.
Great course. Jennifer is very knowledgeable in Excel, and explained thoroughly exactly what I needed.