|
|
|
| Who would benefit from this training
course? 1. Users who are totally new to Excel and/or spreadsheets.
|
|
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 sizing, 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 due to COVID-19
will not be back. "Millions of jobs that have been shortchanged or wiped out entirely by the coronavirus pandemic are unlikely to come back, economists warn, setting up a massive need for career changes and retraining in the United States." - The Washington Post 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.
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 tutor course, you can easily learn about how to efficiently use Excel to remain competitive right from the convenience of your own home or office! The most used versions of Excel from Microsoft are Excel 2016 and Excel 365. In between there have been two other releases: 2019 and 2021. The beautiful part is if you learn to use one version, there is not much difference with the others with the exception of a few added bells and whistles here and there. For example, 2019 has a couple additional chart type options as compared to 2016. In addition, Excel 2019 and 2021 require Windows 10 or 11, Windows Server 2016 or macOS Sierra, while Excel 2016 also runs on Windows 7 or Windows 8.1. Overall, there is not much difference between the four versions. Versions 2016, 2019, and 2021 are fixed, meaning they are a one time payment and what you get is what you get. You will not get any new feature updates. Excel 365 is part of the Office 365 subscription. You pay a monthly or yearly fee and will automatically get new feature updates as they become available. |
|
Excel Environment (File Tab, Ribbon, and Quick Access Toolbar)
As professional computer consultants who regularly train students at all different usage levels of end user software, we at Coronel Data Processing fully understand that new Excel users need a training course that can quickly teach them the basics of working with a spreadsheet, while experienced Excel users need a course to help them become familiar with some of Excel's powerful features. We also understand that while sitting hours in a classroom and going one-on-one with a qualified instructor to learn Excel would be ideal, few people in reality have the time and money. Thus, we have developed "The EasyPass Excel Tutor™ - Office 2016 Through 365 Essentials". This course runs from our eLearning Academy, easypassprep.com. This interactive course can have you up and running with the latest Excel versions in very little time. You go through the training at your own pace and convenience - all from your computer.
We have taken much of our 30 plus years of consulting and training experience and placed it into our Excel training. In the consulting arena, we have designed countless spreadsheets, templates, macros, and other Excel solutions for our clients since 1994. Since 1996, we have trained thousands of students which has led to the development of our PROVEN computer training method, which consists of a THREE PRONG ATTACK that you will see demonstrated throughout our course. Our pincer movement can be summarized as:
1) Describe to the student what
a feature does
2) Demonstrate the feature to the student
3) Let the student try it
Our couse can help you learn what Excel is all about in a short time. We cut through all the fat and give you the meat! Very little filler in our program! Our course has a remarkably simple to use point and click user interface that makes learning Excel easy.
One training solution that has recently become very popular over the last several years, especially with the explosion in the use of smartphones, is training videos. You find them on YouTube and on many other streaming sites. This solution has been implemented in our course as "demos". While training videos are a great source of information and certainly have their place in the learning environment, they ALONE do not allow you to customize a training plan to MAXIMIZE LEARNING and FOR LONG TERM RETENTION.
Lesson topics covered in our Excel course
| 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 |
Lesson 8 - PivotTables 1. What Is A PivotTable? 2. Creating A PivotTable 3. Working With A PivotTable
Lesson 9 – Advanced Features
|
Ask yourself,
"Can I afford not to stay on top of the latest computer technology during these uncertain economic times?"
The EasyPass Excel Tutor - Office 2016 Through 365 Essentials
***This is the Web-Based Version***
Web-Based Version requires:
*PC, Mac, Chromebook, or smart device with Internet access
Once purchased, immediate online access - nothing to install nor configure.
Click Here To Order The EasyPass Excel Tutor - Office 2016 Through 365 Essentials Today
CDP Coronel Data Processing, LLC
The Computer
Specialist
23535 Palomino Dr., #253
Privacy, Purchase, And Return Policies
Copyright © 1996-2025
Coronel Data Processing, LLC
All Rights Reserved