Monday, 30 June 2014

MICROSOFT EXCEL - EASY WAY TO CREATE A CHART IN

CHART, CHART CHART!!! When a chart is created using this program Microsoft Excel, there are always values within each cell that are being represented in a chart, which is then converted to a data point. This is the simple intersection of the X and Y axes (for two-dimensional charts or the X, Y, and Z axes for three-dimensional charts), which can also be referred to as a CELL REFERENCE.
This data may be expressed in any number of chart styles, including bars, columns, lines, and pie wedges.



The easiest way to create a chart is to use the Chart Wizard by following these steps:
Select the data range to be charted, or select a single cell within the table you wish to chart. Don't include any summary or total information in the range. You will create the best charts when you work with raw data. You can select any headings, however.

Click on the Chart Wizard tool to start the Chart Wizard. This displays the Chart Wizard dialogue box, where you are asked to select a chart type.

Select any of the 14 types shown in the Chart Type list. (You can always make changes later.) When you select a type, the information in the Chart Sub-type area of the dialogue box is changed.
Click on one of the Chart Sub-types shown at the right side of the dialogue box.
Click on Next. Excel proceeds to the second step of the Chart Wizard, where your information is first presented as a chart.

Make any necessary changes to the data range depicted in the dialogue box, then click on Next. Excel displays the third step of the Chart Wizard.

Using the controls in the dialogue box, indicate the title, labels, and other formatting you want used for your chart. As you make changes, notice that the sample chart is updated to reflect your changes.
When you are happy with your formatting settings, click on the Next button. Excel displays the final step of the Chart Wizard. Here you select whether you want your chart embedded in your worksheet or to appear on its own, as a chart sheet.

Click on Finish. Your chart is created as directed by you.
You should note that these are general steps for using the Chart Wizard. It is possible that the steps may be modified a bit depending on the type of chart you choose to create.


For some reasons deleting a Chart is what will bother some users, well am also going to show you how to delete a chart..

Excel allows it users to create various patterns of chart based on the data available in the present worksheet. Most of the times, these created charts can be on their independent worksheet, other times they may be under other sheets, hence embedded under those sheets. So weather the chart is embedded or is independent, deleting such charts are always done in the same way, all you need to do is to first of all know the chart to be deleted and later click on the chart.. After selecting the chart, click Delete Sheet from the Edit menu and then excel will bring a prompt asking you if you want to delete the selected chart, all you do is click on OK and the chart sheet is deleted.


LIKE AND SHARE THIS POST WITH YOUR FRIENDS

SUBSCRIBE to my YOUTUBE CHANNEL l for windows tricks and tips...

VISIT OUR FACEBOOK PAGE

Message me on Gmail via
kokothemann@gmial.com or nelson.godstime22@gmail.com

Saturday, 28 June 2014

MICROSOFT WORD - CHANGING THE COLOUR OF HYPERLINKS

As created and built with the software, Hyperlinks in Microsoft word are usually blue in colour.. To determine a hyperlink simply type an email address in word and give a space you will notice that text changing from its original colour (usually black) to blue.. I have wondered if changing this annoying blue colour can be possible, i wanna use my colour black as my hyperlink.. After studying the program carefully, I came to notice that i can remove the blue colour, thereby modifying the Hyperlink and its style.


All you have to do is to present a hyperlink by typing an email address, after typing the email address, highlight the text, and then click on the arrow next to style.. (the circled part of the image), under that menu we have style set, colour and font, select colour and click on a desired colour and your hyperlink colour is changed....

In the case of the modifying aspect simply Highlight the hyperlink , click on Font , Under then click on Font Colour, choose the colour you would like to apply to it but if you prefer blue its not a sin to leave it the way it was. Apart from that you can also decide to use the underline feature either by doubling the underline or selecting an underline that is best suitable for your usage...

Click OK twice to get back to your document.
In spite of what you saw in the Modify Style dialogue box, it is quite impossible for a user to tell Word to format or edit or customise hyperlinks with a different text colour and underline.


WINDOWS - CHANGING THE SCREEN RESOLUTION

It may be that you have just installed anew window in your computer, say windows 7 and at first what you notice is that the icons are somewhat big and the screen resolution is either too big or too small, this post will show you how to adjust it and make sure it suits you..

Well, as i will always say, firsts things first, what you need to do is to open the Personalisation dialogue box by Clicking on the Start button, Click on Control Panel, Double-click on Personalisation and then click on the Display Settings option, change-screen-resolution (vista).. We can open it i windows 7 by Right clicking on the desktop background and the select screen resolution, its easy here then there..
Now we have what we are looking for,
 (see image)

From the above image, you can see that there are lots of changes we can effect on that page, we may decide to change the display type, the resolution and even the orientation, so which ever you want to use your very free to select.. Now in the resolution aspect, you notice at the end of the figure you see recommended in a bracket.. But in some cases, after installing a new windows, maybe before the old windows was removed the drivers were not extracted, and so after the windows was renewed, there is no longer a recommended resolution fit for display for that computer at that time. what the user can do is to get a software popularly known as DRIVER PACK so as to restore that missing driver back to that computer.. Please always select expert mode while searching for drivers. Apart from that the highest resolution a user can select totally depends on the Computer's video card and the computer's displays graphical abilities. The higher the resolution you select the more appealing the display would be and so if you wanna have a better resolution in windows 7, you have to take it to the head, top and there you get your desired display... That's for that.


After you must have been done with your adjustments and all that, simply click on OK to apply the already made changes..

Friday, 27 June 2014

EASY WAYS TO SPEED UP YOUR PC


The speed of our computer matters to 100% of its users. Sometimes we may be victims of a slow computer. but how may we know that this is what we are passing through. There are some easy ways to find out, it may be that the computer's speed of opening programs has reduced drastically, or while gaming our running large programs our computers tends to hang, the processing speed of our computer is reduced even when running lower software's and problems, or alerts of errors at one time or the other, Well I can say at this stage you can try to tackle the problem rather than calling a computer engineer right away, there are some little tips am gonna give to you on what to do should this occur to you.

The windows in your computer runs smoothly using the hard disk, the RAM and a little bit of ROM. The software is big because it has lots of files and folders with it and all these join forces together in order for our computer to be healthy.. I can boldly tell you that there are some factors associated to the slowness of our computers, sometimes the configuration of a computer the add to the slowness or the high speed, HOW SO ? Depending on the size of the RAM, the processor speed and the hard disk size, if you have a 4gb ram and a 2ghz processor speed with a hard disk of 5oogb and your computer is still slow then something is wrong somewhere, because that is a good configuration.
And so, if you have such configuration and your experiencing slowness in your computer, there are some easy steps to follow before deciding to call on an engineer..

Why not try a restart?
This can be very beneficial, restarting the computer at that time may help to restore the speed, by stopping running programs and also logging off other users that may be contributing to the reduction of the computer speed, right ? Another thing to do is to Check your computer via the notifications area on the task bar to see which programs are running in the background. A More proper check can be carried out by visiting the task bar and seeing the running programs and that ones adding pressure to the processor.. You can visit the task bar by pressing CONTROL+ALTERNATE KEY+DELETE



ADDING TO YOUR EXISTING RAM SIZE.
A footnote for Consideration is adding the size of your Random Access Memory bank. This is because when your computer has  high RAM size it will assist the processor, which does all that dirty jobs. And so by means of assisting the processor, the processor does lesser jobs and this adds to the speed of the computer system.

Also as much as possible to remove all the files in your Recycle bin, this may add to the speed of your computer as well. There are what we refer to as Temporary files, These are files created by the computer as its programs are running. These may includes downloads that you i may open directly and others are recovery backups by some programs, files that are crucial to the running of programs. In this case, the restarting can help because most of this files are hidden from the eyes, and so while restarting the are all closed along the line.

The part i love most, applying the Command prompt for Fragmentation. why don't Schedule your disk defragmenter to do defragmentation tasks for you? Its worth the try you know,  It will help your computer by making the files very easy to access in whole instead of being accessed in bits and pieces. After opening your command prompt, type in ‘defrag D:’ to defrag local disk D: or other choices as desired by you..

Dust. Always check for dusts around your computer, because this is another factor that can add to the slowness, so at one time or the other check for dusts and remove them so they don't prevent the computer's processor from breathing..

If tried and the above steps doesn't effect any changes on your computer, then you can call a computer engineer for assistance, THANKS, LIKE AND SHARE WITH YOUR FRIENDS

Wednesday, 25 June 2014

HOW TO CREATE A POWERFUL PRESENTATION


Microsoft's PowerPoint application used for the purpose of creating multimedia presentations. With the aid of clip art, fancy fonts, animations, charts, graphics, sound and the combination of beautiful colour schemes like i explained in THIS POST.. Well it doesn't stop there, creating a presentation with the listed tools above are quite alright but sometimes adding a little magic touch will make things worthwhile. one way of adding a magic touch is by making sure our presentation is very simple an straight to the point, how can we achieve this becomes our next question.


i will show you how to create a simple presentation..

I suggest as a presenter, adding more than one message on a slide will not be too good. Applying images that supports your message are highly recommended as this will enhance your readers to want to watch longer. Pictures gets the attention of viewers than words do..  if you have more than one messages, simply insert another slide either by duplicating the current slide or my pressing CONTROL+M to create a new slide..

While creating a presentation, the colours we decide to use should be worth it. this is because using a different colour in slide one and slide two may reduce the quality of your presentation. Instead of appearing beautiful to your viewers, it will look like a distraction to them, so note this point..

We want to make sure we use a very easy and clearly seen font, something even a baby can see, when we have a good background colour, our font will be pronounce.... Then at the tops, middle and the end try to summarise to them what they are about watching, this will arose their interest as well and want to watch to the end, hence the title matters as well..

Another things is for you as a presenter is to plan your beginning point and your conclusion, as this will assist You in creating the body of the presentation and then linking it to the final point you already created..

knowing the type of audience you have, the idea they have about the material, what you want them to know and add to their previous knowledge if they have any, knowing where the presentation will be taking place and under what condition, knowing your audience will help you discern what conditions will be enjoyable by your audience.. Decide what slide design to use, USE THE BEST!!!


See our colour list that will help you

Red or Orange to trigger excitement or an emotional response
Dark Blue is a calm colour, it is used to project a stable, mature message
Green to make audience comfortable
Yellow to get audience attention quickly, as it captures the eyes
White to project honesty/sincerity
Gray to promote the idea of "quality"
most views do not like black for designs, so keep it far
But you can use dark backgrounds while you use light colours for texts.
The eye is naturally drawn to lighter areas and lighter and warmer coloured objects appear closer than dark objects.



SUBSCRIBE TO OUR YOUTUBE CHANNEL

VISIT US ON FACEBOOK

Message me on Gmail via
kokothemann@gmial.com or nelson.godstime22@gmail.com

MAINTAIN YOUR EXTERNAL HARD DRIVE WITH 5 SIMPLE STEPS

The hard drive is one important tool to us today, as it assists in backing up our files and also helps us in the saving process. Sometimes, when our computer drives are filled up, it is essential that we get a hard drive so that we can easily store up our data there for usage of the future. This is a very common practice today, But it might surprise you to know that lots of persons actually do not care about the hard drive, until maybe it contacts a virus and they lost their files, or maybe it gets corrupt, today am gonna talk about some ways we can maintain and care for our hard drives.


1. Leave the Hard Drive Flat

If your hard drive is a magnetic external hard drive then you should always allow it to lay flat since it was produced to be that way. Hard drives of this nature are more like a record play, due to the great design of the hard drive there is a niddle that moves toward the platter but no matter how fast it moves it cannot touch it, so when you have a hard drive that is suppose to lay flat and maybe you turn it around. This may lead to the niddle in the hard drive going ether too far or two closer to the platter and this may be damaging to the processing speed and performance of your hard drive.

2. Scan the hard drive for errors

This is also another way to maintain our hard drive, we simply can insert the hard drive in the computer, and scan it with your anti virus for errors.. Although it’s not essential to carry this test out often, it’s worth doing every once in a while.

3. Cables Maintenance

Sometimes, the kind of cable we use with our external hard drive really matters. So at all times we want to always make sure that the connection between our hard drive and the cable are intact in order for us not to loose the files in our hard drive due to an unexpected disconnection. This could also occur while your transferring/moving files. the result on the hard drive may be fatal as time goes on, hence we wanna watch this aspect seriously. Using short cables can me more efficient and faster, sometimes longer cables really does help but they can easily develop one fault or the other and starts the connecting and disconnecting process...


3. Make sure you buy a good hard drive

most times, the cause of all these problems may not be laying it flat or the cable, although they have their own problems they add, but the main reasons for such problems is that sometimes we go for hard drives that are not good, simply because they are affordable.
There are lots of hard drives in our locality today, and the best practise should be choosing a hard drive that will work best for you and you alone. Going for hard drives that are cheap or sold in non computer  gadgets stores may be detrimental to us..
To confirm this, when i bought a 500GB hard drive sometime ago it was about 14000 naira, and it contained a very tight table i used this for over 2 years before misplacing it, but recently when i got a 320GB hard drive, OH MY GOODNESS, is was crap, i got it 7000 naira and to my surprise the hard drive came with come with loose cables and an inferior hardware inside.
Doing some little research about hard drives before going to buy them can be a best practise, as it can save you from buying fake and UN-durable hard drives, so after researching about a particular hard drive, looking for it is the next stage..

4. ALWAYS EJECT

This is common with some persons, after using the external hard drive, they open "MY COMPUTER" and right click on the the hard drive partition to look for eject, and once EJECT is not found, they just remove the USB cable from the system. If your doing this, you really have to stop because your causing great damage to your hard drive and the files you have inside.

5. KEEP AWAY FROM DUST

Always have an enemy named dust, always prevent your hard drive from dust at all times, always clean it at all times.


LIKE AND SHARE THIS POST, INVITE YOUR FRIENDS OVER

SUBSCRIBE TO MY YOUTUBE CHANNEL

LIKE MY FACEBOOK FAN PAGE

Message me on Gmail via
kokothemann@gmial.com or nelson.godstime22@gmail.com

BEST VIDEO DOWNLOADER FOR GOOGLE CHROME

Amazing Google has recently designed a solid reputation of rendering quality in everything that they put their minds to. This is the reason that the google Chrome browser has quickly become one of the most popular options of browsers available in the world today. One of such things that people seem to like about Chrome is the ability of the program allowing its users to edit the browser and adding extensions to it. Since watching online videos/streaming is something most people love to do. As for me i love watching videos online too and i know lots of people, so am thankful to Google for bringing this to our notice.. The most interesting part is that we have lots of alternatives when it comes to options available of  Chrome download flash

we have the following, feel free to select any of your choice; 


I. FVD Download Extension for Chrome


The most obvious way to go would be with an extension for the Chrome browser. there are lots of them in the Google store where FVD Download is among the most highly rated. This is obvious because with the FVD downloader, you do not need to go out of the browser before you can start a download of a desired video.. If for example a user is using his/her computer for streaming, you will notice a small arrow signifying that the particular video your watching can be downloaded, if you should click on it, it will prompt you to click on download video, then you select your desired drive and get that video downloaded into your computer..


2 Flash Video Downloader on Chrome


Many at times we may come across a video we may be attracted to, it might be that it contains certain information's that are of great value to us, but while trying to download it we find out that its a flash video and they may be no format for us to download, well this has happened to me twice or thrice, but am here to assure you that we can work it out together, just stay put and continue reading. It is very interesting to discover that Flash Video Downloader for Chrome is an excellent option in this aspect, and it too is incredibly easy to use. So when you find a video your interested in, all you need to do is to copy the URL link of that video and paste it into this software and it will ask you where you want the video to be saved to, all you do is to specify the drive and watch your download start and say download complete. Easy right ? There are more



Freeware for Desktop


The next option i will be talking about is the desktop freeware. It is a very small software, but it is very useful when it comes to talking about downloading. Free make Video Downloader is one of the best example, The advantage of using this software over the other ones is that it comes with great features and settings that other flash video downloaders do not have. But this tool does not provide Mac version, as a user you may try Orbit Downloader Mac, because it has similar features with this one..



All the listed options have their own merits and demerits, but the thing about them is that they are all free, so feel free to test as many as you can so you can know which one suits you..


FEEL FREE TO LIKE AND SHARE THIS POST,


SUBSCRIBE TO MY YOUTUBE CHANNEL


VISIT OUR FACEBOOK PAGE


Message me on Gmail via

kokothemann@gmial.com or nelson.godstime22@gmail.com

Tuesday, 24 June 2014

HOW TO SET DATE AND TIME IN WINDOWS

It is not a wasted effort for our windows to be designed with date feature with it. It is actually designed
to make users keep to time per say.. Well sometimes the dates of our computers may not be correct,
either because the CMOS battery of our computer is weak or because someone deliberately changed it,
whatever the case may be, when such occurs as a user of the computer system, we are therefore
expected to adjust or correct the date and time of that computer. But the big question is how this can
be done... This can be carried out successfully,

simply follow the procedures below

1. Double-click on the time which sits on the right-hand side of your windows (windows 7 users)

2. After that has been done, you will see an image like this


from this image, we will see everything crystal clear, simply Left click on change date and time settings
and a date and time dialogue box will display.. so one can adjust the date and time from there
Apart from manually adjusting our date from the task bar, it is also possible for us to adjust our date and
time using the command prompt.

HOW CAN THIS BE DONE?
this method has been tested and its working really fine, i wont waste yourtime.
Firsts things firsts, open COMMAND PROMPT by Clicking start> all programs > Accessories>
Command prompt. i believe we all knows what it looks like.
After opening it, type DATE.EXE, there you will see (see image)


(mm-dd-yy), just add the date according to the sequence. The month first, followed by the day and the
the month and press enter..

NOTE: to know this has worked, i will suggest you backdate your date so that when you place a correct
date you will see the difference..

(A video about this will be posted on our YOUTUBE CHANNEL, feel free to watch from there, SEEN IS
BELIEVING THEY SAY)
Now click on the other OK button on the Date and Time dialogue box.
In the case of time, after opening the COMMAND PROMPT, simply type TIME.EXE and follow the
same procedures we have with that of the date...


DONT FORGET TO VISIT OUR YOUTUBE CHANNEL
Like our FACEBOOK FAN PAGE
Message me on Gmail via
kokothemann@gmial.com or nelson.godstime22@gmail.com

Adjusting Your View of 3-D Graphs

Excel allows its users to create good looking three-dimensional graphs based on the information displayed in your excel worksheet/worksheets. For some reasons, the default method in which the graphs are created may be satisfactory to you.  Still you may just want to adjust the angle at which you view your graph for easr understanding and better sight for you and maybe your viewers..

Simply following the below steps to asjust your view:

The first thing to do is to Create and display your 3-D graph just the way you want it to be. we can do this by creating a little data and then click on Insert, click on the pattern of chart we want under the chart column and selecting 3d just under the column
(see image below)


While using the appropriate boxes, specify an angle of elevation, rotation, and perspective according to you desire. You can also use the buttons to adjust the values in the boxes to adjust the sizes. While you make changes, know that Excel displays a frame outline of how a 3-D graph appears, more like a preview of what you are doing... When you have adjusted it to your satisfaction, simply click on OK and then wait for the magic, you will notice Your graph is updated with the just adjusted view.

LIKE AND SHARE THIS POST,

view my YOUTUBE CHANNEL  for windows tricks and tips

Like our FACEBOOK FAN PAGE

Message me on Gmail via
kokothemann@gmial.com or nelson.godstime22@gmail.com

Monday, 23 June 2014

ADDING TEXT BOXES TO CHARTS

Charts as explained in my previous post is a pictorial or graphical representation of a given data, this applies to both word and excel and other programs that the term may be used.
When a chart is created from an Excel data, there is this tendency of some users wanting to add text boxes to the current chart, for some reasons best know to them, either for beautification, for adding comment/comments to a point on the graph, or for advertisments, sometimes text boxes are added for an information to be brought out. Whatever the case may be, whatever the reason for adding a text box to a chart maybe, adding a text box to a chart can be carried out in 2 ways, i wll mention them, so read on!!!!

The first method is by making use of the Drawing toolbar. Making sure it is displayed is one thing, after that click the Text Box tool. Then the mouse pointer will change to cross hairs, then click and hold and drag to outline the text box you want created...

The second way to create a text box is to use the Formula bar. Make sure you select any part of your chart except a title or data label. Click in the Formula bar and start typing your desired text to appear in the text box. Press Enter, the text you typed will be placed in a text box in the center of the chart. You can now move, edit the text box as desired


this works for all versions of Excel except there may be changes in most recent versions


view my you tube channel for windows tricks and tips HERE

Like our Facebook fan page
9JALINKZZ

Message me on Gmail via
kokothemann@gmial.com or nelson.godstime22@gmail.com

Sunday, 22 June 2014

USING THE INSERT MENU IN MICROSOFT WORD

Cover page: A Cover Page is the first document of a Document Set. The set, which sometimes include  table of contents, include an index, or indexes, year the document was created and many more is followed by a navigation bar that is specific to the document set. This navigation bar includes a link to the Cover Page
(see image)



Blank page: As the name implies, we can use this feature to create a new blank page, either for the continuation of a previous document or for the purpose of starting a new one. To apply this feature, simply click on BLANKPAGE and it will create a new page just under the present one.

Page break: For some reasons or the other, we might decide to start another document from our present location in a particular page, hence we can use this feature simply by clicking on it and continue or document on that page.

Picture: We can insert pictures for perfect understanding of what the document is talking about. Pictures really go a long way in explaining a topic, and it makes it very easy to understand, They say: Picture speaks louder than voice. Well, when a picture is inserted into the program, the size can either be reduced or expanded, but it cannot be moved to another position or a desired position. How can i move it?  It is possible to move a picture with the feature of "TEXTWRAPPING". This can be found in 3 places. The first place it can be found is under PAGELAYOUT, another place it can be found is when you RIGHTCLICK on the picture, you will also wee it in the format menu.
(see image)

Note: the format menu will only appear when a picture or symbol or table is inserted. Another thing to be noted is that textwrapping would only be found if you click on the picture or object you inserted. So, if you dont click on the picture inserted, you will see textwrapping but will not be able to use it.

Clip art: Clip art is another form of pictures present in the computer, they are more like inbuilt since they cannot be deleted. They are also picture but cannot be compared to real photos. After clicking on CLIPART, a search box will appear, thats where the user can search for the item he/she needs. Not every picture can be found there, take note.

shapes: This feature is used to add shapes to our document, it can be done by selecting a shape and click and holding it on the typing page... There are different aspects of shapes as seen in the image below, so you and i are free enough to use anyone.

smartArt: A SmartArt graphic is a visual representation of your information and ideas. You are free to create a SmartArt graphic by choosing from among many different layouts/patterns we have there to quickly and easily communicate your message, doing so effectively.
Sometimes i create content that contains only text, even though the illustrations and graphics help myaudiences to understand and to recall information better than text.
Creating designer-quality illustrations can be ver difficult, especially if you are not a professional designer or no resources to hire one.. Well, you use previous (old) versions of Microsoft Office, spending lots of time anf effort making the same sizes of shapes and trying to align them properly to where theu fit, getting your doument to look the best way that it should and manually formatting the shapes so they can be just the same as the document's overall style, instead of laying down your effort on your content.
With the help of SmartArt graphics and other new features such as themes, creating designer and quality illustrations with only a few clicks with your computer mouse in possible due to the avaliability of recent or updated versions of microsoft word.
You can create a SmartArt graphic in Microsoft Office Excel 2007, Microsoft Office PowerPoint 2007, Microsoft Office Word 2007, or in an e-mail message in Microsoft Office Outlook 2007. Although creating SmartArt graphic in other 2007 Microsoft Office system programs is impossible, we can simply copy and paste them into these programs.

Chart: Charts are a great way to present data in a way that will be easy for computer users tounderstand manner. If you're working on academic papers and business reports, you will almost certainly want to include a chart in your document. We can also refer to chart as a graphical or pictorial representation of a given data or datas....

it is not very difficult to create a chart in Microsoft Word 2007. All you have to do is to follow these steps:

1. Position your cursor where you would like to insert the chart

2. Open the Insert

3. Click Chart in the Illustrations section

4. Select the style of chart you would like to insert

5. Click OK

ALL DONE, in microsoft word there are nothing like spreadsheets or worksheet, so the chart will appear in your document and thenit will automatically inport a worksheet that will easily explain the data we have on ground.
After adding your chart, you can use the tools in the FORMAT BAR to change the chart style, layout and perform other formatting options.


TO BE CONTINUED, LIKE, SHARE AND INVITE YOUR FRIENDS, WATCH OUR VIDEOS ON YOUTUBE HERE

Saturday, 21 June 2014

USING ANY VIDEO CONVERTER TO CONVERT SONGS AND VIDEOS

There are times when we might be in need of a particular song, been it an audio or a video, and after sending it to oyur devices, (computer or phones) they refuse to play, maybe due to unsupported formats or sometimes the size of the file might be too large for our gadget to play, annoying right? Well, i'm happy to write  this post about how Audios and videos can be converted to siut the compactibility of our phones or gadgets. I have suffered from this while i was still using a java phone and no computers except for those in my school which i bare;y had access to, but as time goes on i happened to come across a software called, total video converter, and while learning how to use this program i understood the fact that whatever song it is, it can be converted to a pattern that your device accepts.
Today am going to be talking about convertion of files using ANY VIDEO CONVERTER...  this is one software i find very interesting as it gives its user a very easy interface to understand..
But what can i convert to ? thats a very nice question, well one thing about convertion is that videos can be converted to audio files but audio files cannot be converted back to videos, reason being that the visual effect has gone missing due to the first stage of conversion..


HOW CAN I CONVERT A SONG/VIDEO USING ANY VIDEO CONVERTER?
1.  All you have to do is to know the file you have and what format you want to convert it to, to learn about FORMATS, CLICK HERE..
2.  Another thing is to have this software of any other converting software with you, they are all almost same..
3.  know the supported files for your gadgets..

Due to the multitude of available files to be converted, the user may decide to add more than one audio or video for the conversion process... But note that the meavier the size of the files the more time it will take before they are all concerted successfully.

the next thing to do is to look for the supported formats to be converted to, from the picture above you can see PRESET OUTPUT, simply click on this feature, a box containing various formats will be displayed to you, (see images)





For using any video converter, from the image above you can clearly see an invitation to add songs, after clicking on it, it will take you to your drives in your computer so all you have to do is to select the drive that has the song you are looking for, and then click OPEN, you will see the song like this.
(see image)

next thing to do is to click on the check box at the starting of the file and then click on convert ALL and wait for the conversion process to be completed after which you close the pop up..

OHHHH, i'm done with my conversion, how can i get it from my system and send it to my mobile? If your using ANY VIDEO CONVERTER,
click on the start or windows button
click on documents
open ANY VIDEO CONVERTER FOLDER
you will see the various formats you have converted to before, simply select the recent format, either MP4, MP3 or which ever and open the folder, you will see your song there in the converted format.


FEEL FREE TO DROP YOUR ADDITIONS AND ASK YOUR QUESTIONS VIA THE COMMENT BOX, SHARE WITH OTHERS, THANKS

Friday, 20 June 2014

A-Z SHORTCUT CONTINUES


shift+arrow right Extend a selection one character to the right.
shift+arrow left Extend a selection one character to the left.
ctrl+shift+arrow right Extend a selection to the end of a word.
ctrl+shift+arrow left Extend a selection to the beginning of a word.
shift+end Extend a selection to the end of a line.
shift+home Extend a selection to the beginning of a line.
shift+arrow down Extend a selection one line down.
shift+arrow up Extend a selection one line up.
ctrl+shift+arrow down Extend a selection to the end of a paragraph.
ctrl+shift+arrow up Extend a selection to the beginning of a paragraph.
shift+page down Extend a selection one screen down.
shift+page up Extend a selection one screen up.
ctrl+shift+home Extend a selection to the beginning of a document.
ctrl+shift+end Extend a selection to the end of a document.
alt+ctrl+shift+page down Extend a selection to the end of a window.
ctrl+a Extend a selection to include the entire document.
ctrl+shift+f8, and then use the arrow up, arrow down, arrow left, arrow right; press esc to cancel selection mode Select a vertical block of text.
f8+arrow up, arrow down, arrow left, arrow right; press esc to cancel selection mode Extend a selection to a specific location in a document.
arrow right One character to the right
ctrl+arrow left One word to the left
ctrl+arrow right One word to the right
ctrl+arrow up One paragraph up
ctrl+arrow down One paragraph down
shift+tab One cell to the left (in a table)
tab One cell to the right (in a table)
arrow up Up one line
arrow down Down one line
end To the end of a line
home To the beginning of a line
alt+ctrl+page up To the top of the window
alt+ctrl+page down To the end of the window
page up Up one screen (scrolling)
page down Down one screen (scrolling)
ctrl+page down To the top of the next page
ctrl+page up To the top of the previous page
ctrl+end   To the end of a document
ctrl+home        To the beginning of a document
shift+f5 To a previous revision
shift+f5 After opening a document, to the location you were working                           in when the document was last closed

tab        To the next cell in a row
shift+tab To the previous cell in a row
alt+home To the first cell in a row
alt+end To the last cell in a row
alt+page up To the first cell in a column
alt+page down To the last cell in a column
arrow up To the previous row
arrow down To the next row
alt+shift+arrow up One row up
alt+shift+arrow down One row down

enter         New paragraphs in a cell
ctrl+tab Tab characters in a cell
ctrl+shift+c Copy formatting from text.
ctrl+shift+v Apply copied formatting to text.
ctrl+shift+f Open the Font dialog box to change the font.
ctrl+shift+< Decrease font size one value
ctrl+shift+> Increase font size one value
ctrl+[ Increase the font size by 1 point.
ctrl+] Decrease the font size by 1 point.
? up

shift+f3 Change the case of letters.
ctrl+shift+a Format all letters as capitals.
ctrl+b Apply bold formatting.
ctrl+u Apply an underline.
ctrl+shift+w Underline words but not spaces.
ctrl+shift+d Double-underline text.
ctrl+shift+h Apply hidden text formatting.
ctrl+i       Apply italic formatting.
ctrl+shift+k Format letters as small capitals.

ctrl+shift++ (Plus Sign) Apply superscript formatting (automatic spacing).
ctrl+spacebar Remove manual character formatting.
ctrl+shift+q Change the selection to the Symbol font.

ctrl+shift+* Display nonprinting characters. * on numeric keyboard will not work
ctrl+shift+c Copy formats.
ctrl+shift+v Paste formats.


ctrl+1 Single-space lines.
ctrl+2 Double-space lines.
ctrl+5 Set 1.5-line spacing.
ctrl+0 (zero) Add or remove one line space preceding a paragraph.

ctrl+shift+m Remove a paragraph indent from the left.
ctrl+t Create a hanging indent.
ctrl+shift+t Reduce a hanging indent.
ctrl+q Remove paragraph formatting.

ctrl+shift+s Open Apply Styles task pane.
alt+ctrl+shift+s Open Styles task pane.
alt+ctrl+k                         Start AutoFormat.
ctrl+shift+n Apply the Normal style.
alt+ctrl+1 Apply the Heading 1 style.
alt+ctrl+2 Apply the Heading 2 style.
alt+ctrl+3 Apply the Heading 3 style.

alt+shift+k Preview a mail merge.
alt+shift+n Merge a document.
alt+shift+m Print the merged document.
alt+shift+e Edit a mail-merge data document.
alt+shift+f Insert a merge field.


alt+shift+d Insert a DATE field.
alt+ctrl+l Insert a LISTNUM field.
alt+shift+p Insert a PAGE field.
alt+shift+t        Insert a TIME field.
ctrl+f9 Insert an empty field.
ctrl+shift+f7 Update linked information in a Microsoft Office Word source                         document.
f9          Update selected fields.
ctrl+shift+f9 Unlink a field.
shift+f9 Switch between a selected field code and its result.
alt+f9 Switch between all field codes and their results.
alt+shift+f9 Run GOTOBUTTON or MACROBUTTON from the field that displays the field results.
f11 Go to the next field.
shift+f11 Go to the previous field.
ctrl+f11 Lock a field.
ctrl+shift+f11 Unlock a field.
? up


f1 Get Help or visit Microsoft Office Online.
f2 Move text or graphics.
f4 Repeat the last action.
f5 Choose the Go To command (Home tab).
f6 Go to the next pane or frame.
f7 Choose the Spelling command (Review tab).
f8 Extend a selection.
f9 Update the selected fields.
f10 Show KeyTips.
f11 Go to the next field.
f12 Choose the Save As command (Microsoft Office Button ).

shift+f1 Start context-sensitive Help or reveal formatting.
shift+f2 Copy text.
shift+f3 Change the case of letters.
shift+f4 Repeat a Find or Go To action.
shift+f5 Move to the last change.
shift+f6 Go to the previous pane or frame (after pressing F6).
shift+f7 Choose the Thesaurus command (Review tab, Proofing group).
shift+f8 Shrink a selection.
shift+f9 Switch between a field code and its result.
shift+f10 Display a shortcut menu.
shift+f11 Go to the previous field.
shift+f12 Choose the Save command (Microsoft Office Button ).

ctrl+f2 Choose the Print Preview command, Microsoft Office Button
ctrl+f3 Cut to the Spike.
ctrl+f4 Close the window.
ctrl+f6 Go to the next window.
ctrl+f9 Insert an empty field.
ctrl+f10 Maximize the document window.
ctrl+f11 Lock a field.
ctrl+f12 Choose the Open command (Microsoft Office Button ).

ctrl+shift+f3 Insert the contents of the Spike.
ctrl+shift+f5 Edit a bookmark.
ctrl+shift+f6 Go to the previous window.
ctrl+shift+f7 Update linked information in an Office Word 2007 source                         document.
ctrl+shift+f8, and arrow keys Extend a selection or block.
ctrl+shift+f9 Unlink a field.
ctrl+shift+f11 Unlock a field.
ctrl+shift+f12 Choose the Print command (Microsoft Office Button ).


alt+f1 Go to the next field.
alt+f3 Create a new Building Block.
alt+f4 Exit Office Word 2007.
alt+f5 Restore the program window size.
alt+f6 Move from an open dialog box back to the document, for                                         dialog boxes such as Find and Replace that support this                                                     behavior.
alt+f7 Find the next misspelling or grammatical error.
alt+f8 Run a macro.
alt+f9 Switch between all field codes and their results.
alt+f10 Maximize the program window.
alt+f11 Display Microsoft Visual Basic code.

alt+shift+f1 Go to the previous field.
alt+shift+f2 Choose the Save command (Microsoft Office Button ).
alt+shift+f7 Display the Research task pane.
alt+shift+f9 Run GOTOBUTTON or MACROBUTTON from the field that                         displays the field results.
alt+shift+f10 Display a menu or message for a smart tag.
ctrl+alt+f1         Display Microsoft System Information.
ctrl+alt+f2        Choose the Open command (Microsoft Office Button ).

Wednesday, 18 June 2014

A-Z MICROSOFT OFFICE SHORT CUTS TO USE

In Microsoft word there are lots of shortcuts that can be used to hasten our job or to add to out typing speed, which ever the case may be, i'm going to tell you some of the little i know. There will be no need wasting your time on this, i will just go ahead to the main issue
NOTE: the above listed shortcuts may/may not work on other versions of Microsoft programs due to software updates, but i assure you all the listed shortcuts are working just fine in OFFICE 2007

ctrl+a highlight all
ctrl+b Make letters bold
ctrl+c Copy selected text or graphics to the Office Clipboard.
ctrl+d font dialogue box
ctrl+e center alignment
ctrl+f Find text, formatting, and special items.
ctrl+g Go to a page, bookmark, footnote, table, comment, graphic, or other options
ctrl+h Replace text, specific formatting, and special items.
ctrl+i  Italic
ctrl+j justify
ctrl+k Insert a hyperlink.
ctrl+l   left alignment
ctrl+m creating a paragraph
ctrl+n Create a new document of the same type as the current or most recent document.
ctrl+o Open a document.
ctrl+p Print a document.
ctrl+q
ctrl+r right alignment
ctrl+s Save a document.
ctrl+t
ctrl+u underline
ctrl+v Paste
ctrl+w Close document.
ctrl+x Cut selected text
ctrl+y Redo last command
ctrl+z Undo last command




ctrl+shift+space bar used for creating a non breaking space
ctrl+- (Hyphen) Create a non breaking hyphen
ctrl+shift+< Decrease font size
ctrl+shift+> Increase font size
ctrl+[ Increase the font size by 1 point.
ctrl+] Decrease the font size by 1 point.
ctrl+space bar Remove paragraph or character formatting.
ctrl+alt+v Paste special
ctrl+shift+v Paste formatting only
ctrl+shift+g Open the Word Count dialog box.
alt+ctrl+s Split the document window.
alt+shift+c                Remove the document window split. (minimize)
alt+ctrl+y Repeat find (after closing Find and Replace window)
alt+ctrl+z Switch between the last four places that you have edited.

Please, Remember to use the enter key altering using the find and replace feature..

ctrl+page up                          Previous edit location.
ctrl+page down                    Next edit location.
alt+ctrl+p                             Print Layout view.
alt+ctrl+o                             Outline view.
alt+ctrl+n                             Draft view.
alt+shift+arrow left Promote a paragraph.
alt+shift+arrow right                Demote a paragraph.
ctrl+shift+n                            Demote to body text.
alt+shift+arrow up Move selected paragraphs up.
alt+shift+arrow down             Move selected paragraphs down.
alt+shift++ (Plus Sign)             Expand text under a heading.
alt+shift+- (Minus Sign) Collapse text under a heading.
alt+shift+a                              Expand or collapse all text or headings.
alt+shift+l                              Show the first line of body text or all body text.
alt+shift+1                             Show all headings with the Heading 1 style.
alt+shift+n                             Show all headings up to Heading n.
ctrl+tab                               Insert a tab character, like a paragraph
alt+ctrl+i                               Switch in or out of print preview.
page up or page down             Move by one preview page when zoomed out.
ctrl+home                               Move to the first preview page when zoomed out.
ctrl+end                                Move to the last preview page when zoomed out.
alt+ctrl+m                                Insert a comment.
ctrl+shift+e                              Turn change tracking on or off.
alt+shift+c                               Close the Reviewing Pane if it is open.?
home           Go to beginning of document.
end                                           Go to end of document.
n, enter                                    Go to page n.
escape                                      Exit reading layout view.
alt+shift+o                               Mark a table of contents entry.
alt+shift+i                                 Mark a table of authorities entry (citation).
alt+shift+x                                Mark an index entry.
alt+ctrl+f                                 Insert a footnote.
alt+ctrl+                                  Insert an end note.
alt+arrow left                          Go back one page.
alt+arrow right                         Go forward one page.
f9                                           Refresh the page
ctrl+f3                                        Cut to the Spike.
ctrl+shift+f3                                Paste the Spike contents.
alt+shift+r                                    Copy the header or footer used in the previous section of the document.
ctrl+f9                                         A field
shift+enter                                    A line break
ctrl+enter                                     A page break
ctrl+shift+enter                             A column break
alt+ctrl+- (Minus Sign)                  An em dash
ctrl+- (Minus Sign)                        An en dash
ctrl+- (Hyphen)                              An optional hyphen
ctrl+shift+- (Hyphen)                     A non breaking hyphen
ctrl+shift+spacebar                       A non breaking space
alt+ctrl+c                                    The copyright symbol
alt+ctrl+r                                    The registered trademark symbol
alt+ctrl+t                                    The trademark symbol
alt+ctrl+. An ellipsis

backspace                                      Delete one character to the left.
ctrl+backspace                              Delete one word to the left.
delete                                            Delete one character to the right.
ctrl+delete                                      Delete one word to the right.
ctrl+f3                                           Cut to the Spike.
alt+f3                                          When text or an object is selected, open the Create New Building Block                                                 dialog box.
shift+f10                                    When the building block — for example, a Smart Art graphic — is                                                          selected, display the shortcut menu that is associated with it.

tell us how you see them, add your's.............!!

Tuesday, 17 June 2014

SOLVING WINDOWS NOT GENUINE PROBLEM

WINDOWS NOT GENUINE SOLVED

This is a verse problem with windows users, it has affected me in the past and sometimes it comes back. So today am going to show you how to get rid of this problem with a software (WINDOWS ACTIVATOR). Its just a little step.
How can i know i am suffering from this ? Well you don't need to be told because its something you can see, what it does is that it changes your desktop background to a black background, and it comes or displays on the screen every 5 minutes, can be annoying sometimes..

How can i fix this problem?

CLICK HERE TO DOWNLOAD WINDOWS ACTIVATOR
After downloading, open the file
Run the file
Select operating system (Windows 7, XP or vista)
Then click ACTIVATE
Wait for the activation process to be completed and
Finally Restart PC

How to know it worked for you, for you to check your windows status
Click on the windows button or Press windows + E and right click and click on properties it will display there
(see image)
It should appear like this with a different code


ADDING SAVE AS PDF IN OFFICE 2007

Adding PDF plugin to Office 2007
IN recent Microsoft programs there is this inbuilt feature of saving a document as a PDF file, this serves as a means of securing our files from scamers as well as people who might want to temper with our credentials. But in the previous versions of Microsoft office programs (2007 downward) this feature is missing. it might interest you to know that this feature has a plugin and i am going to share it with you. All you have to do is download and install this plugin. its just about 1mb so don't be scared about the size.

CLICK HERE TO DOWNLOAD
After downloading this plugin, the next step is to install. There is nothing to adjust in this so just follow the normal installation prompt. When this is done, restart PC.

But where can i find this installed plugin in the program?
Launch the program (M.S word)
click on the office button
Click on save
click on Save as PDF

Sunday, 15 June 2014

LOCATING VIRUSES ON PC USING THE "ATTRIB COMMAND"

Virus has been one of the computers great enemy, it has powers of damaging the computer system and
bring it to its end, according to statistics, virus has brought about the end of 39% of the computers
without antivirus and a number of those with anti virus, so we can see it is a great disease to
computers. There are various means we can get rid of this problem, by installing an anti virus or by
formatting our hard disck drive, or mose seriously formatting the hard disk, thereby changing out
operating system. Well this post can help to bring an end to this great epedemic..
i will show you how to use our MS-DOS (MICROSOFT DISK OPERATING SYSTEM) to detect our
virus for us from our computer.

First things first, open MS-DOS by clicking on the windows or start button, then type Command
prompt or cmd (windows 7 users). As for Xp users, click on start, click run and type CMD, and hit OK or
click on start, click on all programs, click on Accessories and then click command prompt..
Then, type in the Infected Drive such as for example: dir/p C:
after the C: Type in the end switch as s - h *. * /s /d and then simply press the ENTER key.

The command prompt will load all the files in your drive. If you see anything suspicious for example:
Autorun.inf or a .exe file. These files you need to watch out for. (see image)


look properly readers, do you see any ? Well i dont, but If you see any .exe and the autorun.inf then you have just found a tainted file, all you have to do id to write done the program name and where the program is located in your drive.

Then change the name Autorun.inf so you can open it without activating the virus and letting it infect
the system. Its best you rename it as a rar. extension so it can be placed in a folder. Now, Go to start,
and double click the My computer icon. Select the drive where you can locate this file that has been
infected. Find the program directory that contains autorun.inf
Right-click on the file you renamed "virusfile" and choose "Delete."
Right-click on the ".exe" file and choose "Delete." You have now removed the virus from your
computer's hard drive.

Its that easy, invite your friends and share this post