Differences between revisions 12 and 20 (spanning 8 versions)
Revision 12 as of 2023-01-13 22:15:31
Size: 1100
Comment:
Revision 20 as of 2025-07-18 14:15:00
Size: 1299
Comment: Link
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 27: Line 28:
 * [[Excel/Filter|Filter]]
 * [[Excel/Index|Index]]
 * [[Excel/StatisticFunctions|Statistic Functions]]
Line 29: Line 33:



== Data Processing ==

 * [[Excel/Deduplication|Deduplication]]
 * [[Excel/JoiningData|JoiningData]]
Line 47: Line 44:
== Power Query ==

 * [[Excel/GetAndTransformData|Get and Transform Data]]
 * [[Excel/PowerQuery|Excel Power Query]]
 * [[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)