Hi,
A workbook very often contains a lot of worksheets, which makes it hard to easily find the correct sheet.
Moving the sheets by left clicking the arrows on the bottom left corner is an option, but not the best choice.
Try a right click on the arrows . A nice overview of the worksheets is displayed.
Left [...]
Hi,
In order to move a button on a toolbar, press and hold the ALT key, whilst dragging the button of your choice to the desired location.
Enjoy,
Stefaan
Hi,
This trick is only valid for one cell.
As far as I am aware, there is no trick to do the same for a range of cells.
Select the cell
Hit F2 key (=edit the content of the cell)
Hit F9 key (=paste as value)
Enjoy,
Stefaan
Hi,
Very often, in time registration, decimals are used to indicate hours.
e.g. 1.5 instead of 1:30
This is in fact incorrect. Excel translates 1.5 into a date.
1.5 is in fact 1.5 days after 01-Jan-1900.
When you apply a date format to a cell containing 2, this would return 02-Jan-1990
Back to the problem. How Can we convert decimal numbers [...]
Hi,
Last week I found an excellent Year calendar via http://www.spreadsheetpage.com.
It was an Excel book that created a year calendar.
This was very sofisticated. My needs however were slightly different.
I was in need of an overview by month for all my team members’ whereabouts.(yes I know, webbased solutions,blablabla)
Creating this file one time is fine, but I didn’t [...]
Excel has two date systems, but is defaulted to the 1900 Date system. This system however can not handle negative hours.
1900 Date system
In the 1900 date system, the first day that is supported is January 1, 1900. When you enter a date, the date is converted into a serial number that represents the number of [...]
In this example we will add times. The result will be greater than 24:00 hours.
By default, Excel displays 24:00 as 12:00, 28:00 as 04:00
In the above example, the actual hours worked would be 38. However, the format being used does not allow Excel to display elapsed hours.
Instead Excel displays the result of the subtraction 38:00-24:00.
How [...]
These following shortcuts are included in the complete list from post http://excel.vaneenoo.eu/?p=24.
These are the shortcuts I use all the time:
CTRL+”*” : Selects the current region
CTRL+”+” : Inserts the same number of selected rows/columns
CTRL+”-” : Deletes the selected rows/colums
CTRL+”;” :Inserts a snapshot of the current date
CTRL+SHIFT+”;” : Insert a snapshot of the current time
SHIFT+F11 [...]
Ever wanted to past data (Table, Pivot Report, etc.) as a picture ?
When you follow the menu Edit, you’ll notice that no options are available to paste the copied data as a picture.
How can we paste data as a picture ?
Another great link sent to me by Alfred vachris
Excel Compare is a tool that saves you the trouble of manually searching for differences and offers you computer-aided comparing of Excel files. Excel Compare allows you to compare Excel files, Excel spreadsheets and selected ranges of sheets. Excel Compare compares data straight from your worksheets, and [...]
Using the function wizard is often very time consuming…here’s a shortcut I use all the time.
Write the equal sign and then the name of the function
e.g. =vlookup
Press and hold CRTL and press a (CTRL-A)
There you are.
Tip: try the same, but use CTRL-SHIFT-A
This is a little game I designed, in order to make a recap slightly more interactive.
This will only work if you have activated the Analysis Toolpak Add-In.
(Tools - AddIns - Analysis Toolpak)
Click on the picture of the dice to get different questions.
The questions can be modified on the second page.
Recap Dice
Hi,
Please find below 9 pages of shortcuts. Some of them are extremely useful.
Others are crap
general_shortcuts
Enjoy
Stefaan
This group has been designed for Excel trainers who want to share their expertise, knowledge and exercises with other trainers.
Every contribution is appreciated!