|
Size: 911
Comment:
|
Size: 1256
Comment: Links
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 15: | Line 15: |
| * [[Excel/SearchQueries|Search Queries]] | * [[Excel/CopyPaste|Copy/Paste]] * [[Excel/FindReplace|Find/Replace]] |
| Line 17: | Line 18: |
---- |
|
| Line 25: | Line 24: |
| * [[Excel/Concat|Concat]] * [[Excel/Concatenate|Concatenate]] |
|
| Line 27: | Line 28: |
---- == Data Processing == * [[Excel/Deduplication|Deduplication]] * [[Excel/Merges|Merges]] ---- |
* [[Excel/Filter|Filter]] * [[Excel/Index|Index]] * [[Excel/StatisticFunctions|Statistic Functions]] * [[Excel/TextJoin|TextJoin]] * [[Excel/VLookup|VLookup]] |
| Line 43: | Line 38: |
| * [[Excel/DeveloperRibbon|Developer Ribbon]] * [[Excel/VBA|Excel VBA]] |
|
| Line 44: | Line 41: |
== Power Query == * [[Excel/GetAndTransformData|Get and Transform Data]] * [[Excel/UnpivotColumns|Unpivot Columns]] |
Microsoft Excel
A piece of software that often is mistaken for a database, or a professional data visualization platform, or a reliable math/finance tool.
Consider alternative programs that are more beginner-friendly and reliable, such as the Google search calculator or emacs SES mode.
Contents
User Interface
Functions
VBA