How can I learn Microsoft Excel?

Answer 1

Microsoft Excel Basics:

I have developed Excel courseware and used it for over 30 years to teach Excel to over 2, 000 students. The basic courseware covers the following topics:

THE EXCEL WORKBOOK

THE BLANK WORKSHEET:

MOVING AROUND THE WORKSHEET

MOUSE POINTER SYMBOLS

ENTERING DATA

USING MATHEMATICAL OPERATORS

ROW, COLUMN AND RANGE SELECTING

ENTERING AND FORMATTING DATA

UNDERSTANDING CELL REFERENCES WHEN COPYING FORMULAS

UNDERSTANDING CELL REFERENCES

A. RELATIVE EXAMPLE:

B. ABSOLUTE EXAMPLE:

C. MIXED EXAMPLE:

SAVING AND NAMING A FILE

PRINTING YOUR WORKSHEET

A. PRINT PREVIEWING YOUR WORKSHEET

B. HEADERS AND FOOTERS

C. SETTING MANUAL PAGE BREAKS

D. SELECTING A PRINT AREA

USING FUNCTIONS

PASTING IN FORMULAS ON A WORKSHEET

FLASH FILL

SORTING A DATABASE

CREATING AUTOMATIC SUBTOTALS

COLLAPSING THE OUTLINE STRUCTURE

REMOVING A SUBTOTAL

PRINTING YOUR WORKBOOK

This free courseware is available for my tutoring sessions and includes over 70 sample workbook files.

I also have Excel Intermediate, and Excel Advanced courseware available for free during my tutoring sessions!

This is the first of three courses (Basic, Intermediate and Advanced)

If you are interested in learning MS Excel, Please contact me.