Monthly Archives: February 2012

1 2 3 15

Microsoft Word Hint and Tips

Microsoft Word is an outstandingly powerful program, but getting at that power may not be as easy or intuitive as you might like. It can be incredibly frustrating when you know you should be able to do something with the program but can’t, for the life of you, figure out how to do it. Check out the following Hints and Tips we’ve put together to make using it easer:

Microsoft Word

Align charts and pictures

  • In Word 2010, anchor charts and pictures to text to keep them in place. To do this, click the object and set the text-wrapping option to something other than ‘In-line with text’.
  • Create sub-lists

In Word 2003, choose Bullets and Numbering from the Format menu, click the Outline Numbered tab and choose create another item at the same level. Press the Tab button to drill down one level.

  • Show formatting marks

To display formatting marks in Word 2010,click the paragraph mark symbol(¶)in the Paragraph section of the Home tab. To adjust which marks are displayed, open the File menu, choose Options, click Display and then tick the boxes as appropriate. Click OK to save changes.

  • Perform simple sums

To add figures in Word 2010, click File followed by options. Click Quick Access Toolbar, Select All Command from the dropdown menu and then scroll through to find Calculate: click to select it the click Add. Click OK to save the changes.

  • Stop Insert key annoyances

In Word 2003, choose options from the Tools menu then select the Edit tab. Tick the ‘Use the INS key for paste’ box and click OK. The Insert key will now act as the paste function.

  • Link text boxes

To have text flow from one box to the next in Word 2010,click the Insert tab followed by Text box and insert text boxes into the document. Click the first box and then choose the Format tab within Drawing Tools. Click the Create Link icon in the Text selection then click the second box and the boxes will be linked.

  • Email documents as PDFs

To email documents as PDFs in Word 2010, click the File button and choose Save & Send followed by create PDF/XPS Document. Click on the Create PDF/XPS button and follow the instructions to complete the process.

  • Save as.doc

Word 2010 can save documents to older Word formats. Click File followed by Options and then click Save on the left. Choose ‘Word 97-2003 Document (*.doc)’.

  • See pictures in documents

If Word 2003 shows placeholders where images should be, first choose Options from the Tools menu then click the View tab. Now remove the tick from the ‘Picture placeholder’ box.

  • Make text fit

To shrink a document easily in Word 2003, choose Font from the Format menu then select the Character Spacing tab and use the Scale box to reduce the letter width and the Spacing box to reduce the space between letters.

  • Protect documents with passwords

To add password to Word 2007 doc., click the Protect Document icon on the Review tab. Click Editing restrictions, select how much formatting is allowed, tick the ‘Allow only this type of editing in the document ‘box and choose an option from the dropdown menu below. Click ‘Yes, Start Enforcing Protection’, type a password for the document twice and then click on OK.

  • Make the ribbon fun

The office 2007 and 2007 ribbon sharply divide opinion. But if you’re stuck with it (at work, say), then download Microsoft’s Ribbon Hero 2 game to learn how to make most of it .Get it free, from www.ribbonhero.com

  • Swap footnotes for endnotes

In Word 2003, open the Insert menu, point Reference and then choose Footnote. Select Endnotes and then choose whether footnotes should appear at the end of the document or section. Choose the formatting options, then click the Insert button.

  • Change case

All versions of Word have a shortcut for rectifying incorrect capitalisation. Select the affected text then hold down Shift and tap F3 to cycle through three variations: upper case, capitalise initial letter, and all lower case.

  • Use thin font variations

Where space is tight, use fonts designed for small spaces, such as Arial Narrow rather than Arial – as this avoids having to use a smaller font size.

  • Browse documents by image

To check images in large Word documents click the small circle icon at the bottom of the right hand scroll bar. Click on the Browse by Graphic icon and then click the double arrows above and below the circle icon to skip through the document’s images.

  • View hidden text

To view hidden text in Word 2003 documents, choose Options from the Tools menu, select the View tab, tick the ‘Hidden text ‘box and click OK. This is useful for adding notes that won’t be printed.

  • Split the document view

To split doc. in two, so two parts can be viewed at one, in Word 2003 choose Split from the Window menu. In Word 2007/10, the Split button is on the ribbon’s View tab. Drag the mouse to position the split point then left-click.

About

For over 5 years ediaro.com (a member of Fladio International Nigeria Limited) has provided web solutions and advertising for public and private sectors. Our main division is Computer and Information Technology. Thanks to our flexible approach towards the development of new solutions, we have often been at the inception of digital revolution and incorporating the most recent technologies. When you partner with ediaro.com, you are associating with one of Africa's best company for your ICT needs, we are the 1st Nigerian Company listed on the Economic Community for West African States (ECOWAS) ECOBIZ computer session in 2010. Focusing on quality, reliability and design of our products and services has brought us customers and partnership with local and Multinational Companies such as United Bank for Africa Plc (UBA), Interswitch Limited, Stanbic IBTC Bank Plc among others. Our current customer portfolio covers individuals, companies and Government agencies across the globe including Nigeria, India, United Kingdom, Mozambique and United States of America.

How Merchants can Identify online Fraud Patterns

With the Introduction of the cashless society into the Nigeria Society, many merchants are now setting up online e-How Merchants can Identify online Fraud Patternscommerce websites selling locally and internationally, infact we at ediaro.com saw an increase in our customer we develop e-commerce website for. Having an online stores has its benefits ranging from wider customer base, instantly selling to the global markets, marketing your products and brand among others. Unfortunately, the high risk of internet fraud and cybercrime is a serious problem that must be tackled simultaneously; as we often advice and support all our customers we develop websites for.

Find below, ediaro.com safety tips, By Abdulazeez Idiaro – you can use them to Identify online debit/credit can fraud as a merchant. It’s important to watch for this common signs of fraud. Though the circumstances below often apply to honest customers too, they can also be indicators of illegal activity.

Pay Extra-Diligence to orders that are:

  • Unusually very large beyond reasonable doubt.
  • Shipping to an address that is different from the billing address
  • Shipping to countries you don’t normally ship to especially the “High risk areas”.
  • Shipping multiple identical items to the same person/at the same time.
  • Unable to pass an address verification process
  • Orders that looks extra-ordinary in any way

Pay closer attention to customers who:

  • Use an anonymous/free email address
  • Supply a non-existent or under-construction website address
  • Use a non available, disconnected or changed telephone number
  • Supply a fake-sounding physical address (such as 123 Right Street)
  • A order to a post office box
  • Want shipping as quickly as possible at any price
  • Do not pass credit or identity checks
  • Don’t make immediate full payment
  • First time buyers

 Pay closer attention to credit card numbers that:

  • Generate multiple orders over a short time span, especially if each order ships to a different address
  • Are one of several card numbers shipping to the same address

If you’d like to receive more articles, sign up for ediaro.com newsletter athttp://newsletter.ediaro.com/

Join our facebook Fanpage by Clicking on like at: http://www.facebook.com/ediaro

About

For over 5 years ediaro.com (a member of Fladio International Nigeria Limited) has provided web solutions and advertising for public and private sectors. Our main division is Computer and Information Technology. Thanks to our flexible approach towards the development of new solutions, we have often been at the inception of digital revolution and incorporating the most recent technologies. When you partner with ediaro.com, you are associating with one of Africa's best company for your ICT needs, we are the 1st Nigerian Company listed on the Economic Community for West African States (ECOWAS) ECOBIZ computer session in 2010. Focusing on quality, reliability and design of our products and services has brought us customers and partnership with local and Multinational Companies such as United Bank for Africa Plc (UBA), Interswitch Limited, Stanbic IBTC Bank Plc among others. Our current customer portfolio covers individuals, companies and Government agencies across the globe including Nigeria, India, United Kingdom, Mozambique and United States of America.

Microsoft Excel Hints and tips

Excel spreadsheets are a useful tool in any business and, although they can be time consuming to build, it is worthwhile Microsoft Excelto reduce the time you take to build your spreadsheets by learning as many shortcuts as possible. Find below some hints and tips to using spreadsheets:

  • How to restrict users to using only a certain range of cells within one or more worksheets ?

Solution
Navigate to the worksheet you wish to restrict and then press Alt + F11. The Visual Basic Editor is now displayed. If the Properties dialog box is not displayed, then press F4 to display it. One of the Properties within the dialog box is called ScrollArea – the range that you enter into here will be range that the user is restricted to using.

Tip – Another way to get into the Visual Basic Editor is to right click on the worksheet name tab and then and select view code.

Caution – The user can still navigate to and alter a cell outside the restricted area by typing the cell reference into the Name Box located above cell A1.

Big Problem – When you re-open the workbook, even after you have saved it – the ScrollArea restriction that you have just set disappears. To solve this problem you need to enter a piece of VBA code that will set the restriction the moment the workbook is opened.

  • Groups rows and columns

In Excel 2007/10, select a range of rows or columns, then click the Group dropdown menu on the Data tab and choose Rows or Columns. Now click on the Group button and a bar will appear above the spreadsheet, with numbers showing the different levels of grouping.

  • How to hide a worksheet so that it does not appear in the Format > Sheet > Unhide… Dialog Box ?

Solution
Right click on the worksheet tab that you want to hide and then select view code. Then press F4 to view the Properties Dialog Box. There is a property called Visible – change this to xlSheetVeryHidden. Note that you must have at least one sheet visible at all times.

  • Reveal formulae

To quickly see all formulae used in an Excel spreadsheet, hold down Control and tap the ‘key (the button to the left of the number 1 on most keyboards). Press it again to reverse the change.

  • Remove duplicate data

To find and remove duplicate data items in Excel 2010, select the relevant area then click Remove Duplications on the Data tab. If there are column headings, select ‘My data has headers’ and click Select All. Click OK to remove duplicates.

  • How to find out the name of the last user who opened an Excel file ?

Solution
When you open an Excel file, your name is embedded in the file. This occurs even if you do not save the file.

Note – This behaviour does not occur if the file is a read-only file, or if personal information has been removed.  To remove personal information from an Excel workbook select Tools > Options > Security and then check Remove personal information from file properties on save.

The name that is stored is the user name listed in the Options dialog box – Tools > Options > General.

To see the name simply open the Excel file using any text editor such as Notepad or Microsoft Word.  The users name will appear somewhere within the text.

  • Show recent documents

In Excel 2010, open the File menu, click Options. Click Advanced options then scroll down to the Display section and type the desired number into the ‘Show this number of Recent Documents ‘box.

  • Remove unprintable characters

Data imported from external sources can sometimes contain unprintable characters. To remove these from data contained in cell A1,say, choose another cell and use formula=CLEAN(A1).

  • Clearer numbers

It’s possible to have Excel abbreviate large numbers, so that 1,000,000 become 1M and 1,000 becomes 1K, for example. To do this, select the relevant cells and press Control and 1 to show the Format Cells window. Select the Number tab, choose the Custom option then click in the Type box and type [>=1000000]0,,”M”;[>=1000]]0,”K”;0(with no spaces).

Click OK.

  • Customise the ribbon

Click File followed by the Customize ribbon. Click New Group at the bottom right and then Rename. Type a name and click OK. Now drag and drop icons from the left-hand column into the new group.

  • Customise the Status bar

The Status bar at the bottom of the Excel window can be customized. Right-click on an empty part and chose an option from the pop-up menu.

  • Text to columns

If you have a list of forenames and surnames in a single column, it’s easy to separate them. In Excel 2003, select the affected column then open the Data menu and choose Text to Columns. Choose Delimited, click Next and tick the box (or boxes) representing the characters that delimit the names (typically a space). If the preview looks right, click Next followed by Finish.

  • Check formulae

In Excel 2003,open the View menu, point to Toolbars and choose Formula Auditing. On the toolbar that appears, troubleshoot problems.

  • How to count the number of words within a cell ?

Type the following formula =LEN(TRIM(A1))-LEN(SUBSTITUTE(A1,” “,””))+1 – assuming that you want to count the number of words within cell A1.

  • Better Autofill

Autofill is a great timesaver but if you need to lock certain cell references before using it, then append a ‘$’ symbol before both the letter and number, so A1 would become $A$1.

  • Is there a way to count the number of words within a range ?

Type the following formula =SUM(LEN(TRIM(A1:C3))-LEN(SUBSTITUTE(A1:C3,” “,””))+1)-SUM(IF(ISBLANK(A1:C3)=TRUE,1,0)) – assuming that you want to count the number of words within the range of cells A1:C3.

After you have entered this formula you must select the cell that has the formula and then press F2 and then Ctrl + Shift + Enter to make this an Array Formula.

About

For over 5 years ediaro.com (a member of Fladio International Nigeria Limited) has provided web solutions and advertising for public and private sectors. Our main division is Computer and Information Technology. Thanks to our flexible approach towards the development of new solutions, we have often been at the inception of digital revolution and incorporating the most recent technologies. When you partner with ediaro.com, you are associating with one of Africa's best company for your ICT needs, we are the 1st Nigerian Company listed on the Economic Community for West African States (ECOWAS) ECOBIZ computer session in 2010. Focusing on quality, reliability and design of our products and services has brought us customers and partnership with local and Multinational Companies such as United Bank for Africa Plc (UBA), Interswitch Limited, Stanbic IBTC Bank Plc among others. Our current customer portfolio covers individuals, companies and Government agencies across the globe including Nigeria, India, United Kingdom, Mozambique and United States of America.

1 2 3 15