Microsoft Excel tips and tricks. Excel bookkeeping & accounting is easy.

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

No prior knowledge needed.

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!



DOWNLOAD
uploadgig


rapidgator


nitroflare