Data Manipulation in Excel Cheat Sheet
Discover how to manipulate data in Excel using this convenient cheat sheet!
May 2023 · 4 min read
Have this cheat sheet at your fingertips
Download PDFMaster your data skills with DataCamp
More than 10 million people learn Python, R, SQL, and other tech skills using our hands-on courses crafted by industry experts.
Topics
RelatedSee MoreSee More
podcast
The Venture Mindset with Ilya Strebulaev, Economist Professor at Stanford Graduate School of Business
Richie and Ilya explore the venture mindset, the importance of embracing unknowns, how VCs deal with unpredictability, how our education affects our decision-making ability, venture mindset principles and much more.
Richie Cotton
59 min
cheat sheet
LaTeX Cheat Sheet
Learn everything you need to know about LaTeX in this convenient cheat sheet!
Richie Cotton
tutorial
How to Calculate Factorials in Excel: A Complete Guide
Learn to calculate factorials in Excel with ease. Discover FACT, FACTDOUBLE, GAMMA functions, and more to solve mathematical and real-world problems.
Elena Kosourova
7 min
tutorial
How to Use the XLOOKUP Excel Function with Multiple Criteria
This tutorial discusses the purpose and syntax of the XLOOKUP Excel function, its advantages concerning its predecessors, the two main ways of using XLOOKUP with multiple criteria including their pros and cons, extending functionality through the optional parameters, and the way of running a similar search in older Excel versions.
Elena Kosourova
0 min
tutorial
How to Calculate Confidence Intervals in Excel
A beginner-friendly, comprehensive tutorial on understanding Confidence Interval calculations in Microsoft Excel.
Arunn Thevapalan
8 min
tutorial
Monte Carlo Simulation in Excel: A Complete Guide
A beginner-friendly, comprehensive tutorial on performing Monte Carlo Simulation in Microsoft Excel, along with examples, best practices, and advanced techniques.
Arunn Thevapalan
9 min