Posts

Showing posts with the label Class

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 ...

Penzu - Keep your private thoughts secure using this online journaling tool

Image
Description:  Everyone knows the benefits of journaling, it relieves stress, makes you stick to your goals but what many don't know is that you can now also do it online from anywhere and never lose your thoughts again.  Penzu is an online diary that let's you write down your private thoughts securely. If you have been looking for a digital diary solution, look no more. I am confident you will love this free, private and secure way of capturing your thoughts and important events. It is of course entirely up to you what type of a journal you keep. Some people like to do a daily journal, while others want to capture their travels through Africa. And don't forget the bright minds looking for a solution to capture all of their ideas that are rushing through their creative minds, or the teenagers venting about their friends or perhaps their annoying parents. In addition to the free version, there is also Penzu Pro and Penzu Classroom with added functionality for those enth...

Coursera - Get FREE education from professors at leading universities

Image
Coursera - Welcome Screen Description: Over 4 million people from all around the world have already used Coursera to study anything from History of Rock, Songwriting, Financial Markets, Nanotechnology to Optimization of Antibiotics. There are currently 393 courses available to choose from offered by leading scholars from 83 different universities including, Harvard, Stanford, Columbia University, Princeton, Technical University of Denmark, University of Melbourne or The Hong Kong University of Technology. New courses are added frequently and are now also offered in various other languages including English, German, Spanish, French, Chinese and Italian, with the vast majority of  Coursera  courses offered in English today. There are various ways in which you can browse through the courses, you can view those that are upcoming or view them by their specific thematic grouping and choose one or more of the following categories: Coursera - List of Topical Categories of C...