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
Show more
Show less
Requirements
No prior knowledge needed.
Description
In this course you will learn the basics of Microsoft Excel. This course is designed for people interested in bookkeeping and accounting, but the Excel knowledge can be applied to any other profession that uses Excel. By the end of this course, you will have a solid understanding of how to use basic functions of Microsoft Excel.
You will learn:
Navigating around Microsoft Excel
Entering text and numbers
Adding numbers (SUM function), subtracting, multiplying, and dividing
Correcting cells and moving around cells
Inserting columns and rows
Adding and deleting cell format (bold, font, etc.)
Using Copy, Cut, Paste, and Format Painter to quickly copy cell formatting
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 (pie charts, column charts, etc.)
Sorting numbers
Filtering numbers
Using Freeze Panes to see columns and row headings
And much more!
https://www.udemy.com/course/microsoft-excel-basics-course/

Related Downloads :

{related-news}