Here is another skill any employer would be pleased to see on your resume. Or, if you are a college or University student, here is an opportunity to score an A+ for your next project.
What is so special about this courseware? Let us find out.
Often you have to deal with situations requiring elegant mathematical and analytical tools for processing DATA. Writing C# or VB .Net code from scratch to implement such elegant mathematical and analytical tools for processing data would be like “re-inventing the wheel”. Why? Well, it’s because applications like Microsoft Excel are already available with all kinds of computational tools for processing data in any way we like. So, instead of trying to “re-invent the wheel”, it would therefore make more sense learning to write C# or VB .Net programs that can take advantage of the computational power available in MS Excel. This is exactly the goal of this courseware.
Not only Microsoft Excel comes with a huge library of mathematical formulas and data analysis tools, it also comes loaded with all kinds of options for displaying and graphing data. Imagine, you are writing an application for some Data Acquisition System (DAS). Wouldn’t it be great to have all data coming from the Data Acquisition (DAQ) system to appear graphically on the screen, eg. as an X vs Y plot, or as bar graph. And, even more wonderful, to watch this X vs Y plot (or bar graph, etc) change in reaction to changes in data values (all in real time!).
Knowing how to write C#/VB programs that can interface and interact with MS Excel is a great skill with application areas extending far beyond DAQ systems (or DAS).
For example, consider a situation where you need to automate routine tasks like printing data from an Excel worksheet every 20 minutes. Or, consider another situation, where data from one spreadsheet has to be automatically copied to another spreadsheet in response to some triggering event. This and many more tasks could be automated by learning how to programmatically manage and control Excel files from your C#/VB applications.
This courseware is divided into two parts.
Part I of this courseware has a Step by Step Study Guide for Hands-On exercises showing you how to interface your C#/VB applications with MS Excel to programmatically accomplish several tasks that include:
1. Create new Excel files
2. Open existing Excel files for both reading and writing data
3. Write Data to any specific cell(s) on any specific worksheet within an Excel file
4. Read Data from any specific cell(s) on any specific worksheet within a given Excel file
5. Copy pictures from image files to any specific area of a worksheet within an Excel file
6. Copy data from one spreadsheet to another spreadsheet within the same Excel file or a different Excel file.
7. Print worksheet contents from any place within an Excel file
8. Search an Excel file for any specific data
9. And, much more…
Once you have completed all the Part I exercises, you may then proceed to Part II of this courseware, where you get an opportunity to apply all the concepts and skills (you learned in Part I) to develop a real application called, “An Excel-based Lookup Table”.
You will learn to develop this interesting feature-loaded application (in both C# and VB .Net). But before you proceed to build this application, you are first made to watch a short but a highly informative video presentation that focuses on Look Up Tables (LUT) and their applications in Science and technology. In yet another video, you are taken through a comprehensive tour of the Excel-based Look Up Table that you will be building on your own as part of this courseware. When you build this application guided by the Step by Step Study Guide, you will also learn how to write C#/VB code for various tasks that include:
1. Exporting Spreadsheet Data to an array
2. Import data from an array into a spreadsheet
3. Export spreadsheet data to CSV-formatted text file
4. Import data into spreadsheet from a CSV-formatted text file
5. Interpolating a value of (a function or series) between two known values. Or, even, use extrapolation to estimate (a value of a variable outside a known range) from values within a known range by assuming that the estimated value follows logically from the known values.
This courseware assumes basic C# and VB .Net programming skills.
Price: $9.95
Item#: EXCLPRGI
