CDP Computer Tutorials – Your simple solution to improving your computer skills

Electronic Excel Tutor™ – Office 2016/365 Basics For The PC (Windows 10 Download)

Who would benefit from this training program?

1. Users who are totally new to Excel and/or spreadsheets.
2. Experienced Excel users who are new to the 2016 or 365 Environment.
3. Experienced Excel users who are looking for shortcuts and tips.
4. Experienced/Novice users wanting to learn Excel Charts, Tables, VLOOKUPs, and Pivot Tables.
5. Users who want much more than just a video to learn from.
6. Users wanting to stay competitive in both school and the job market.

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.


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 tutor program, 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, Excel 2019 and Excel 365.  The beautiful part is if you learn to use one, there is not much difference with the others.  Versions 2016 and 2019 are fixed, meaning it is 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.  Overall, there is not much difference between the three versions.

Excel 2010 Environment (File Button (Tab), Ribbon, and Quick Access Toolbar)
Excel 2016 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 program that can quickly teach them the basics of working with a spreadsheet, while experience Excel users need a program to help them become familiar with the Excel 2016 environment and use powerful advanced tools.  We also understand that while sitting hours in a classroom and going one-on-one with a qualified instructor to learn Excel 2016 would be ideal, few people in reality have the time and money.  Thus, we have developed an educational computer program called “The Electronic Excel Tutor™ – Office 2016/365 Basics”.   This is an interactive computer program that can have you up and running with the latest Excel version 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 25 plus years of consulting and training experience and placed it into The Electronic Excel Tutor™ – Office 2016/365 Basics.  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 program.  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

Excel Training Method

Our program 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 program 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 program 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 EASILY TAKE NOTES FOR LONG TERM RETENTION.  In our program, we have added a “Course Map” option designed to help you go through the program more easily and an option to create a notes sheet of things that pertain directly to you.  Each key screen in the program has a checkbox that can be marked when that section of the program has been completed.  All checkmarks then appear on the Course Map screen next to their respective topic so you know what parts of the program you have already completed.  On each key screen there is an option to create and edit your own personalized notes sheet.

Lesson topics covered in The Electronic Excel Tutor – Office 2016/365 Basics

Lesson 1 – Getting Started
    1. Launching the Program
    2. The Excel Environment
    3. Navigating
    4. Saving A Workbook
    5. Closing 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 

Ask yourself,
“Can I afford not to stay on top of the latest computer technology during these uncertain economic times?”
Full-working version requires:

 *Windows 7/ Windows 8/ Windows 10 (Does not run on a Mac nor Chromebook)
 *460 MB Free Disk Space
 *2 GB RAM (4GB or greater recommended)
 *1024 X 768 screen resolution or greater recommended

Purchase S0019S

Electronic Word Tutor™ – Office 2016/365 Basics For The PC (Windows 10 Download)

Who would benefit from this training program?

1. Users who are totally new to Word and/or word processors.
2. Experienced Word users who are new to the 2016/365 Environments.
3. Experienced Word users who are looking for shortcuts and tips.
4. Users who want much more than just a video to learn from.
5. Users wanting to stay competitive in school and/or the job market.

Education and knowledge in today’s fast pace, high-tech world is now more important than ever before, especially during tough economic times of “company down sizing, furloughs, and lay-offs.”  However, computer and other business related classes can be very expensive and very time consuming.  One alternative to the traditional sit down class is training software.  With our training program you can learn about how to efficiently use Word 2016, Word 2019, and 365 to remain competitive right from the convenience of your own home or office, at a pace you set.

Over the last several decades, computers have greatly changed the way we do things in our everyday lives, especially during the pandemic of 2020. 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!  Those without strong computer skills will find themselves struggling and maybe even out of a job.  Thus, as we put the COVID-19 Pandemic behind us, computer education will be more important than ever before!

“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

One computer program which is currently in high demand in the job market and in education is Microsoft Word.  Word is a word processing program used to create documents.  These documents include reports, memos, forms, web pages, and much more.  There is no greater demand in education and business than a person with “strong” word processing skills.  And the beautiful part is, many of the skills you learn in word processing carry over to other computer programs.

As professional computer consultants who regularly train students at all different usage levels, we at Coronel Data Processing fully understand that new Word users need a training program that can quickly teach them the basics of working with a document, while experience Word users need a program to help them become familiar with the 2016, 2019, and 365 environments.  We also understand that sitting hours in a classroom and going one-on-one with a qualified instructor to learn Word would be ideal, however, few people in reality have the time and money.  Thus, we have developed an educational computer program called “The Electronic Word Tutor™ – Office 2016/365 Basics.”   This is an interactive computer program that can have you up and running with the latest Word versions in very little time.  You go at your own pace, at your convenience – all on your computer.

We have taken much of our training and consulting experience and placed it into The Electronic Word Tutor™ – Office 2016/365 Basics.  Over the years we have developed a computer training method which consists of a three prong attack that you will see demonstrated throughout this program.  This method 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

This program can help you learn what the latest versions of Word are all about.  We cut through all the fat and give you the meat!  Very little filler used here!  Our program has a remarkably simple to use point and click user-interface that makes learning easy.

One training solution that has recently become very popular over the last several years are training videos.  You find them on YouTube and on many other sites.  This solution has been implemented in our program 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 EASILY TAKE NOTES FOR LONG TERM RETENTION.  Thus, we have added a “Course Map” option designed to help users go through the program more easily and an option to create a notes sheet of things that pertain directly to them.  Each key screen in the program has a checkbox that can be marked when that section of the program has been completed. All checkmarks then appear on the Course Map screen next to their respective topic so you know what parts of the program you have already completed.  In addition, there is an option on each key screen to create and edit your own personalized notes sheet.

Full-working version requires:

*Windows 7/ Windows 8/ Windows 10 (Does not run on a Mac nor Chromebook)
*460 MB Free Disk Space
*2 GB RAM (4GB or greater recommended)
*1024 X 768 screen resolution or greater recommended

Purchase S0020S

Electronic PowerPoint Tutor™ – Office 2016/365 Basics For The PC (Windows 10 Download)

Coming In September 2021!!!

Electronic Computer Tutor™ –  For The PC (Windows 10 Download)

Who would benefit from this training program?
1. Novice computer users.
2. Computer users wanting to learn useful tips and tricks that will last a lifetime.
3. Computer users new to Windows 10.
4. Existing Windows users looking to learn the essentials.
5. People who are always looking to increase their technical knowledge.

Our EducationWare program has helped many learn about their computer, common computer terms and vocabulary, computer maintenance, the Internet, and essential Windows basics. And it can do the same for you!  Our program has a remarkably simple to use point and click user-interface that makes learning fun and easy.

In The Electronic Computer Tutor™ we have:

  1. A computer glossary of the most used computer terminology. Often you will hear people at the office or computer stores throwing around computer terms and most in reality do not know what the terms truly mean.  With our program, you no longer have to be in the dark wondering what the gurus are saying.
  2. A section on computer history. Get a good idea on how all this computerization came about. By knowing a little bit of the history, you can get a feel for where it is all going.
  3. A section on hardware. Click on what you want to learn more about and you will get a pop-up screen telling you about it or you will be taken to a screen with a much more in depth break-down. This will give you an appreciation for your computer as well as a much better understanding of how it works.
  4. A section about basic computer maintenance. Often, the problems that we as computer consultants encounter with our client’s computers are related to a lack of proper maintenance. Applying simple maintenance to our automobiles, washing machines, A/C units, and everything else we own can make them last well beyond their initial warranty. With a few simple steps, your computer too can stay problem free for years.
  5. An Internet section.  Learn what the Internet is about and such things as how to tighten up your Internet search.
  6. A Windows tutorial module. Our program teaches about Windows high points. Worried about Windows 10, Microsoft’s latest operating system release? We cover Windows 10 highlights.
  7. A section that gives some power user tips for working with your computer and programs. In our consulting/training experience, most computer users are unaware of what their programs can actually do. 
  8. A section on computer trouble shooting tips.  All computers act up at one time or another.  The vast majority of computer problems can easily be resolved with a little know how.
  9. A course map section that allows you to tailor a personal learning plan. Within our program, you can decide how you want to approach the information we present.
  10. Electronic quizzes that allow you to challenge your computer knowledge.

Minimum Computer Requirements

*Windows 7 / Windows 8 / Windows 10 (Does not run on a Mac nor Chromebook)
*20 MB Free Disk Space
*2 GB RAM or greater
*1024 X 768 screen resolution or greater recommended

Purchase S0002S

Developing A Website™ –  For The PC (Windows 10 Download)

Who would benefit from this training program?

1. People wanting to learn about Internet design.
2. People planning a new website.
3. People wanting to improve the design of an existing website.
4. People looking to drive traffic to their website.
5. People looking for ways to make money with the Internet.

While creating a website is now a snap to do with today’s easy to use technology and drag and drop interfaces, the vast majority of websites are not successful. They get very little traffic, if any.  And many of those websites that do get traffic do not produce much in results. Much of this has to do with the design of the site. This includes both what you see and do not see on the web pages that make up the site.

The purpose behind our training program is to help you “create a pulling website” that brings in the maximum traffic possible and leads to the most promising results. To do this does not have to be very expensive, intimidating, nor complicated. By the time you get through our program, you too can possess the knowledge required to be up and running with your own winning website!

In our program we take a simple approach to the designing and maintaining of a website. We break down the basics and then show you how to design your own site while avoiding many of the pit falls often encountered by the average novice designer. You will then have the knowledge needed to start designing or enhancing your own website or to work closely with the programmer and technicians doing the work for you.

There is a process in creating a successful pulling website. In many ways it can be compared to cooking a wonderful meal. While everyone has access to a kitchen, cooking utensils, and ingredients, not everyone knows how to cook.  That is why cook books are so popular and packaged food comes with directions on it.  Our program can serve as your “Web Development Cook Book”!

Much too often many of the basic essentials are overlooked during the design which results in the website failing or not doing as well as it could.  For example, ever wonder why some websites end up on top of the list on a search engine’s result page and while other sites do not?  A large part of this has to do with the design of the website in which key “ingredients” are “not” left out. Our program addresses things like this. 

We have put over 25 years of knowledge and experience in the computer consulting business into this program.  Want to learn our secrets? Read on!

For years (since 1994) we have been in the computer education and consulting game!  The one trend we have seen steadily on the rise up all of these years and seems to have no end in sight is the need for more education and knowledge.  Education and knowledge in today’s fast pace, high-tech world is now more important than ever before for the aggressive entrepreneur.  However, quality computer and other business related classes can be very expensive and very time consuming.  One alternative to the traditional sit down class is training software.  With our training program you can learn about website developing essentials right from the convenience of your own home or office, at a pace you set.

Everywhere we look and turn, there is talk concerning the Internet and all its many subdivisions.  In many areas and ways, the Internet now rivals, and even surpasses, both television and radio in information distribution and entertainment.  For most people in business, the Internet now serves a role that is just as important as their telephone, cell phone, and fax machine.  Few can argue against the fact that the Internet will no doubt continue to play a major role in how we do things well into the 21st century, especially with the adaptation of Smartphones.

The upward trends in the number of people flocking to join the online community suggests that online usage will continue to grow at a steady rate for years to come.  Not even the “Great Recession of 2008” was able to curb this upward trend of people getting onto the Super Information Highway.  In fact, the Recession of 2008 boosted Internet usage as people used it to find information on everything from career moves, to debt reduction, to low cost entertainment.  Thus, there are many business opportunities for people from all walks of life who have an idea, product, or service they want to sell or promote via the Internet.

The most mesmerizing thing about the Internet is that it is one of the few entities left where the “AMERICAN DREAM” is still alive and well.  There are many opportunities over the Internet if you have the right idea, product, or service.  If you can get yourself onto the Internet, you too can compete with the “BIG BOYS!”  Your work and efforts will stand or fall entirely on their own merits.  Within the broadest limits imaginable, there is no one to stop you, no one to second-guess you, and no one to restrict your growth!

Those currently in business, or thinking of starting a business, who “properly” establish themselves on the Internet will have the potential to make a lot of money and remain technologically competitive, regardless of what type of business they are in.   The COVID-19 lockdown drastically changed the online culture and now is “the time to strike while the iron is hot.”

To create a pulling Internet site is much easier to do than first imagined, and the cost does not have to bankrupt you!  Our computer program well help you understand the basics of an Internet site that are often overlooked during the development and refinement stages.  In addition, we show you how to build a website on a shoestring.  No product to sell, no problem! Our program talks about how to find a product.

There was a time that getting your businesses onto the Internet was extremely complicated, confusing, and expensive.  Back in the early 1990’s, a website with all the fancy bells and whistles could easily cost in excess of $10,000 to develop. And only those well versed in Hypertext Markup Language (HTML) were capable of creating the simplest of web pages. However, the simplicity of modern day computers with their point and click interfaces and user friendly drag and drop web development software have made this modern medium of communication easy to create and maintain. The once restricted online benefits have been well placed into the hands of the common person.  If you can use one of the newer word processors and web browsers, you too can easily publish to the Internet.  It’s really that easy!  However, just like a master chef who has spent years in the kitchen, you need to know what you are doing to develop that steady flow of constant traffic to your site that produces significant results.

It is much too easy for us to get distracted and thrown off course during the design and implementation stages of our website. This is especially true if we want it to have all the fancy bells and whistles overnight. Think about all that goes into baking a fine tasting cake.  It only takes one ingredient left out or one step skipped to ruin it!  In many ways, developing a powerful pulling website is no different.  To help keep you on track, most screens in our program have an option called Task List.  Use this database option to best implement and keep track of the items discussed in that section. Considered this your personal “Web Recipe” that is tailored towards your personal Internet goals. Use the Task List to create and edit notes and use tracking features to keep focused on the key items to consider while developing and refining your website.

By the time you get through our tutorial program, you too can be up and running with your own pulling website!

Why wait? Get the latest full-version copy of our program, “Developing A Website,” today!!!

Minimum Computer Requirements

*Windows 7 / Windows 8 / Windows 10 (Does not run on a Mac nor Chromebook)
*20 MB Free Disk Space
*2 GB RAM or greater
*1024 X 768 screen resolution or greater recommended

Purchase S0005S

error: Page content is protected!!!