Skip to main content

Posts

Showing posts with the label MS-Excel

HOW TO GENERATE EQUATIONS AND SQUARE ROOTS FROM A GRAPH (MICROSOFT EXCEL)

Let me believe that we all already know what a graph is, but for those of us who are not sure what a graph is;  “GRAPH is a diagram showing the relation between variable quantities, typically of two variables, each measured along one of a pair of axes at right angles”. There are various kinds of graphs, but I will write specifically on Linear graphs. Let me also assume you all already know how to plot graphs, but if my

SOME KEYBOARD SECRETS REVEALED

The key board is an input device used to enter commands and instructions into the computer system. The keyboard functions are usually called "SHORT-CUTS ". This is because they provide you with quick access to complex functions with just hitting a key on the keyboard or some couples of keys. Shortcuts are likely used by gurus (IT experts) as they understand the importance of using them; they know how fast they can be when they apply those shortcut keys in their day to day use of computer.  Why waste your time going to OFFICE BUTTON (FILE) each time you want to SAVE your work when you can just hold down your CTRL key and press S (CTRL+S) or why stress yourself trying to Select All text in your document by dragging from beginning to End when you can simply use this command (CTRL + A). I am certain that most of you Already know these simple shortcut keys, but if there is any one reading this post who cannot apply these simple shortcuts from CTRL+A to CTRL+Z, th...

MAKING MICROSOFT EXCEL YOUR BEST ACCOUNTING SOFTWARE

I have for most times heard people complain about Excel being very complex to use. Some say “Excel environment is too wide to understand”. But I tell you “ Excel is the best accounting software ever ”.   There is this word I value so much and that word is “ Your Ignorant is your Greatest Weak Point”. To break it down, this word simply means “What you don’t know can cause you your down fall”. Nigerians can simply tell you “What you don’t know, pass you”. “Ignorant” may be the reason why you hate Microsoft Excel or why you feel Excel can’t work for you. Before you finalize in your choice of which accounting software that can work for you, you would like to let me tour you round the excel environment. I am about to review to you how you can confidently use Microsoft Excel in your office, home and school without having to ask anyone a single question (i.e, I will give you all the tips you need to start manipulating Microsoft Excel by yourself).

Learn how to do many things in Excel

HOW TO MERGE CELLS :   this command is used to join two or more cells to form one but big cell, Process: highlight the cells and from the home tab, click on format and select format cell, click on alignment from the box that will appear, click on merge cell from the four Conner box and finally click OK. HOW TO GIVE CELL BORDER: though excel have is like a table in times of description, but when printed out the border will not print together with the write-ups, for your you excel work to print together with the border you need to add cell borders to it. Now how can you add it? Follow the procedure very well:

INTRODUCTION TO MS-EXCEL (KEYPOINT)

INTRODUCTION:   Excel is an application package that is design to handle numeric data (so many data) .e.g. Taxes, Sales, Payrolls and result etc. in the computer system, so that they could be calculated quickly and with ease.