Posts

Showing posts with the label Course

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

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