IT News, How To's & updates
1) Pivot Tables Pivot Tables are used to reorganize data in a spreadsheet. They won't change the data that you have, but they can sum up values and compare different information in your spreadsheet, depending on what you'd like them to do. Let's take a look at an example. Let's say I want to take a look at how many... Continue Reading →
Even though we live our lives bathed in 3G and 4G networks, there is still a lot to be said for good, reliable WiFi. Nowadays, there are so many free WiFi hotspots around that the chances are fairly good that you’ll be able to connect to one up fairly easily, especially if you live in a... Continue Reading →
What do Cookies Do? A cookie is the term given to describe a type of message that is given to a Web browser by a Web server. The main purpose of a cookie is to identify users and possibly prepare customized Web pages or to save site login information for you. When you enter a... Continue Reading →
After Microsoft developed Excel to the 2010 version, it offered more surprises than ever. In order to deal with tons of big data, you can’t ignore the important role Excel plays in daily work. However, both for beginners and advanced users, there are still many useful tips and tricks that are inevitably overlooked. Here are... Continue Reading →
Granted, the technical specifications that ship with the iPhone 6s are impressive as is the physical appearance of the device – a design that we know resonates with consumers due to it being proven by the popularity of the iPhone 6. But what about competing devices like Samsung’s Galaxy S6? Let’s take a look at each... Continue Reading →
Users will also be able to hide posts and images that they post, stopping their ex from seeing them. This is effectively the same option as above, but simply reversed. Exes will no longer see what a user posts unless specifically tagged, for example. While the two options are great for future posts, Facebook will... Continue Reading →
With Microsoft Office applications, you can create a simple To Do list or make a checklist in Word 2013 and check off items electronically. The underlying trick for doing so is very simple and takes not more than few minutes. The result looks something like the illustration below. Having said that, if you just need a... Continue Reading →
Microsoft Excel 2010 Slicers are easy to use visual controls added to Excel 2010 that allows to quickly and easily filter data in an interactive way by selecting values from a list. The slicer feature provides user with a rich visualization of the pivot table on which dynamic segmenting & filtering can be applied to... Continue Reading →
Microsoft Excel is the most useful and easy tool for business analysts. It has large number of useful formulas, features and bundles of interactive charts. But, most of us are not known of all of them and there are some more features which are powerful and easy to use to make our work simpler. You... Continue Reading →
In this post we will see how to get a list of files in a folder into Excel. We will show you how to use Excel to view Files and Folders details in Windows, by importing all files and folders details in to Microsoft Excel to keep track of file size, file type and last... Continue Reading →
Svanews 