Microsoft Excel: Difference between revisions
(Created page with "{{Breadcrumbs |align=right |page= |url= |officialwebsite=no |wikipedia=yes |powerpedia=no |openei=no |imwiki=no |imwikisupport=no }} '''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 p...") |
No edit summary |
||
| Line 21: | Line 21: | ||
}} | }} | ||
'''Microsoft Excel''' is a commercial spreadsheet application written and distributed by Microsoft for | '''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 == | == Tips == | ||
* If you [http://office.microsoft.com/en-us/excel-help/save-all-or-part-of-a-workbook-to-a-static-web-page-HA010220003.aspx save all or part of a workbook as web page], the files folder it create will have image versions of your charts. | * If you [http://office.microsoft.com/en-us/excel-help/save-all-or-part-of-a-workbook-to-a-static-web-page-HA010220003.aspx 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: | * You can hide the ribbon/toolbar by: | ||
*# Double click on one of the ribbon tabs - such as Home, Insert, or Page Layout OR | *# Double click on one of the ribbon tabs - such as Home, Insert, or Page Layout OR | ||
*# Press the {{keypress|Ctrl|F1}} keys on the keyboard. | *# Press the {{keypress|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)"<ref>http://stackoverflow.com/questions/2595692/how-do-i-convert-a-column-of-text-urls-into-active-hyperlinks-in-excel</ref> | * You can convert multiple text URLs to active URLs in a column next to it using the formula "=HYPERLINK(A1)"<ref>http://stackoverflow.com/questions/2595692/how-do-i-convert-a-column-of-text-urls-into-active-hyperlinks-in-excel</ref> | ||
* {{keypress|Ctrl|~}} shows all the formulas on the current worksheet | * {{keypress|Ctrl|~}} shows all the formulas on the current worksheet | ||
* {{keypress|F2}} shows the formula for the cell you are on | * {{keypress|F2}} shows the formula for the cell you are on | ||
** {{keypress|F2}} followed by {{keypress|F9}} converts a formula to a value. Then press {{keypress|Enter}} to replace the formula with the value or {{keypress|Esc}} to keep the formula. | |||
** {{keypress|F2}} followed by {{keypress|F9}} converts a formula to a value. Then press {{keypress|Enter}} to replace the formula with the value or {{keypress|Esc}} to keep the formula. | |||
=== Wiki converter === | === Wiki converter === | ||
| Line 45: | Line 39: | ||
{{Notice|Copying from Excel, using [[VisualEditor]], might be an easier method.}} | {{Notice|Copying from Excel, using [[VisualEditor]], might be an easier method.}} | ||
The [http://tools.wmflabs.org/excel2wiki/index.php Copy and Paste Excel-to-Wiki Converter] allows you to copy excel information to wiki text table that can be added to | The [http://tools.wmflabs.org/excel2wiki/index.php Copy and Paste Excel-to-Wiki Converter] allows you to copy excel information to wiki text table that can be added to Saintapedia. It's features includes: | ||
* format first row as header | * format first row as header | ||
| Line 64: | Line 58: | ||
There is a [http://wang.wustl.edu/mediawiki/extensions/index.php simpler tool] hosted by the Washington University in St. Louis. | There is a [http://wang.wustl.edu/mediawiki/extensions/index.php simpler tool] hosted by the Washington University in St. Louis. | ||
=== Exporting Graphs as Images === | === 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. | 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. | ||
==Related== | ==Related== | ||
Revision as of 12:24, 13 September 2024
|
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:
- Double click on one of the ribbon tabs - such as Home, Insert, or Page Layout OR
- 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)"[1]
- 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
 | Copying from Excel, using VisualEditor, might be an easier method. |
The Copy and Paste Excel-to-Wiki Converter allows you to copy excel information to wiki text table that can be added to Saintapedia. 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.