Showing posts with label Tech. Show all posts
Showing posts with label Tech. Show all posts

Fixed Rows And Columns Headings In Pivot Table

Problem: You want to show some data in excel pivot table in which you want to fix row headings and column headings of your pivot table.

 

Let’s have a real world scenario here to understand the pivot table easily.

 

You need to show the value of Sales Opportunities in a pivot table with Months as column headings and the Sales Managers names as rows.

 

Where there is data in the underlying database (spreadsheet is linked to a SQL server database) then there is no problem. However if there is no data for a given month then of course by default the Pivot Table doesn't supply that month as a column.

 

Is there anyway to force a Pivot Table to show column headings in a non-dynamic form. So if there is no data for May the column is still there. This will make readability for my boss a lot easier.

 

On a similar subject is there also anyway I could fix the rows so that all Sales Managers show up even if there is no data.

 

Solution:

Locate your data in excel and make a pivot table with it. Select any column heading or row heading of your pivot table and right click on it. Select Field Settings from right click menu after that goto layout & Print and select Show items with no data. That’s it!!

 

 

For you help I am also attaching the snap shots. Hope this tutorial will work for you!!


Input Devices Of Computer

Input Devices

The input unit is formed by the input devices attached to the computer. Ex - Keyboard, Microphone etc. An input unit takes the input & converts it into binary form so that it can be understood by the computer.

Keyboard

This is most commonly used device which acts as input device. Its structure is like typewriter.It contains no. of  keys which have some specific ASCII values. Like ‘A’ has ASCII value 65. When this is pressed , it is converted into 65 & this 65 is sent to CPU in the form of Binary language (i.e. 1000001). Then operations are done on this data.

Most common and very popular input device is keyboard. The keyboard helps in inputting the data to the computer.The layout of the keyboard is like that of traditional typewriter, although there are some additional keys provided for performing some additional functions.

 

Keyboard are of two sizes 84 keys or 101/102 keys, but now 104 keys or 108 keys keyboard is also available for Windows and Internet.

Mouse

This is a pointing device which contains a roller in its base. When the mouse is moved on any surface, the pointer on the screen is also moved. It contains a potentiometer coupled with the roller. This potentiometer senses the motion of mouse & convert it into digital value. A mouse may contain two or three buttons.

Mouse is most popular Pointing device. It is a very famous cursor-control device. It is a small palm size box with a round ball at its base which senses the movement of mouse and sends corresponding signals to CPU on pressing the buttons.

 

Generally it has two buttons called left and right button and scroll bar is present at the mid. Mouse can be used to control the position of cursor on screen, but it cannot be used to enter text into the computer.

Now a day's optical mouse are very popular.

Bar Code Reader

It is a device which is used to read the code from the products which are usually in the form of Bars. It contains a light sensitive detector which identifies the values of the bars on the product & converts them into numeric code.

 

These Bar readers are used in Shopping malls in a very large scale.

Bar Code Reader is a device used for reading bar coded data (data in form of light and dark lines). Bar coded data is generally used in labelling goods, numbering the books etc. It may be a hand held scanner or may be embedded in a stationary scanner.

 

Bar Code Reader scans a bar code image, converts it into an alphanumeric value which is then fed to the computer to which bar code reader is connected.

Digital Camera

As the name specifies, these camera stores the data digitally, which then can be stored in the computer & can be stored for a long time. But it has very limited storage capacity. These are very popular because of less expensive photographs & Speed.

Light Pen

It is a pointing device which contains a photocell mounted at its tip. It senses the light from the screen when it becomes closer to the screen, & generates a pulse. So for identifying a particular location on the screen these light pens are very useful. But this is not in very much use these days.

Light pen is a pointing device which is similar to a pen. It is used to select a displayed menu item or draw pictures on the monitor screen.It consists of a photocell and an optical system placed in a small tube.

 

When light pen's tip is moved over the monitor screen and pen button is pressed, its photocell sensing element detects the screen location and sends the corresponding signal to the CPU.

Scanner

The scanner is an input device like the photocopier machine which makes the electronic copy of the picture or document which can be further edited.

Scanner is an input device which works more like a photocopy machine. It is used when some information is available on a paper and it is to be transferred to the hard disc of the computer for further manipulation.

 

Scanner captures images from the source which are then converted into the digital form that can be stored on the disc.These images can be edited before they are printed.

Mic's OR Microphones

The scanner is an input device like the photocopier machine which makes the electronic copy of the picture or document which can be further edited.

 

Microphone is an input device to input sound that is then stored in digital form. The microphone is used for various applications like adding sound to a multimedia presentation or for mixing music.

 

Magnetic Ink Card Reader(MICR)

MICR input device is generally used in banks because of a large number of cheques to be processed every day. The bank's code number and cheque number are printed on the cheques with a special type of ink that contains particles of magnetic material that are machine readable.

 

This reading process is called Magnetic Ink Character Recognition(MICR). The main advantages of MICR is that it is fast and less error prone.

 

Optical Character Reader(OCR)

OCR is an input device used to read a printed text. OCR scans text optically character by character, converts them into a machine readable code and stores the text on the system memory.

 

Optical Mark Reader(OMR)

OMR is a special type of optical scanner used to recognize the type of mark made by pen or pencil. It is used where one out of a few alternatives is to be selected and marked. It is specially used for checking the answer sheets of examinations having multiple choice questions.


Top 25 Very Useful Excel Keyboard Shortcuts 2013

 

1. To format any selected object, press ctrl+1
2. To insert current date, press ctrl+;
3. To insert current time, press ctrl+shift+;
4. To repeat last action, press F4
5. To edit a cell comment, press shift + F2
6. To autosum selected cells, press alt + =
7. To see the suggest drop-down in a cell, press alt + down arrow
8. To enter multiple lines in a cell, press alt+enter
9. To insert a new sheet, press shift + F11
10. To edit active cell, press F2 (places cursor in the end)
11. To hide current row, press ctrl+9
12. To hide current column, press ctrl+0
13. To unhide rows in selected range, press ctrl+shift+9
14. To unhide columns in selected range, press ctrl+shift+0
15. To recalculate formulas, press F9
16. To select data in current region, press ctrl+shift+8
17. To see formulas in the worksheet, press ctrl+shift+` (ctrl+~)
18. While editing formulas to change the reference type from absolute to relative vice versa, press F4
19. To format a number as currency, press ctrl+shift+4 (ctrl+$)
20. To apply outline border around selected cells, press ctrl+shift+7
21. To open the macros dialog box, press alt+F8
22. To copy value from above cell, press ctrl+’
23. To format current cell with comma formats, press ctrl+shift+1
24. To go to the next worksheet, press ctrl+shift+pg down
25. To go to the previous worksheet, press ctrl+shift+pg up


First “Facebook Phone'” Unveils By HTC

HTC and Facebook unveiled the new Facebook-HTC First smartphone. HTC First is a new deeply integrated Facebook phone that is going to use the newly-revealed Facebook Home user interface.

 

 

The HTC First smartphone features the Snapdragon 400 dual-core processor and Android 4.1 Jelly Bean OS. The device features a 4.3-inch display with 1280 x 720 pixels resolution. It has a 5-megapixel camera with 1080p HD video capture, a flash, and 4G LTE from AT&T.

 

The Facebook-inspired HTC First phone comes preloaded with the newly-announced Facebook Home, a new user interface overlay that replaces the Home screen of select Android smartphones such as the Samsung Galaxy S III, Samsung Galaxy S4, HTC One, HTC One X and HTC One X+ with Facebook's software.

Meanwhile, according to Facebook CEO Mark Zuckerberg, the new Facebook Home user interface/software for Android prioritizes and puts people first, not apps.

 

Furthermore, HTC's "Facebook" phone will also come preloaded with Instagram, and will come in four different body colors. This mobile phone will be sold exclusively by AT&T in the United States for $99.99 with a 2-year contract.

 

Would this HTC First smartphone from HTC and Facebook collaboration be more successful and noteworthy than previously launched Facebook-integrated phones' HTC ChaCha and HTC Salsa? I guess we'll just have to wait and see.


Booting-Up Your Computer Fast

Does your Windows computer take really long to start-up?

 

Well, you are not alone with this problem but fortunately, with some minor tweaks, you can get your sluggish Windows to start much faster without re-installing Windows or adding any new hardware.

 

The logic is fairly simple. Your computer loads quite a few software programs and services during start-up (look at all the icons in your Windows System tray). If you can trim this list, your computer’s boot time will decrease.

 

I have been testing a free utility called Soluto and it helped reduce the start-up time of my Windows computer from 3.15 minutes to around 1.25 minutes. All this with a few easy clicks and without confusing the user with any technical jargon.

 

 

After you install Soluto, it sorts your start-up programs list into three categories:

 

  • No-brainer – remove these programs from start-up with giving a second thought.
  • Potentially removable – another list of start-up programs that may also be removed provided you know what these programs do.
  • Required – Certain programs and services are required to run Windows properly and therefore should not be removed.

 

Depending upon the software app, you may then either choose “Pause” to completely remove that app from the start-up queue or choose “Delay” when you want the app to run automatically but not immediately at start-up. Soluto will launch the “delayed” app once the boot up is over and your system is idle.

 

You can also hover the mouse over any program name and Soluto will display the number of seconds that the app adds to the start-up time. And don’t bother about making mistakes because Soluto has a useful “Undo all” feature that will restore the start-up list to the original state with a click.

 

 

Once you are done classifying your start-up programs list, reboot the computer and you should notice a difference between the start-up time.

 

Where to download Soluto?

The official site for Soluto is soluto.com but in order to download the program, you should head over to mysoluto.com.


Top Five Myths of Cloud Computing In 2013

Technologies around the Internet and the WAN have been around for some time. However, it wasn’t until very recently that a specific term began circulating which was supposed to emphasize the combination of these technologies. Cloud computing was born out of the idea of a distributed computing system where information was available from numerous different points. Although the idea has certainly caught on – there are still some misconceptions and confusions around the cloud.

 

 

Many businesses have found great ways to utilize a cloud model. Now, they’re able to be more agile, grow faster and even add to their business resiliency. Still, there are those that have never really worked with an enterprise cloud model and are held back by myths and confusion points around the technology.

 

    In HP’s Five myths of cloud computing, we learn some of the biggest myths currently circulating in the cloud industry. Remember, the cloud is a vast, diverse, model which can accommodate many different types of organizations. Whether it’s a private, public, hybrid or community cloud – there may be a fit for your organization. Still, without full understanding the cloud model, it’s easy to be confused by so many different types of offerings.

 

The Five myths of cloud computing whitepaper outlines the key areas where IT managers and business stakeholders should seek more clarification. Specifically:

 

Myth 1: The public cloud is the most inexpensive way to procure IT services

Myth 2: Baby steps in virtualization are the only way to reach the cloud

Myth 3: Critical applications do not belong in the cloud
Myth 4: All cloud security requirements are created equally
Myth 5: There is only one way to do cloud computing