Shopping Cart
Subscribe to Newsletter

Order Inernational Payment Ebook
Register on ediarosms.com
Web Design Packages

Computer & ICT Tips

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 ediaro. com

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.

Windows Keyboard Shortcuts

Windows Keyboard Shortcuts

To Press
Set focus on a notification. Windows Key+B
View properties for the selected item. ALT+ENTER
Displays the properties of the selected object. ALT+Enter
Cycle through items in the order they were opened. ALT+ESC
“Close the active item, or quit the active program. ALT+F4
Opens the shortcut menu for the active window. ALT+SPACEBAR
Display the System menu for the active window. ALT+SPACEBAR
Switch between open items. ALT+TAB
Carry out the corresponding command or select the corresponding option in a dialog box. ALT+Underlined letter
Display the corresponding menu. ALT+Underlined letter in a menu name
Select a button if the active option is a group of option buttons in a dialog box. Arrow keys
View the folder one level up in My Computer or Windows Explorer. BACKSPACE
Open a folder one level up if a folder is selected in the Save As or Open dialog box in a dialog box. BACKSPACE
Copy selected item. CTRL while dragging an item
Select all. CTRL+A
Copy. CTRL+C
Move the insertion point to the beginning of the next paragraph. CTRL+DOWN ARROW
Display the Start menu. CTRL+ESC
Close the active document in programs that allow you to have multiple documents open simultaneously. CTRL+F4
Move the insertion point to the beginning of the previous word. CTRL+LEFT ARROW
Move the insertion point to the beginning of the next word. CTRL+RIGHT ARROW
Create shortcut to selected item. CTRL+SHIFT while dragging an item
Highlight a block of text. CTRL+SHIFT with any of the arrow keys
Move backward through tabs in a dialog box. CTRL+SHIFT+TAB
Move forward through tabs in a dialog box. CTRL+TAB
Move the insertion point to the beginning of the previous paragraph. CTRL+UP ARROW
Paste. CTRL+V
Search for computers. CTRL+Windows Key+F
Cut. CTRL+X
Undo. CTRL+Z
Delete. DELETE
Display the bottom of the active window. END
Carry out the command for the active option or button in a dialog box. ENTER
Cancel the current task. ESC
Display Help in a dialog box. F1
Activate the menu bar in the active program. F10
Rename selected item. F2
Search for a file or folder. F3
Display the Address bar list in My Computer or Windows Explorer. F4
Display the items in the active list in a dialog box. F4
Refresh the active window. F5
Cycle through screen elements in a window or on the desktop. F6
Display the top of the active window. HOME
Switch MouseKeys on and off. Left ALT +left SHIFT +NUM LOCK
Switch High Contrast on and off. Left ALT +left SHIFT +PRINT SCREEN
Open the next menu to the left, or close a submenu. LEFT ARROW
Collapse current selection if it’s expanded, or select parent folder. LEFT ARROW
Display the items in the active list in a dialog box. F4
Refresh the active window. F5
Cycle through screen elements in a window or on the desktop. F6
Display the top of the active window. HOME
Switch MouseKeys on and off. Left ALT +left SHIFT +NUM LOCK
Switch High Contrast on and off. Left ALT +left SHIFT +PRINT SCREEN
Open the next menu to the left, or close a submenu. LEFT ARROW
Collapse current selection if it’s expanded, or select parent folder. LEFT ARROW
Display the items in the active list in a dialog box. F4
Refresh the active window. F5
Cycle through screen elements in a window or on the desktop. F6
Display the top of the active window. HOME
Switch MouseKeys on and off. Left ALT +left SHIFT +NUM LOCK
Switch High Contrast on and off. Left ALT +left SHIFT +PRINT SCREEN
Open the next menu to the left, or close a submenu. LEFT ARROW
Collapse current selection if it’s expanded, or select parent folder. LEFT ARROW
Display the shortcut menu for the selected item. Menu key
Switch ToggleKeys on and off. NUM LOCK for five seconds
Display all subfolders under the selected folder. NUM LOCK+ASTERISK on numeric keypad (*)
Collapse the selected folder. NUM LOCK+MINUS SIGN on numeric keypad (-)
Display the contents of the selected folder. NUM LOCK+PLUS SIGN on numeric keypad (+)
Open the next menu to the right, or open a submenu. RIGHT ARROW
Display current selection if it’s collapsed, or select first subfolder. RIGHT ARROW
Switch FilterKeys on and off. Right SHIFT for eight seconds
Display the items in the active list in a dialog box. F4
Refresh the active window. F5
Cycle through screen elements in a window or on the desktop. F6
Display the top of the active window. HOME
Switch MouseKeys on and off. Left ALT +left SHIFT +NUM LOCK
Switch High Contrast on and off. Left ALT +left SHIFT +PRINT SCREEN
Open the next menu to the left, or close a submenu. LEFT ARROW
Collapse current selection if it’s expanded, or select parent folder. LEFT ARROW
Display the shortcut menu for the selected item. Menu key
Switch ToggleKeys on and off. NUM LOCK for five seconds
Display all subfolders under the selected folder. NUM LOCK+ASTERISK on numeric keypad (*)
Collapse the selected folder. NUM LOCK+MINUS SIGN on numeric keypad (-)
Display the contents of the selected folder. NUM LOCK+PLUS SIGN on numeric keypad (+)
Open the next menu to the right, or open a submenu. RIGHT ARROW
Display current selection if it’s collapsed, or select first subfolder. RIGHT ARROW
Switch FilterKeys on and off. Right SHIFT for eight seconds
Switch StickyKeys on and off. SHIFT five times
Prevent the CD from automatically playing. SHIFT when you insert a CD into the CD-ROM drive
Select more than one item in a window or on the desktop, or select text within a document. SHIFT with any of the arrow keys
Delete selected item permanently without placing the item in the Recycle Bin. SHIFT+DELETE
Display the shortcut menu for the selected item. SHIFT+F10
Move backward through options in a dialog box. SHIFT+TAB
Select or clear the check box if the active option is a check box in a dialog box. SPACEBAR
Move forward through options in a dialog box. TAB
Carry out the corresponding command. Underlined letter in a command name on an open menu
Display or hide the Start menu. Windows Key
Lock your computer if you are connected to a network domain, or switch users if you are not connected to a network domain. Windows Key+ L
Display the System Properties dialog box. Windows Key+BREAK
Show the desktop. Windows Key+D
Open My Computer. Windows Key+E
Search for a file or folder. Windows Key+F
Display Windows Help. Windows Key+F1
Minimize all windows. Windows Key+M
Open the Run dialog box. Windows Key+R
Restores minimized windows. Windows Key+Shift+M
Opens Utility Manager. Windows Key+U
 
Shortcut Keys Description
WINKEY Pressing the Windows key alone will open Start.
WINKEY + F1 Opens the Microsoft Windows help and support center.
WINKEY + F3 Opens the Advanced find window in Microsoft Outlook.
WINKEY + D Brings the desktop to the top of all other windows.
WINKEY + M Minimizes all windows.
WINKEY + SHIFT + M Undo the minimize done by WINKEY + M and WINKEY + D.
WINKEY + E Open Microsoft Explorer.
WINKEY + Tab Cycle through open programs through the taskbar.
WINKEY + F Display the Windows Search / Find feature.
WINKEY + CTRL+ F Display the search for computers window.
WINKEY + R Open the run window.
WINKEY + Pause / Break key Open the system properties window.
WINKEY + U Open Utility Manager.
WINKEY + L Lock the computer and switch users if needed (Windows XP and above only).
WINKEY + P Quickly change between monitor display types. (Windows 7 only)
WINKEY + LEFT ARROW Shrinks the window to 1/2 screen on the left side for side by side viewing. (Windows 7 only)
WINKEY + RIGHT ARROW Shrinks the window to 1/2 screen on the right side for side by side viewing. (Windows 7 only)
WINKEY + UP ARROW When in the side by side viewing mode, this shortcut takes the screen back to full size. (Windows 7 only)
WINKEY + DOWN ARROW Minimizes the screen.  Also, when in the side by side viewing mode, this shortcut takes the screen back to a minimized size. (Windows 7 only)
Others

I still wonder why there is still no shortcut to create a new folder. So, this is actually not a keyboard shortcut, but a trick shortcut.

  • Alt – goes to the menu
  • F – Selects “File” beside “Edit”
  • W – Selects “New”
  • F – Selects “Folder”.
  • Windows Logo + E – Open computer

You know that windows logo button between Ctrl and Alt on the bottom left of the keyboard? If you press Windows Logo + E, it will open the computer.

  • No, not automatically disassemble the computer and unscrew it,  but open the window where you will see the disk drives and the CD Rom.
  • Windows Logo + D – Show desktop; minimize all windows

You know when you have so many windows open, and you need to go to the desktop to open a program?

  • You don’t need to minimize every single window one by one again. Just press Windows Logo + D and you will arrive on the desktop.
  • Tab – Go to next text area

When filling forms on the web, especially username and password forms, this goes extremely handy.

  • When logging in, after typing the username, just hit “Tab” and tada! – you are at the password form without touching the mouse!
  • Typing name of file you’re looking for – Locating file

Lets say you are in a folder called ‘Pictures’ and you want to locate a file photo called “mejumping.jpg”, just type “mejum…”. Usually you don’t need to type the file’s entire name – just some of its first letters will do.

  • Ctrl + Click – Individually selecting multiple files

Lets say you are on a folder with lots of photos. You only want to select your good photos. How? Click a good photo. Then, Ctrl + click another good photo. Next, Ctrl + click another good photo!

See? It doesn’t unselect the previous files but adds the next files you have clicked to the selection!

  • Shift + Click – Select files from one end to another

You are on a photo page.. again. And now, you want to select photos from “PICT1209” to “PICT1281”. How? Click “PICT1209”. Then Shift + Click “PICT1281”.

Tada! You have selected all the photos between “PICT1209” and “PICT1281”!

  • Alt + Double click – View file properties

If you want to view the properties of a file, don’t need to Right Click >> Properties. Just hit Alt + Double Click and the properties will appear right before your eyes!

  • Windows Logo + 1, 2, or 3…–Launch quick launch items

If you have items in your Quick Launch (the part on the right of the Start button), here is a very nice way to quickly launch the quick launch.

If you want to launch quick launch item #1, hit Win + 1. Item #2? Win + 2. And so on and on and on… until item number 9.

Increase Volume Tremendously in VLC Media Player

Do you have a movie to watch but the volume is too soft? Well, here is a very simple and easy way to increase volume on computer with VLC media player.

  1. Open your video using VLC media player.
  2. Click on the video on the screen.
  3. Using your scroll wheel, scroll up until the volume goes to 400%.
  4. Still too soft? Want more boostage? Alright!
  5. On the Menu, click “Tools” and then click “Effects and Filters”.
  6. Check “Enable” and push the first slide bar to the MAX!

About ediaro. com

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.

Windows 7, Vista and XP Tips & Tweaks

  • Disabling Windows Vista And Windows 7 Login At Startup

When you start your Windows Vista or Windows 7 computer, by default the system makes you enter your password to log in. Here’s a way to get around it.


When you first install Vista or 7 and start using it, you are required to enter in a password for your account. But after that, you’re not really given a choice to remove the password if you don’t want it. You’re just sort of stuck typing it in every time and that can get old rather quickly!

If you’re not the only one who uses your computer, consider leaving it this way. It is a good security feature and it helps to keep all of the different accounts, files and preferences separate from each other. But if you’re the only one who ever uses your computer, you should be able to get rid of the password prompt if you want.

If you’d like to bypass the Windows Vista and 7 log on process and remove your password, just follow these steps:

  1. Go to Start, Control Panel.
  2. Click on the User Accounts and Family Safety link.
  3. Next, click on the User Accounts link.
  4. Under the “Make changes to your user account” section, click on the Remove Your Password link for your account.
  5. On the next screen that comes up, enter in your current password.
  6. Click on the Remove Password button to confirm everything.

Close out of all the open windows and restart your computer. That will allow you to test the system to make sure your password really was removed.

From now on, when you start up your Vista Or 7 computer, you will be taken to your desktop automatically and you will no longer have to worry about a password.

  •  Speedier mouse

To speed up mouse-pointer movements in Windows 7, click Start followed by Control Panel then click the ‘Hardware and Sound’ link and finally Mouse. Select Pointer Options and use the Motion slider to alter the speed.

  • Removing Internet Explorer 9

To remove IE9 from Windows 7, open Control Panel, click Uninstall a program and then click on the ‘View installed updates’ link. Choose IE9, and click Uninstall. IE9 will still be listed as an important update in Windows Update, so deselect it.

  • Prevent display rotation

In Windows 7, right-click the Desktop and choose Graphics Options then Graphics Properties. Deselect the ‘Enable rotation’ option in the Rotate tab.

  • Adjust program volume

To adjust a particular application’s volume in Vista & 7, right-click the volume icon in the Notification Area then click Open Volume Mixer. Now use the sliders to control each application’s sound level.

  • Organise backups

To keep backups in chronological order, use the date ot name the file- starting with the year(so ’2010-05-01-backup.zip’.for example).

  • Remove unwanted wireless networks

In XP, right-click the Notification Area’s wireless icon then choose View Available Wireless Networks. Click ‘Change advanced setting’ then Wireless Networks. Select the unwanted network and then click Remove.

  • Shake for clarity

In Windows 7, click and hold to ‘grab’ any open window’s title bar, then shake it around and all other open windows will minimise to the Taskbar.

  • Convert units

Windows 7?s Calculator application has a Unit Conversion option on the View menu. You will also find mortgage and leasing tools on the Worksheets submenu.

  • Restore previous file versions

To restore previous file versions in Windows 7, right-click a file and then chose Properties. Select the Previous Version tab, choose a version and then click Restore.

  • How to Turn Off Windows Help & Support

Windows has a built-in “Help & Support” feature that allows it to provide beginning users with hints and tips. Windows automatically starts these features using a Service every time the computer is booted. Services can use up system resources and CPU power if they are running, even if you are not currently using their features. If you are an advanced or intermediate user who does not need the “Help & Support” features of the Windows operating system, you can disable them by disabling the service that automatically starts them.

  1. Open the Start menu. Click on “Run” and enter “services.msc” into the “Open” dialog box. Press “OK.”
  2. Locate the Service named “Help and Support” in the right side of the window. Double click on the service.
  3. Set the “Startup type” to “Disabled” with the appropriate radio button. Press “OK.”
  4. Close all open windows and reboot the computer to put the changes into effect.
  • Monitor audio recording

In Windows 7, click Start, type sound and click the Sound icon. Click on the Recording tab, right-click the recording device and choose Properties. Click the Listen tab and tick ‘Listen to this device’.

  • Desktop slideshows

For Windows 7 slideshows, click Start, type desktop background and click ‘Change Desktop Background’. Click Browse, find an image folder and click OK. Tick the desired photos then click ‘Save changes’.

  • Create DVD slideshow

To burn slideshows to DVD in Vista and 7, click Start, type windows DVD maker and press Enter .Drag and drop photos and videos onto the windows, click Next, choose a menu style and add a soundtrack if wanted . Insert a recordable DVD and click Burn.

  • Aero Snap Shortcuts

In Windows7, hold the Windows key and tap the right or left arrow keys to have the current window set to the right or left edge of the screen.

  • Sort folders

Favorite files or folders can be kept at the top of the sort order in Windows Explorer by renaming them to start with either the ‘#’or’~’ symbol – just tap F2 to rename.

  • How To Save Word Documents (.docx) As PDF Documents; By using this Add-on

You can now easily save your Word Documents as PDF Documents; all you need to have is Microsoft Office 2007. This extension is not available for Microsoft Office 2010 because it already has another built-in extension for converting Word To PDF! So, if you’re a MS 2010 user; then you don’t have to download this extension as it is already there for you…
For Microsoft Office 2007 users, You need to download the “SaveAsPDFAndXML”extension to do this…
Microsoft Office 2007 Users; Click Here To Download!

  • Ultimate Control Panel

Expert Vista and 7 users can create a folder that contains all Control Panel tools. Click Start Followed by your username. Click New Folder(or from the File menu) button and name it ‘GodMode.{ED7BA470-8E54-465E-825C-9971204E01C}’.Double-click to see the Control Panel tools, Note this should not be used in 64-bit versions of Windows as it’s known to cause problems.

  • Add Desktops

Add additional named Desktops to Windows using the free Virtual win program.

  • Disable Caps Lock

In Vista or 7, click Start, type keyboard and then click Keyboard. Choose Key Settings, scroll to the CAPS LOCK entry, select it and then click Configure/Edit. Tick the ‘Disable the CAPS LOCK key’ box then click Finish, then OK.

  • Fix unrecognized USB memory keys

If a USB memory key isn’t recognized, click start, tight-click(My) computer then choose Manage. Click Disk Management and look for an entry that lacks a drive latter: right-click it and choose ‘Change Drive Latter and Paths….’. Click Change and choose the drive latter from the dropdown menu.

  • Permanently delete files

To securely delete files, download the free Eraser program, Once installed, press Control(Ctrl) and N to create a new task .Select ‘Run immediately’ and then click Add data. Select Unused disk space and click on OK.

  • Free up disk space

For a bit of extra disk space in any version of Windows, click Start, point to All programs followed by Accessories then System Tools and click Disk Cleanup and follow the prompts to remove unwanted junk.

About ediaro. com

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.

Point of Sale (POS) Security Tips: For Preventing/Reducing Fraud and theft in stock.

Point of Sale (POS) Security Tips: For Preventing/Reducing Fraud and theft in stock.The introduction of the Cashless Society into the Nigerian economy has brought about attendant benefit of easy audit trail for Nigerian Business Men and Women. Nearly 50% of retail business pilfering and stealing comes from employee theft. This poses more risk thank retailers think and it’s something every business owner should take seriously.

As a plan to maximize the potentials of POS for easy audit trail using POS Software, follow the following ediaro.com security tips:

  1. Require store managers to review register transactions every day – look for excessive openings of the drawer, small cash refunds, returns, etc. (Important Tip: Make sure your employees can see you or a manager reviewing this information. Don’t hide in the back room because just by letting them watch you can reduce more theft than anything.)
  2. Look at your “voided/cancelled/deleted sales report” every day.
  3. Look at your “returned transactions” report every day.
  4. Use common system passwords. Traditionally, POS systems are configured using standard/vendor supplied passwords to simplify ongoing support, from the operating system’s administrator password to the account used to log into the POS software. The issue with using standard passwords is the challenge of changing those passwords when an employee is terminated or if the password is made public. Ensure you change default system passwords.
  5. Do not share passwords so your cashiers can logon with a different username – each user should have their logon username and password.
  6. Add password protection/security to all areas of your software and ONLY allow employees to access what they really need.
  7. Unneeded services and user accounts should be turned off with a few clicks to instantly remove their associated security implications.
  8. Look at your “inventory adjustments report” every day.
  9. Look at your “profit margin reports” every day. If your margins are low in a certain category for that day, then you should do a little research to find out why.
  10. Keep your inventory count accurate.
  11. Make it common knowledge with your employees that your stock is constantly monitored in your POS system.
  12. The POS device should always stay within the merchant’s control, especially for Portable POS.
  13. Secure the access to your customer’s personal information in your POS software… particularly, their credit card information!
  14. Clerk/merchant staff should be very vigilant of their surroundings to prevent “Shoulder surfing” from other people standing nearby in your store – which could brew bad customer perception about your store.

To get extensive safety tips about POS, ATM security tips, online order, merchant online store security tips among others, get a copy of the upcoming book by Abdulazeez Idiaro: Safeguarding yourself and business from fraud in a cashless societyyou can register for launching date newsletter at: http://safeguardingyourselfandbusinessfromfraudinacashlesssociety.ediaro.com

If you’d like to receive more articles like this and many more, sign up for ediaro.com newsletter at http://newsletter.ediaro.com/

Join our facebook Fanpage at: http://www.facebook.com/browse/page_fans/?page_id=155197421218141

About ediaro. com

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.

Join our Social Network
Visit Us On TwitterVisit Us On FacebookVisit Us On Instagram