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
ChatGPT is a phenomenal AI Tool.
But don't limit yourself to just ChatGPT.
Here're 8 AI-powered tools you should try in 2023:
1. KaiberAI
@KaiberAI helps you generate beautiful videos in minutes.
Transform your ideas into the visual stories of your dreams with this Amazing Tool.
New features:
1. Upload your custom music
2. Prompt Templates
3. Camera Movements:
Check here
https://t.co/ivnDRf628L
2. @tldview TLDV
Best ChatGPT Alternative for meetings.
Make your meetings 10X more productive with this amazing tool.
Try it now:
https://t.co/vOy3sS4QfJ
3. ComposeAI
Use ComposeAI for generating any text using AI.
It’s will help you write better content in seconds.
Try it here:
https://t.co/ksj5aop5ZI
4. Browser AI
Use this AI tool to extract and monitor data from any website.
Train a robot in 2 minutes to do your work.
No coding required.
https://t.co/nNiawtUMyO
But don't limit yourself to just ChatGPT.
Here're 8 AI-powered tools you should try in 2023:
1. KaiberAI
@KaiberAI helps you generate beautiful videos in minutes.
Transform your ideas into the visual stories of your dreams with this Amazing Tool.
New features:
1. Upload your custom music
2. Prompt Templates
3. Camera Movements:
Check here
https://t.co/ivnDRf628L
2. @tldview TLDV
Best ChatGPT Alternative for meetings.
Make your meetings 10X more productive with this amazing tool.
Try it now:
https://t.co/vOy3sS4QfJ
3. ComposeAI
Use ComposeAI for generating any text using AI.
It’s will help you write better content in seconds.
Try it here:
https://t.co/ksj5aop5ZI
4. Browser AI
Use this AI tool to extract and monitor data from any website.
Train a robot in 2 minutes to do your work.
No coding required.
https://t.co/nNiawtUMyO
You May Also Like
So the cryptocurrency industry has basically two products, one which is relatively benign and doesn't have product market fit, and one which is malignant and does. The industry has a weird superposition of understanding this fact and (strategically?) not understanding it.
The benign product is sovereign programmable money, which is historically a niche interest of folks with a relatively clustered set of beliefs about the state, the literary merit of Snow Crash, and the utility of gold to the modern economy.
This product has narrow appeal and, accordingly, is worth about as much as everything else on a 486 sitting in someone's basement is worth.
The other product is investment scams, which have approximately the best product market fit of anything produced by humans. In no age, in no country, in no city, at no level of sophistication do people consistently say "Actually I would prefer not to get money for nothing."
This product needs the exchanges like they need oxygen, because the value of it is directly tied to having payment rails to move real currency into the ecosystem and some jurisdictional and regulatory legerdemain to stay one step ahead of the banhammer.
If everyone was holding bitcoin on the old x86 in their parents basement, we would be finding a price bottom. The problem is the risk is all pooled at a few brokerages and a network of rotten exchanges with counter party risk that makes AIG circa 2008 look like a good credit.
— Greg Wester (@gwestr) November 25, 2018
The benign product is sovereign programmable money, which is historically a niche interest of folks with a relatively clustered set of beliefs about the state, the literary merit of Snow Crash, and the utility of gold to the modern economy.
This product has narrow appeal and, accordingly, is worth about as much as everything else on a 486 sitting in someone's basement is worth.
The other product is investment scams, which have approximately the best product market fit of anything produced by humans. In no age, in no country, in no city, at no level of sophistication do people consistently say "Actually I would prefer not to get money for nothing."
This product needs the exchanges like they need oxygen, because the value of it is directly tied to having payment rails to move real currency into the ecosystem and some jurisdictional and regulatory legerdemain to stay one step ahead of the banhammer.
