Posts

ADVANCED COPY AND PASTE IN EXCEL

Image
Copy and Paste is one of the simple tool use in Excel but today we will be learning one of the rarely used Copy and Paste Special tool. Do you have a data in Vertical orientation that you want to copy and paste in Horizontal orientation or the vice versa then follow this tutorial to get the work done. 1. Highlight the cells and copy. (Shortcut for copy is Ctrl+C)  2. Select the cell you want to start the paste, click on the paste button and select PASTE SPECIAL.  4. Tick the TRANSPOSE and Click OK.  You can also watch the video tutorial here.  In my next tutorial we will be learning how to link Excel to Power Point for presentation. Anytime the Excel is updated it automatically update on the Power Point. Subscribe to receive first hand information and leave your comments. Thanks.

Using Excel to Read articles and financial statement

Image
MICROSOFT EXCEL, MY TALKING TOM PART 2 Using Excel to read articles and financial statement Good day power users, I n this tutorial we will be learning how to use excel to read articles and financial statement. This is a continuation of the part 1 tutorial. Do well to go through the part one if you haven't done that please. Follow this link to view part 1. Microsoft Excel, My talking Tom Part 1 STEP 1. Activate the Customize Quick Access Toolbar-----More Commands Select custom Ribbon Change the popular Commands to Commands Not in the Ribbon and  Click on the New group (Custom)    STEP 2 Scroll down the commands not in the Ribbon and select SPEAK CELLS Click on ADD and then OK. STEP 3 Copy and Paste any article in a Cell. Highlight the cell Click on the SPEAK CELLS button on the Home Tab   Reading Financial Statement.   Highlight all data and click on the the Speak Cells button.   Video tutorial

Microsoft Excel, My Talking Tom

Image
Part 1 I never believed everything is possible until I identified this technique in Excel where excel functions as a reading tool. Now it is possible to read articles, financial statement and the likes with excel. HOW TO ACTIVATE THE SPEAK ON ENTER BUTTON. STEPS   1. Open any Excel Workbook, and click on the Customize quick access Toolbar and click on the More Commands button.          2. Select the Customize Ribbon                 3. In the Customize Ribbons , click on New Group at the right bottom corner and change the POPULAR                     COMMANDS TO COMMANDS NOT IN THE RIBBON.      4.  Scroll to SPEAK ON ENTER, click on the ADD button and finally click on OK                  5. Check far right of the Home Tab for speak on enter Icon . Click on it to activate it. Now you can type              anything in the workbook and excel will speak back to you when you hit enter.                   You can also