Microsoft Excel Basics (Bookkeeping & Accounting)
Bookkeeping & accounting in Microsoft Excel. Microsoft Excel tips and tricks. Excel bookkeeping & accounting is easy.
What you’ll learn
-
Microsoft Excel basics
-
Adding numbers, subtracting, multiplying, and dividing
-
Using formulas to work with numbers
-
Inserting columns and rows
-
Using cell format (bold, font size, highlight, etc.)
-
Using Format Painter to quickly copy cell formatting
-
Using Wrap text in a cell
-
Formatting numbers using dollar sign, percentage, decimals
-
Conditional formatting to add colors to make sense of cell data
-
Using charts (i.e. pie chart) to present your data
-
Sorting and filtering numbers
-
Using “Freeze Panes” to see columns and row headings
Requirements
-
No prior knowledge needed.
Who this course is for:
- Beginner bookkeeping & accounting students
- People who need to use Excel in their work or life
