Over the last several decades, computers have greatly changed the way we do things in our everyday lives. They have added convenience to our daily tasks, have enhanced our education, and have provided us with many convenient office tools. Trends in education and the job market over the last ten years indicate that those who have strong computer skills will remain competitive and keep working.  This is especially true during tough economic times resulting in “company down sizings, furloughs, and mass lay-offs”!  Those without strong computer skills will find themselves struggling and maybe even out of a job.  Unfortunately, many jobs that went away when the economy crashed back in 2008 will not be back (Even in a Recovery, Some Jobs Won’t Return – Wall Street Journal).  Thus, computer education that keeps you up-to-date in today’s fast pace, high-tech world is now more important than ever before!

All businesses and individuals have the need to crunch numbers and see data in one form or another, at one time or another.  Thus, one program which is currently in high demand in the job market and used heavily in education is Microsoft Excel.  Excel is a program used to create spreadsheets.  A spreadsheet is a computer program designed to facilitate the manipulation of data in the form of numbers and lists.  It will save you lots of time and improve accuracy when calculating equations with many variables.  With a spreadsheet you can easily produce projections, budgets, salary expenses, tax reports, proposals, charts, loan estimates, and so much more!  No wonder there is so much need for this program at school, work, and home.

Excel Spreadsheet

The problem with trying to keep up with technology is that quality computer and other related classes can be very expensive and time consuming to take.  A good sit down class can take weeks at the local Junior College or one to three days if going the “Boot Camp” route.  The problem with the Boot Camp route is that you are not given much time to absorb and put into practice all the information you are quickly hit with.  While Boot Camps present you with lots of good information, long term retention is often not too good, especially for the novice user. 

One alternative to the traditional sit down class is using training software (eLearning products).  With training software, you set the pace and time spent to learn any particular topic.  In our Excel 2016 tutor program, you can easily learn about how to efficiently use Excel 2016 to remain competitive right from the convenience of your own home or office!

Lesson 1 – Getting Started
    1. Launching the Program
    2. The Excel Environment
    3. Navigating
    4. Saving A Workbook
    5. Closing A Workbook
    6. Opening A Workbook

Lesson 2 – Creating A Basic Worksheet
    1. Creating A New Workbook
    2. Entering Text And Values
    3. Creating Basic Formulas
    4. Using Functions In Formulas
    5. Using The AutoSum Tool
    6. Insert Function Dialog Box
    7. Absolute References

Lesson 3 – Modifying A Worksheet
    1. Selecting A Range Of Cells
    2. Edit The Entry In A Cell
    3. Removing A Cell Entry
    4. Renaming A Worksheet
    5. Insert Or Delete A Worksheet
    6. Moving Or Copying Worksheets
    7. Inserting Rows, Columns, And Cells
    8. Deleting Rows, Columns, And Cells
    9. Using Undo/Redo
    10. Moving And Copying

Lesson 4 – Formatting
    1. Adjusting Column And Row Sizes
    2. Fonts
    3. Font Styles
    4. The Format Painter
    5. Alignment
    6. Number Formatting
    7. Formatting With Borders
    8. Fill Color
    9. Font Color
    10. Additional Format Options

Lesson 5 – Printing
    1. Print Preview
    2. Page Break Preview
    3. Page Setup
    4. Print Options

Lesson 6 – Charts
    1. Creating Charts
    2. Editing Charts
    3. Printing or Publishing Charts

Lesson 7 – VLOOKUPs
    1. What Is A VLOOKUP?
    2. Excel Tables
    3. Creating VLOOKUPs