Contact TTS for your IT Training needs
Friday, 9 October 2009

Excel 2007: What's New?



Excel 2007 looks very different from earlier versions of the software, but underneath all the cosmetic changes are quite a few useful new features:

1. New User Interface - Excel 2007 includes a single ribbon at the top of the screen and not the menu/toolbar seen in previous versions. This makes every feature easier to locate and use.

2. Improved Conditional Formatting - this has become much more powerful. Take a look at the screen shot above.

3. Formula AutoComplete - entering formulas can now be far less cumbersome. When you beging typing a formula, Excel displays a continually updated drop down list of matching items, including a description of each item.

4. Improved Pivot Tables - this feature is possibly one of the most underutilised in the application. With a few mouse clicks a pivot table can turn a range of data into a useful summary table. Just about every aspect of pivot tables has improved in Excel 2007. Pivot charts (created from pivot tables) now retain their formatting when updated.

5. Larger Worksheets - an Excel 2007 woksheet has more than 1,000 times as many cells as an Excel 2003 worksheet. In fact, the 2007 worksheet contains 1,048,576 rows and 16,384 columns.

So how do I get to learn about all the new features in Excel 2007? Rather than spending months and months playing around with all these new features why not do it all in a day or two and attend one of our public scheduled courses. Course are available at Introduction, Intermedaite and Advanced level so whatever your experience there is a course that will be suitable. Locations are also available UK wide.

In addition to our public scheduled Excel 2007 courses, we also offer on-site training. This allows us to tailor the contents of the course to suit your exact needs and the needs of your business. For people that find it difficult to take time away from the office, Excel 2007 online and computer based training (CBT) is now available. This allows you to study at your own pace and at times to suit you.

For further details please use the contact page on the website or see the full course listings at http://www.tts-uk.com/.
Bookmark and Share
0 comments
Monday, 5 October 2009

Is IPv6 Finally Needed?

The Internet Protocol (IP) that we currently use is version 4 (known as IPv4). This has been around for many years but does not scale well enough to last longer term. The address space (the number of IP addresses that exist) is running out.

Internet founder Vint Cerf believes that we are now facing and address crisis on the internet. "The internet cannot continue to grow effectively without the need for new address space" supplied by IPv6, says Cerf. "We're going to run out of IPv4 address space somewhere around 2011, and that's not very long from now in terms of preparing a fully operational IPv6 system running concurrently with IPv4."

The main difference between the 2 versions is that IPv6 uses 128 bit addresses whereas IPv4 uses 32 bits (you may have seen IP addresses written like this, 192.138.1.2, which give you around 4 billion combinations. This means that IPv6 has much more flexibility when it comes to allocating addresses and routing internet traffic. IPv6 gives you a lot of addresses - more than enough to give you an address for every atom in every computer in the world!

It would seem to be in everyone's interest to adopt IPv6, but here we are 10 years after it was designated the successor to IPv4 really not much further forward. There's no doubt the financial investment to upgrade sytems has much to do with this. Regardless of this though says Cerf, "it's absolutely critical that our business sector, the private secor, be prepared for operation of both IPv6 and IPv4."

For anyone out there that doesn't have a plan to adopt IPv6 then I say then start to think about one now. For anyone looking to upgrade their skills on IPv6 then attending the 3 day Implementing IPv6 course would certainly help. By the end of this course you will be able to:

Plan for IPv6 addressing
Analyse IPv6 packets
Plan a migration strategy for IPv6
Configure PCs and routers for IPv6

A shorter 2 day course exists - IPv6: An Introduction. This course provides a technical overview of the aspects of IPv6 and the differences with IPv4.

For further details about IPv6 training or details of any of our technical IT courses then please contact us
Bookmark and Share
0 comments