Custom Search

Importing Data from Microsoft® Excel into LISTSERV® Maestro

Posted in: MICROSOFT EXCEL |

File title:
Importing Data from Microsoft® Excel into LISTSERV® Maestro

File content:
Introduction, Setting Up the ODBC Driver Plugin in LISTSERV Maestro, Setting Up the ODBC Driver for Excel in LISTSERV Maestro, Setting Up the ODBC Data Source, Accessing the ODBC Data Source from LISTSERV Maestro, SQL Statements and Excel (Using Named Ranges, Naming Data Ranges in Excel, Using Worksheet Names, Using Cell Ranges), Joining Data from Multiple Named Ranges or Worksheets, Conclusion, References.

File type: PDF

File size: 827 kb

File url:
http://www.lsoft.com/resources/wp-odbc-excel.pdf

Getting Started with Microsoft Excel

Posted in: MICROSOFT EXCEL |

File title:
Getting Started with Microsoft Excel

File content:
Starting Excel

Exploring the Excel Interface
Components of the Excel Window, Standard Toolbar, Formatting toolbar, Formula bar, Name box, Row and column headings, Active cell, Fill handle, Worksheet tabs.

Working with Excel documents
Opening and Closing Documents, Saving a Document, Difference between Save As and Save, Creating a New Workbook, Managing Multiple Workbooks.

Entering and Editing Data
Entering Data, Editing Data, Moving the Active Cell, Go To Command, Clearing Cell Contents, Undoing Mistakes, Copying and Moving Data.

Formatting Data
Changing formats using the toolbar, Font tab in Format Cells, Alignment, Format Alignment command, Changing Numeric Formatting, Placing borders around cells, Shading cells, Changing column width with the Format menu, Changing column widths by dragging column borders.

Formulas and Functions
Formulas, Copying Formulas, SUM( ) function, AutoSum button, Using the Insert Function Button, Adjusting Page Setup settings, To change page margins, To change page orientation, To change the header or footer.

Printing
Print preview, Sending your workbook to the printer.

Getting Help
The Contents Tab, The Answer Wizard Tab, The Index Tab.

File size: 280 kb

File type: PDF

File url:
http://www.dartmouth.edu/~rwit/files/database/Excel.pdf

The Misuse of RC4 in Microsoft Word and Excel

Posted in: MICROSOFT EXCEL |

File title:
The Misuse of RC4 in Microsoft Word and Excel

File Content:
Introduction

Introduction to the Security of Microsoft Office

The Misuse of RC4 in Microsoft Word
Evidence that RC4 is misused in Microsoft Word, The attack on the Microsoft Word.

The Misuse of RC4 in Microsoft Excel
Modifying the Microsoft Excel document, Evidence that RC4 is misused in Microsoft Excel.

The Countermeasures

Conclusion

References

Encryption in Microsoft Word 2002

File type: PDF

File size: 143 KB

File url:
http://eprint.iacr.org/2005/007.pdf

Microsoft Excel - A Beginner’s Guide to Working With Spreadsheet Applications

Posted in: MICROSOFT EXCEL |

File title:
Microsoft Excel
A Beginner’s Guide to Working With Spreadsheet Applications

File content:
What is Microsoft Excel? How to Create an Excel Spreadsheet; Title bar, Menu bar, Toolbars, and Status bar in Word; How to Save an Excel Spreadsheet; Undo is your Friend! What is a Column? What is a Row? What is a Cell? How do I edit the contents of a Cell? How do I Sum a Column of data? What is a Formula? How do I create a Formula? How do I find out how to do more in Excel? Additional Resources.

File format : PDF

File size: 104 kb

File url:
http://main.ascension.lib.la.us/uploads/File/Classes/TutorialIntrotoExcel.pdf