Differences between revisions 11 and 19 (spanning 8 versions)
Revision 11 as of 2022-12-29 13:34:05
Size: 1084
Comment:
Revision 19 as of 2025-07-18 13:52:49
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 29: Line 28:
 * [[Excel/Filter|Filter]]
 * [[Excel/Index|Index]]
 * [[Excel/StatisticFunctions|Statistic Functions]]
Line 30: Line 32:

----



== Data Processing ==

 * [[Excel/Deduplication|Deduplication]]
 * [[Excel/Merges|Merges]]

----
 * [[Excel/VLookup|VLookup]]
Line 52: Line 44:
== 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.


User Interface

Functions

VBA

Power Query


CategoryRicottone

Excel (last edited 2025-07-18 14:15:00 by DominicRicottone)