Microsoft Excel

Microsoft Excel on Wikipedia

Microsoft Excel is a commercial spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. It is a widely used spreadsheet for these platforms. Excel forms part of Microsoft Office.

Tips

• If you save all or part of a workbook as web page, the files folder it create will have image versions of your charts.
• You can hide the ribbon/toolbar by:
  1. Double click on one of the ribbon tabs - such as Home, Insert, or Page Layout OR
  2. Press the Ctrl+F1 keys on the keyboard.

• You can convert multiple text URLs to active URLs in a column next to it using the formula "=HYPERLINK(A1)"
• Ctrl+~ shows all the formulas on the current worksheet
• F2 shows the formula for the cell you are on
  • F2 followed by F9 converts a formula to a value. Then press ↵ Enter to replace the formula with the value or Esc to keep the formula.

Wiki converter

The Copy and Paste Excel-to-Wiki Converter allows you to copy excel information to wiki text table that can be added to USApedia. It's features includes:

• format first row as header

• format first column as header

• use class="wikitable"

• use {{table}}

• collapsible

• sortable

• collapsed

• autocollapse

There is a simpler tool hosted by the Washington University in St. Louis.

Exporting Graphs as Images

If you save an excel file with graphs as an html file, it will create a sub-folder that includes the graphs as gif and png image files.

External links

• Copy and Paste Excel-to-Wiki Converter