Tag Archive for colins-it

The new Blackberry BB10 smartphone review

Blackberry have been loosing their grip on the market for some time now but all their hopes and future of the business is relying on their latest BB10 smartphone which has just been announced.

Everyone is saying how amazing it is but lets look a little deeper into this.

Blackberry Jam event

launch of the new Blackberry BB10 device

The BB10 is based on a totally new platform which unfortunately has led to multiple delays that has led to the firm’s share price shrinking even lower as well as the departure of most of the senior management team.

In addition, Blackberry is announced for the first time a drop in subscribers in December. However, moving forward, several tech blogs have praised BB10′s Flow feature which allows users to swipe and slide between apps and messages.

The firm’s share price has risen to $15.66 from September’s low of $6.31

Blackberry have promised more than 70,000 apps as well as movies, TV shows and music from most of the major studios and labels when its revamped Blackberry World store opens for business.

These days it is not just baout the phone but about the platform behind it. The iphone may not be perfect but it’s true value lies with the apps that it supports. Apple App Store is probably a bigger success than the actual iPhone and iPad because it makes those devices so much more powerful.

Blackberry 10 handsets

the two new Blackberry devices

I have ditched my Blackberry 9900 as it simply didn’t have any apps that i could use. As an IT executive, I use apps daily for tracking my mileage, my time sheet and our support tickets. I switch to an old iPhone just to get access to these and chucked Blackberry’s top of the range smartphone at the time.

However, if Blackberry deliver on their new Blackberry World promise then it really could be a new beginning for RIM. What this means is that if RIM is to succeed, the company must somehow offset the greater component purchasing power of its larger rivals, match Apple and Samsung on design, attract application developers away from iPhone, Android and Windows Phone – all while pushing a compelling marketing message on a relatively limited budget.

Q10 handset

The new Q10 handset

RIM’s move to BB10 is likely to erode a significant profit stream: BB7 subscribers pay RIM, through their carriers, a monthly fee for RIM’s unique services. With BB10 this monthly fee drops away for consumers and for smaller companies. We estimate that this may cut RIM’s gross profit by over £640 million over the next two years.

To counter this, RIM will need to raise device sales by approximately 15 million units, or 50%. Only if sales exceed this level can RIM’s profits start to rise.

The first two handsets powered by the new Blackberry 10 operating system have been unveiled.

The Z10 is controlled via a 4.2in (10.7cm) touchscreen while the Q10 has a smaller 3.1in (7.9cm) screen and physical keyboard.

The UK will be the first to get the Z10 where it will launch on Thursday. What i didn’t realise and would have strongly suggested anyway was that the company has changed it’s name from Research in Motion (RIM) to Blackberry. RIM is not the most attractive name for a company.

Touchscreen keyboard

The new user interface allows up to eight apps to run simultaneously, four of which can appear in small windows on the same screen – something the firm boasts as “true multitasking”. Executives said the intention was to let users “flow” through applications using swipes and other gestures rather than copy the “in and out” nature experienced when navigating rivals’ devices.

looking at the new Z10 BB10 smartphone

For example BB10′s Hub – which brings together emails, texts and other notifications – can be accessed by swiping up and then to the right from any app. The user then needs to reverse the gesture to return to where they started.

The BBM messaging app can now make audio and video calls as well as being able to share what is on one person’s screen with the other user’s device.

The Z10 is not Blackberry’s first to feature a touchscreen keyboard, however it has adopted new features to attract users more used to physical buttons.

Blackberry BB10

For example a feature which learns the words and phrases the owner most often types and then uses this to suggest words which float above the keyboard and can be flicked into place.

It will also learn to anticipate and correct frequently made mistakes by big finger users – such as if the user often hits the letter C when they mean to tap space.

According to Francisco Jeronimo, European mobiles devices research manager at IDC, the new keyboard is the jewel in the crown for Blackberry.

And in addition, “The browser, one of the weakest features on the old Blackberry devices, is now an enjoyable experience.”

“This is not a new Blackberry device, this is a completely new Blackberry experience. For the first time the traditional keyboard Blackberry users will it find easier to type on a touchscreen.”

Companies are also given the option of being able to remotely wipe sensitive files like any device attached too a Microsoft Exchange server.

Meanwhile the in-built Pictures app includes a facility called Timeshift designed to ensure everyone has their eyes open in group photos.

It involves the user taking several pictures in a row and then scrolling through the shots to select the best frame. Now that sound pretty cool. Will be able to get a much better picture of the dog to post on facebook!

All sounds encouraging?

The Blackberry BB10 smartphone

Jan Dawson, chief telecoms analyst at Ovum had this to say:

“We don’t expect a speedy exit from the market; with no debt, 80 million subscribers and profitability in the black in at least some recent quarters, the company can continue in this vein for years. But its glory days are past, and it is only a matter of time before it reaches a natural end.”

Blackberry’s shares fell more than 6% following the launch.

The Blackberry BB10 Calendar

BlackBerry Z10
3G: £49.99 then £36 per month on a 24-month contract
4G: £49.99 then £41 per month on a 24-month contract

There’s one key addition that gives a clue to the future of BlackBerry, however, and it’s called Balance, in the sense of “work-life”. Swipe down and you can easily select between a ‘Work’ and ‘Personal’ persona; the colour of the screen changes, the inboxes and everything else are wholly separate. It’s neat, offering two phones in one. But it also introduces a division that is as much a benefit as an inconvenience. With more and more people totally combining their work and personal lives on a single device, it seems to be a step that only benefits the corporate IT department, who have to be running BlackBerry Enterprise Service to make it work anyway.

And it seems that that is where the Z10 will find favour – if you work for a company that isn’t terribly forward-thinking, you may soon find they’re offering you a new BlackBerry. But if you work for a firm that cares whether you get to work on time and thinks it might be useful that there’s a National Rail app with train times on your phone, you may not.

Manufacturer’s specifications:
Size: 130×65.6x9mm
Screen: 4.2”, 1280x768px, 356dpi
Memory: 2GB RAM; 16GB Flash (hot-swappable MicroSD)
Processor: Dual Core 1.5GHz
Talk time: up to 11hours
Camera: 8MP/1080p; 2MP/720p
HDMI Port

BB10 Adds So Many Features That So Few People Want

More info and images on the new blackberry phone from the blackberry site itself.

9 Things to do when the Internet drops out…

There is no quicker way to realise how much you rely on your internet connection when it suddenly drops off. You get the dreaded and hated “Internet Explorer can not display this page” and your email say it’s trying to connect.

help, we have no internet

internet explorer cannot display the webpage

Here are some tips and ideas on what to do when this happens so that you don’t go completely insane. At the same time, it may be a good idea to look at building in some Internet redundancy by having a second Internet connection. With a phone line around £15 per month and a broadband connection around £20, it is a very small price to pay per month verses the amount of money you probably lose per hour when your staff can’t work. Contact us here for more info - http://www.colins-it.co.uk/contact.html

need more than one internet connection?

Broadband Backup

However, while you are down, here are 9 ways to stay productive. If you have a power outage to boot then some of these may not be relevant.

1: Use Windows offline folders or on-line briefcase

It is always very useful when travelling, having a copy of all the data you require on your laptop. Same concept apply if the server goes down, each computer has a copy of the data that synchronises around the office and into the cloud whenever a file is added or updated. This starts from only £10 per month for 512GB of data. You can also take advantage of the Windows offline files feature. It allows you to mark folders on network drives as available for offline use. The contents of the folders are then cached to the laptop’s hard drive. This way, you can always access your files, regardless of whether you’re connected to the network. When you do connect, the changes are synchronised.

backup online

2: Find another way to get online

If you’re at home or at the office and the Internet goes down, the most sensible solution might be to find another connection. Probably won’t work for a big office but either use your mobile phone, a 3G dongle or head off to Starbucks or similar coffee shop with Wi-Fi internet access.

 

connecting to the internet while having a coffee

mobile internet while having a coffee?

3: Print what you’ll need

If you have a big report to go through and you are having issues with connecting to the network or will have issues with power on your laptop, then print it out and work on it manually. Sometimes going back to paper can be productive if you are facing computer problems at that specific point in time.

print out your work but watch those trees…

4: Answer emails

With no internet, it is a great time catch up on all those emails you have not answered yet. Microsoft Outlook caches Exchange Server mailboxes in an .OST file. This means that Outlook can display your email messages, contacts, tasks, and calendar, even if it can’t connect to Exchange. This caching makes it possible to reply to email messages even without Internet connectivity. Your replies will be sent once a connection to the mail server can be re-established.

If you have email on your phone then you can often keep going by reading and replying to emails on there or your iPad etc until you are fully operational again. Works very well when you are out the office.

need your emails where ever you are

Need email on the move?

5: Take care of other neglected tasks

If the Internet is going to be down for a hopefully short time period that doesn’t involve heading over to Costa / Starbucks then do those tasks you have been meaning to get round to doing but never seem to have a chance. For example, clean your desk or work on your latest travel expense report. Renew your tax disc or actually put tax disc in the car!!

6: Take the Internet offline with you

If you need to do a lot of research while travelling then you can download various websites that you need to look through / read by using a feature in Internet Explorer that makes Web page contents available offline. Simply cache the pages you need before heading out the door.

7: Give your brain a break

The idea of taking a brain break probably seems really out of place, especially since this article is all about staying productive when no Internet service is available. Taking a short break often improves productivity. And what better time to take a break than when your ISP is having an outage? Just put your swimming costume on and head out the door. Just be careful if it’s winter or if you’re living in the UK!!

hosted exchange

take a break while the internet if off…

8: Have a brain storm staff meeting

If you work in an office environment and your Internet service goes offline, one way to remain productive is to have an brain storm staff meeting. The outage may give you time to go through outstanding issues, catch up on the status of various projects, and discuss issues that might ordinarily have been neglected.

american president Obama

Not sure if following Obama’s style is recommended?

9: Return phone calls

Most people have a string of phone calls to make that they put off. If you have a VOIP system you are stuffed although you probably have a mobile phone. Now would be a great time to make those calls while there is no facebook on your office PC to distract you.

iPhone 5 review

review the new iphone 5

 

Apple fans probably spend 11 months waiting for the next iPhone. Having spent the first month of a new iPhone release being very excited and probably a little disappointed to as to what Apple have released. To be fair, in order to sum up the new iPhone 5, it is Thinner. Lighter. Faster and Simpler! Boom!With the new iPhone incorporating all the improvements and refinements people have been demanding over the past year, it is truly fabulous however there will always be a few disappointed users…

Despite this, the real vote is when people dig into their wallet in order to buy the new iPhone.The iPhone 5′s new design is lighter and yet leaves room for a larger display and LTE wireless, all while increasing battery life. In nearly every respect, this is an upgrade over the 4S that came before, though it arrives almost a year later than many had hoped.

the new iphone 5

review iphone 5

 

Hardware

Apple introduced the iPhone 5 to the world by elevating it from a hidden pylon, rising from the floor and literally sitting on a pedestal for the world to admire while precisely focused lights made the thing gleam like a jewel.

The collection of square edges and raw materials was a huge contrast to everything else Apple is producing and, every other mobile device on the market. Apple have no reason (and haven’t) to compromise the beautiful and unique design of their iPhone 5.

buy iphone 5

the white iphone 5

Visually, it is relatively the same to the iPhone 4S but the biggest change is not a visual one. Pick up the iPhone 5 and you’re immediately struck by the reduction in weight. At 112 grams it’s 20 percent lighter than the 4S. This indeed has a big impact, so much so that it’s the lightness, not the bigger display or the thinness, that nearly everybody praises when first getting a chance to hold the iPhone 5 in their paws.

iPhone 5 vs. iPhone 4S
iPhone 5 vs iPhone 4S

iPhone 5 length

The size difference is relatively difficult to tell as they are the same width although obviously the iPhone 5 is slightly longer and thinner. The iPhone 5 measures 4.87 x 2.31 x 0.3 inches (124 x 59 x 7.6mm), making it about a 1cm taller than before. The extra room happens outside of your hand hold so you hardly notice it.

The new height makes room for that 4-inch, 1,136 x 640 display. Steve Jobs famously said that the 3.5-inch screen size is the “sweet spot” and, frankly, it was about time Apple added a little more sugar. The new height results in a phone finally be 16:9 with more usable space and better presentation for HD content. Yet, it’s still easy to use with one hand as with the iPhone 4S.

That comfort is also helped by the decrease in thickness: 7.6mm, down from 9.3mm on the iPhone 4S. While it isn’t the world’s thinnest smartphone that Apple seem to think, it is still a rather impressively beautiful device.

No more glass back to break but an all-new aluminum construction extends around the back, which is either anodized black or left raw depending on whether you opt for the darker or lighter of the two offerings. The white phone is bright and clean-looking; the black, dark and slightly eveil looking however it does pick up finger marks more than it’s white counterpart. Two slivers of glass punctuate the top and bottom of the back sides. These glossy bands break up the matte uniformity, but help boost antenna performance which is fabulous news to all of us quite frankly.

iPhone 5 vs iPhone 4S back

compare iphone 5 size

The antennas still comprise the rim of the device although now thinner. These are the same sort of dynamically reconfiguring antennas used on the 4S but with a lot more success as they don’t have the same sort of signal issues.

The face of the device is still fashioned out of glass and while Apple wouldn’t confirm whether that front is indeed the sort of primate-proof silica produced by Corning. With the metal back now sitting flush to the chamfered edge of the device, it’s now thicker on top than on the bottom.

The elevated glass means your finger doesn’t hit any rough edges while the front-facing FaceTime HD camera now sits centrally  directly above the earpiece. The resistance of the home button feels slightly different than that on the 4S which we are hoping means it will be more durable.

The position and design of the other buttons is likewise largely unchanged from the 4S, with the discrete, circular volume up and down buttons on the left just below the (slightly thinner) toggle switch while the headphone jack now moves to the bottom. This is just like the iPod so probably a good decision.

The phone’s speakers with 26 holes, are also positioned on the bottom on either side of the new Lightning connector.

Battery life & Performance

Twice as fast? Twice the graphics performance? Thinner AND better battery life? Are you kidding? Nope! The iPhone 5 over-delivers on all those promises. Tests indicate that the new phone is more than twice as fast and your apps will load noticeably quicker, HDR images are processed in half the time and tasks like video rendering in iMovie are equally rapid.

Web pages load very quickly, snapping into view as fast as the data is available.

battery iphone 5

iphone battery level

So what kind of battery life can you expect? Speed is useless if it only lasts a few hours a day but, shockingly, the iPhone 5 copes incredibly well. In a day of heavy usage with LTE, GPS and WiFi all enabled, we managed over 14 hours before the phone went black!

When it comes to wireless performance, the iPhone 5 didn’t let us down. Overall, the iPhone 5 did an excellent job at finding and keeping signals, and call quality is pretty good. This is pretty huge because iPhones in the past have been badly let down by signal challenges.

Whats inside

The new A6 processor, a chip that Apple wasn’t too keen to describe other than it being “twice as fast” as the last-gen A5 and “22 percent smaller.” However, Geekbench has identified it as a dual-core 1.05GHz processor with 1GB of RAM.

iphone 5 chip

iPhone 5 a6 chip

Apple are clearly not up for playing the core count and gigahertz game, so they’re keeping quiet. What is key is that we’ve left the world where clock speed or core count could be directly correlated with performance across CPU architectures and yet the press continue to push this as the core performance comparison. And with Apple constructing its own, custom SoC for the A6, that’s doubly true. Why, the dual-core A5 chip in the iPhone 4S shows as 800MHz, so looking purely at numbers this new phone should only be 25 percent faster, not 50% faster.

Storage hasn’t changed with a choice of 16, 32 or 64GB models. Unsurprisingly, storage is not expandable, but that’s where iCloud comes into it.

The addition of LTE being the biggest wireless addition. Across the regional variants that will be sold around the world, 700MHz AWS bands for LTE for AT&T in the US are supported, plus Rogers, Bell and Telus in Canada and various carriers in Europe and Asia using bands 1, 3 and 5. Meanwhile, a CDMA version handles Verizon and Sprint LTE in the US plus KDDI in Japan using Bands 1, 3, 5, 13 and 25.

 

That’s a lot of spectrum to cover — and we haven’t even broached the GSM/EDGE, UMTS/HSPA+, DC-HSDPA support in the GSM model, nor the CDMA EV-DO Rev. A and Rev. B support in the other.

The choice of CDMA vs. GSM will likely come down to which carrier you’re on, and which carrier you’d like to be on. Beyond the availability of bands, an important distinction is the ability to do simultaneous voice and data. None of the iPhone 5 models can handle Voice over LTE, so when doing voice calling the phone falls back to either GSM or CDMA, and CDMA doesn’t support simultaneous voice and data.

The Apple iPhone 5: See what's inside

Opening the iPhone 5

On top of all that is an expanded selection of WiFi connectivity options. The iPhone 5 adds 802.11a support to complete the set of a/b/g/n compatibility. That connectivity is now dual-band as well, so you can step up out of the crowded 2.4GHz into the clear air at 5GHz. Bluetooth 4.0, GPS and GLONASS support all return.

Lightning

For nearly 10 years the 30-pin Dock connector has been on all devices and accessories however since iPods started getting thinner we all knew its days were numbered. Apple has finally decided it was time for the Dock connector to go, but is the Lightning really the best way forward?

The Lightning connector is significantly easier to connect. It slots in nicely and does so regardless of plugging in right-side-up or upside-down. It’s also small, seems infinitely more durable than its flimsy-feeling elder and even stronger than micro-USB alternatives.

iphone 5 speakers

But Lightning comes up short in a number of important areas. It is, unfortunately  incompatible with the roughly 355 million billion iPhone and iPod accessories currently on the market. And while this should be fixed via a $30 adapter, it will never be the best solution. It won’t support iPod Out, the specification used in some cars (most notably BMW and Mini) to enable in-dash control of an iPod or iPhone.

Another challenge is the speed of this new connector. Lightning’s name comes as a play on the Thunderbolt connector, yet Lightning has, at least for now, no relation to Thunderbolt at all. It is surprising that there is a speed difference between the two phones as the implementation that comes with the iPhone 5 is based on USB 2.0, meaning that theoretical maximum data transfer rates are no faster than what came before.

Tests carried out implied a 20% speed difference but is this the cable or this the faster A6 processor at work?

 

New 4 Inch Display

The iPhone 5 boasts a 4-inch display that provides a half-inch of additional diagonal extent compared to its predecessors. I don’t think it makes a huge difference but it does make it more competitive with the other phones in the market without being silly big.

The iPhone 4S already has one of the best displays on the market with regard to things like pixel density, brightness and contrast, and the iPhone 5 takes it up another level. Not only is there an additional 176 rows of pixels but the quality is even better.

iphone 5

The black iPhone 5

Displaying imagery is much more chromatically neutral than before. The phone also moves up to full sRGB coverage, meaning it can accurately represent every color provided by that spectrum, a claim to fame few smartphones can match.

Apple also promises fewer layers sandwiched between the subpixels and the surface of the glass, the idea being greater contrast when you’re outside.

Software
iPhone 5 homescreen

iPhone 5 homescreen

The iPhone ships with Apple’s latest iOS 6 mobile operating system. The new Maps app  will have the biggest impact on most users, (especially those living in zone where the maps seems to have been missed off) and in general the Maps were beautiful, fast and smooth.

However, the maps are not as comprehensive as Google’s offerings on Android. It also lacks the detailed layering that you can apply in Google Maps and Google Navigation, showing you whatever you want to see. Maps will list some important Points of interest but you will need an app if you require a lot more detail. Finally, while Maps does appear to show traffic, there was no traffic jam warning which is kinda the whole point.

iOS 6 3D Maps comparison

iphone 5 maps

Passbook is Apple’s virtual wallet, providing the ability for companies to write custom apps that will slot in here and provide access to things like movie tickets and value cards. However, with insufficient players onboard, this is one for the future rather than right here, right now. Given Apple’s ability to blow us out the water, i recommend watching this space.

iOS 6 Maps public transport

iPhone 5 transport apps

A welcome addition is the new Shared Photo Streams feature. You can select a few pictures from your roll, and share it with one or more friends. New photos added to the stream popped up in about half a minute so it is a pretty decent way to share photo’s with friends.

In general, iOS 6 has seen a few nice little additions where needed but this is no major leap forward that was probably needed. iCloud integration is tighter as you will expect, Safari is better and the overall experience and speed is more polished.

Cameras

The iSight camera here is basically unchanged from the 4S. The overall mechanism has been made smaller to fit within the tight confines of the iPhone 5, and the protective bit of glass on the outside has been replaced with a 6mm disc of crystal sapphire for durability.

So, that means we have an 8-megapixel, backside-illuminated sensor shooting through a five-element, f/2.4 lens. And, with the bigger screen, we now have a larger shutter release button, which is slightly easier to tap by big thumbs.

As camera phones go, the iPhone 5′s Image quality is still among the best out there.  What has improved, though, is the speed. You take a flurry of rapid pictures and the iPhone 5 will keep up. This is on par with the Galaxy Nexus, which also has a ridiculously quick shooter.

HD Camera

The iPhone 5 camera

So, while the camera on the back is minimally improved, the one on the front is a big step forward. Replacing the VGA FaceTime camera is a 1.2-megapixel FaceTime HD unit capable of capturing 720p video. Resolution is obviously massively increased, but so too is overall image quality, with far more accurate colour reproduction.

Panorama mode has been introduced into iO6, where you can tap one button and just sweep the phone around to create a massive image. Resulting files are something like 11,000 x 2,500, with the exact resolution varying based on how smoothly you panned from left to right. If you wander up or down the display will warn you to keep in line, and you’ll want to, as every time you stray you’re effectively cropping the resulting image. so this will probably take a lot of trial and error as well as a tri-pod..

Video capture remains the same on the rear-facing camera — 1080p maximum and offering bright contrast and colors plus the same digital image stabilization that we saw before, which results in reasonably smooth shots.

Wrap-up
iPhone 5 vs iPhone 4S

The new iPhone 5 review

The iPhone 5 is a significant improvement over the iPhone 4S in nearly every aspect. However the new iOS6 is a bit of a disappointment  At least, as it is software, it can be upgraded and doesn’t require a new bit of hardware to be launched in 12 months time.
Still, the iPhone 5 absolutely shines and is certainly worth the upgrade in our opinion. As Apple bangs on, this is without a doubt the best iPhone yet!

Microsoft Excel 2010 short-cuts & Free training

If you use Microsoft Excel quite a lot in your day to day job then you will find using various short cuts speeds up everything you do which can only be a good thing.

You will also find it a lot easier than reaching for the mouse all the time to do a small task or flick to another sheet or workbook.

There are a few links at the bottom to some free excel training.

CTRL+SHFT+( Unhides any hidden rows within the selection. +       –
CTRL+SHFT+& Applies the outline border to the selected cells. +       –
CTRL+SHFT_ Removes the outline border from the selected cells. +       –
CTRL+SHFT+~ Applies the General number format. +       –
CTRL+SHFT+$ Applies the Currency format with two decimal places (negative numbers in parentheses). +       –
CTRL+SHFT+% Applies the Percentage format with no decimal places. +       –
CTRL+SHFT+^ Applies the Scientific number format with two decimal places. +       –
CTRL+SHFT+# Applies the Date format with the day, month, and year. +       –
CTRL+SHFT+@ Applies the Time format with the hour and minute, and AM or PM. +       –
CTRL+SHFT+! Applies the Number format with two decimal places, thousands separator, and minus sign (-) for negative values. +       –
CTRL+SHFT+* Selects the current region around the active cell (the data area enclosed by blank rows and blank columns). In a PivotTable, it selects the entire PivotTable report. +       –
CTRL+SHFT+: Enters the current time. +       –
CTRL+SHFT+ Copies the value from the cell above the active cell into the cell or the Formula Bar. +       –
CTRL+SHFT+Plus (+) Displays the Insert dialog box to insert blank cells. +       –
CTRL+Minus (-) Displays the Delete dialog box to delete the selected cells. +       –
CTRL+; Enters the current date. +       –
CTRL+` Alternates between displaying cell values and displaying formulas in the worksheet. +       –
CTRL+’ Copies a formula from the cell above the active cell into the cell or the Formula Bar. +       –
CTRL+1 Displays the Format Cells dialog box. +       –
CTRL+2 Applies or removes bold formatting. +       –
CTRL+3 Applies or removes italic formatting. +       –
CTRL+4 Applies or removes underlining. +       –
CTRL+5 Applies or removes strikethrough. +       –
CTRL+6 Alternates between hiding and displaying objects. +       –
CTRL+8 Displays or hides the outline symbols. +       –
CTRL+9 Hides the selected rows. +       –
CTRL+0 Hides the selected columns. +       –
CTRL+A Selects the entire worksheet. If the worksheet contains data, CTRL+A selects the current region. Pressing CTRL+A a second time selects the entire worksheet. When the insertion point is to the right of a function name in a formula, displays the Function Arguments dialog box. CTRL+SHIFT+A inserts the argument names and parentheses when the insertion point is to the right of a function name in a formula. +       –
CTRL+B Applies or removes bold formatting. +       –
CTRL+C Copies the selected cells. +       –
CTRL+D Uses the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below. +       –
CTRL+F Displays the Find and Replace dialog box, with the Find tab selected. SHIFT+F5 also displays this tab, while SHIFT+F4 repeats the last Find action. CTRL+SHIFT+F opens the Format Cells dialog box with the Font tab selected. +       –
CTRL+G Displays the Go To dialog box. F5 also displays this dialog box. +       –
CTRL+H Displays the Find and Replace dialog box, with the Replace tab selected. +       –
CTRL+I Applies or removes italic formatting. +       –
CTRL+K Displays the Insert Hyperlink dialog box for new hyperlinks or the Edit Hyperlink dialog box for selected existing hyperlinks. +       –
CTRL+L Displays the Create Table dialog box. +       –
CTRL+N Creates a new, blank workbook. +       –
CTRL+O Displays the Open dialog box to open or find a file. CTRL+SHIFT+O selects all cells that contain comments. +       –
CTRL+P Displays the Print tab in Microsoft Office Backstage view. CTRL+SHIFT+P opens the Format Cells dialog box with the Font tab selected. +       –
CTRL+R Uses the Fill Right command to copy the contents and format of the leftmost cell of a selected range into the cells to the right. +       –
CTRL+S Saves the active file with its current file name, location, and file format. +       –
CTRL+T Displays the Create Table dialog box. +       –
CTRL+U Applies or removes underlining. CTRL+SHIFT+U switches between expanding and collapsing of the formula bar. +       –
CTRL+V Inserts the contents of the Clipboard at the insertion point and replaces any selection. Available only after you have cut or copied an object, text, or cell contents. CTRL+ALT+V displays the Paste Special dialog box. Available only after you have cut or copied an object, text, or cell contents on a worksheet or in another program. +       –
CTRL+W Closes the selected workbook window. +       –
CTRL+X Cuts the selected cells. +       –
CTRL+Y Repeats the last command or action, if possible. +       –
CTRL+Z Uses the Undo command to reverse the last command or to delete the last entry that you typed. +       –

Want to learn more about using Microsoft Excel? Here are some useful links from Microsoft:

Downloadable training content adapted from the training course, “Get to know Excel 2010 – Create your first spreadsheet,” in PowerPoint format

 

Downloadable training content adapted from the training course, “Get to know Excel 2010: Create formulas,” in PowerPoint format.

 

Save time by creating and running macros in Excel 2010

Take the next steps in improving your Excel skills

 

Quick Overview of Excel

11 reasons to consider upgrading to Windows Server 2012

So Microsoft bounce in with another brand new server product. Generally we find new versions of Microsoft server products are better than their predecessors and certainly much better than their desktop operating system counterparts which has a few people excited but a lot more nervous and awaiting the inevitable service pack 1 release.

Having had a play with the release preview of Windows Server 2012, we have discovered some interesting things about the new server to share with you. The new interface has a few people sceptical, formerly known as Metro, but with more emphasis on Server Core and the Minimal Server Interface, the UI is unlikely to be the deciding factor when deciding to upgrade. More important are the big changes and new capabilities that make Server 2012 better able to handle your network’s workloads and needs.

Here are 10 reasons to give serious consideration to upgrading to Server 2012 sooner rather than later.

1: Freedom of interface choice

A Server Core installation provides security and performance advantages, but in the past, you had to make a choice: If you installed Server Core, you were stuck with it with only the command line as your interface. However, this changes with Windows Server 2012.

Microsoft realized is that the command line is great for some tasks and the graphical interface is preferable for others. Server 2012 makes the GUI a “feature” — one that can be turned on and off at will, therefore saving resources when the server is simply being a server. You do it through the Remove Roles Or Features option in Server Manager.

2: Server Manager

Regarding the Server Manager, even many of those who dislike the new (metro) tile-based interface overall have admitted that the design’s implementation in the new Server Manager is brilliant.

Figure A

Server Manager

One of the best things about the new Server Manager is the multi-server capabilities, which makes it easy to deploy roles and features remotely to physical and virtual servers. It’s easy to create a server group — a collection of servers that can be managed together. The remote administration improvements let you provision servers without having to make an RDP connection.

3: Server Message Block 3.0

The SMB protocol has been significantly improved in Windows Server 2012 as well as Windows 8. The new version supports new file server features, like SMB transparent failover, SMB Scale Out, SMB Multichannel, SMB Direct, SMB encryption, VSS for SMB file sharing, SMB directory leasing, and SMB PowerShell.  It also works beautifully with Hyper-V, so that VHD files and virtual machine configuration files can be hosted on SMB 3.0 shares. A SQL system database can be stored on an SMB share, as well, with improvements to performance.

4: Dynamic Access Control (DAC)

Microsoft has shifted the focus from separate security products to a more “baked in” approach of integrating security into every part of the operating system.

Dynamic Access Control is one such example, helping IT pros create more centralized security models for access to network resources by tagging sensitive data both manually and automatically, based on factors such as the file content or the creator. After that, claims based access controls can be applied.

5: Storage Spaces

Storage is an interesting topic in the IT industry these days. We are still a long way off storing everything in the cloud (many organizations are still concerned about security and reliability). There are myriad solutions for storing data on your network in a way that provides better utilization of storage resources, centralized management, and better scalability, along with security and reliability. SANs and NAS do that, but they can be expensive.

Storage Spaces is a fantastic new feature in Server 2012 that lets you use inexpensive hard drives to create a storage pool, which can then be divided into spaces that are used like physical disks. They can include hot standby drives and use redundancy methods such as 2- or 3-way mirroring or parity. What’s great is that you can add new disks any time, and a space can be larger than the physical capacity of the pool. When you add new drives, the space automatically uses the extra capacity.

6: Virtualization

Virtualization was the biggest thing before the cloud hit the IT industry and it is still the thing to do when it comes to servers. Hyper-V is Microsoft’s answer to VMware / XenServer. Microsoft’s virtualization platform is liked by a lot of IT Pro’s and wither each new version Windows hypervisor gets a little better, and Hyper-V in Windows Server 2012 brings a number of new features to the table. One of the most interesting is Hyper-V Replica.

This is a replication mechanism that will be a disaster recovery godsend to SMBs that may not be able to deploy complex and costly replication solutions. It logs changes to the disks in a VM and uses compression to save on bandwidth, replicating from a primary server to a replica server.

You are able to store multiple snapshots of a VM on the replica server and then select the one you want to use. It works with both standalone hosts and clusters in any combination.

7: Virtual Desktop Infrastructure

Windows Terminal Services was renamed Remote Desktop Services and has since expanded to encompass much more than the ability to RDP into the desktop of a remote server. Microsoft then launched a centralized Virtual Desktop Infrastructure (VDI) solution in Windows Server 2008 R2 and now some significant improvements have been made in Server 2012.

You no longer need a dedicated GPU graphics card in the server to use RemoteFX, which vastly improves the quality of graphics over RDP. Instead, you can use a virtualized GPU on standard server hardware. USB over RDP is much better, and the Fair Share feature can manage how CPU, memory, disk space, and bandwidth are allocated among users to stop certain users stealing all the bandwidth.

8: DirectAccess

DirectAccess was supposed to be Microsoft’s “VPN replacement,”. It allowed you to create a secure connection from client to corporate network without the performance drain and with a more transparent user experience than a traditional VPN. Administrators get more control over the machines and the ability to manage them even before users log in. Group policy is utilised to control the machines as well and there is no hassle of setting up a VPN connection.

So why hasen’t DirectAccess taken off? Two main reasons, it can’t be virtulized and its  dependent on IPv6. However in Windows Server 2012, DirectAccess now works with IPv4 and lo and behold it can run on a Hyper-V virtual machine. It also comes with a new wizard to help make configuration a lot easier.

9: Resilient File System

NTFS has been around since 1993 and its been a long and well needed replacement for a while. There was speculation early on that a new file system would be introduced with Windows 7, but it didn’t materialise.

Windows Server 2012 finally brings us our long-awaited new file system, the Resilient File System. While it supports many of the NTFS features, a few have been abandoned, i.e. file compression, EFS, and disk quotas. However, instead we get data verification and auto correction, and it’s designed to work with Storage Spaces to create shrinkable/expandable logical storage pools.

Maximum scalability is the key drive behind ReFS, supporting up to 16 exabytes in practice. ReFS supports a theoretical limit of 256 zetabytes (more than 270 billion terabytes). That allows for a lot of scaling and a whole bunch of cloud storage!

10: Easy licensing

Microsoft and easy licencing don’t really go in the same sentence. However Microsoft have actually listened this time and Windows Server 2012 is offered in only four editions: Datacenter, Standard, Essentials, and Foundation. The first two are licensed per-processor plus CAL, and the other two (for small businesses) are licensed per-server with limits on the number of user accounts (15 for Foundation and 25 for Essentials). See the chart with licensing details for each edition below:

11: The New Active Directory

In todays business environments, data is nto always stored on the customer’s server due to the utilisation of cloud technology. In addition data is accessed by staff on various different devices like phones, laptops, desktops and other removable devices.

To address these new challenges, organizations have to change how they approach identity and security. Windows Server 2012 contribution to helping with this challenge is the introduction of Dynamic Access Control, and it brings with it exciting new capabilities and deployment options for DirectAccess. This means you will be able to better manage and protect data access, simplify deployment and management of your identity infrastructure, and provide more secure access to data from virtually anywhere.

Have you used the new Windows 2012 yet? What do you think?

7 valuable VMware infrastructure backup tips

At small companies or in brand-new virtual infrastructures, backup can be straight forward. You may be able to use a free tool that makes VMware backup deceivingly simple.

However, over time, your infrastructure will probably grow, as well as the number of virtual machines and the amount of data needing backup. As this happens, you’ll find what other virtualization experts have already figured out – virtualization backup can be much more complex that it seems and you need the right tool for the job.

In this blog, you’ll learn how to save time, prevent data-loss, and create a bulletproof VMware backup infrastructure by employing the 7 valuable VMware infrastructure backup tips from virtualization backup experts.

Selecting the right tool for the job of backing up your virtual infrastructure is the critical piece of your entire virtual infrastructure protection plan.

Here are the steps I recommend to select the right backup tool for your virtual infrastructure:

1. Don’t assume you have to select the same tool as everyone else. There are a number of good tools on the market. Just because a tool has the best marketing strategy doesn’t make it the best tool. Do your own research and find the best tool for your environment.

2. Test tools for yourself and take your time doing it. Every tool offers a free trial period that allows you to test their product on your own infrastructure (plus, if you are really interested in the product, most companies will give you a free extension to try their product longer than the original trial). Make sure that you test these tools in a test environment and not your live infrastructure. Put these tools through their paces, with your applications, and focus on features related to recovery.

Remember, you aren’t just getting a tool to backup your VMs, what you really want is them to be restored and FAST. Test things like multiple restores at a time, file level restore, and application integrity after restore.

3. Make your life easier by selecting a tool that has the latest features. Your tool should offer features like fast restore for multiple VMs, application integrity in your backups, replication, backup of multiple hypervisors, backup of physical and virtual servers, deduplication, and more. Cost make effect your decision here…

Avoid VMware Snapshots of Virtual Machines

Snapshots aren’t backup. Snapshots should only be used for very short-term and not as your primary backup method. Let’s say that you are about to perform an application upgrade, you would take a snapshot (and do a backup) before the upgrade. Then, the next day, if the app upgrade was successful, you would remove your shapshot.

A week later you needed a pre-upgrade database then you could restore if from your backup and not the snapshot.

Snapshots take up tons of disk space and space in your backup repository. Space used by snapshots is, many times, forgotten and easily overlooked, causing unexpected results.

Plan for Offsite Backup and Replication

The problem with so many VMWare backup tools is that they stop once something is backed up. They leave the files on a disk and leave it up to you to figure out how to get them offsite in case there is a disaster.

Something else to consider is that you may need to recover a virtual server on a physical server or vice versa. Can your backup product cover all of these scenarios?

I recommend moving to 100% virtualization, backing up all VMs, and then replicating those backups offsite. In the event of a disaster, you’ll be able to bring them up at the DR site. And more importantly all your data will be on another site if you just need to restore one VM.

Test your backups!

Just because your backup software tells you that backups were “100% successful”, doesn’t mean that you can restore your data. You need to either manually test your virtual machine restores AND applications inside or have your backup software do this for you.

How many VMs have you restored that bluescreened when they were booted up?

How many VMs have you restored that had corrupted Exchange or SQL server databases?

To ensure that your backups will be 100% recoverable, make sure that you test:

• VM image level restore
• VM file level restore
• The VMs boot successfully and filesystems (like NTFS) mount perfectly
• The application databases mount and services start (e.g. Exchange, SQL, and SharePoint)

Testing all of this on a periodic basis can be very time consuming but it is vital to save your bacon and your job / company should it ever be needed in an emergency.

Cloud Backup and DR

Replicating to your own secondary datacenter is an option however not everyone has a secondary datacenter, nor does it make sense for everyone to build one. Cloud-based disaster recovery services are now available that can store your replicated data pretty affordably so worth considering.

How Applications Affect Backups

End users now expect applications like Exchange, SQL, and Sharepoint to be available 24×7. There is no more backup window. Your backup software must be able to:

• Backup mission critical applications without downtime
• Verify that backups have application integrity
• Restore individual items from mission critical applications back into production

The purpose of your backups is to also protect your applications. Make sure that your backup software not only backs up VMs, but recovers your critical application data.

Agent-less vs agent-based backup

From our experience, agents may be a headache to deploy but they do tend to be more reliable communication with the agent and server. However, agent-less backups means it is very simply to deploy and manage. So look at both options and see which one works best for you.

Conclusion

Make sure that you plan for offsite backup and replication, consider cloud-based
backup, and use automated testing to ensure backups are recoverable. Selecting a backup tool that knows your applications and can reliably restore them is crucial. Finally, don’t dismiss any tool without fully understanding and testing its capabilities, personally in your test environment.

 

a day in the life of a network engineer…

I thought it may be interesting in writing a blog about what we actually get up to. The kind of things we deal with on a day to day basis. I am sure other network engineers out there will have some interesting comments to make of their own experiences?

Issues range from people having viruses on their laptop computer. We will get rid of the virus for them, clean up the computer of any additional spyware or software that shouldn’t be installed, install premium and authentic anti-virus software and make sure the laptop is completely clean and virus free. In addition we will advise if they need to upgrade their laptop’s memory for example or if they are running out of disc space. We also ensure they are backing up their precious documents and photos so they don’t lose anything if the hard drive crashes.

We have recovered data for clients where their hard drive has crashed but they need vital documents. Even if we have to send it off to a 3rd party data recovery specialist, we handle the whole process for them. Arranging collection and delivery and putting the customer’s data back on their laptop. We will also install a new hard drive and set up their system again for them.

We manage client’s whole network of computers and server. We had a call yesterday where the client in Coventry could not access any of their servers. After much looking round we discovered a small network switch was not working. It wasn’t quite as simple as turning it back on but through our knowledge and problem solving skills, they were all back up and running.

We had another client who was not receiving email. More specifically whenever they reboot their router their IP address changes so they don’t get their email delivered. It is a bit like constantly changing your address and expecting the postman to find you. In this instance we called up the internet service provider and ordered them a permanent address so regardless of the router rebooting, they will always have email.

We have had more technical challenges where email stops working on a client’s server. We have a look for a specific error message in the event log and then do some research on this event and how to resolve it. It is not always the error you first see but may be a totally different error which is having a knock on effect so you have to think out the box. It is always satisfying and a relief when everything starts working again after successfully resolving an issue. Obviously failure is not an option so we need to utilise all our resources to quickly resolve issues which in turn reduce downtime for the client and save them money.

We are very strong advocates of everyone who has a computer firstly backing up their data and secondly having good anti-virus protection. If you use free anti-virus protection, don’t be surprised if a virus gets through and destroys your computer. Not only do we sell a product called Trend Micro which we have found to be the best in the market but we also install it for our clients and make sure they are fully protected. We don’t even charge for this. We often install the anti-virus remotely on a client’s computer which saves time for both us and them.

We also sell an online backup product at only £5 a month for unlimited data. We set this up for clients remotely as well, making sure the relevant files are all selected for backing up and it is actually working. It is pointless installing and paying for a backup solution when it is not actually backing up your critical data.

After all the work we do, here is some feedback from a few of our clients

Darren Rawlinson – “For Colin, providing IT solutions isn’t just solving a problem you may have come to him with first; it’s about providing knowledge, support and guidance as well as extremely personable and professional approach, which works well with small and larger clients. Colin is also professional enough to see the value in working in partnership to achieve common goals and greater future value for all.”

“Colin is impressive in his quiet confidence in his skills and abilities and in his commitment to work and causes. So far we have collaborated outside work; Colin supports Cord, the international peace building charity, strongly in various ways. I recommend him as someone who takes the initiative, thinks around a situation to find the best way of tackling it and delivers 100% reliably on what he says he will do. A very good guy to work with! Kit Lawry, Cord”

Peter O’Donnell – “Colin understands what a business needs, not just what they think they want. He designs, delivers and support all his projects and systems with great professionalism and enthusiasm. And he works all the hours of the day to get it done. A professional IT supplier and terrific person.”

PS – Pictures are for fun and not representative of actual customers!

Free tools for removing nasty software

CCleaner

Malicious software (be they viruses, rootkits, trojans, worms, or malware) are so prevalent it seems one of the primary jobs for IT is the protecting, cleaning, and removing of said software. It seems no matter how hard you try, or how much you pay for the software you use to protect your desktops, it always seems like a losing battle.It doesn’t have to be that way. There are plenty of tools that can help in the quest to have a virus/malware-free environment. These tools can be either installed on your machines or used as a toolkit to carry with you to fight the good fight. We find that these tools do the best job at keeping my systems clean.

Malwarebytes

People are always surprised to find out they need anti-spyware as well as anti-virus protection. Of the anti-malware tools I have used, Malwarebytes seems to be the most effective. Now there are two different versions of Malwarebytes: Free and Paid. The biggest difference is the Paid version has a real-time scanner built in. The free version must be run manually. This is not a problem if you are in control of all the PC scanning, or you can trust your users to manually run the software nightly (as well as manually update the definitions often.) If you can not trust your users to run this piece of software, you might need to buckle down and drop the $24.95 for the licensed version.

CCleaner

Another free tool, CCleaner does two things incredibly well: Cleans the Windows registry and removes cached web data. There are a lot of registry cleaners available, but CCleaner is the one I always trust. As with any tool, you want to make sure you understand the tool before using. And although cleaning cached browser data is fairly harmless, cleaning the registry is not.

I highly recommend always doing a backup of the registry when using CCleaner to take care of this task. Fortunately CCleaner has a built-in tool for backing up said registry as I have heard of a few people coming unstuck with ccleaner.

Microsoft Security Essentials

After using so many different anti-virus tools, the one tool that seems to work nearly as well as any other, without any attached cost, is Microsoft Security Essentials. Not only will this anti-virus tool work well to help prevent infection, it does so with as little drain on the system as nearly any anti-virus tool.

Windows

Combofix

Combofix is my first line of defense tool when I suspect something has taken over a machine. But you shouldn’t just run this powerful tool without a few considerations. First, and foremost, what will Combofix fix? After a successful run of Combofix, you should have cleaned (if applicable): Malware, Rootkits, Trojans, Worms, and Viruses. What you need to know about Combofix, prior to running is quite important. The single most important issue with Combofix is that you can not run it with an antivirus tool enabled. With some antivirus solutions you can simple disable the tool (Symantec Endpoint Protection is a perfect example). One particular antivirus solution, AVG, I have found to require complete removal before running Combofix. And to be on the safe side, I prefer to run Combofix with the computer in safe mode. One other note: Never download Combofix from any other site than Bleeping Computer or ForoSpyware.

Trend Micro

Trend have a few great (free) tools for getting rid of horrid software. Take a look at their page of free downloads. We are using these in our environment now which is really helping keeping systems clean. This includes housecall as an online scanner and PC cleanup. There is also RUBotted, Rootkit Buster All and HijackThis. http://www.trendmicro.co.uk/products/free-tools-and-services/index.html

Finally

There are so many pieces of software available to keep your PC clean however, do some research before you use anything as sometimes the software you are trying to use to clean up your computer is itself a little nasty critter. Trend Micro is a trusted source and have a great reputation as do the other products listed above but let us know what you think and if you have any better tools?

What is a Raspberry Pi

Just when you thought another ‘fruit-based’ piece of tech would be more than the market could bear, up pops the Raspberry Pi. Never heard of it?  Let me enlighten you. The Raspberry Pi is best described as a mini PC about the size of a credit card and what does it cost?…. about 25 to 30 quid. Yes, that’s right, £25 to £30 for a fully operational PC. To make it work you will need a TV/monitor, keyboard, micro USB cable and SD card but with its 700MHz Arm processor and 256MB it is capable of running Linux, full screen video and office applications.

The ground breaking Raspberry Pi has been developed in the UK by the Raspberry Pi Foundation which is a Cambridge based charity. It has been developed to promote the study of computer science in UK schools and inject some fun back into computing. The idea is to make IT a cool thing to do and be involved with and to encourage youngsters the sort of skills that will serve them well in an ever changing hi-tech world.

There is something quite retro about the Raspberry Pi which is very appealing. Similar to what the BBC Micro and the Sinclair Spectrum did in the 1980s, the Raspberry Pi is hoping to re-engage kids with the world of computing not just as a user but getting behind the scenes to see how a computer works, is built, and needs to be programmed.

It’s not just for kids though, IT enthusiasts all over the world are embracing the Raspberry Pi, especially web developers. The Raspberry Pi is capable of running web servers, browsers and text editors so it contains the environment that any would-be web developer needs. The Raspberry Pi is also the type of kit that you can experiment with and adapt for various IT functions ….. any computer enthusiast finds that hard to resist! Such was the demand for the Raspberry Pi when it launched back in February that the initial 10,000 units sold out in minutes and the Raspberry Pi online shop crashed.

the rasberry pi

So these are exciting times for the UK computer industry. Other countries have stolen a march on the UK in the computer industry since the 1980s but it is hoped that the Raspberry Pi will help create the developers and programmers of tomorrow and give the UK a new competitive advantage in the computer industry.

the rasberry pi logo

Back the F:\ UP!

In its simplest terms online backup is a way of keeping your data files safe in the ‘cloud’ so that you can access them anytime, anyplace, anywhere ( for those of you who remember the old Martini ads!) and in the event of a disaster, you can have complete peace of mind that they can be easily restored.

 

image copyright http://ijustine.com/

There are a plethora of online backup services out there so without going into the pros and cons of each service I have compiled the top 5 features that I think are the most important:

1. Easy to set up – you don’t want to have to call in Bill Gates to set it up. You want something that is very easy to configure and where you don’t spend all day scratching your heads with a bemused expression on your face – don’t worry, we’ve all been there.

2. Automatic – it needs to be automatic so that it runs without you having to think about it. Don’t buy a service that you have to prompt yourself – you can’t be trusted.

3. Simple disaster recovery – if the worse does happen, and sometimes it does, you want a backup service that is able to restore all your data quickly and easily without you needing to take a crash course in computer science.

4. Compatibility – you need an online backup service that will work with a broad range of operating services. You might be using Windows 7 now but you are bound to upgrade at some point so you want to make sure that your online backup service doesn’t go AWOL just because you change your operating system.

5. Transmission encrypted – it needs to be transmission encrypted so that your data remains completely secure. This means that nobody can intercept your data and have their wicked way with it. Let’s face it, that’s why you are doing a backup in the first place.

So that’s my top 5. I could witter on for ages about various features and their benefits but I like to cut to the chase and I also like an online backup service to do the same.

 

“I have been working with this online backup for a number of years now and I’m pleased to say that it meets the top 5 criteria that I’m looking for and I am able to offer it to my clients with absolute confidence.”

Check out this link and for £5 a month you can be safe and secure in the cloud http://www.colins-it.com/Online-Backup.html

For advice about online backup and IT support in general please contact Colins-IT on 0800 107 7782 or email at sales@colins-it.co.uk