Posts

Showing posts with the label Analytics

VLOOKUP - Excel Function Everyone Should Know

Image
I usually post on this blog about different technologies, most of them web-based. It occurred to me however, that perhaps people would like to learn some cool functions they can use with Microsoft Excel. VLOOKUP is one of those Excel functions that can be sometimes overlooked but perhaps everyone should know about because it can save you a lot of time and can be very powerful when dealing with large data sets. What exactly is VLOOKUP? Basically, VLOOKUP lets you  search for specific information  in your spreadsheet. For example, if you have a list of players for a particular sports team and some basic information about them, you could search for the name of someone based on their number. To go along and work on the examples, please download the spreadsheet . In this first example, we are going to use VLOOKUP to find the name for number  88 . You can probably see that it is Jessica Chandler, but that's because this is a simple example. Once you learn how to use ...

Infogram - Great tool for making stunning graphs based on real data

Image
Infogram Infographic Example Description:   Infogram is a website where you can create various different charts to visually portray your data. Anything from bubble charts and treemaps to simple pie charts.  You can either work with a built-in worksheet tool or import your data in an XLS, XLSX and CSV formats. You can download your infographic as a PNG or a PDF file and seamlessly share on various social media sites including Facebook, Twitter and Interest. So next time, when you are asked to present some data, test out Infogram and be ready to wow your boss, your teacher or your friends. Pros: You can create graphs using real data, you can add your own images and video. Cons:  There is limited availability of other objects to be used in your  infographics, such as people or buildings. Link:   infogr.am Cost:  FREE Experience: I was able to create the following infographic myself. The process was pretty intuitive and I would use ...

Sliderocket - Create a Presentation That Will Rock Everyone's Socks Off

Image
Sliderocket  Description:  At this website, you can create and share your beautiful dynamic presentations. This tool provides a brand new take on presenting. You can create your presentations online or offline, you can collaborate on them with others, you can view them on mobile devices. One of the other features that is certainly interesting is the fact that you can track the effectiveness of your presentations. The list goes on...  To learn more about this product, please go here . Pros: Sliderocket allows you to create presentations that will be more interactive and dynamic than presentations you can create with Microsoft PowerPoint. You will also have an opportunity to track which particular presentations/slides are effective. Cons: It is not as transformational in its approach as Prezi , because it continues to have the linear feel. Link:   sliderocket.com Cost:  FREE Disclaimer:  Please note that all of the information provided above is ...