Formulas and Functions


Key Differences

Formulas: Custom calculations created by the user using operators, cell references, and constants.

Functions: Predefined formulas in Excel designed to perform specific tasks, like summing values or finding the average.

Data people, repeat after me:

Excel is not a database.
Excel is not a database.
Excel is not a database.
Excel is not a database.
Excel is not a database.
Excel is not a database.
Excel is not a database.
Excel is not a database.
Excel is not a database.
Excel is not a database.

These 10 tips will make you feel like an expert and increase your productivity 100X:

1. Excel Keyboard Shortcuts:

These save a lot of time.

For example, you can press "Ctrl+C" to copy, "Ctrl+V" to paste, and "Ctrl+Z" to undo.

There are many more, so check out this cheatsheet:

Excel for Data Analysis

If you want to Excel at using the most used business software in the World, learn these powerful features:

• Wildcards
• XLookup
• Sparklines
• Remove duplicates
• Duplicate
• Transpose
• Trim
• Pivot tables
• Upper, lower, proper case
• Stock market data

Like it you need a complete tutorial on all these topics 👍❤️

Microsoft Excel is used by 99% of the World’s businesses.

But the truth is most people don't know how to use it.

10 must-have Excel skills to accelerate your career: 👇👇

• Wildcards:

A wildcard is a special character that allows you to perform partial matches on text in your Excel formulas.

Excel has three wildcards:

• Asterisk "*"
• Question mark "?"
• Tilde "~"

• XLookup:

XLookup is an upgrade compared to VLOOKUP or Index & Match.

Use the XLOOKUP function to find things in a table or range by row.

=XLOOKUP (lookup value, lookup array, return array)

• Sparklines:

Sparklines allow you to insert mini graphs inside a cell and provide a visual representation of data.

Use sparklines to show trends or patterns in data.

On the 'Insert tab', click 'Sparklines'.

• Remove duplicates:

Alt+A+M removes duplicates in a set of data in Excel.

• Duplicate:

Duplicate the data from the cell above.

Ctrl + D fills and overwrites a cell with the contents of the cell above it.

• Transpose:

This will transform items in rows to be shown in columns instead, or vice versa.

To transpose a column to a row:

1. Select the data in the column
2. Select the cell you want the row to start
3. Right-click, choose paste special, select Transpose

• Trim:

Trim helps to remove the extra spaces in data.

TRIM can be useful in removing irregular spacing from imported data.

=TRIM()