Monthly Archives: October 2012

SHORTCUTS AND TRICKS

Navigating round the system can be cool, exciting but equally stressful and time consuming if not for the shortcuts made available to us. Shortcuts are a set of instructions or commands given by computer users to the computer to perform specific functions. For instance, imagine you want to select over a thousand items, instead of holding the control key and clicking on the items or dragging the mouse over the items, you simply hold the control key and hit the “a” key and it selects everything. Quite easy, eh?!, But I bet most of you already knew that. That is just one of the numerous ways in which shortcuts are helpful.

Shortcuts can also be created for files and folders by right- clicking on the desktop, selecting new and under it shortcuts. You can also create commands to make your system shutdown (that will be for later).

Knowing all the shortcuts doesn’t make you computer competent. It just makes our works that much easier and faster.

Let us discuss the shortcuts we all know. Apart from the one we mentioned earlier we have quite a number, the famous “copy and paste”, otherwise known as “control c” and “control v”. The “control z” which is simply to undo the last action. I can go on and on, Yes!, ‘dem plenty!’. “Wouldn’t it be nice if we can get all the shortcuts collated in one place”, some of you may have wondered. We have collated as much as we could.

If you are interested in becoming computer competent, email us at info@quadclover.com now

 

SHORT CUT KEYS (WINDOWS)

1 Alt+Enter Display properties for selected item 18 F2 Rename Selected file
2 Alt + F4 Close Active windows or program 19 F3 Search for file or folder
3 Alt + Double + Click Display Properties dialog box 20 F4 Displays Address Bar list
4 Alt + Tab Switch Between open windows or programs 21 F5 Refresh active windows
5 Backspace Open a folder one level up 22 F6 Cycle through screen element in a window
6 Ctrl + A Select All 23 F10 Activate the Menu Bar
7 Ctrl + C Copy highlighted text selection 24 Shift + Ctrl + Esc Task Manager
8 Ctrl + X Cut 25 Shift + F10 Display shortcut Menu for selected item
9 Ctrl + V Paste (copied item) 26 Shift Stop an auto-run CD from playing automatically
10 Ctrl + Z Undo 27 Win key + D Display the desktop
11 Delete Delete 28 Win key + E Opens My Computer
12 Shift + Delete Delete without sending to Recycle Bin(do this with caution) 29 Win key + F Search for Files and Folder
13 Ctrl + Drag Copy 30 Win key + M Minimize all Open windows
14 Ctrl +shift +Drag Create short cut 31 Win key +shift + M Restore all Minimized open windows
15 Ctrl + F4 Close active documents in multiple document program 32 Win key + L Lock the Computer
16 Ctrl + Win key + F Search for Computers 33 Win key + R Open the run dialog Box
17 Ctrl + Esc Display the Start menu      

 

 

Is that all? Some of you may have wondered. Some of you would have gone further to ask if there are shortcuts for applications (for example Microsoft Word, excel and the likes).

Yes we do have shortcuts and some of the shortcuts listed above can also be used in these applications

 

 

 

 

            SHORT CUT KEYS (MICROSOFT WORD)

1 Ctrl + A Select all contents of the page 16 Ctrl + W Close current document
2 Ctrl + B Bold highlighted selection 17 Ctrl + X Cut selected Text
3 Ctrl + C Copy selected Text 18 Ctrl + Y Redo the Last action
4 Ctrl + D Open the font dialog Box 19 Ctrl + Z Undo last action
5 Ctrl + E Align the line or selected text to the center of the screen 20 Ctrl + Shift + > Increase selected font +1. pt up To 12pts. and then increase font +2pts.
6 Ctrl + F Open find and replace Box 21 Ctrl + Shift + < Decrease selected font -1pts if 12pt. or lower, if above 12 decrease font by +2pts.
7 Ctrl + G + or Ctrl + F5 Open find and replace Box 22 Ctrl + ] Increase selected font +1pts.
8 Ctrl + H Open find and replace Box 23 Ctrl + [ Decrease selected font –pts.
9 Click, Hold and drag More highlighted text from one point to the other 24 Ctrl + Del Deletes word to right of cursor
10 Ctrl + I Italicize highlighted selection 25 Ctrl +Backspace Deletes a word towards the left of cursor
11 Ctrl + J Justify (spread) the text across the page 26 Ctrl + Home Moves the cursor to the beginning of the document
12 Ctrl + K Insert link 27 Ctrl + End Moves the cursor to the End of the document
13 Ctrl + L Align the Line or selected text to the left of the screen 28 Ctrl +1 Single-Space lines
14 Ctrl + M Indent the paragraph 29 Ctrl + 2 Double-Space lines
15 Ctrl + Mouse wheel Zoom the Document 30 Ctrl + 5 1.5-line spacing
31 Ctrl + N Open a new Document 41 Ctrl + Spacebar Reset highlighted text to the default font
32 Ctrl + O Open an existing Document 42 Ctrl + F1 Open the task pane
33 Ctrl + P Open print window 43 Ctrl + F2 Print preview
34 Ctrl + R Aligns the line or selected text to the right of the screen 44 Double-click on a word Select the word
35 Ctrl + S Save the current  document 45 Triple-click on a line Select the paragraph
36 Ctrl + T Reduce hanging indent `46 Shift + F3 Cycle selection through sentence case, capital, and small letters
37 Ctrl + Shift + T Increasing Hanging indent 47 F4 Repeat the last action performed
38 Ctrl + M Increase paragraph indent from left to right 48 F5 Open the field, replace, and go to window in Microsoft Word
39 Ctrl + U Underline Selection 49 F7 Spell and grammar check selected text and /or document
40 Ctrl + V Paste Contents of Clipboard 50 F12 Save as

 

 

SHORT CUT KEYS (MICROSOFT EXCEL)

1 Alt + = Auto sum all values above the

Selection cell

18 Ctrl + 0 Hides the selected column
2 Alt + F1 Create chat of selected range 19 Ctrl + F6 Switch between open workbooks/windows
3 Alt + F2 Save As 20 Ctrl + F9 Minimize current window
4 Alt + Shift + F1 Insert new worksheet 21 Ctrl + F10 Maximize current minimized window
5 Ctrl + A Select all content of the worksheet 22 Ctrl + Page Up Move to the left among open worksheet
6 Ctrl + B Bold highlighted selection 23 Ctrl + page Down Move to the right among open worksheet
7 Ctrl + C Copies selected cell 24 Ctrl + Tab Cycle through open excel files
8 Ctrl + D Uses the fill Down command to copy the contents and format of the topmost cell of a selected range into the cell below 25 Ctrl + ‘ Insert the Value of the above cell in to the current cell
9 Ctrl + F Find 26 Ctrl + Shift + + Insert dialog box
10 Ctrl + G Go to 27 Ctrl + Shift + ~ Remove the outline border from the selected cells
11 Ctrl + H Replace 28 Ctrl + Shift + ! Format number in comma format
12 Ctrl + I Italicized 29 Ctrl + Shift + $ Format number in currency format
13 Ctrl + K Insert link 30 Ctrl + Shift + # Format number in date format
14 Ctrl + K Insert link, to remove link, select link, hold Ctrl and Click. Then click on Remove link button 31 Ctrl + Shift + % Format number in percentage format in no decimal spaces
15 Ctrl + U Underline highlighted selection 32 Ctrl + Shift + ^ Format number in scientific format
16 Ctrl + P Show print dialog Box 33 Ctrl + Shift + @ Format  number in time format
17 Ctrl + Z Undo last section 34 Ctrl + Spacebar Select entire column
35 Ctrl + 1 Display format cells dialog box 43 Shift + Spacebar Select entire Row
36 Ctrl + 2 Bold selected cell 44 F2 Select cell for editing
37 Ctrl + 3 Italicize 45 F5 Go to
38 Ctrl + 4 Underline 46 Shift + Arrow key Extend selection by one cell
39 Ctrl + 5 Strikethrough 47 Ctrl + Shift + ( Unhide any hidden columns within the selection.
40 Ctrl + 6 Alternates between hiding objects, displaying objects 48 Ctrl + Shift + ) Unhide any hidden rows within the selection
41 Ctrl + 8 Displays or hides the outline symbols 49 Shift F3 Open Excel formula window
42 Ctrl + 9 Hides the selected row 50 Shift F5 Find

 

 

 

 

SHORT CUT KEYS (MICROSOFT POWERPOINT)

1 Backspace or Up Arrow key Previous slide during presentation 21 Ctrl + Z Undo
2 Ctrl + F Find 22 Ctrl + = Change to subscript
3 Ctrl + G Change grid and guide settings 23 Ctrl + Shift + + Superscript
4 Ctrl + H Replace 24 Ctrl + F1 Show/ hide task pane
5 Ctrl + I Italicize Text 25 Ctrl + Shift + > Increase font size
6 Ctrl + J Justify text 26 Ctrl + Shift + < Decrease font size
7 Ctrl + K Insert hyperlink 27 Ctrl + Shift + C Copy format
8 Ctrl + L Left align 28 Ctrl + Shift + F Change font
9 Ctrl + M New slide 29 Ctrl + Shift + P Change font size
10 Ctrl + O Open 30 Ctrl + Shift + V Paste Formats
11 Ctrl + P Print 31 Ctrl + Shift + Tab Switch between outline and slides pane in normal view
12 Ctrl + Q Close PowerPoint 32 Ctrl +  Up Arrow Go up one paragraph
13 Ctrl + R Right align Text 33 Enter or Down Arrow key Next Slide
14 Ctrl + S Save 34 Esc, Ctrl, + Break or hyphen End Slide show
15 Ctrl + T Font dialog Box 35 Shift + F3 Change Text Case
16 Ctrl + U Underline highlighted text 36 Shift + F7 Thesaurus
17 Ctrl + V Paste 37 Shift + F9 Shoe or hide grid lines
18 Ctrl + W Close preparation 38 F1 Help
19 Ctrl + X Cut 39 F5 Slide Show
20 Ctrl + Y Redo last Action 40 F10 Set focus to first menu, File menu

That brings us to the end of this post. Thanks for Reading.

Advertisements
Categories: Uncategorized | 2 Comments

SAFETY IN THE CLOUD

Look up in the sky, it’s a bird, it’s a plane, NO!  It’s Sky drive -the future- that backs up data in a cloud. You have heard the popular saying “one day, we will build houses in the sky”. Well the ICT world is ahead, putting in place means for ‘storing data in clouds’. Rain clouds you say?  Of course not! A cloud in IT will only have meaning when concatenated with “computing”.

Cloud computing comes into focus when you think about what IT always needs – a way to increase capacity or add capabilities on the go without investing in new infrastructure, training new personnel, or licensing new software.

 

Before focusing totally on skydrives and cloud computing, I would like to remind you about other types of storage devices still being utilized. We shall also tell you which one is best and why, the best time to back up and how to remind you to back up.

1)      Floppy disks: this is slowly being phased out – if it hasn’t been completely – we have two types.    3½ and 5 1/4. They are used to store data of less than 10MB in size. It is not suitable for places that require large storage of data.

 

ADVANTAGES

i.)                  It is affordable

ii.)                 It is portable

DISADVANTGES

I)        It does not allow for large storage

II)      It is slowly being phased out.

2)      CDs/DVDs:  they are capable of holding up to 8GB worth of data. Contrary to popular belief, they can transfer viruses -not all of them though- the ones which can transfer viruses are the writeable and rewritable discs while the readable ones cannot.

 

ADVANTAGES

i)                    It is affordable and easy to use.

ii)                   It is portable

iii)                 It allows more space for storage than the floppy disk

DISADVANTAGES

i)                    It can easily be damaged

ii)                   If the lens of the disc drive becomes weak, data cannot be read

3)      Flash Drives and Hard Disk Drives: Data can be backed up to another storage device which uses USB ports. These devices are portable and can be used to transfer and back-up large data. Though special care must be taken to avoid it going bad.

 

ADVANTAGES

i)                    It allows the most storage for data

DISADVANTAGES

I)                    If the hard drive becomes unreadable, data can be lost completely.

4)      SkyDrive: Skydrive is based on the principles of cloud computing.

Cloud computing is at an early stage, with a crew of providers large and small delivering a slew of cloud-based services, from full-blown applications to storage services to spam filtering. Yes, utility-style infrastructure providers are part of the mix, but so are SaaS (software as a service) providers such as Salesforce.com. Today, for the most part, IT must plug into cloud-based services individually, but cloud computing aggregators and integrators are already emerging.

We have two types.

The first allows a single application to be used by a thousand customers. No investment in servers is required. It is called SaaS.

Secondly, the utility computing offers storage and virtual servers that IT can access on demand.

ADVANTAGES

i)                    It provides the most secure form of backing up.

DISADVANTAGES

I)                    Because of the nature of our internet service, it is not advisable.

Sky Drive utilizes the cloud computing principle but it really means backing up your files online. Microsoft and Google offer this.

IMPORTANCE OF BACKING UP

John has been working with a reputable company for over 3 years. He sees how his superiors in the IT room handle networking issues on a daily basis and has always been impressed. One day, he decided to go for the well known professional course Cisco Certified Networking Associate (CCNA). It took him 4 months to read and pass. He came back all smiles and resumed work.

A couple of weeks later, he was put on night duty and was told to monitor the network. He was grinning from ear to ear; because this was the first time he was going to be alone. One of his superiors, Dipo, was at the hospital expecting his first child while the other, Charles, left the office early as he wasn’t feeling too well.

John who passed the professional exam without actually using a live router decided to use this time to experiment and forgot to save the configuration of the router. After a couple of minutes, he crashed the network. Devastated, he knew with this, he was certainly getting the boot in the morning. He called Dipo telling him what he had done. Dipo in a calm voice told him that he will be with him shortly.

Dipo arrived an hour later, and within 20 minutes, he had restored the network. Curious, John inquired of Dipo asking what he did. Unknowingly to John, Dipo had told Charles to copy out the configuration before leaving the office every night.

WINDOWS BACKUP

Windows gives you the opportunity to back up your files with the automatic backup and restore feature. It can be found in the control panel and it is very easy to use.

select backup and restore

select set backup

Select where you will like to back up to

That is all there is to It.

That brings us to the end of this week. Have a lovely weekend.

Categories: Uncategorized | 1 Comment

DOING MORE WITH MICROSOFT OFFICE

Happy Independence Day in arrears people. Shall we rise for the national anthem? (Nah just kidding). That is definitely not why we are here. But let’s not forget something Nigeria celebrated her 52nd year of independence. Most of us are asking what we have to show for it. Yes, we are not living the way we would have liked. Good roads, constant power supply and better living conditions and Boko Haram stop with the killing. But we have a lot to be grateful about.

First of all, it could have been worse than what it is. We don’t have any natural disaster happening in any part of Nigeria. Secondly, unlimited Opportunities. Majority are waiting for government to provide them with jobs while they sit back and fold their arms. I hate to break it to you, but that ship has long sailed.

Apart from the crude oil and other natural resources, Nigeria has not fully explored one area which is ICT. Hate it or love it, it is not going away anytime soon. Most companies require applicants to be computer competent. Even more so, we are having computerized job tests. Before I continue, I will like to say there is a difference between being computer literate and competent. Even so, the difference between a computer literate and an “illiterate” is that one knows about computer while the other does not. While being competent is using the computer to achieve a specific task given.

We have different areas in computing. Networking, software development, web development and the likes. We would not be talking about those ones for now. We will start with the most popular requirement for increasing chances of getting a job and that is getting familiar with Microsoft office.

Do you know you can get a lot more from the Microsoft office package? Did you know that you can use Microsoft excel to design and even make web pages. Yes you saw right and no I am not crazy.

Let’s start with the one everyone knows or think they know

a)      Microsoft word: is a Word processing application. Word processing in the sense that it handles creating, editing, saving of text documents. You can also design invoices, receipts and the likes. Some people go as far as using it to design letter headed papers. It is possible. I am sure a lot of people didn’t know this.

b)      Microsoft Excel: handles most of the calculations, analyzing data and expressing them in forms of bar chart, pie chart, and the likes. We pretty much know these already. But did you know that you can design as well.  These were done in excel and I kid you not.

c)       Microsoft PowerPoint: creating and editing presentation or slide shows, meetings and web pages have never been this easy. You can also alter the orientation of the slide shows, increase or slow down and many more.

d)      Microsoft Outlook: Is a tool for sending and receiving mail. It is much more than that. It can also serve as your organizer. Keeping records of tasks done and setting reminders for appointments.

e)      Microsoft Access: Is a tool for creating and managing of database and the likes.

f)       Microsoft publisher: This particular application is relatively new and very useful. You can create almost everything from business cards, banners, brochures, calendar, envelope, flyers, greeting cards, invitation cards, newsletter, letterheads, programs, cvs, websites and complimentary cards. The only catch is that you can only make use of the templates provided. So if you are looking for something unique. Sorry, this would not help.

There are other applications in the whole package. We only decided to mention a few. The only thing left for me to say is stop underutilizing your office application.

If you wish to know more about ICT or getting more from your Microsoft office or the prospect of getting involved in ICT and also a show case of the courses we offer training on Visit www.quadclover.com for more info or send a mail to us info@quadclover.com or call 08097913802

Thank you and God Bless.

Categories: Uncategorized | 8 Comments

Create a free website or blog at WordPress.com.