Private Excel course via Skype

Did you know that F4 repeats the last command if it is possible? If you are coloring, F4 repeats the last color or formatting.

For example, I use it when I look at a larger lists and highlight the problematic data in yellow. This is much easier to press the F4 button than to always click on the “bucket”.

In the Cell Format (Ctrl 1) panel, you can specify more advanced formatting, – e.g. border, font style, font size – and the F4 button will repeat it all.

Ctrl Y does the same thing if you use it alone – not after Ctrl Z = undo.

If you want more help, don’t hesitate to try the private Excel course via Skype. We will help you know Excel better and use it in a more effective way. You will be very grateful for the time you can save.

Some people – even serious managers – say, it’s not important to keep tracking because they ‘know’ or ‘feel’ the numbers.

“I feel like my company is doing well.”
“I don’t record my costs because I can keep track of it in my head.”
“During the holidays I surely gained 3 kilos.”

You may know … 

I believe in facts!

“What you keep tracking starts to improve” bővebben

If you just click with the mouse once per minute, that’s 480 times are a business day! If you click every second, it’s 28,800 clicks a day.

We – who works 8 hours a day with computer – are somewhere on this scale.

Mostly we click because we want to see the mouse at a given point and it’s easier to point out. (Surprisingly, this is the reason why the mouse was developed). “1. Let’s start the click-killing! Use the navigation arrows!” bővebben

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

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