Microsoft Excel 2010 Training (Beginners to Advanced) is an on-going Course that daily adds new teachings to take you from beginners stage to advanced (See available lessons below by clicking on their title – more would be added daily until the courses are completed)

Below you will find what the Training involves: 

Microsoft Excel 2010 Training, Beginners to Advanced 

In Microsoft Excel 2010 Essential Training, Beginners to Advanced, demonstrates the core features and tools in Excel 2010. The course introduces key Excel skills, shows how to utilize these skills with in-depth tutorials on Excel functions and spreadsheet formatting. It also covers prepping documents for printing, working with large worksheets and workbooks, collaborating with others, using Excel as a database, analyzing data, charting, and automating and customizing Excel. Exercise files are included with the course.

Topics Include:

[wpanchor id=”excelbasics”]
Excel Basics

Lesson 1: Starting Microsoft Excel

Lesson 2: The Microsoft Excel 2010 Interface

Lesson 3: Understanding the Layout of an Excel Worksheet

[wpanchor id=”entereditdata”]
How to Enter and Edit Excel Data

Lesson 4: How to Enter text into a Cell

Lesson 5: How to Enter a Number into a Cell

Lesson 6: How to Enter a Date or Time into a Cell

Lesson 7: How to insert a Symbol into a Cell

Lesson 8: How to Edit data in a Cell

Lesson 9: How to delete data in a Cell

[wpanchor id=”ranges”]

Lesson 10: How to Select a Range of Cells

Lesson 11: How to Select a Range of Individual Cells

Lesson 12: How to Select a row of Cells

Lesson 13: How to Select a column of Cells

Lesson 14: How to fill a Range with the same Data

Lesson 15: How to autofill a series of numbers, dates and alpha-numeric values

Lesson 16: How to move or copy a range

Lesson 17: How to insert a row

Lesson 18: How to insert a column

Lesson 19: How to insert a cell or range

Lesson 20: How to delete data from a range

Lesson 21: How to delete a range

Lesson 22: How to hide a row or column

Lesson 23: How to freeze rows

Lesson 24: How to freeze Columns

Lesson 25: How to merge two cells or more

Lesson 26: How to transpose a row or column of data

[wpanchor id=”formattingranges”]
Formatting Ranges:

Lesson 27: How to change the Font (typeface) of a cell or range

Lesson 28: How to change the Font size of a cell or range

Lesson 29: How to apply Font effects

Lesson 30: How to change Font colors

Lesson 31: How to align text within a cell

Lesson 32: How to center text across multiple Columns

Lesson 33: How to rotate text within a cell

Lesson 34: How to add a background color to a range

Lesson 35: How to apply a Number Format

Lesson 36: How to change the number of decimal places in a selected number or numbers

Lesson 37: How to apply an Auto format to a Range

Lesson 38: How to apply Conditional Formatting to a Range

Lesson 39: How to apply a Style to a Range

Lesson 40: How to change the Column Width

Lesson 41: How to change the Row Height

Lesson 42: How to Wrap Text within a Cell

Lesson 43: How to Add a Border to a Range

Lesson 44: How to Copy formatting from one cell to Another

Lesson 45: How to Create Basic Excel Formulas: Addition, Subtraction, Multiplication, Division

Lesson 46: How to use Functions in Excel

Lesson 47:  How to add a column or row of numbers


Once you have completed the above stage for Microsoft Excel 2010 Beginners Course, you will have the option to move on to the Intermediate and Advanced Microsoft Excel 2010 Training Courses. Just enter your name and email address below for early sign up for these courses, and as soon as they are uploaded to our site you will be among the first to receive links from us in your inbox to the Microsoft Excel 2010 intermediate and advanced courses.


Subscribe for Microsoft Excel 2010 Training

Enter your full name and email address in the form below; then click the 'Submit' button.

Enter Your Best Email Address in the form above

Please wait...