You have just applied a formatting style to a cell, use Ctrl + Y to quickly apply the same formatting to another cell.
I've used Microsoft Excel for 20 years and these 10 shortcuts will make you an Excel Guru in 5 minutes & maximize your productivity 100x:
🧵 Don't use Excel without knowing these 10 shortcuts:
You have just applied a formatting style to a cell, use Ctrl + Y to quickly apply the same formatting to another cell.
If you have a cell that contains a formula, you can use Ctrl + ~ to switch between the formula view and the value view of the cell. This allows you to see the underlying formula used to calculate the cell value.
The AutoSum shortcut is useful for quickly calculating the sum of a range of cells without having to manually type in the formula
When tracking the progress of a project, add the date each time a task is completed. Use Ctrl + ; to quickly insert the current date.
This shortcut is useful for quickly creating a hyperlink to a website, file, or another location in your spreadsheet.
This shortcut opens the Paste Special dialog box, allowing you to select the options for pasting the copied data, such as formatting, formulas, values, or comments.
This is useful for quickly copying data or formulas from the top cell to the cells below.
If you have data with headers in the top row, and you want to keep the headers visible while scrolling, use Alt + W + F + F to freeze the top row, so the headers remain visible while scrolling through the data.
If you have multiple columns, and some of the columns contain text or numbers that are too wide to display in full, then use Alt + H + O + I to quickly adjust the width of the columns to display the full content of the cells.
This shortcut adds a filter to the selected cells, allowing you to sort and filter the data based on certain information, such as sales data for a time period or region.
Use filter options to display only the information you need.
If you have a word or value you need to replace with something else, use Ctrl + H to enter the text or value you want to find, and then enter the text or value you want to replace it with, to replace all instances of it.
This shortcut is useful for adding comments to cells to provide additional information or context about the data.
• RT the FIRST tweet🔁
• Follow me @FluentInFinance
• Sign-up for my FREE newsletter to learn valuable skills: https://t.co/0pElxsPaXr!
More from All
You May Also Like
1/“What would need to be true for you to….X”
Why is this the most powerful question you can ask when attempting to reach an agreement with another human being or organization?
A thread, co-written by @deanmbrody:
2/ First, “X” could be lots of things. Examples: What would need to be true for you to
- “Feel it's in our best interest for me to be CMO"
- “Feel that we’re in a good place as a company”
- “Feel that we’re on the same page”
- “Feel that we both got what we wanted from this deal
3/ Normally, we aren’t that direct. Example from startup/VC land:
Founders leave VC meetings thinking that every VC will invest, but they rarely do.
Worse over, the founders don’t know what they need to do in order to be fundable.
4/ So why should you ask the magic Q?
To get clarity.
You want to know where you stand, and what it takes to get what you want in a way that also gets them what they want.
It also holds them (mentally) accountable once the thing they need becomes true.
5/ Staying in the context of soliciting investors, the question is “what would need to be true for you to want to invest (or partner with us on this journey, etc)?”
Multiple responses to this question are likely to deliver a positive result.
Why is this the most powerful question you can ask when attempting to reach an agreement with another human being or organization?
A thread, co-written by @deanmbrody:
Next level tactic when closing a sale, candidate, or investment:
— Erik Torenberg (@eriktorenberg) February 27, 2018
Ask: \u201cWhat needs to be true for you to be all in?\u201d
You'll usually get an explicit answer that you might not get otherwise. It also holds them accountable once the thing they need becomes true.
2/ First, “X” could be lots of things. Examples: What would need to be true for you to
- “Feel it's in our best interest for me to be CMO"
- “Feel that we’re in a good place as a company”
- “Feel that we’re on the same page”
- “Feel that we both got what we wanted from this deal
3/ Normally, we aren’t that direct. Example from startup/VC land:
Founders leave VC meetings thinking that every VC will invest, but they rarely do.
Worse over, the founders don’t know what they need to do in order to be fundable.
4/ So why should you ask the magic Q?
To get clarity.
You want to know where you stand, and what it takes to get what you want in a way that also gets them what they want.
It also holds them (mentally) accountable once the thing they need becomes true.
5/ Staying in the context of soliciting investors, the question is “what would need to be true for you to want to invest (or partner with us on this journey, etc)?”
Multiple responses to this question are likely to deliver a positive result.