I've used Microsoft Excel for 15+ years and these 15 tips will make you feel like an expert & increase your productivity.
Don't use Excel again without knowing these 15 functions:
Don't use Excel again without knowing these 15 functions:
1) 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.
Formula: =XLOOKUP (lookup value, lookup array, return array)
XLookup is an upgrade compared to VLOOKUP or Index & Match. Use the XLOOKUP function to find things in a table or range by row.
Formula: =XLOOKUP (lookup value, lookup array, return array)
2) TRIM
TRIM helps to remove the extra spaces in data.
TRIM can be useful in removing irregular spacing from imported data
Formula: =TRIM()
TRIM helps to remove the extra spaces in data.
TRIM can be useful in removing irregular spacing from imported data
Formula: =TRIM()
3) Sparklines
Sparklines allow you to insert mini graphs inside a cell to provide a visual representation of data.
Use sparklines to show trends or patterns in data.
On the 'Insert tab', click 'Sparklines'
Sparklines allow you to insert mini graphs inside a cell to provide a visual representation of data.
Use sparklines to show trends or patterns in data.
On the 'Insert tab', click 'Sparklines'
4) Transpose
This will transform items in rows, to instead be shown in columns, 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
This will transform items in rows, to instead be shown in columns, 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
5) Index Match:
The main difference between VLOOKUP and INDEX MATCH is the column reference
VLOOKUP uses a static column reference but INDEX MATCH uses a dynamic column reference
Index Match is much more flexible as you can search by row, by column, or by both
The main difference between VLOOKUP and INDEX MATCH is the column reference
VLOOKUP uses a static column reference but INDEX MATCH uses a dynamic column reference
Index Match is much more flexible as you can search by row, by column, or by both
6) Remove Duplicates
Remove duplicates in a set of data in Excel
Shortcut: Alt+A+M
Remove duplicates in a set of data in Excel
Shortcut: Alt+A+M
7) Wildcards
A wildcard is a special character that allows you to perform partial matches on text in your Excel formulas.
Excel has three wildcards: an asterisk "*", question mark "?", and "~"
A wildcard is a special character that allows you to perform partial matches on text in your Excel formulas.
Excel has three wildcards: an asterisk "*", question mark "?", and "~"
8) DatedIf:
Calculates the number of (1) days, (2) months, or (3) years between two different dates
Formula: =DATEDIF(X,Y,"D")
X = Start date cell
Y = End date cell
"D"= Time interval
β’ D = Days
β’ M = Months
β’ Y = Years
Calculates the number of (1) days, (2) months, or (3) years between two different dates
Formula: =DATEDIF(X,Y,"D")
X = Start date cell
Y = End date cell
"D"= Time interval
β’ D = Days
β’ M = Months
β’ Y = Years
9) Importing data from websites:
With Excel, you can connect to multiple data sources, text files, other Excel files, databases & websites.
β’ Select 'Data' > Get & Transform > From Web
β’ Press CTRL+V to paste the URL into the text box, then select OK
This will save hours!
With Excel, you can connect to multiple data sources, text files, other Excel files, databases & websites.
β’ Select 'Data' > Get & Transform > From Web
β’ Press CTRL+V to paste the URL into the text box, then select OK
This will save hours!
10) Goal Seek:
Get fast answers with Goal Seek. It is also known as What-if-Analysis.
Goal Seek basically uses trial & error to back-solve a problem, by plugging in guesses until it arrives at the correct answer.
Get fast answers with Goal Seek. It is also known as What-if-Analysis.
Goal Seek basically uses trial & error to back-solve a problem, by plugging in guesses until it arrives at the correct answer.
11) Conditional Formatting:
Conditional formatting helps to visualize data and shows patterns & trends in your data
Select 'Home' > Conditional Formatting > Highlighting Cell Rules
Conditional formatting helps to visualize data and shows patterns & trends in your data
Select 'Home' > Conditional Formatting > Highlighting Cell Rules
12) TRIM
TRIM helps to remove the extra spaces in data.
TRIM can be useful in removing irregular spacing from imported data
Formula: =TRIM()
TRIM helps to remove the extra spaces in data.
TRIM can be useful in removing irregular spacing from imported data
Formula: =TRIM()
13) Pivot Tables
A powerful tool to calculate, summarize & analyze data, which allows you to compare or find patterns & trends in data.
To access this function, go to "Insert" in the Menu bar, and then select "Pivot Table"
A powerful tool to calculate, summarize & analyze data, which allows you to compare or find patterns & trends in data.
To access this function, go to "Insert" in the Menu bar, and then select "Pivot Table"
14) UPPER, LOWER, PROPER
=UPPER, Converts text to all uppercase,
=LOWER, Converts text string to lowercase,
=PROPER, Converts text to proper case
=UPPER, Converts text to all uppercase,
=LOWER, Converts text string to lowercase,
=PROPER, Converts text to proper case
15) Stock Market data
You can get stock data in Excel
Enter a list of stock ticker symbols then select the cells and go to the Data tab, then click the Stocks button within the Data Types group.
Excel will match each cell value to a company stock and fill in the data
You can get stock data in Excel
Enter a list of stock ticker symbols then select the cells and go to the Data tab, then click the Stocks button within the Data Types group.
Excel will match each cell value to a company stock and fill in the data
Microsoft Excel is a must-have skill in today's job market. These threads take time to write so if you found it helpful, please:
β’ RT the FIRST tweet to share itπ
β’ Follow me @FluentInFinance for more
β’ Sign-up for my FREE newsletter to learn more: TheMoneyNewsletter.com!
β’ RT the FIRST tweet to share itπ
β’ Follow me @FluentInFinance for more
β’ Sign-up for my FREE newsletter to learn more: TheMoneyNewsletter.com!
Loading suggestions...