Imagine yourself on stage presenting a bunch of data with excel,
will you be running around in circles or straight to the point? Learn the Excel
Tips provided below and make yourself a confident presenter.
1、Hide the Toolbar
Since Excel 2007, Toolbar has occupied quarter of the screen. If you want more data to be shown on the screen rather than the Toolbar, you can hide the Toolbar by clicking on the ‘minimize’ button.
Since Excel 2007, Toolbar has occupied quarter of the screen. If you want more data to be shown on the screen rather than the Toolbar, you can hide the Toolbar by clicking on the ‘minimize’ button.
2、Full Screen
Click ‘Full Screen’ to display the spreadsheet fully, click ‘esc’ to exit full screen.
Click ‘Full Screen’ to display the spreadsheet fully, click ‘esc’ to exit full screen.
3、Multiple Windows
If you want to compare the data between two separate spreadsheets, click on ‘arrange all’. If you want to compare the data between two tables in the same spreadsheet, click on ‘new window’ first, then ‘arrange all’.
If you want to compare the data between two separate spreadsheets, click on ‘arrange all’. If you want to compare the data between two tables in the same spreadsheet, click on ‘new window’ first, then ‘arrange all’.
4、Switching between Windows
If you open more than one excel file at the same time, press the shortcut key ‘ctrl+tab’ to switch your window from one to another.
If you open more than one excel file at the same time, press the shortcut key ‘ctrl+tab’ to switch your window from one to another.
5、Zoom In/ Out
Press ctrl+scroll your mouse wheel to zoom in or zoom out the display of the spreadsheet.
Press ctrl+scroll your mouse wheel to zoom in or zoom out the display of the spreadsheet.
6、Check on the Designated Area of
a Spreadsheet
To check on the designated area of a spreadsheet, click on ‘view’ – zoom in to the designated area.
To check on the designated area of a spreadsheet, click on ‘view’ – zoom in to the designated area.
7、Freeze Header Rows
When there are too many rows on a table, you have to pre-set ‘freeze header rows’ in order for your headers to keep showing when you scroll down the table.
When there are too many rows on a table, you have to pre-set ‘freeze header rows’ in order for your headers to keep showing when you scroll down the table.
8、Hide 0 Value
Too many 0 value in a table could make you confuse. In order to avoid this, go to ‘file > option > advance > remove the ‘show zero in cells that have zero value’ option’.
Too many 0 value in a table could make you confuse. In order to avoid this, go to ‘file > option > advance > remove the ‘show zero in cells that have zero value’ option’.
9、Beware of Rounding Errors
Be noted that sometimes Excel will round off the value in a cell for display purpose, and this will directly change the amount that you keyed in manually. You must understand that this is because of the ‘round off principle’ or else your supervisor may think that it is your careless mistakes.
Be noted that sometimes Excel will round off the value in a cell for display purpose, and this will directly change the amount that you keyed in manually. You must understand that this is because of the ‘round off principle’ or else your supervisor may think that it is your careless mistakes.
10、 Add Hyperlink on Demo Menu
Create a Demo Directory in your spreadsheet and add as a hyperlink (right click on menu > hyperlink > follow the prompts to add a link). This may avoid you to search for your spreadsheets everywhere in the middle of your presentation.
Create a Demo Directory in your spreadsheet and add as a hyperlink (right click on menu > hyperlink > follow the prompts to add a link). This may avoid you to search for your spreadsheets everywhere in the middle of your presentation.
