Basic Excel for Basic Bookkeeping and Accounting
Learn the basics of Excel, the very basics of bookkeeping, and how you can do simple and basic bookkeeping in Excel.
4.33 (641 reviews)
9,183
students
1.5 hours
content
May 2020
last update
$74.99
regular price
What you will 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
Related Topics
596598
udemy ID
8/29/2015
course created date
11/20/2019
course indexed date
Bot
course submited by