Category Archives: Writings

Microsoft Excel – Most Common Function Groups

Microsoft excel has a lot of functions that you can use for the worksheets that you use. To see all of the functions that are available, refer to reference available in Microsoft Excel (or Google “Excel” followed by one of the below categories that is in bold to see all the functions in that category!). These functions are often performed to manipulate, modify, change, or view the data in the cells of a Microsoft Excel worksheet. The list of all of these worksheet functions can be found are at the official Microsoft Excel reference that is available with the Microsoft Excel product. If you’re looking to become an Excel expert, we strongly recommend you go to: https://www.houstonexcelclasses.com/

The functions are separated into categories. I will talk about the different categories and what kind of functions are available in each category.

These functions are just some of the functions that are available in Microsoft Excel. Most of them cannot be used very efficiently just by themselves. You have to know when to use which one and how to use them together to perform the proper function in an Excel worksheet cell to achieve the desired result.

Database functions

When you use an Excel worksheet in conjunction with a database you can use these functions to perform mathematical calculations from the data retrieved from the database entries.

Date and time functions

A cell with a date and time function usually modifies some text to convert it to a date or different parts of that date. Most of the functions convert serial numbers to dates and dates to serial numbers.

Engineering functions

This group of functions is fairly advanced and has operations that are done at the engineering level which probably won’t be necessary for any common tasks.

Financial functions

There are a lot of financial calculations that are done for example investments and assets. There are functions available in this category that will help with those calculations.

Information functions

These kinds of functions return information about the cell, whether it is text, an integer, a Boolean, etc. along with other related information

Logical functions

This category includes the basic logic of functions such as “and”, “or”, “if”, “true”, and “false”. These kinds of functions are often used with cells, inside of nested functions.

Lookup and reference functions

These functions return properties and information about objects that you use in the function such as a row number or for looking up the value of an array.

Math and trigonometry functions

These are the basic mathematic and trigonometric functions that are available and are often used by mathematicians and also to perform basic tasks.

Statistical functions

Anything related to probability and statistics can be found here in this statistical category.

Text functions

Any kind of manipulation you want to do to a string of text can be found in this category of functions.

External functions

There are two functions in this category that convert Euros and also perform SQL requests which are not very common functions.

The usefulness of this list is realized when you want to find out what kind of functions are available to you in a certain category of work for whcih you are using Microsoft Excel. Searching for help on a specific category of functions in Microsoft Excel will liekly yield much better search results as opposed to searching for random available Excel functions. The above is an official Microsoft Excel function categories.

Are Men or Women Better at Using and Caring for Cars and Electronics?

Some people debate that males are better at mechanics (cars) and electronics than females. It’s been my experience that gender has nothing to do with it. I’ve known males and females who are klutzes when it comes to caring for cars or electronics. Read on and decide for yourself and make sure to check out Keuze Helper. They are a Dutch site dedicated to helping Dutch folk with their electronics.

At a previous job I was waiting on the dock one day while a fellow supervisor backed up the van so we could load it. Keep in mind, I’m female, the driver was male. As I stood there watching, the driver got in the van, started it up and fiddled around for a bit. Then he opened the door, got out of the van, and yelled to me, “How do you release the parking brake?” I told him how (there’s a lever to the left of the steering wheel you have to pull).

He turned around, with his feet still planted on pavement, and released the parking brake. Apparently he had already put the van in reverse; at this point I lost it and was on the ground laughing with tears in my eyes. He ended up jogging alongside the van until he could climb inside and stop the van from backing into a truck. He was completely unhurt, and I apologized for getting such a good laugh at his “near death experience”. But it’s still kinda funny. Now I ask you, are males really so mechanically inclined?

On the other hand, I don’t think females are very good with mechanics or electronics either. At least, caring for these items seems to be difficult. One day at work (current job), my boss put her cell phone into her back pocket. She then had to use the restroom, and as she told me afterwards, she flushed her phone down the toilet.

It seems she stood up, pulled up her pants, and as she turned around and flushed, the phone (which had somehow ended up near the open end of the pocket) fell. This is a public toilet, so it’s completely understandable she wasn’t fishing it out of the pipe, even if it was reachable. So she had to buy a new phone… Funniest part was she couldn’t claim a damaged phone on insurance (which was a possibility) because she couldn’t provide the company with evidence the phone had been damaged.

Personally, it’s been my experience that an individual’s aptitude with cars or electronics has nothing to do with gender.

10 Nintendo NES Games that Shine as Retro Classics

For those of us old enough to remember, the NES (Nintendo Entertainment System) was the first real gaming console that captured the hearts of American gamers. It was on this console that gamers were first introduced to such famous figures as Mario, Megaman, Ninja Gaiden, Final Fantasy, and many more.

Other classic characters from this console were never brought back in later games despite their large popularity. These games need to be given a second look by young gamers, as they are an exciting part of gaming history. Keep in mind you can still play retro games at various sites. Our favorite one is linked.

1. Ninja Gaiden II: The Dark Sword of Chaos – Released in 1990, this is actually the second in the series on the NES console. You control Ryu, a ninja who battles other ninjas to save your girlfriend. The game features impressive levels and a variety of weapons that make the game a pleasure. There is nothing quite like killing scores of orange ninja clones.

2. Final Fantasy – Released in 1990, this was one of the most influential games of all time and has today spurred over 12 sequels. With RPG history of his caliber, it is something worth taking a look at. The game features traditions of Final Fantasy that fans will delight in seeing in their first incarnation.

3. Megaman 6 – In 1994, already far into the Megaman series, this game admittedly does not bring anything new to the Megaman series, but as the last Megaman released on the NES, it is worth a look for gamers who don’t want to go back any further into bad graphics territory.

4. Dragon Warrior IV – Released in 1992, it is arguable whether this or its predecessor Dragon Warrior III deserves the spot. Either way, the Dragon Warrior series is an excellent example of the RPG sector of the NES. Along with Final Fantasy, Dragon Warrior paved the way for future RPG games which relied strongly on good storyline and intricate battle systems.

5. Kirby’s Adventure – The Kirby game series was actually started on the Gameboy, but in 1993 it was brought to the NES in impressive form. The cute character of Kirby found his way into gaming hearts with his fun abilities, minigames, and clever level design.

6. Kid Icarus – Though partly only raised in popularity recently by Super Smash Bros. Brawl, Kid Icarus was a strong game in its own right when it came onto the scene in 1987. Combining elements of Metroid and Zelda, the game pioneered some of the first action gaming ever seen and in a fun and engaging way.

7. Super Mario Bros 2 – What would any list be without Mario on the scene. In this 1988 title, gamers were wowed by the fun levels and creative characters of the series. With virtually nothing to complain about with this game, players were completely blown away by the fun that they were having.

8. The Legend of Zelda – Released in 1987, it took the world by storm by its fun gameplay despite its lack of any real storyline. The second Legend of Zelda came a year later and was arguably the stranger of the two. It introduced experience points into the world of Zelda, making it more like the RPG series which gained popularity. This was a decision that was ultimately not approved of for future games, but it is still a fun and interesting game that is worth a look at.

9. Duck Hunt – Released in 1985 with a special gun and sensor, this game quickly became a huge part of popular culture. The gameplay was simple and yet addictive: players aim their guns at passing ducks that zoom by quickly and try to hit as many as possible in a short period of time while your faithful hound gathers them or laughs at you when you miss. Classic.

10. Metroid – In 1987 our beloved female bounty hunter made her way into the scene battling aliens in her unique way. The game has been complained about for being difficult, but despite this it is a famous title that has created an entire series throughout Nintendo history.

Honorable mentions:

Castlevania II: Simon’s Quest – In 1988 the NES got one of its most beloved games that gamers know only little about today. This game involves traveling through side-scrolling levels of darkness and evil to hunt down vampires and other creatures of the night with your innovative group of weapons. The game was very impressive for the time and is still as addictive as ever.

Bomberman – In 1987 the world was introduced for the first time to this famous puzzle/adventure game which uses square stages full of obstacles and a little man with bombs to fill hours of your time. A fun game and a notable slice of history for the puzzle game genre as well as an early adventure game. Link from Zelda could have taken a page from Bomberman’s book when it comes to his bomb weaponry.

Men Beware – You Can Be a Fashion Victim


Men! Beware as you can also be fashion victims. Read and use the following guide to help you enjoy wearing nice clothes. At the same time, you will feel comfortable.

1. Why do men wear ties?

Haven’t you wondered why that tie must be tied tightly around your neck in order to be professionally dressed? Did you ever think that ties can actually be unhealthy. A small study published in the British Journal of Ophthalmology in 2003 found that wearing tight ties daily [or often] could raise eye pressure. This could perhaps lead to a mis-diagnosis of glaucoma. So yes, wear the tie, tied in your preferred knot, but DO NOT tie it so tightly as to bother you.

2. Do you still buy the same size shirt collar size as you did in high school?

If so, perhaps you don’t realize just how tightly that shirt collar fits. To find the right size, measure around the base of the neck just below the Adam’s apple. Leave a fingertip’s width. Also, realize that using starch when laundering shirts can shrink collars. When it comes to black men fashion, we strongly recommend that you update your wardrobe once every 2 – 5 years.

3. How about your belt?

If you must hold your breath so much it hurts, just to get your belt tightened, it is too tight. Do not delay, go out and buy yourself a new belt. This is not a splurge, but could improve your health,

4. Do you take time to look at all the jeans out there?

Maybe those Levis you’ve been wearing for years – or the skinny jeans – need to be upgraded to a bigger size or just a different type of fit. Jeans should be one of the most comfortable things we wear. If they bind and keep us from bending or sitting comfortably, it’s time for 1] a new pair, 2] Good Will, or 3] eating less and exercising more.

5. For goodness sake buy yourself a heavy coat, hat, gloves and even a scarf.

No, you won’t need the entire collection very often, but if you must walk, travel long distances by car, or live in a cold climate you need to be safe. Wrapping a scarf around your mouth and nose on below zero and very windy days can keep your lungs from sucking in so much cold air. For anyone with lung problems – you know the problem.

Researchers have found that wearing clothing that fits too tightly can possibly cause acid reflux, heart and breathing concerns. Ask a friend if you must – but you will look much better in the size meant for you than the size you possibly continue to buy – “just because.” Many wives or family members often purchase their guy’s clothing. Remind them, if needed, that the size 15 shirt no longer fits or is comfortable.

The Sportsbook’s Odds System Explained

Odds. Carefully formulated to cause an overload of brain activity to the betting enthusiast over which line to choose. Sure, lines might present you with a myriad of simple numbers – the A team vs. the B team with a plus and minus for each creating the favorite and the underdog, but how are handicapper lines made? What is the logical, numerical basis behind the numbers – and who creates them? This is evident with Asian sports betting sites, such as taruhan online .

For starters, the lines (odds to the layman) is in reference to the point spread of professional sports games. The point spread philosophy is pretty straight forward; suppose you have the New York Knicks at a point spread of +5 and the Milwaukee Bucks at a point spread of -5. What does this mean? In order for the person betting on the Knicks to cash in, they must either 1) win the game outright or 2) lose the game by less than 4 points. In order for the Bucks aficionado to cash in, they must 1) win the game by more than 5 points. If the Bucks win by exactly 5 points, the bet is ruled a ¨tie¨, or ¨push¨ and no money is won on both sides.

Spreads are manmade with the provided help of statistical data. The lines you see in newspaper publications and online betting websites are mostly figured by the Las Vegas Sports Consultants organization. The sanctioning body for all sportsbooks in Las Vegas, they dish out lines daily to online sportsbooks. The Las Vegas Sports Consultants organization is made up by a myriad of sports experts who think up various strategies based on a host of data to determine the best line for any professional sports game.

The odds are more than just a point spread. For starters, these experts take into consideration any insider information (conflicts in the baseball clubhouse that might affect the outcome of a game, weather, the absence of the coach, etc.)Don´t be misinformed – the main determinant in deciding a point spread is numerical and statistical data based on past trends. The intricacies of deciding on a point spread is two-fold: 1) load Las Vegas bank accounts with cash from lost bets and 2) line Las Vegas´ pockets with cash from bets won! Surprising?

In order to minimize sportsbook losses, oddsmakers have to come up with a line that will have one half of the betting public choose one team and the other half choose the other team. Remember, most bettors have to pay $20 to win $18, or $10 to win $9. When you win, Las Vegas still retails 10% of the original bet amount. Since the majority of most sportsbooks receive their daily lines from the Las Vegas Sports Consultants organizations, it´s easy to understand why some lines are exactly the same at BetJamaica.com and Bodog.com. In essence, making the odds is a tough job – oddsmakers have to create a ¨balance¨ between the favorite and the underdog in order to make money. If too many bettors and gamblers bet on one side, lines must be ¨moved¨ accordingly to encourage betting on the other side. To conclude, crafting the odds means big business in the gambling industry. One half point could make or break half a million dollars deposited into the wide pockets of Las Vegas oddsmakers. Remember, they make money by losing AND winning, wheras you make money by simply winning the game. A bona fide business, indeed.

How to Quit Smoking: From a Financial Perspective

Habitual smokers are told everyday what is wrong with smoking, but it never phases them. They can still smoke over a pack a day and feel like there is nothing wrong with it and society should just let them be.

These are also the people who sometimes complain about how they don’t have enough money to see a movie or go on a vacation. Well there is a key ingredient people are forgetting to tell smokers. It costs money, even if it has become routine in their lives.

1. How much does a pack of cigarettes cost?

A pack of cigarettes costs around $4-$5, and for the sake of this article I am going to say they are $5 This is much less than the average vape from vape India which comes in at a fraction of the cost.

2. How much a week do you smoke?

The average smoker smokes more than 1 pack a day. This is $5 a day that smokers can easily throw away. Under this light it would seem easy to get rid of the $5 a day without much thought. Now multiply this number by 7 days a week and you have around $35, still not that much but imagine that extra money in your pocket every week.

3. A month is around 30 days, so multiply the pack a day by 30 and you have about $150 a month.

Now seeing as a pack a day is the low end for smokers, we can also multiply 30 by $7.50 or more. This ends up being over $200, which is the equivalent to a car payment. Imagine being able to buy a brand new car with the money you have spent on smoking over the past 10 years?

4. Now 12 months out of the year. Multiply the $200 a month by 12, and you have around $2400 dollars a year.

This is a small family vacation, or the start of a pension fund. If you put $2400 a year into a mutual fund for 40 years, that’s over $300,000 to help you retire. But you will never have this free money because you are spending it on a silly habit.

5. Lets say you started smoking when you were 18, and are now 28.

For the past 10 years you’ve spent about $20,000, I will lessen the number because I know cigarettes prices have increased the past few years. WOW what would you do with 20 grand right now? That’s like winning the grand prize of a scratch lotto ticket!

Putting cigarettes into a financial perspective is a power tool in learning how to quit smoking. There is all of the heath risks and societal pressures to also stop, but those do nothing for people. Peoples mind run on money, and once they realize how much unneeded spending they are doing, they will soon quit that habit.

Ways to Make Money Online from Home

Working from home is the dream of many; avoiding the daily commute, dealing with a boss and coworkers is enough to push people to look for new opportunities online. The web lets you bridge your skills in business to the entire world; the following will give you a few ideas on how and where to get started making money online from home.

Idea 1: Create an online store

Have a product, craft or service you could offer in exchange for cold-hard money? Starting your own online shop is quite easy to enter with so many various tools already available on the web for free or for pay. You could go the extra mile by starting your own online store from products you buy from manufacturers. Don’t forget, your skills may always be in demand so offering them for a charge can get you started with this home-based business career.

Idea 2: Sell freelance services

Either you could seek out clients on your own or let them come to you; freelancing online can be accomplished by any person with an existing skill or by those that take the time to learn what’s required from others that demand these types of services. You can begin earning your keep by starting your own website with your services or bring those skills to freelance marketplaces like oDesk, Guru or the various job boards scattered across the net.

Another freelance service people might be looking for is cryptocurrency research. This will result in a lot of money to be made as the crypto markets expand. We recently saw an ad for someone to research the Bitcoin Diamond Trezor Wallet and it was paying quite well.

Idea 3: Offer advice, consulting or mentoring

Have you been in a field of work or know something intimately that others have asked for your experience? It’s surprisingly enough but people are more than willing to pay for your knowledge about a subject from consulting to mentoring. Life coaching, business advice, hobby direction and many others can find you in the perfect position to make money online from the comfort of your own home. You could even take these consulting and mentoring jobs a step further by translating your knowledge to text, audio or video and sell these talks as an online product!

Idea 4: Work for virtual businesses

Businesses around the world are seeking out international help to handle additional services they may not be able to find in their local work force. Working online will require additional tools besides a computer like virtual meeting software but for the small cost of entry, you can find many different ways to make money from home online. Virtual assistant, researcher, writer, receptionist and many other opportunities are yours from the leisure of your own home.

How to Play: Texas Holdem for Beginners

Texas Holdem is by far the best accepted for of poker played today due to is popularity there are alike several TV shows of the game.

Besides actuality accepted texas Holdem is additionally the best bold for a abecedarian to learn, the bold can be abstruse afterwards a few account and afte aloof a few hours of convenance you can be arena adequately able-bodied adjoin added beginners, but to absolutely get acceptable you charge comedy often.

Texas Holdem is played the aforementioned way in the casino, online poker and in your home with your pals.

Texas Holdem is played in the afterward manner

1. Action structures can vary. In Texas Holdem rarely are antes used. Best Texas Holdem amateur alpha with aboriginal two players on the dealers larboard agreement agreed bets. These players are alleged the baby and ample blind, and their bets are alleged announcement the blinds.

2. Anniversary amateur receives 2 cards face down. These cards are alleged you abridged cards and they are the alone cards that are different to you.

3. Afterwards anniversary amateur is dealt their aperture cards a annular of action takes abode starting with the amateur to the larboard of the 2 blinds this annular of action is alleged the pre-flop. Aloof like in any added poker bold a amateur can alarm accession of bend during their turn.

4. Afterwards the Pre-Flop annular is over the banker will abolish the top agenda from the accouter and abandon it, this is alleged the Bake Card. This is done to accomplish abiding that no cheating is done. The banker will again about-face over 3 cards in the centermost of the table.

This annular is alleged the Flop. Any amateur may use any of these cards to accomplish the best 5 agenda duke possible, but you are not accustomed to absolutely blow the cards, anniversary amateur can use the aforementioned cards if it advice them, this is why your aperture cards are so important.

5. As with the pre-flop there is now addition annular of betting, it is at this point you will alpha to see players folding.

6. Afterwards the action is over, the banker will bake addition card, again accord the fourth of the common cards. This agenda is alleged the About-face card

7. Again addition annular of action begins and now is back you will alpha to see the admeasurement of the pot absolutely grow.

8. One aftermost time the banker burns the top agenda afore axis over the aftermost agenda of the game, alleged the River card. Players now accept all 5 of the common cards and their own aperture agenda to accomplish the best 5 agenda hand.

9. One aftermost adventitious is accustomed to accession the bets or get out of the game. Afterwards this anniversary amateur still in the bold will appearance their cards. This is alleged the Showdown. The amateur with the best duke is declared the champ and wins the pot.

Now that you apperceive the basal adjustment of the bold you are accessible to alpha arena Texas Holdem. Holdem is a simple bold to apprentice but if adamantine to master. This is the allotment that will booty you abounding duke and abounding dollars, but if you put in the time you will be adored for it.

Foods for Prostate Health

If you are a man over 50 years old, you’ve probably been advised time and again to get regular check ups for prostate health by your loved ones and your doctors. Take the advice: a healthy prostate can mean the difference between life and death. The earlier you spot the signs of prostate cancer, the easier it will be for you to treat and survive it. Your health is not something to play with, especially when it comes to prostate cancer, one of the leading causes of death among older men.

But the best way to treat a deadly disease such as prostate cancer is to avoid it all together. One way to prevent prostate cancer and all kinds of illnesses is through nutrition. Nutrition, as many people are aware, plays a vital role in how the body functions. The quantity and quality of the foods we eat today impact the lives we lead tomorrow. So to ensure optimal prostate health for tomorrow, we should eat foods that promote optimal prostate health today; nutrition against prostate cancer is the best way to ensure good prostate health.

To maintain a healthy prostate, prevent cancer or treat prostate cancer, try to eat more cruciferous vegetables and foods that contain lycopene, polyphenols and isoflavones. Also, your nutrition against prostate cancer should contain foods with vitamins and minerals that promote good prostate health. Vitamins A (beta-carotene), B6, C, D, E and the mineral, selenium, may help prevent and treat prostate cancer.

To stay on top of the latest health tips, we recommend that you check out HealthyMe123. They have incredible resources to combat all health issues.

Lycopene

Lycopene is a very important nutrient in your nutrition against prostate cancer. It is a naturally occurring compound found in fruits that has been proven to rid the body of free radicals. Lycopene is found mainly in tomatoes, pink grapefruit, guava and papaya. So to prevent or treat prostate cancer, you can eat more foods containing lycopene. But of all the lycopene-rich foods, the one health professionals tout as most effective against prostate cancer is the tomato. Research shows that tomato-based products and cooked tomatoes are better at fighting prostate cancer. Researchers cite that the lycopene in tomato sauces and in cooked tomatoes are more potent against prostate cancer because lycopene works best when exposed to heat. Eat more tomato-based foods for good prostate health.

Polyphenols and Isoflavones

Polyphenols and isoflavones are antioxidants found in red wine, pomegranates and soy products that promote good prostate health. Polyphenols are found in foods such as pomegranate, red wine, green tea, berries, legumes, apples and cabbage among others. Polyphenols are shown to block the growth of prostate cancer cells and angiogenesis, where tumor cells form new blood vessels to speed up their own growth.

Meanwhile, isoflavones found mainly in soy products also disrupt prostate cancer cell growth and angiogenesis. Genistein, daizden and equol have shown to retard prostate cancer spread in some studies, but in others they have had no effect or negative effects on prostate cancer cell growth. So talk to your doctor before you try adding soy to your diet to promote a healthier prostate or to treat prostate cancer. The research on isoflavones though promising is also inconclusive when it comes to treating and preventing prostate cancer.

Cruciferous Vegetables

Cruciferous vegetables such as kale, broccoli, cauliflower, cabbage, bok choy and Brussels sprouts are potent arsenals in your nutrition against prostate cancer. Cruciferous vegetables contain sulforaphane, a compound that enables the body’s proteins to clean up cancer-causing carcinogens in the body. Research shows that eating five servings of cruciferous vegetables per week decreases prostate cancer risk by 10 to 20 percent. Eating cruciferous vegetables regularly is a good way to prevent prostate cancer, research suggests. That’s because sulforaphane helps to expel carcinogens before they can progress into prostate cancer.

Vitamins and Minerals against Prostate Cancer

Vitamins A, C and E are known antioxidants that prevent free radicals from forming in the body. Free radicals are cancer-causing elements that steal oxygen from the cells in the body. When free radicals steal oxygen from the cells in the body, those cells themselves become unstable and cancerous; they are in need of oxygen. Well, antioxidants provide that extra oxygen to free radicals, stabilizing them and preventing them from stealing oxygen from our cells.

Vitamin B6 and vitamin D play a role in cell growth and cell death. Therefore, they work with antioxidants to balance the oxidative processes in the body, preventing prostate cancer. Foods rich in vitamin A are: apricots, lettuce, spinach, chicken livers; vitamin B6: fortified cereals, chickpeas, nuts; vitamin C: citrus fruits and juices, red peppers, grape juice; vitamin D: fortified milk, yogurt; vitamin E: fortified cereals, tomato-based products, nuts and spinach.

The mineral selenium that is found in plant foods, meats and seafood has been shown to reduce the risk of developing prostate cancer. Selenium is found in nuts, fish, whole-grain wheat flour and garlic. Also, as seafood is good to eat in the nutrition against prostate cancer, eating foods that contain omega-3 fatty acids can also reduce the risk of developing prostate cancer or can effectively treat prostate cancer.

No one can discount the effectiveness of chemotherapy and traditional medicine in treating prostate cancer. But if those who have prostate cancer or who are at increased risk of developing prostate cancer don’t modify their nutrition, they are doing themselves a disservice. Nutrition plays a very important role in whether we are able to fight any illness. And by eating foods rich in antioxidants, through nutrition we should be able to treat prostate cancer more effectively.

How to Setup a VPN on Mac OS X

Ok, so here is the scenario. You are trying to upload torrents and it cuts off peers A LOT. You then did research to see if your ISP does network shaping (Qos shaping) and find out they do. You then are stuck in a bad situation! But don’t worry, read below:
Here is a solution: use a VPN.

Getting a VPN

You will want to sign up for a free VPN obviously. There are many different solutions, you can use google to search for more. Right now, I am using one that has a 30-day free trial called Switch VPN. Click here to get free VPN Trial.

It will ask you to sign up, do so. It will also ask if you are part of the EU, maybe, maybe not, just say yes… 😉 Once you are signed up, and you have activated your account after receiving the email, we can start setting up the preferences on your mac.

Step one

Go to your system prefrences. Click network, and click the plus on the bottom left to add a new connection.

Step two

In Interface, click VPN. In Type, use PPTP. Click create.

Step three

Now for some more settings. For server address, type “pptp.switchvpn.com” (without quotes).

For account name, type the account name you signed up with in the Switch VPN site. In the picture, it shows my name, because I signed up with that… Don’t use the name here 😛

Step Four

Now, click Authentication Settings. This will bring you up to a password box. Make sure the Password is checked, and type in the password you used to sign up with. Click ok when done.

Step Five

You are now set up with VPN on the settings side. You need to have port 1723 open to your computer for it to function correctly!

And there you go, no more traffic shaping, and faster upload speed using your new VPN!!