Excel, program pengolah angka buatan Microsoft ini cukup memusingkan bagi yang tak terbiasa menggunakannya, termasuk saya :D. Tapi sedikit tips dan trik bisa membantu Anda menggunakan Excel, lama kelamaan anda akan menyukainya juga he he he…
Adding Date and Time
To add a date at the Cell, press [Ctrl] while pressing Colon / semicolon. Similarly, to add a time, press [Ctrl] + [Shift] while pressing Colon / semicolon.
Changing the Color Tab
You can change the color tab in the Excel spreadsheet. Click the tab that will color, then select the menu [Format] [Sheet] [Tab Color]. Specify color and click [OK].
Hiding Sheets
You can hide an Excel worksheet to reduce the sheet that appears on the screen. Highlight Sheet which will be hidden and select [Format] [Sheet] [Hide]. To show again click [Unhide].
Cleaning Format
To clean the format in Excel spreadsheet, highlight the Cell which will be modified and select [Edit] [Clear] [Formats].
Monitoring Cell
Use the Watch Window to monitor cell in another workbook. To add a cell to the Watch Window, right-click on the Cell and select [Add Watch]. You can set the Watch Window position above or below the standard toolbar in Excel.
Adding Quotes
Excel can recognize the symbol of the stock and fetch stock quotes using MSN MoneyCentral Investor. First, activate the Smart Tags by selecting [Tools] [AutoCorrect Options] [Smart Tags]. Make sure the box "Label data with smart tags" is checked and press [OK]. Open the Internet and enter a stock symbol into the Cell. A small green triangle will appear at the bottom right corner of the Cell. Move your cursor over the cell, then click on the icon that appears and select "Insert refreshable stock price." Choose "On a new sheet" to display quotes or excerpts on another Worksheet or "Starting at cell" to display the stock price at the Cell that you are open.
Simultaneously Change
To change the typeface or size of cell in a spreadsheet all at once, click the box in the upper left corner.
Sorting Data
You can rearrange the data in a spreadsheet by clicking the box in the upper left corner. Then select [Data] [Sort]. In the Sort window, select the column you want sorted from top to bottom or vice versa.
No comments:
Post a Comment