Speed up your work, take part in the Excel Shortcut Challenge, learn 1 shortcut each day for 30 days!
With this small effort, you can save hours and days on a long term: I believe, that you can save minimum 20-30 minutes a day!
This is 10-15 workday a year!
This can be your second holiday. For this, it is worth to let off the mouse! “Shortcut challenge: Speed up your work” bővebben
Excel time management often causes a despair: instead of a date, a number is displayed, e.g. 41615. It depends on the cellformat.
Excel stores dates as a serial number. By default, January 1, 1900 is equivalent to number 1, and for example, 1st January 2013 is 41275, or 22th September 2017 is 43000, and 18th July 2020 will be 44000! “3 secrets about Excel time management” bővebben
Okay, Excel shortcuts are useful, but how do you remember so many letters? It’s best to stick to something. (You are lucky, because you understand English, and it’s easy to remember the words. But I mostly teach Hungarians, so I also have teach them some English as well.)
Here are 7 easy-to-remember Excel shortcuts:
You’ve probably seen poker players risking everything at bet, saying “All in”.
You can easily remember the shortcut to select everything (all cells) in an Excel table is Ctrl A (all). “7 easy-to-remember Excel shortcuts that can save you hours” bővebben
I’ve seen others add comments, insert notes into Excel spreadsheets – like post-it or sticky notes. How can I do the same? Can it be printed?
Answer: right-click on the cell and click Insert Comment.
Add comments to your file
You can add comments using the right mouse button or use Shift F2 shortcut. First, they look spectacular, take my advice, rather avoid using the comments. Instead, put the text into a separate cell – make a Comment column – and you can easily filter or sort these information.
“How can you add comments to an Excel table?” bővebben
Make or get a 2018 FIFA World Cup Excel Template for recording results! Following the matches is a great way to practice Excel! I recommend 3 great Excel templates.
The point is to use Excel and learn from it. Good experiences (like the FIFA World Cup) can change your attitude to Excel, and also help you remember more information (Excel features), since you are emotionally or intellectually tossed. “The 3 best FIFA World Cup Excel Templates” bővebben
With an Excel Hyperlink you can link another file or website to your Excel file, so you don’t have to search for it again and again. Or if the Excel file or Word document is too large, you can make a link inside the file, so you can jump from one point to another with a single click.
It’s simplier than you think, and it works in Excel, Word, Outlook and even on the Internet (for example, online email or web site editors) and it even has a hotkey! “What is an Excel Hyperlink, and how to use them?” bővebben
Move cells and columns with your mouse
If you want to copy cells or columns to a nearby location, simply select the cells and then hold the mouse over the border. In this case, the 4-way arrow is displayed, which means that you can move the cells. Simply move them with the mouse (drag-and-drop).
If you also press Ctrl, the arrow changes to +.
If you are moving the range this way, the original cells will be preserved and there will be a copy on the other place, too. “Tricky secret to move cells in Excel” bővebben