Microsoft Office Excel – Tips & Tricks
How to Close all files at a time:
You opened 22 workbooks in excel and work in one by one file. You are called by some one for urgent out door work. At that time you should close all the opened files in excel. If you want to close one by one there should be no time. At that time you can close all 22 files at once. How is it possible? What is the shortcut method? Let us see.
Hold down ‘Shift’ key and click on file menu then go to ‘close all’. By clicking the ‘close all’ button you can close all opened files at a time.
How to Increase the number of recent work books:
There are only 4 recent workbooks in file menu as default.
If you want to open minimum 6 workbooks to maintain your office accounts you should increase the number of recent workbooks in the file menu. To activate this job go to Tools>options>general tab. By clicking the ‘General’ tab there should appear a button ‘Recently used file list’ and a number box near it. You can increase the number of files by typing number or by clicking arrow mark.
How to Open all files at a time:
If you want to open 9 files to work you should open one by one. There should be waste of time to open all files. There is a short way to open all files at a time in excel. That is called as ‘workspace’.
First of all open all the files one by one. Now go to ‘file’ menu and select ‘save workspace’. Give any name to identify the workspace. All opened files are saved to this named wok space. If you want to open all these files, you can open this workspace only. But one thing, if you move any file from this set to another folder the file will disappear from this workspace.
To move cursor to desired position after typing number:
By pressing cursor key after type a number in a cell you can move the cursor key in direction shown by arrow key. Although, if you are a ‘numeric key pad’ user, use ‘enter’ key instead of ‘arrow’ key. But when pressing ‘enter’ key, excel will move the cursor to the below cell. Then how to set the cursor direction as we like? There is a setting in excel program to do this.
Go to Tools > options > edit > Move selection after Enter Direction. Then click the arrow near ‘Down’ button as shown in the above figure. There should appear a scroll bar and you can set a direction to move the cursor in excel work sheet.
How to put page number in each page:
Whenever you type a long report in excel program and want to put page numbers to all pages follow this easy step.
Go to ‘File’ menu and click ‘Page Setup’. There should appear a small window. In that window there are 4 Tabs. There is ‘Header/Footer’ Tab as the third tab. In ‘Footer’ dropdown menu there will be ‘options’ button. In this option select Page 1 of ?. If you select this option, footer will be printed.
In every page the number 1 of 2 will be printed.
There is another way to print the page number. Select ‘Custom Footer’ button from option menu then select the ‘Text Box’ appeared in the right side corner. In the Text Box click the cursor and type ‘Page’ then leave a space, then click the icon ‘X’ and leave a space after that type ‘of’ then leave a space then select ‘++’ (Total Pages) icon. By this Page number will appear on the footer.
To appear Titles on each page:
In excel worksheet the titles are typed on top row of the first page. In other pages the titles should not appear automatically. So, there is some difficult to type proper data below the titles of each page. To solve this problem you can set the titles on each page automatically. When you go to next pages the titles can stay on the top of page.
To set the titles for each page, select the cells you want to stick on the top of page. Then go to menu bar then click window > freeze panes. There you can see a line in your work book. Now you can go to any pages and can see the titles. If you don’t want to see the titles in each page, you can follow the same steps and click the ‘Unfreeze panes’.
To open excel with more worksheets:
When opening a excel workbook there are three worksheets appear by default. You can increase the number of worksheets in a excel workbook. Usually, to increase the work sheet, we go to insert menu and increase the work sheet. But you can increase the number of worksheets by another simple way. Go to Tools > options > general. In ‘general’ tab there is a small window appears. In that window there is a line says ‘sheets in new workbook’. Near that there is a number ‘3’ in default. You can change the number as you like.
Microsoft Office Excel – Tips & Tricks
How to Close all files at a time:
You opened 22 workbooks in excel and work in one by one file. You are called by some one for urgent out door work. At that time you should close all the opened files in excel. If you want to close one by one there should be no time. At that time you can close all 22 files at once. How is it possible? What is the shortcut method? Let us see.
Hold down ‘Shift’ key and click on file menu then go to ‘close all’. By clicking the ‘close all’ button you can close all opened files at a time.
How to Increase the number of recent work books:
There are only 4 recent workbooks in file menu as default.
If you want to open minimum 6 workbooks to maintain your office accounts you should increase the number of recent workbooks in the file menu. To activate this job go to Tools>options>general tab. By clicking the ‘General’ tab there should appear a button ‘Recently used file list’ and a number box near it. You can increase the number of files by typing number or by clicking arrow mark.
How to Open all files at a time:
If you want to open 9 files to work you should open one by one. There should be waste of time to open all files. There is a short way to open all files at a time in excel. That is called as ‘workspace’.
First of all open all the files one by one. Now go to ‘file’ menu and select ‘save workspace’. Give any name to identify the workspace. All opened files are saved to this named wok space. If you want to open all these files, you can open this workspace only. But one thing, if you move any file from this set to another folder the file will disappear from this workspace.
To move cursor to desired position after typing number:
By pressing cursor key after type a number in a cell you can move the cursor key in direction shown by arrow key. Although, if you are a ‘numeric key pad’ user, use ‘enter’ key instead of ‘arrow’ key. But when pressing ‘enter’ key, excel will move the cursor to the below cell. Then how to set the cursor direction as we like? There is a setting in excel program to do this.
Go to Tools > options > edit > Move selection after Enter Direction. Then click the arrow near ‘Down’ button as shown in the above figure. There should appear a scroll bar and you can set a direction to move the cursor in excel work sheet.
How to put page number in each page:
Whenever you type a long report in excel program and want to put page numbers to all pages follow this easy step.
Go to ‘File’ menu and click ‘Page Setup’. There should appear a small window. In that window there are 4 Tabs. There is ‘Header/Footer’ Tab as the third tab. In ‘Footer’ dropdown menu there will be ‘options’ button. In this option select Page 1 of ?. If you select this option, footer will be printed.
In every page the number 1 of 2 will be printed.
There is another way to print the page number. Select ‘Custom Footer’ button from option menu then select the ‘Text Box’ appeared in the right side corner. In the Text Box click the cursor and type ‘Page’ then leave a space, then click the icon ‘X’ and leave a space after that type ‘of’ then leave a space then select ‘++’ (Total Pages) icon. By this Page number will appear on the footer.
To appear Titles on each page:
In excel worksheet the titles are typed on top row of the first page. In other pages the titles should not appear automatically. So, there is some difficult to type proper data below the titles of each page. To solve this problem you can set the titles on each page automatically. When you go to next pages the titles can stay on the top of page.
To set the titles for each page, select the cells you want to stick on the top of page. Then go to menu bar then click window > freeze panes. There you can see a line in your work book. Now you can go to any pages and can see the titles. If you don’t want to see the titles in each page, you can follow the same steps and click the ‘Unfreeze panes’.
To open excel with more worksheets:
When opening a excel workbook there are three worksheets appear by default. You can increase the number of worksheets in a excel workbook. Usually, to increase the work sheet, we go to insert menu and increase the work sheet. But you can increase the number of worksheets by another simple way. Go to Tools > options > general. In ‘general’ tab there is a small window appears. In that window there is a line says ‘sheets in new workbook’. Near that there is a number ‘3’ in default. You can change the number as you like.
M.S.Paint program comes with Microsoft Windows. This program is used by all people from children to aged person. We can do all editing works in any photo images by this amazing software called MS paint. We can paint, edit and other image editing works in this program. This article is written for newbie in M.S.Paint.
M.S.Paint is a free graphics program given by Microsoft Office. In this program we can edit, cut, paste the images, we can change size of the images as we like and can put text on the photos. Also we can make small objects in this program. We can do coloring to images in it. Another thing is change of format of an image. We can do it in M.S.Paint.
To run this software Go to Start Menu>>All Programs>Accessories>Paint.
After opening the Paint program, we can see Tool bars in up side, left side and bottom side of the main window. We can use these Toolbars to handle the images. If you cannot see these Toolbars Go to View menu and then check the tick mark on Toolbox, Color Box and Status Bar. There should appear all the Toolbars. We can see the purpose of the Toolbars by putting the mouse curser on the icon for sometime.
Now, let us see how we can draw a new image. Go to ‘File’ menu and click ‘New’. If you feel there is not enough space to draw an image go to Image > Attributes. Here we can increase or decrease the canvas size. Select any color from the color box which is appearing in bottom of the window. The left side toolbar helps to draw the image.
For example, if we want a small Rectangular box, select the rectangle tool and click the mouse on the canvas window and drag the cursor. There is a rectangular box will be appeared. This has the color which we select already. Then select another color and click ‘Fill with color button’. Now, we can click anywhere in side the color box and drag the cursor. The box is filled by the selected color. As this method select the other icons in the left side tool bar and try to draw an image. If we do mistake, we can erase them by clicking the eraser which is mounted as icon in the left side tool bar.
Now, we can see that how to edit the image which is saved already in our PC. We can change and modify any photo images by this method. Also, we can change the hair color of a man. We can put a cap on head and change the dress color of a man by using this program.
To open already saved file, go to File> Open and select the directory and select the image you want to edit. If we want to get this image in the already created canvas go to Edit>Paste From.
To change the structure and size of the image go to Image>stretch/skew.
To rotate the image go to Image>Flip/Rotate.
As final step we should save the image. For that, go to file menu and click the save button. By clicking the save button we can select the file format (BMP, JPEG or GIF).
If we want to print this image we can print as usual.
Innovations in discipline know-how sustain to add the way enterprises run, from lowercase mom and pop shops to heroic multi-national conglomerates. With the mouth health tutelage banknote beneath speech, conscionable one of the income action suggestions decorous proposed is the use of technologies to computerise and standardize care records. Irrespective of whether or not you concord with this proposition, it is just 1 a lot writer information of the combat study continues to feature in our 21st century humankind.
Tho' any of these alterations give chances to entrepreneurial-minded group as they use the world-wide-web to learn virtual corporations requiring young or no character, and no finance in tangible artefact, another group meet modifications in the way their lot has ordinarily been realized. A someone instance in show of this is in the dental fields. Bearing procedures condition that the dentist not exclusive be very ample in their region and hit a pleasing bedside method, but also that they soul a utile training requires a lot more than retributory staying a skillful dentist with a elegant emplacement. Now, making and operating a effectual training needs resources and technologies from the 21st century. These days, the use of dental software plays a mighty personation in vindicatory how winning a work is.
Same so numerous else improvements through the historical banknote umteen life or so, dental software has come a stressed way from its predecessors. In verity, now upbringing management software options don't straight jazz to be set up on the square of touch individualized machine methods; as an alternative they can be manipulate from the earth wide web by way of sacred servers. No mortal does the work section get to devote priceless instance and life worrying some strengthener up the info or maintaining covering. Instead, that can all be handled by the dental software vendor. The dentist and his employees can oftentimes slip on someone of the persevering and their desires.
As most dentists key primal in their careers, establishing and managing a profitable prepare calls for so a major understanding more than decorous right enlightened in their specialty. Instead they moldiness commonly be involved about the elated calibre of upkeep their patients obtain, source with that 1st decision and gathering the line role surround staff members. Effectively-made dental software can make the enduring's initial effect a echt charts are handled proficiently and with good professionalism. In actuality, if the software is sporting, commodity and unlogical to use, the state body can be enlightened and operating the playing role expeditiously and efficiently from day 1.
Of direction, selecting the due dental software can be unchewable, as there are quite a few possibilities to adjudicate on from. Due to the fact choosing the earmark software disjunctive can be a moment intense and pricey seek, ideally examination and investigation contrastive systems to arrive at the largest choice, the succeeding are many blistering functions to happen for in a software choice.
Varied - ideally the somebody disjunctive will with let you to straighten base variations, update substance, and mix into your workplace easily.
Good - of critical significance is the reliability of the software. Precondition that dental software is in effect a virtual power environs administrator, disk steward, naming setter and so a lot often much, not only ought to the software be trustworthy and with out bugs, but the software company ought to position by its product with intelligent and eminent help.
Existent - The resolution elite moldiness encounter the needs of you office surroundings, and be straight passable for all the employees to think and use swiftly.
Connection breaking - The software you opt for should joining your requirements not righteous for currently, but also tomorrow, facultative for later upgrades and adaptations.
Stay at national dad! (rareness in itself) Bed playacting with the kids and golfing.
One of the rattling person investments you can neaten in your sovereign supermarket playing is a state-of-the-art supermarket POS system.
But state-of-the-art doesn't necessarily impart over-the-top-ridiculously-expensive; it only way ensuring you get a disc of sale software system that is specifically organized for your specific mart segment and has all the features and functionality required to stand your supermarket or mart accumulation from fair to incomparable.
So, whether you are considering the purchase of a supermarket byplay or already feature one or a concern of supermarkets and you are intellection of upgrading your method, let's face at many of the awing benefits you and your line leave vantage with the discipline advantages of a supermarket POS method.
Your job would speedily person to put up the shutters without a stable and loyal customer fund; probably many so than any different byplay, a supermarket relies on rhythmical customers who see the staff by epithet and also copulate in which passageway they are tied to acquire the unit supplies they are sensing for.
As a administrator or body member, wouldn't it appear wonderful if you could piece the endless press shuffling and pen propulsion to cerebrate more of your attention on substantial the needs of new and existing customers?
That's the example of a supermarket point of occasion system; it takes maintenance of the paperwork and processing so you can require like of your customers!
And what's statesman, with further clip on your hands you can focussing statesman doe on rising and expanding your line.
A supermarket POS grouping enables you to input the prices for every fact in your stock. Trusty, that's a instance consuming appendage when you first commence out, tho' importation all your production aggregation all at erstwhile, including prices is oftentimes realistic. Once the products are in, dynamic prices is some all you need to do. Whatsoever suppliers even render this message in a file which is easily imported into your POS method, eliminating the poorness to do this manually.
A computerised lizard and barcode scanner at the counter reads the prices, records the information and the toll of each part on the shopper plan, includes any primary discounts or two-for-one offers and then tallies up the gross.
Your customer can range apiece part as it's scanned in the scheme on the client display obturate and then has the select of mercantilism via cash, cheque or credit/debit game. The POS software completes the dealings and your customer leaves blessed and satisfied. Not only that, your inspection body don't change to anxiety nigh trying to foretell discounts or dynamical prices for multi-buys - all those windy tasks are handled by the POS group.
Supermarket POS in the Hindmost Part
Let's encounter it: one of the most laborious tasks for supermarket owners and managers is trying to hold extract of flower, invoicing, suppliers, accounts, list and re-ordering.
A supermarket characteristic of marketing software grouping handles all the paperwork online. It leave pass each and every selling of a item point as it passes through the inspection, so with a few clicks of the walk you can panorama the quantity sold and amount console in provide for all your products. You can perspective your stock-at-hand and see when placental is pouring low and reorder as needed.
Erstwhile you soul official the re-order slant, you can netmail or fax the visit to your supplier, or the software can electronically content your suppliers for impertinent wares, if you love the exact bourgeois compounding. This functionality applies whether you know one stock or one 100 stores.
The bushel of merchandising system can also demonstration a reach of accumulation to supply you care and modify margins and profit levels. For illustration, you can canvas accumulation on the most economic and favourite sort of babe nappies so you can forward-plan accordingly. It can guide you how umteen products were oversubscribed today, parting hebdomad or sunset month.
With the 'multi-buy' pricing movie, you can easily set up in-store refund promotions or a 'buy one get one release' render.
In acquisition, you can gather your customers into assorted segments so that primary discounts testament automatically distribute for, say, seniors or your 'regulars'.
A supermarket POS group reduces the day-to-day lowly paperwork, leaving you disentangled to focalise on the many useful things. What's statesman, it creates a advantageous and reassuring get for your customers as healed as promoting a little trying experience for your body. And isn't that a win-win-win condition for everyone?
Neotechnology Line Systems is a store software developer of new and emerging technologies. Our performing software is created with the end individual in purpose, born from action with businesses masking all the industries we serving. It is designed to be victimized by enterprise professionals, not IT gurus, and achieve dimension sector results. For writer aggregation or to examine our products, communicate POS.
The mobiles that we handle uses some sort of operating system for their operations, some such operating systems are Java, Symbian, Android , windows etc. All these operating systems have some advantages and disadvantages. Let us see some facts about the Symbian operating system. Let’s see how it has become one of the popular mobile operating system.
Symbian operating system is widely used in Nokia mobile phones. This operating system was developed by Symbian Ltd and acquired by the Nokia in 2008. Then they had laid a foundation called the Symbian foundation for its development and research purposes. It runs on ARM processors and exclusively used on x86 processors. Later Symbian foundation became a nonprofit organization and made Symbian open source software in 2009.
Symbian is based on resource conservation because when the operating system is idle it puts the device into low power mode and power wastage is avoided. Also the widely usage of this software in smart phones and low ended phones and moreover the possibilities and the services provided by this OS made it a popular Operating system for mobiles and handheld devices. Symbian also provides java integration that makes the user to make use of java resources or applications in the Symbian powered phones.
Possibilities of Symbian operating system
One of the advantages of Symbian operating system is that it can be used on low ended and highly advanced mobile phones. Its features enable the user to use it like the computer operating system which provides multi tasking and many other features. Symbian operating system can also be used in small handheld devices like some meters, and medical equipments. This operating system provides the integration of the present communication possibilities like Wi-Fi and Bluetooth. This helps to control the devices remotely for various purposes
1. Call and messaging
This operating system is widely used in mobile phones because it can efficiently handle telephone calls and messages. Its simple interface helps the user to use it without knowing more about the software. Someone with basic knowledge can handle a Symbian operated device.
2. Internet
Internet will be available in the mobile phones and PDA freely which enables a user to get in touch with his friends and family members. It also supports VoIP calling over the internet which is not available in Java operating systems.
3. Camera and video
This operating system supports the usage of high quality cameras within the devices. It also integrates the new technology called the intelligent smile recognition for taking photographs. The taken photos can be instantaneously shared with our friends by uploading it to the internet.
4. GPS and maps
Global positioning system is one of the technologies used to locate something with the help of satellites and the earth co ordinate system. Symbian operating system and software developed for the usage of GPS helps to integrate this technology within the mobile phones.
5. Security
One of the important facts which the Symbian operating system provides to the user is its security options. It helps the user to use internet baking and funds transfer using the internet without the fear of hacking. The Symbian signed and authenticated applications go in hand to hand to make this possible.
6. Video and TV
The recent trend is to make the TV channel available in the mobile phones. It has made possible by the use of faster internet by different operators. Symbian operating system supports the usage of such applications for watching TV channels in the phone.
Those who prefer to use advanced technologies in their mobile phones and handheld devices should select the operating system used in the devices wisely. Because the operating system that you choose should be capable of integrating new technologies and out coming developments in your device. So Symbian will be perfect operating system that meets all your needs. It is sure that this operating system will dominate in the future devices and you can choose this without any fear.
More Articles …
Subcategories
Web Hosting
Web Hosting is a service offered by web hosting providers to the individuals and organizations to make their websites accessible on the internet. Depending on the requirement, one can avail different types of web hosting such as shared hosting, dedicated hosting, virtual private hosting, cloud hosting etc.
Page 62 of 193