5 Mobile Android Games Worth Checking Out

5 Mobile Android Games Worth Checking Out

smart phone online gaming

Android owners with even a passing interest in video games have a lot to be excited about. Smart devices are more capable than ever when it comes to handling the necessary technical aspects of gaming, which has led to some seriously impressive results.

However, beyond gorgeous graphics, what it all really boils down to is whether or not the game is actually any fun to play. Not only that, but is it easy to boot up and enjoy whenever you get the urge/some free time? Or is it something that bogs down your device and only incites frustration? Well, with the help of this post, you’ll be sure to avoid any aggravation and simply enjoy your experience, because we can all use more time for relaxation. Here are five mobile games worth checking out on your Android device—and they’re all free.

Bad Piggies

If you have played/heard of the wildly popular Angry Birds, chances are you’ll be familiar with the main characters of Rovio’s Bad Piggies. While the pigs are once again after the birds’ eggs, this time they’re on the attack. Basically, you must use your knowledge of physics and problem-solving capabilities to build machines and steer the pigs to their final destination. It’s a little tricky but ultimately a ton of fun once you get used to it.

Disco Zoo

Disco Zoo, created by the team at NimbleBit, takes gamers back to the days of playing Battleship with your friends and family. However, it ditches the naval warfare approach and opts for something sillier, though equally challenging. Like you did in Battleship, you’re trying to discover the hidden pieces (or animals, in this case) and eventually throw a disco party. Yes, it’s absurd, but it’s a lot of fun, too.

Betfair Bingo

Continuing the throwback feel created by Disco Zoo, Betfair bingo embodies the anyone-can-play dynamic of a game that can be traced back to the 16th century. On the Betfair gaming platform, though, everything is modern and stylish. Also, newcomers are offered sign-up bonuses, there’s a chance to play for charity, and you can even win some serious cash. This isn’t your grandma’s bingo, though she, too, could learn to play it pretty quickly.

Pocket League Story 2

Football fans, rejoice, because the cartoon-y Pocket League Story 2 is one of the best sim-based sports games available right now. Developed by Japan’s Kairosoft, the title centers on all the aspects of the sport outside of actually playing it. The goal is to grow your team from local heroes to international superstars, all through obtaining the best players, building your own facilities, and nurturing your squad.

Nightbird Trigger X

And now for what’s easily the prettiest game on here, Nightbird Trigger X offers fast-paced, pick-up-and-play action for gamers wanting a little more excitement. There’s a lot going on in this title from COLOPL, but it’s an addictive and ever-expanding (through updates) experience worth playing. If you can’t get enough of it, you can always go back and play the previous entries in the Nightbird Trigger series.

So there you have it, five games for your Android that are free to play and sure to eat up any and all of your free time. Did we miss a game that you think should make the list? Make a case for it in the comments section!

4 Biggest Competitors of the New iPhone 6

iphone 6 vs anroid

The iPhone 6 and iPhone 6 Plus were just released and for those who aren’t jumping ship to buy the newest item in Apple’s long lineup, there’s great news. Several Android phones are going neck-to-neck to deliver features that (quite possibly) blow the iPhone 6 right out of the water.

At first glance, the iPhone 6 and 6 Plus look amazing and sleek externally—but you have to really examine what lays under the hood. The iPhone 6, features a 4.7” screen that is slightly smaller than ones found on most smartphones. The much larger 5.5” on the iPhone 6 Plus, push it into “phablet” territory— although the phone is much narrower (and longer) than most others. The iPhone 6 and 6 plus models are fairly light; weighing 4.55 ounces and 6.07, respectively.

The regular iPhone 6 features a LED backlit IPS and retina display with a 1334×750 resolution; the iPhone 6 Plus comes with a better 1920×1080 resolution.

Both feature only an 8 MP camera and 1.2 MP front-facing one, which are surprisingly much lower than expected. The video option looks more promising—as it will record in continuous autofocus in 1080p HD. Like other Apple produces, both the iPhone 6 and 6 Plus come only in fixed 16, 64 and 128 G storage options; why there isn’t a 32 G, is a mystery. Neither phone includes a removable storage option (via a microSD card slot) — so whatever storage option you buy is exactly what you’ll get.

So if you want something other than one of the new iPhone 6 models, these 4 top Android models deliver the most bang for the buck and will undoubtedly give Apple a run for its money.

1.    Samsung Galaxy S5

galaxy s5

 

 

 

 

 

 

 

The Samsung Galaxy S5 features a 5.1” Full HD Touch Screen Display, which is slightly larger than the iPhone 6’s 4.7” screen. Its screen comes in a super AMOLED screen display with 1920x 1080 pixels (the same as the iPhone 6 Plus). There is hardly anything comparable with the S5’s brilliant 16 MP camera. It also has a 2 MP front-facing camera.

Though it comes with 16 GB of storage, the S5 can be expanded via a microSD card (unlike either iPhone 6 model). In terms of operating systems, the S5 runs off of Android 4.4 Kitkat® (where the iPhone runs off of iOS 8). The S5 is a heftier, but more solid phone in the Galaxy’s lineup (5.59 oz)—heavier than the standard iPhone 6, yet much lighter than the iPhone 6 Plus.

2.    LG G3

lg g3

 

 

 

 

 

 

 

 

 

The LG G3 features a large 5.5-inch Quad HD IPS display (the same size as the iPhone 6 Plus screen). At, 5.28 oz. the LG G3 is remarkably nearly a gram lighter than the iPhone 6 Plus! Its 13 MP camera blows the iPhone 6’s 8 MP camera out of the water. Like the Galaxy S5, the LG G3 has an Android 4.4 Kitkat operating system.

3.    Samsung Galaxy Note 4

The Samsung Galaxy Note 4 will be released on Oct. 17th. This phablet holds a lot of promise and will go neck-to-neck with the iPhone 6 Plus. With a 5.7” HD screen, it’ll be bigger than the Plus’s 5.5”. At 6.21 oz., it’ll also weigh more. Unlike the iPhone 6 Plus’s fixed storage, the Note 4 will come with 32 and 64 GB memory options, as well as expandable storage space.

Unlike many other devices on the market, the Note 4 will come with a 16 MP camera and impressive 3.7 MG front-facing camera. The Note 4 will also feature a metal frame, unlike many in Samsung’s Galaxy lineup.  It’ll run off of Android 4.4 KitKat, have an AMOLED display and have a screen resolution of 2560 x 1440.

4.    HTC One M8

htc one

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

The HTC One M8 features a 5” full HD screen and weights 5.64 oz. — lighter than a nice middle ground between the two iPhone 6 models. Unique to the M8 is a Duo Camera with “UltraPixel” and a Smart Flash. They allow users can add unique 3D features to photos after they are taken. There’s also a feature called, “Zoe Highlights” that create 30-second photo montages with different themes.

If you haven’t yet run out to get the new iPhone 6—or aren’t ever planning to—don’t worry. Android phones continue to push the boundaries of today’s mobile technology. These four phones will definitely out shine the iPhone—and you can avoid those long lines and backorders.

Andrea Fisher is a digital marketer and content specialist for digitaltvbundles.com. She has been published in a variety of publications, including the Chicago Tribune and Business Insider.

Excel Auto Filter and Freeze Panes, Work Smart!

Introduction to Excel

Sorting Data, AutoFilter and Freeze panes

 

Download Sorting Data pdf :Autofilter and freeze panes

You can use sorting to organise your spreadsheet data in ascending or descending order.  You are allowed upto three levels of sort for example, if you sort by Surname in ascending order and then First name in ascending order, when Excel comes across two people called “smith”, it would then put them in first name order “Colin” and then “Robert” for example.

  1. Move to a cell in the column you want to sort by.
  2. Click on the Sort Ascending button to sort A-Z, 1-100 or
  3. Click on the Sort Descending button to sort Z-A, 100-1

2014-09-13_14-25-20

 

To Sort data using up to three fields

 

  1. Move to a cell inside your data
  2. Click on the Data menu, and then click on the sort command
  3. The Sort dialogue box will be displayed.

pic2

  1. If your list has text field names, click on the header Row option under the My list has command, if Excel has not selected it automatically.
  2. Under the Sort By command, click on the drop-down arrow, and then click on the label of the column that you want to sort by first.
  3. Click on the Ascending or Descending option.
  4. Under the Then by command, click on the drop-down arrow, and then click on the label of the column that you want to sort by next.
  5. Click on the Ascending or Descending option.
  6. Repeat steps 6 and 7 until you have completed your sort options.
  7. Click on the OK button.

AUTOFILTERING DATA

The AutoFilter command gives you quick and easy access to a great deal of database management power.  It allow you to set criteria, and filters out row of data that do not match the criteria you have specified.

To find specific data using AutoFilter

 

  1. Make sure that you are within your database.
  2. Click on the data menu, click on the Filter command, and then click on the AutoFilter option.
  3. Click on the drop-down arrow next to the field name where you want to set criteria.
  4. Click on the set of criteria you want to view.

2014-09-13_14-33-33

 

Custom Filtering Data

 

Using the AutoFilter is a very quick and easy way to find an exact match to criteria that you specify.  Sometimes though you will need to find a range of answers rather than exact match, amounts between £3000 and £6000 for example, or names beginning with the letter B, for this you can use custom filtering.

 

To create a Custom AutoFilter

 

  1. Make sure that the AutoFilter command is switched on.
  2. Click on the drop-down arrow next to the field name where you want to set a custom filter.
  3. Click on the (Custom …) command.
  4. The Custom AutoFilter dialogue box will be displayed.

pic4

 

  1. Under the Show rows where option, click on the box that contains the word equals.
  2. Type in the box to the right what you want to find, or click on the drop down arrow and choose from the list.
  3. Click on the And option if you want to set more than one criteria.
  4. When you have finished setting your criteria, click on the OK button.

 

 

Freezing Panes

Freezing panes is extremely useful when you have column or row headings which you want to keep in view when you scroll the screen to add more data.

To Freeze Panes

  1. Select the column to the right of the columns you want to freeze, or row beneath the rows to freeze.
  2. Click on the Window menu, and then click on the Freeze Panes command.

To Unfreeze Panes

  1. Click on the Window menu, and then click on the Unfreeze Panes command.

Download Sorting Data pdf :Autofilter and freeze panes

Other Lessons

 

 

 

Introduction to Charts in MS Excel

Introduction to Charts in MS Excel

In the next part of this training series I show you how to set up charts in Microsoft Excel.

Download this lesson on excel charts as a pdf: Introduction to Charts

To Create a chart using the Chart wizard

  1. Select the data on your worksheet, that you want to create the chart from.
  2. Click on the Chart Wizard button on the toolbar.

pic1

 

When you release the mouse button Step1 of the Chart Wizard will be displayed.

pic 2

 

  1. Under the Chart type: option, click on the different chart types to view the types of  chart that you want to create.
  2. Under the Chart sub type option, click on the sub-type you would like for your chart.
  3. To see how your data would look using a certain chart type, press and hold to view sample button.
  4. When you have found the type of chart you would like to create, click on the next button.
  5. Next to the data range option, check that the range you selected on your worksheet is correct, if the range is incorrect click on the selector button, reselect the range on your worksheet, and then click the selector button again.

pic 3

 

Click the next button.

pic 4

 

  1. Under the Chart title box, type in the title you would like for your chart, and any axis titles.
  2. Click on the Legend tab, and choose whether you would like a legend displayed, and its position.
  3. Click on the Data Labels tab, and choose whether you would like your data labelled.
  4. When you have finished choosing titles, legends, labels and any other details, click on the Next button.

pic 5

 

  1. The final part is to decide whether you would like your chart displayed as a new sheet or included on the same sheet as your data.
  2. Click on the Finish button.

 

Don’t forget you down download the introduction to charts as a PDF: Introduction to Charts

Other Lessons

 

 

Quick Start Guide to Creating Excel Formulas

Creating Formulae by Geeks Have Landed

Download this lesson as a pdf: Creating Formulae

In this lesson we discover formulas in Excel and how effective they are.

A formula in Excel always begins with = .

Operation

Symbol

Formula in D4

Result in D4

Addition

+

=B4+C4

30

Subtraction

=B4-C4

10

Multiplication

*

=B4*C4

200

Division

/

=B4/C4

2

If the Formula Bar is not displayed, click on View on the title bar and then click on Formula Bar from the drop-down menu.  The Formula Bar should now be displayed.

When you write formulas in Excel, you can use the Formula Bar and Formula Palette with the mouse to write the formula.  The advantage of using the mouse over the keyboard is that you do not need to remember the references of the cells to be used in the formula, you can just click on them instead.

pic 1

 

  1. Move to the cell where you want to enter the formula.
  2. Click on the Edit Formula button on the Formula Bar =
  3. Click on the first cell to be used in the formula.
  4. Type in the arithmetic operator e.g. +,*,/,-
  5. Click on the next cell to be used in the formula.

Click on the OK button on the Formula Palette to enter the formula

 

Basic Statistical Functions

 

The following are examples of some basic statistical functions

 

MAX Returns the highest value of its arguments
MIN Returns the lowest value of its arguments
AVERAGE Returns the average value of its arguments
COUNT Returns how many numbers are found in the list of arguments

 

To enter a Function

 

  1. Move to the cell where you want to enter the function e.g. C14 (as below)
  2. Click on the Edit Formula button on the Formula Bar.
  3. Click on the drop-down arrow to the right of the Function List button on the Formula Palette.

pic 2

 

4       Click on the name of the function that you would like to use.  Or if the function is not displayed , click on the More Functions option.

5       The Formula Palette will extend.

6       Enter the argument for the function, clicking on the selector button to gain access to the cells on the worksheet if required.  If you use the selector button to select cells on the worksheet, click on the selector button again to re-extend the Formula Palette.

pic 3

 

When you have finished entering the arguments for the function, click the OK button.

pic 4

 

Enter the details as in the table above, leaving cells C14:C18 blank to enter the formula as below using the mouse and the formula palette.

pic 5

 

Don’t forget you can download this tutorial as a pdf: Creating Formulae

Other Lessons

Speed Up Ms Excel With Auto Options

Speed Up Microsoft Excel With Auto Options

Excel has several Auto options that can speed up basic data entry.

Download the lesson as a pdf : Data Entry Auto options

  • AutoFill
  • Auto Complete
  • Auto Correct

Open a new sheet in Excel, if when you open a new sheet 3 sheets open as below

pic1

 If you only want Excel to open one sheet at a time.

  • Click on Tools from the Title Bar.
  • Click on Options from the drop down menu
  • Click on the General tab and change the amount in Sheets in new workbook to 1.

 

AutoFill

AutoFill can speed up entering data that forms part of a list such as months of the year or days of the week.  The method we will use is called a Filling Series and is accomplished using the Fill Handle found on the bottom right corner cell of the selected range.

Type a month into cell B2, you can use the full name or the first three letters. e.g Jan or January

pic 2pic 3

Select the cell containing the starting data.  Move the mouse pointer to the bottom right hand corner of the cell to display the fill handle. Hold the left mouse button down and drag down the column.  As you drag notice that Excel will show you what part of the series you have reached.  Release the mouse and the series fills.

The AutoFill can be used with other data series.

pic 4 pic 5

Enter Monday in cell  B2 drag the fill handle to fill the series.

AutoFill can also be used with other data series e.g. Week 1 or Project

pic 6pic 7

Auto Correct

This will correct common spelling and typing errors.

For example

accomodate will be corrected to accommodate

Teh will be corrected to The

BUdget will be corrected to Budget

monday will be corrected to Monday

(N.B This does not work for month names!)

For a list of auto corrections select Tools – AutoCorrect

pic 9

 

Auto Complete

If the first few characters you type in a cell match an existing entry in that column, Excel fills in the remaining characters for you.  Excel completes only those entries that contain text or a combination of text and numbers, dates, or times are not completed.

Enter the following names going down one column

pic 11

Now enter “P” : Excel will assume you want to enter Paul

pic 12

To change Paul to Peter, simply over-type the highlighted text.

You can turn off AutoComplete using Tool: Options and deselect AutoComplete within the Edit tab.

You can also select a list of entries already in the column.  To display the list press Alt + Arrow down and then pick from the list.

Have a go yourself

Create the following worksheet using AutoFill to speed up your entries. You should only need your keyboard a few times.

pic 13

TIPS

To enter the today’s date into a cell, select the cell you want to place the date on the keyboard press and hold Ctrl : (Control key + colon)

 To enter the current time press and hold Ctrl Shift : (Control + Shift + colon)

Don’t forget you can print off the training above here download pdf: Data Entry Auto options

Other Lessons

 

 

Apple announces iPhone 6 launch date

Apple announces iPhone 6 launch date amongst other product launches.

apple logo

It’s the most hotly anticipated technology of release of the year and now Apple have confirmed what we’ve all been waiting for: the launch party date for the iPhone 6.

“9.9.2014. Wish we could say more,” says a teasing a press release for the official launch party, which will take place at in Cupertino, California. The exclusive event at the Flint Centre for the Performing Arts will have a nostalgic theme to it, as it’s the same place in which Apple founder Steve Jobs first launched the Apple Mac some 30 years ago.

The event is expected to be the launching platform for a number of Apple products, including both a 5.5 inch and a 4.7 inch version of the iPhone 6 handset.

iwatch

 

Amongst its already varied roster of products is the highly-speculated ‘iWatch’, a hand-held device which is rumoured to monitor the health of its wearers, amongst other futuristic features. (Geeks Have Landed first wrote about the apple iwatch back in May 2013)

Apple wishes it could reveal more, but the rumour mill is already churning out a whole host of highly advanced upgrades for the new device. After releasing the iPhone 5S and 5C last summer, Apple has this time round promised a complete re-invention of the iPhone we know, rather than a few upgrades.

The newest handset will be a gamer’s paradise as it’s alleged it will feature a flexible, scratch-proof sapphire screen with a Retina display+ which will boast a 1,704×904 screen resolution. With mobile games like www.riverbellecasino.com/ca/online-blackjack taking over smartphone users’ time at an exponential rate, the newest release from Apple will only serve to prolong the shelf life of the mobile gaming industry.

Amongst other rumours surrounding the new phone are those of the highly anticipated iOS 8, which will have a huge focus on the aforementioned health monitoring. As part of the iWatch’s features, heart rate and fitness monitors will allegedly come as standard, and users will be able to track their progress with their smartphones.

All these new features are not likely to come cheap, and the market retail price is rumoured to start at around £550 / $650 / AU$869. This is hardly likely to deter technology freaks however, and with an official release date set to be one week after the launch party, Apple could soon find itself selling out of its latest products in a matter of hours.

Apple has quite a lot to live up to if the rumours turn out to be true, but with the success of its previous models considered, it shouldn’t have any problem making it to the top once again.

How to Start With Microsoft Excel

Welcome to Microsoft Excel Training

This is part of the tutorial side of the website.

In this mini-series I will cover the basics of using Microsoft Excel.

Topics I will cover are

 

Introduction to Excel

Creating a Spreadsheet

  1. Open Excel  by double clicking on the Excel icon on your desktop.
  2. A blank sheet should appear, if it doesn’t click on the white page on the left hand side to create a new sheet

intro open a spreadsheet

 

 

 

 

 

 

 

 

 

 

 

3.Enter the information on the sheet as below

into pic2

 

 

 

 

 

 

 

 

 

 

 

4. Enter the data into the boxes

intro pic 3

 

 

 

 

 

 

 

 

 

 

 

5. Highlight the figures you have just entered by placing your mouse over the cell B4 click once on the left button and holding this button down move the cursor until all the numbers have been selected.

6. From the Title bar select Format by clicking once on it – and then select Cells from the drop down menu that appears.

intro pic 4

 

 

 

 

 

 

 

 

 

 

 

7.Select Number; Currency and decide how you wish to display negative numbers.

intro pic5

 

 

 

 

 

 

 

 

 

 

 

 

8. To use the computer to total the figure automatically select the cell E4 by placing the mouse cursor over the cell and click once.  Select AutoSum from the Standard Toolbar

intro pic 6

 

 

 

 

 

 

 

 

 

 

 

9. The figures you want to calculate should be automatically highlighted.  Now press Enter on your keyboard the =SUM(B4:D4) should changed to the total £19,216.00.

10. Repeat the procedure in cell E5 and E6.  You will notice that when E6 has been highlighted  the computer does not automatically select the figures in B6,C6 and C8 to total but selects the two totals in E4 and E5.

11.To alter the selection place the mouse over cell D6 and click and hold the left button and drag the mouse to cell B6 and release.  The figure you want to total should now be selected.  Press Enter to display the total.

intro pic 7

 

 

 

 

 

 

 

 

 

 

 

12. To save your completed Spreadsheet select File from the Title Bar and then select Save from the drop down menu bar.

13. IMPORTANT – The first time you save a spreadsheet it will automatically open the Save As Dialog box.  Make sure you remember where you have saved your file.

 

 

EA Sports FIFA Ultimate Team (FUT)

FIFA Ulitimate Team Improvements

ea sports fif15

The recent trailer for EA Sports’ FIFA 15, as always, looked fantastic. Gameplay looks silky smooth and with next-generation consoles, player intelligence should be at never before seen heights.

FIFA 15 is a very big release for EA, it could be the football game to finally break the US market. The World Cup is boosting football’s profile over in the States. Their recent match against Portugal was watched by a record 25million people, and despite them not being fancied with bet365 the U.S. players have performed valiantly and are continuing to upset the odds.

The point being, with America having a heightened interest in football, they should be more inclined to buy FIFA or PES. Both need to up their game in order to dominate the lucrative American market.

Everyone’s favourite FIFA mode is FIFA Ultimate Team (FUT) which is arguably the most played online mode of any video game, but, like all things, there is room for improvement.

 fifa-15-ultimate team

Pink Slip Matches

A pink slip match is where you take on a fellow player online and staking a designated player, usually a rare player to make matches more tense. This form of betting is proving extremely popular with FUT players, hell, nearly 1 million people just go on YouTube to watch WS2 play a pink slip match. The problem with the current system is that it is all based on trust, there is no guarantee that you will get your card. You could beat a guy fair and square but there is nothing forcing them into giving you their guy. By incorporating a pink slip match option not only will EA appease the masses but they will make the game considerably better.

 

Customisation

Does it not seem odd that you can create your dream team but not your own kit or badge? On the PES’ of old people used to spend precious hours making their kit perfect, people liked the amount of customisation allotted to them back then. For the game’s programmers, it is literally a five minute job to add it to the game engine. You could have tie-ins like different sponsors depending on which league you are, which helps keep the kits fresh etc.

 

The ability to win player

If you or your mate play FUT then you will know about the dangers of being sucked in by special player packs. You end up spending about £10 worth of coins and in return all you get is Tom Cleverley. You see more people grow disillusioned in their pursuit of players than they are after a loss. So why not have tournaments where rare players are available to win? For example, you could have a Team of the Year tournament involving 108 players, the winner gets to pick whoever he wants and the last eight get a random rare player. This would also help the tournaments regain some prevalence.

 

Crack down on quitters

With next-gen consoles you feel that connections errors are a thing of the past, so hopefully EA will be able to start punishing those petulant quitters. Quitters are the bane of every gamers life and have no place online. If they quit, EA should enforce some draconian punishments, such as removing one of their players or imposing temporary bans. Just like simulation in football, this problem needs to be eradicated and the only way to do that is by being tough.

 

1 4 5 6 7 8 68