Microsoft Excel 2003 - Quick Reference Guide
File title:
Microsoft Excel 2003 - Quick Reference Guide
File content:
Starting Excel
Opening a New Workbook, Opening an Existing File, Saving a Worksheet, Viewing the Task Pane, Saving a Worksheet as a Web Page, Entering Data, Closing Worksheets, Using Repeat, Undo and Redo, Moving or Copying Data, Insert a Comment.
Output
Previewing your Workbook, Printing a Workbook or Worksheet, Emailing a Workbook, Previewing Printed Worksheets.
Working with Toolbars
Viewing the Various Toolbars, Repositioning a Toolbar.
Viewing Worksheets
Changing Views, Viewing Multiple Worksheets, Comparing Workbooks Side by Side.
Formatting Worksheets
Changing Font Properties, Inserting Hyperlinks, Formatting Margins.
Using Pictures in Worksheets
Inserting Images/Objects, Resizing Images/Objects.
Worksheet Manipulation
Selecting Worksheets, Selecting Rows and Columns, Adding a New Sheet, Moving a Sheet, Copying a Sheet, Deleting a Worksheet, Renaming a Worksheet, Color Coding a Worksheet Tab, Inserting Rows and Columns, Deleting Rows and Columns, Adjusting Column Width and Row Height, Freezing a Row or Column, Creating Footers and Headers, Using the Format Painter, Applying or Removing Cell Boarders, Merging Cells, Clearing Cell Format or Contents, Using AutoFill Feature to Create a Calendar, Using AutoFill Feature to Create a List of #, Using the AutoSum Button.
How to Graph Data
Getting Started for All Graphs.
File size: 517 kb
File url:
http://www.uml.edu/it/documents/Excel2003_QuickRef.pdf
INTERMEDIATE EXCEL
File title:
INTERMEDIATE EXCEL
File content:
Introduction, Lists, PivotTables (Elements of a PivotTable, Setting up a PivotTable, Begin building your pivot table, CompletedPivotTable), Data Forms (Using a Data Form, Advanced Analytical Tools), Scenario Manager (Using the Scenario Manager, To view a Scenario), Goal Seek (Using Goal Seek), Complex Analysis: The Solver (Elements of the Solver, Using the Solver, To Run the Solver, To Generate a Report/Printout of the Solution), Macros (Running the Macro/Macro Options, Assigning a macro to a button, Assigning a macro to a short cut key).
File type: PDF
File size: 224 kb
File url:
http://www.lib.umich.edu/hsl/resources/guides/IntermedExcel.pdf
Microsoft Excel Hints and Tips
File title:
Microsoft Excel Hints and Tips
File content:
Introduction, Starting Microsoft Excel and Opening Files, Making Good Use of the Keyboard, Data Entry and Cell Formatting, Moving Around and Selecting Cells, Making Good Use of the Mouse, Screen Layout, Using Colours and Adding Comments, Cell Referencing, Charts, Printing Tips, Other Tips.
File type: PDF
File size: 106 kb
File url:
http://www.reading.ac.uk/web/FILES/www_File_Library/Microsoft_Excel_Hints_and_Tips.pdf
Creating Electronic Portfolios using Microsoft Word and Excel
File title:
Step-by-Step
Creating Electronic Portfolios using Microsoft Word and Excel
File content:
What to do? Here is the process we will cover:
Collect the documents in electronic form and store in a single folder, Create a list of the artifacts you have collected using an Excel Spreadsheet, Create the Reflective Portfolio in Word.
Stage 2 - Collecting the Artifacts - The Working Portfolio
Hints on collecting your Artifacts:, Create a list of your Artifacts in Excel.
Stage 3 - Selection, Reflection & Direction - The Reflective Portfolio
Set up the portfolio demonstrating your chosen standards, Copy the Performance Indicators into document, Create Navigation Headings with the Outline View, Using the Document Map, Using the Style Menu, Change the Paragraph Style to Create Page Breaks, Write Reflections on Each Standard, Create a Table of Contents.
Stage 4 - Add hypertext links - The Connected Portfolio
Scanning directly into a Microsoft Word 2001 Document.
File type: PDF
File size: 940 kb
File url:
http://ali.apple.com/ali_media/Users/147/files/others/stepbystep_WordExcelEPs.pdf
Microsoft Excel 2007
File title:
Microsoft Excel 2007
File content:
Things to Note – Data Types and Formulas
Entering Data, Data Types, Formulas.
MS EXCEL 2007 - New Interface
Arrangement of Tools in Excel 2007, MS OFFICE BUTTON, QUICK ACCESS TOOLBAR, RIBBON TABS (Tool Groups, Dialog Box Launch Arrow).
Getting Started
Start a new Workbook, Open an existing Workbook, Open a file from a different version or format, IMPORTANT NOTES: Saving Documents in Excel 2007, Save the current Workbook OR Save the Workbook as a different name - version - or format.
Formatting Data
Insert Data into a cell
Home Tab - Font, Alignment, Number & Cell Groups
Insert more Cells into a Sheet, Change the Type of Data within a Cell or cells (Ex: increase decimal places), Change the Font of the Data in a Cell, Change the Alignment of the Data in a Cell, Format Cells Dialog Box - (has not changed from Word 2000, 2003), Format the Borders of Cells, Format the Column Width or Row Height of Cells, Move a cell(s), Merge Cells Combine several Cells into 1, Automatically fill Data Cells, Sorting Data.
Formulas - The Formula Bar & Functions
To begin a Formula:, Functions & Operators for Formulas, AutoSum Automatically Sum your Data.
Creating and Formatting Charts
Inserting a Chart from Data, Chart Tools Tab: (Design Tab, Layout Tab, Format Tab), Creating a Chart Step 1 Choose / Change a Chart Design.
Creating a Chart - Steps 2 - 4
Creating a Chart Step 2 Data Range, Creating a Chart Step 3 Chart Location, Creating a Chart Step 4 Labels (Chart Titles, Axis Titles, Gridlines, Legend Position, Background), Stretching the Chart.
Formatting Elements of a Chart
Formatting Axes Change the Pattern, Scale, Font, Number Type, and Angle of the X and Y Axes. Of these, the most important is the Scale of the Axes, Formatting a Series of Data Change the appearance of a Data Series Line and its Markers, Display and Format Data Labels Show the Data Values Data Labels The X or Y values can be displayed next to each Data Marker in a Series Line.
Charts - Error Bars and Trendlines
Adding Error Bars to a Series of Data Error Bar A small line extending from each Data Marker that represents the potential error of your data, Creating Trend Lines and their Equations Trendline The line that best represents the average of your data points. Excel can provide an equation for the Trendline.
Printing
Set the Print Area of a spreadsheet, Preview the print-out.
File type: PDF
File url:
http://www.sfg.uvic.ca/assets/pdfs/excel-handout07.pdf
File size: 1411 kb
Importing Data from Microsoft® Excel into LISTSERV® Maestro
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
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
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
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
Problems With Using Microsoft Excel for Statistics
File title:
Problems With Using Microsoft Excel for Statistics
File content:
Example: Excel Graphics With False Third Dimension (taken from JSE!), Example: Pyramid Charts, Example: Excel Default Scatterplot, Example: Excel Default Histogram, Example: Excel Histogram (stretched vertically to read labels), Example: Excel 2000 Help Screen for the Two-sample T-Test, Example: Excel 2000 Confidence Function, Example: Excel 2000 STDEV Function.
File format: PDF
File size: 413 kb
File url:
http://www.cs.uiowa.edu/~jcryer/JSMTalk2001.pdf
OpenOffice.org’s Documentation of the Microsoft Excel File Format
File title:
OpenOffice.org’s Documentation of the Microsoft Excel File Format
File content:
Introduction
License Notices, Abstract, Byte Order.
Document Structure
Document Types, The Binary Interchange File Format, File Structure, BIFF Record Structure, Common Record Substructures.
Formulas
Common Formula Structure, Token Classes, Cell Addresses in Tokens, Token Overview, Unary Operator Tokens, Binary Operator Tokens, Function Operator Tokens, Constant Operand Tokens, Operand Tokens, Control Tokens, Built-In Sheet Functions.
Worksheet/Workbook Stream
Worksheet/Workbook Stream, Record Order in Streams and Substreams, Calculation Settings Block, Page Settings Block, Sheet View Settings Block, Cell Formatting, Cell Table and Row Blocks, Array Formulas and Shared Formulas, Multiple Operation Tables, Internal and External References, Shared String Table (BIFF8), Conditional Formatting Table (BIFF8), Hyperlink Table (BIFF8), Data Validity Table (BIFF8), AutoFilter, Advanced Filter, Scenarios, Web Queries (BIFF8), Worksheet/Workbook Protection, File Protection.
Worksheet/Workbook Records
Overview, Ordered by Record Identifier, Overview, Ordered by Record Names, Overview, Ordered by BIFF Versions, ARRAY, BACKUP, BITMAP, BLANK, BOF – Beginning of File, BOOKBOOL, BOOLERR, BOTTOMMARGIN, BUILTINFMTCOUNT, CALCCOUNT, CALCMODE, CFHEADER, CFRULE – Conditional Formatting Rule, CODEPAGE, COLINFO, COLUMNDEFAULT, COLWIDTH, CONTINUE, COUNTRY, CRN, DATATABLE – Multiple Operation Table, DATATABLE2 – Multiple Operation Table, DATAVALIDATION, DATAVALIDATIONS, DATEMODE, DBCELL, DCONREF – Data Consolidation Reference, DEFAULTROWHEIGHT, DEFCOLWIDTH, DEFINEDNAME, DELTA, DIMENSION, DSF – Double Stream File, EOF – End of File, EXTERNALBOOK – External Workbook, EXTERNALNAME, EXTERNCOUNT, EXTERNSHEET, EXTSST – Extended SST, FILEPASS, FILESHARING, FONT, FONT2, FONTCOLOR, FOOTER, FORMAT, FORMULA, GCW – Global Column Width, GRIDSET, GUTS, HCENTER, HEADER, HIDEOBJ, HORIZONTALPAGEBREAKS, HYPERLINK, INDEX, INTEGER, ITERATION, IXFE – Index to XF, LABEL, LABELRANGES, LABELSST, LEFTMARGIN, MERGEDCELLS, MULBLANK – Multiple BLANK, MULRK – Multiple RK, NOTE, NUMBER, OBJECTPROTECT, PAGESETUP, PALETTE, PANE, PASSWORD, PHONETICPR, PLS, PRECISION, PRINTGRIDLINES, PRINTHEADERS, PROTECT, QUICKTIP, RANGEPROTECTION, REFMODE, RIGHTMARGIN, RK, ROW, RSTRING, SAVERECALC, SCENPROTECT, SCL, SELECTION, SHAREDFMLA – Shared Formula, SHEET, SHEETLAYOUT, SHEETPR, SHEETPROTECTION, SORT, SST – Shared String Table, STANDARDWIDTH, STRING, STYLE, TOPMARGIN, UNCALCED, USESELFS, VCENTER, VERTICALPAGEBREAKS, WINDOW1, WINDOW2, WINDOWPROTECT, WRITEACCESS, WRITEPROT, XCT – CRN Count, XF – Extended Format.
Drawing Objects
Charts
Document Integration, General Chart Structure, Common Record Blocks, Record Overview, Ordered by Identifier, Record Overview, Ordered by Name, CHAREAFORMAT, CHAXISLINE, CHBEGIN – Begin of Block, CHEND – End of Block, CHFRAME, CHLINEFORMAT, CHSOURCELINK, CHSTRING.
PivotTables
Change Tracking
Workspace Documents
Workspace Stream, Overview, Ordered by Record Identifier, INDEX, SHEETHDR, SHEETSOFFSET.
File type: PDF
File url:
http://sc.openoffice.org/excelfileformat.pdf
File size: 1.14 mb
Tutorial – Microsoft Office Excel 2003
File title:
Tutorial – Microsoft Office Excel 2003
File content:
Introduction, Opening Excel, Standard Toolbar (New, Open, Save, Permission, Print, Print Preview, Research, Copy, Paste, Undo, Insert Hyperlink, AutoSum, Sort Ascending, Chart Wizard, Microsoft Excel Help, More Options), Formatting Toolbar (FOnt, SIze, Bold, Italics, Underline, Align Left, Center, Align Right, Merge & Center, Currency Style, Percent Style, Decrease Indent, Border, Fill Color, Font Color), Navigating the Spreadsheet, A Simple Spreadsheet, Simple Formulas, Insert Rows & Columns, Sorting, Cell Formatting, Chart Wizard.
File type: PDF
File url:
http://getit.rutgers.edu/tutorials/excel/media/excel.pdf
File size:
246 kb