Top 10+ Free Excel Games To Download

Here you can download some of best games that can be played in Excel. Just download it and start playing in your excel :)

---

2D Knockout: 2D knockout is a boxing game. You have to play against the boxers of various countries. The objective of this game is to defeat your opponent.

Download it here.

---

3D Tic Tac Toe:3D Tic Tac Toe is a must try game for all the tic tac toe lovers. The objective of the game is to get 4 X’s or 0’s in a row, whosoever gets it first wins the game.

You can download this game here.

---

Adrenaline Challenge:This is a motor cycle game with predefined objectives. Complete the objectives as fast as possible and move to the next stage.

Get it here.

---

Air Fighting: This is a traditional Air Plane fighting game. The objective of this game is to destroy all the opponent air planes.

Click this link to download.

---

Angry Birds: I can bet that most of us would have played angry birds before, but this is a handy flash version of the game. This is a must try for all the angry birds lovers.

You can download this game here.

---

Angry birds Rio: This is another angry bird’s game with bigger and better graphics. I am quite sure that you will fell in love with this one.

Download it here.

---

Apple Shooter: Apple shooter is a very nice game designed by Wolf games. Here your objective is to shoot the apple without killing the man beneath it.

Get it here.

---

Ball Challenge: This game has a set of blue and red balls bouncing inside a box. You need to keep the blue balls inside one compartment and the red ones inside another compartment.

Click this link to download.

---

Bang Bang -2: Bang Bang-2 is a first person shooting game. Your objective is to kill as many people in the stipulated time.

Excel game here.

---

Baseball Pinch Hitter -2: This game has awesome graphics and great gameplay. The game has certain levels and you have to meet some targets to clear those level.

You can download this game here.

---

Batman: Play the heroic Batman game to save the Gotham city from bad people. Defeat the bad people and move to the next levels.

Download it here.

---

Bloxorz: The aim of this game is to roll the block such that it falls in the square hole inside the board. The game has 33 stages and different challenges that you will love to tackle.

Get it here.

---

BMX-Tricks: Ride your cycle and perform different stunts on the track to earn extra points in stipulated time. You can ride over grills, on tables etc. to earn extra points.

Click this link to download.

---

BowMan: This is a third person shooting game where you have to kill your opponent using arrows. You can shoot the arrow at different angles and power to hit the opponent.

You can download this game here.

---

Bowling: This is a cool game with 3D graphics. Aim the bowl using the mouse to hit the pins. A must try game for bowling lovers.

Download it here.

---

Chaser: This is a nice time pass game. The game is very similar to the traditional snake’s game with the only difference that you and computer are playing on the same board.

Get it here.

---

Chopper Challenge: Fly the chopper as far as possible and avoid the obstacles in the path. Make a high score and challenge your friends.

Click this link to download.

---

Crab Ball: This a little funny volleyball like game between two crabs. Simply download the game and enjoy playing it.

Excel game here.

---

Defend Your Castle: Defend Your Castle was one of the most rated games of 2012. Here your goal is to protect your castle from the opponent team.

Download the game here.

---

Down Hill Stunts: This is a motor bike game, your aim is to ride your bike on the track and collect the stars on the way and that too without crashing.

Download it here.

---

Drunk Driving: In this game your task is to handle an uncontrollable car. Avoid the obstacles like other cars and buses to clear stages.

You can download this game here.

---

Easy Chess: This a flash version of the chess game. A must try game for a die-hard chess lover.

Download it here.

---

Famous Eyes: This game consists of images of eyes of some of the famous personalities, identify them and earn points.

Get it here.

---

Fishy: Fishy is small time pass game, where you have to feed your fish on the other small fishes and also save your fish from the other fishes that are bigger than it.

Click this link to download.

---

Frog leap: This is a little puzzle game. The game challenges you to interchange the positions of 6 frogs. Clear the level and challenge your friends.

Excel game here.

---

Golf: The main objective of this game is to put the ball inside the hole in minimum number of strokes. The game also offers a multiplayer mode.

Download the game here.

Top 10 Quick Time-Saving Excel Shortcuts for All

Ok guys, so today I am listing top 10 quick time saving excel shortcuts that will improve your excel skills and save you lots of time.

Excel Tip No. 1: Automatically SUM() with ALT + =

Click ALT+= in first empty cell of column and get the result.

Excel Tip No. 2: Logic for Number Formatting Keyboard Shortcuts

At times keyboard shortcuts seem random, but there is logic behind them. Let's break an example down. To format a number as a currency the shortcut is CRTL + SHIFT + 4.

Both the SHIFT and 4 keys seem random, but they're intentionally used because SHIFT + 4 is the dollar sign ($). Therefore if we want to format as a currency, it's simply: CTRL + ‘$' (where the dollar sign is SHIFT + 4). The same is true for formatting a number as a percent.

Excel Tip No. 3: Display Formulas with CTRL + `

When you're troubleshooting misbehaving numbers first look at the formulas. Display the formula used in a cell by hitting just two keys: Ctrl + ` (known as the acute accent key) – this key is furthest to the left on the row with the number keys. When shifted it is the tilde (~).

Excel Tip No. 4: Jump to the Start or End of a Column Keyboard Shortcut

You are thousands of rows deep into your data set and need to get to the first or last cell. Scrolling is OK but the quickest way is to use the keyboard shortcut CTRL + ↑ to jump to the top cell, or CTRL + ↓ to drop to the last cell before an empty cell.

When you combine this shortcut with the SHIFT key, you'll select a continuous block of cells from your original starting point.

Excel Tip No. 5: Repeat a Formula to Multiple Cells

Never type out the same formula over and over in new cells again. This trick populates all of the cells in a column with the same formula, but adjusts to use the data specific to each row.

Create the formula you need in the first cell. Then move your cursor to the lower right corner of that cell and, when it turns into a plus sign, double click to copy that formula into the rest of the cells in that column. Each cell in the column will show the results of the formula using the data in that row.

Excel Tip No. 6: Add or Delete Columns Keyboard Shortcut

Managing columns and rows in your spreadsheet is an all-day task. Whether adding or deleting, you can save a little time when you use this keyboard shortcut. CTRL + ‘-‘ (minus key) will delete the column your cursor is in and CTRL + SHIFT + ‘=' (equal key) will add a new column. From an earlier tip, think about CTRL + ‘+' (plus sign).

Excel Tip No. 7: Adjust Width of One or Multiple Columns

It's easy to adjust a column to the width of its content and get rid of those useless ##### entries. Click on the column's header, move your cursor to the right side of the header and double click when it turns into a plus sign.

Excel Tip No. 8: Copy a Pattern of Numbers or Even Dates

Another amazing feature built into Excel is its ability to recognize a pattern in your data, and allow you to automatically copy it to other cells. Simply enter information in two rows which establish the pattern, highlight those rows and drag down for as many cells as you want to populate. This works with numbers, days of the week or months!

Excel Tip No. 9: Tab Between Worksheets

Jumping from worksheet to worksheet doesn't mean you have to move your hand off the keyboard with this cool shortcut. To change to the next worksheet to the right enter CTRL + PGDN. And conversely change to the worksheet to the left by entering CTRL + PGUP.

Excel Tip No. 10: Double Click Format Painter

Format Painter is a great tool which lets you duplicate a format in other cells with no more effort than a mouse click. Many Excel users (Outlook, Word and PowerPoint too) use this handy feature, but did you know you can double-click Format Painter to copy the format into multiple cells? It's quite a time-saver.

   

Excel formulas cheat sheet: 15 tips for calculations and common tasks

Many of us fell in love with Excel as we delved into its deep and sophisticated formula features. Because there are multiple ways to get results, you can decide which method works best for you. For example, there are several ways to enter formulas and calculate numbers in Excel.

Five ways to enter formulas

1. Manually enter Excel formulas:

Long Lists: =SUM(B4:B13)

Short Lists: =SUM(B4,B5,B6,B7); =SUM(B4+B5+B6+B7). Or, place your cursor in the first empty cell at the bottom of your list (or any cell, really) and press the plus sign, then click B4; press the plus sign again and click B5; and so on to the end; then press Enter. Excel adds/totals this list you just “pointed to:” =+B4+B5+B6+B7.

2. Click the Insert Function button

Use the Insert Function button under the Formulas tab to select a function from Excel’s menu list:

=COUNT(B4:B13) Counts the numbers in a range (ignores blank/empty cells).

=COUNTA(B3:B13) Counts all characters in a range (also ignores blank/empty cells).

3. Select a function from a group (Formulas tab)

Narrow your search a bit and choose a formula subset for Financial, Logical, or Date/Time, for example.

=TODAY() Inserts today’s date.

4. The Recently Used button

Click the Recently Used button to show functions you've used recently. It's a welcome timesaver, especially when wrestling with an extra-hairy spreadsheet.

=AVERAGE(B4:B13) adds the list, divides by the number of values, then provides the average.

5. Auto functions under the AutoSum button

Auto functions are my editor's personal favorite, because they're so fast. Select a cell range and a function, and your result appears with no muss or fuss. Here are a few examples:

=MAX(B4:B13) returns the highest value in the list.

=MIN(B4:B13) returns the lowest value in the list.

JD SARTAIN

Use the AutoSum button to calculate basic formulas such as SUM, AVERAGE, COUNT, etc.

Note: If your cursor is positioned in the empty cell just below your range of numbers, Excel determines that this is the range you want to calculate and automatically highlights the range, or enters the range cell addresses in the corresponding dialog boxes.

Bonus tip: With basic formulas, the AutoSum button is the top choice. It’s faster to click AutoSum>SUM (notice that Excel highlights the range for you) and press Enter.

Another bonus tip: The quickest way to add/total a list of numbers is to position your cursor at the bottom of the list and press Alt+ = (press the Alt key and hold, press the equal sign, release both keys), then press Enter. Excel highlights the range and totals the column.

Five handy formulas for common tasks

The five formulas below may have somewhat inscrutable names, but their functions save time and data entry on a daily basis.

Note: Some formulas require you to input the single cell or range address of the values or text you want calculated. When Excel displays the various cell/range dialog boxes, you can either manually enter the cell/range address, or cursor and point to it. Pointing means you click the field box first, then click the corresponding cell over in the worksheet. Repeat this process for formulas that calculate a range of cells (e.g., beginning date, ending date, etc.)

1. =DAYS

This is a handy formula to calculate the number of days between two dates (so there’s no worries about how many days are in each month of the range).

Example: End Date October 12, 2015 minus Start Date March 31, 2015 = 195 days

Formula: =DAYS(A30,A29)

2. =NETWORKDAYS

This similar formula calculates the number of workdays (i.e., a five-day workweek) within a specified timeframe. It also includes an option to subtract the holidays from the total, but this must be entered as a range of dates.

Example: Start Date March 31, 2015 minus End Date October 12, 2015 = 140 days

Formula: =NETWORKDAYS(A33,A34)

3. =TRIM

TRIM is a lifesaver if you’re always importing or pasting text into Excel (such as from a database, website, word processing software, or other text-based program). So often, the imported text is filled with extra spaces scattered throughout the list. TRIM removes the extra spaces in seconds. In this case, just enter the formula once, then copy it down to the end of the list.

Example: =TRIM plus the cell address inside parenthesis.

Formula: =TRIM(A39)

4. =CONCATENATE

This is another keeper if you import a lot of data into Excel. This formula joins (or merges) the contents of two or more fields/cells into one. For example: In databases; dates, times, phone numbers, and other multiple data records are often entered in separate fields, which is a real inconvenience. To add spaces between words or punctuation between fields, just surround this data with quotation marks.

Example: =CONCATENATE plus (month,”space”,day,”comma space”,year) where month, day, and year are cell addresses and the info inside the quotation marks is actually a space and a comma.

Formula: For dates enter: =CONCATENATE(E33,” “,F33,”, “,G33)

Formula: For phone numbers enter: =CONCATENATE(E37,”-“,F37,”-“,G37)

5. =DATEVALUE

DATEVALUE converts the above formula into an Excel date, which is necessary if you plan to use this date for calculations. This one is easy: Select DATEVALUE from the formula list. Click the Date_Text field in the dialog box, click the corresponding cell on the spreadsheet, then click OK, and copy down. The results are Excel serial numbers, so you must choose Format>Format Cells>Number>Date, and then select a format from the list.

Formula: =DATEVALUE(H33)

Three more formula tips

As you work with formulas more, keep these bonus tips in mind to avoid confusion:

Tip 1: You don’t need another formula to convert formulas to text or numbers. Just copy the range of formulas and then paste as Special>Values. Why bother to convert the formulas to values? Because you can’t move or manipulate the data until it’s converted. Those cells may look like phone numbers, but they’re actually formulas, which cannot be edited as numbers or text.

Tip 2: If you use Copy and Paste>Special>Values for dates, the result will be text and cannot be converted to a real date. Dates require the DATEVALUE formula to function as actual dates.

Tip 3: Formulas are always displayed in uppercase; however, if you type them in lowercase, Excel converts them to uppercase. Also notice there are no spaces in formulas. If your formula fails, check for spaces and remove them.

Source - PC World

Update Facebook Profile Picture Without Notifying Other Friends

Whenever you update your profile picture on facebook, every friend of yours get notified. Some times you update some general stuffs like your home town and educational update which may be some time irritating for your friends. Today I'll share a tip with you with which you can update your facebook photos and other updates without notifying others.


How to Update Facebook Profile Picture Without Notifying Others : 

 You can stop two things that is the notification that your friends see on their timeline whenever you change your profile picture and hiding your profile picture that is preventing public or friends from enlarging the profile picture.

First update your profile picture as you normally do that is go to your profile page and then add a profile photo or update profile picture. After choosing your photo and cropping it, you will see an option like stop notifications at your right side which has nothing to do with. This stop notification option will only stop you from getting notifications that is when someone likes or comments on your profile picture, but not your friends.

So to stop notifying your friends about the profile picture update, go to your timeline immediately after changing your profile picture or view your activity log. You will then see your own picture saying you have changed your profile picture. Just drop down the post at the top right corner and then select hide from timeline which then hides the profile picture from your timeline and your friend’s timeline.  You can go on with this method whenever you think of updating profile picture without notifying or annoying your friends. Anyhow they can still see that your new profile picture changed and they can like it, share it or comment on it. How to prevent those activities? You can do that by making your profile picture private.

Preventing public or friends from enlarging your profile picture that is making your profile picture unclickable or making your profile picture private is simple.  Just view your profile picture, drop down the public option at the top corner and then select it to “only me” or you can choose custom settings. That’s it now your friends or public can’t enlarge your photo, can’t like your photo and can’t share your photo.

In a same way you can hide your cover photo notifications from your friend’s timeline, but not the cover photo.

[Download] Complete List Of Excel KeyBoard Shortcuts

This article assumes you are using Excel on a Windows PC. If you are using a Mac, these shortcuts will change slightly.

All the Keyboard Shortcuts has been complied in a pdf file you can download it from below given link

 Click below button to Download

   

If Above button is not working then copy paste this url in your browser - http://www.4shared.com/web/preview/pdf/e3E9M7tNba?

How to Find and Fix Errors in Complex Formulas in Excel

Here, I'll show you a quick, simple, and effective way to fix formulas and functions in Excel. It can be hard to find out how to fix a formula or function in Excel that is broken or not returning the result that you expect.

Thankfully, there is a really great tool that will help you troubleshoot the formula and pin-point the problem.  It is called Evaluate Formula and it will save you hours!

Below, I will give you a sample problem and show you, step-by-step, how to find and fix the error.

Here, we have what should be a Vlookup formula that is not returning what we expect.  Let's take a look at the formula now:

This is one formula that contains three functions, the IF function, the IFERROR function, and the VLOOKUP function.  Looking at this, though it may seem a bit complex, everything appears to be input exactly how it should be.  All functions look OK and the IF statement check at the front, that requires cell A6 to equal yes, looks good to me, but the formula is not working.

Let's use the Evaluate Formula feature so that we dont waste any time troubleshooting this formula.

Select the cell that contains the formula or function that is not working and then go to the Formulas Tab and click the Evaluate Formula button, which is located in theFormula Auditing section of the menu.

The entire formula contents of the cell appear in the window.  The Evaluate Formula feature will walk you through the execution of the entire formula and show you exactly what it sees.

Notice how A6 contains an underline beneath it?  This is what is evaluated first within this formula.  Click the Evaluate button at the bottom of the window to see how Excel evaluates this, in this case, what it will return for the cell reference A6.

The value of cell A6 has been returned into this formula and we can see how Excel is now comparing that value to the value yes to see if they are equal.  Hit Evaluate again.

FALSE.  We can see that the IF statement in the cell is preventing anything else from happening with this function because the condition in the IF statement has evaluated to FALSE.  Hit the Evaluate button once more and you will see the final result, which is a blank.

Now, hit the Restart button that appeared where the Evaluate button used to be and you can start over in order to more closely analyze everything.

This, time, if you would like, you can hit the Step In button, which allows you, when possible, to enter a cell that is being referenced by the current formula.  This feature is great for really complex formulas that are dependent upon many cells in Excel.

If you do that in this case, everything still looks OK for cell A6.  So, hit Step Out and let's get back to the main formula.  Now, the next step has already been evaluated for us so we can see what cell A6 returns to the formula.  Now, take a close look!

CRAP!!!!  There is a dirty stinking space after the yes in cell A6!!!!

Let's correct that by closing the Evaluate Formula window and going to cell A6 to remove the space from the end of "yes" and try our vlookup formula again to see what happens.

It finally works!

Now, we could have probably figured that out on our own after a while, but the Evaluate Formula feature showed very clearly, albeit, you must have been paying attention, that there was an extra space after the value coming from cell A6.  

Believe it or not, extra spaces, which are by nature very difficult to find, cause many many many MANY hours of troubleshooting for people.

In another tutorial, I will show you a simple way to avoid some of the headaches associated with spaces.

I hope you enjoyed the tutorial! :)

Merging Two Excel Files using VLOOKUP Function

Merging of two Excel files using VLOOKUP function comes very handy if we're manually matching two Excel files, it is very time consuming if the size of data is large. Here this merging function will help us.

Here below is an Tutorial video From Danny Rocks that will help you in accomplish this task!