Basic Excel for Basic Bookkeeping and Accounting
What you'll learn
- Open, save and close a workbook in Excel
- Identify parts of an Excel workbook
- Enter and delete data
- Insert and remove columns and rows
- Use cut, copy, paste, undo, redo, find and replace
- Insert basic formula
- Use paste special
- Format text and cells
- Use excel autofill, flashfill, autosum and autocomplete
- Sort data
- Insert tables and filters
- use names and data validation to restrict user imputs
- Insert charts
- Insert pivot tables, timeline and charts
- Set up a basic Sales and sales returns daybook in Excel
- Set up a basic Purchase and purchase returns daybook in Excel
- Set up a basic petty cash daybook in Excel
- Set up basic payments and receipts daybooks
- Identify key information to record in the daybooks
Requirements
- This course is recorded using Excel 2013
- You must have a willingness to learn
- You must have English language skills
Description
Basic Excel for Basic Bookkeeping - an introductory course for those that are new to Excel and new to Bookkeeping.
In This Course You Will Learn The Basics Of Excel, The Very Basics of Bookkeeping, And How You Can Do Simple and Basic Bookkeeping in Excel.
If you need to record basic transactions for your business. If you are new to Excel? THEN REGISTER NOW
Course Overview
We will begin this course by introducing you to Excel, where you will learn the very basics. We will introduce you to a workbook and the ribbons, and you will learn how to select, enter and delete data.
In section 2 we will move into the very basics of bookkeeping, we will introduce you to the day books that you should keep and we will identify key details that you should record in these day-books. These day-books, prepared in Excel, are available for download, and we will use them in the rest of this course while we are working in Excel.
In section 3 - Excel working with data, you will learn how insert, remove and merge cells, rows and columns. We will also look at find and replace, hide and unhide and Special paste. After this we will move on to entering basic formula and some formatting.
Section 4 of this course - Excel Organizing and sorting data, will give you the opportunity to organize the day-books using tables, filters, names and data validation
Finally in section 5 Excel Analyzing data you will be introduced to Excels recommended charts and recommended pivot tables.
This course contains:
Notes to download - Available Now
Sample practice day-books - Available Now
Exercises to complete - Available Now
Certificate of Completion
*****BONUS****** FREE Join a community of other learners where you can interact with each other and with the instructor.
********************************************************************************************
REGISTER NOW and get started with Bookkeeping in Excel Today!
*******************************************************************************************
By the end of this course, you'll have the knowledge and confidence to record your basic bookkeeping transaction in Excel. You will also be confident in using the basics of Excel for almost any task. In addition to this you will also have the foundations to move on to a more advanced Excel or Bookkeeping course.
********************************************************************************************
Your purchase is 100% RISK FREE with a 30 day money-back guarantee. If you don't learn anything new from this course, simply request a refund within your 30 day period for your money back, no questions asked.
Who this course is for:
- This Basic Excel for Basic Bookkeeping course is meant for newbies who are not familiar with Excel or bookkeeping
- No prior Excel skills or bookkeeping knowledge is required
- This course is not for you if you are looking for advanced Excel or bookkeeping skills
Instructor
- 4.2 Instructor Rating
- 2,787 Reviews
- 154,296 Students
- 11 Courses
With over 25 years of expertise in Accountancy, Business Management, and Operations, I, Paula, am a seasoned CPA (Certified Public Accountant) dedicated to empowering learners with practical skills and knowledge. As a former Microsoft MVP (Most Valuable Professional) in Excel for two consecutive years (2020 & 2021), I've been recognized for my commitment to excellence in spreadsheet solutions and financial analysis.
Having immersed myself in the Web3 landscape since 2016, I've become a leading voice in simplifying complex concepts, making Web3 and Blockchain technology accessible to all. And so, my journey took an exciting turn in 202 when I embraced the transformative potential of Web3, Blockchain, and Digital Assets and pivoted my training to focus on web.
Founder of A Block of Crypto: As the founder of A Block of Crypto, I am passionate about demystifying the world of cryptocurrency and blockchain. Through engaging courses and interactive online meetups, I strive to make Web3 and blockchain technology as intuitive as ABC. My mission is not just to educate but to onboard and retain users in the rapidly evolving Web3 ecosystem.
What I Offer:
Comprehensive Courses: Dive deep into the fundamentals of Web3, Blockchain, and Crypto with my meticulously crafted courses designed for beginners and seasoned professionals alike.
Interactive Online Meetups: Join our vibrant community and participate in regular online meetups where you can network with like-minded individuals, ask questions, and stay updated on the latest developments in the world of Web3.
Web3 Support: Whether you're navigating your first crypto project or exploring decentralized finance (DeFi) protocols, I'm here to provide guidance and support every step of the way.
Let's Connect: Embark on your journey into the exciting world of Web3 and Blockchain with me. Follow me on Udemy to stay updated on upcoming courses, events, and exclusive learning opportunities. Together, let's unlock the full potential of decentralized technology and shape the future of finance and beyond.