 |
See List of User
Interface Features and Functions: |
 |
User Functions - Writing your own VBA
worksheet functions
-This we will try to do in at least
every other meeting. |
 | Web Resources for Help and Assistance. |
 | Regression Analysis: Linear, Multiple Linear,
Non-linear. |
 | Pivot Tables and Charting. |
 | Create Hyperlinks to other cells in your workbook. |
 | Use VBA to have Excel Store data into an
Access Table. |
 | Creating your own Addins (I could
use help with this one.) |
 | Attaching Toolbars to Workbooks to run macros in the
workbook or addins. |
 | MS Query. |
 | Data Transmission Service (DTS) for moving data between
Excel and Access. |
 | Template Wizard: a tool to link Excel worksheets to a
Database Table. |
 |
Use VBA and DAO to automatically get an
Access Query result and load into Excel |
 |
Use VBA and DAO to put get an Access Query
and load some fields in the order desired into the Excel Workbook. |
 | Secure your data |
 | Use VBA to build charts on demand. |
 | Star Office and Open Office - alternatives to MS
Office. |
 | Seagate Analysis - a Free tool for Database-like
formated reports, OLAP, and queries. |
 | Publishing Excel to the internet. |