Windows Newsletter #211

October 30, 2009 by admin · Leave a Comment

Welcome to edition #211 of my fortnightly Windows Newsletter !

MAIN TOPIC: Microsoft Excel

I hope you get something out of the articles and please do leave a comment below with any suggestions for the next Windows newsletter I am publishing on the 13th November 2009.

Currently I am planning the main topic to be Microsoft Word…

——————————————————————————————————————–

# Understanding Excel Dates and Times

Most Excel users have, at some time, entered dates and times into their spreadsheets, but relatively few users fully understand the way that Excel stores times and dates. This can often lead to confusion, and it prevents users from benefiting from a whole range of useful operations and formulas involving Excel dates and times. Read more…

www.updatexp.com/understanding-excel-dates-and-times.html

——————————————————————————————————————–

# The Excel IF Value

One of the MOST POWERFUL features of Excel is the use of IF functions. Understanding this use of the IF Value will take you beyond what the majority of most users of Excel will ever achieve. Read more…

www.updatexp.com/excel-if-value.html

——————————————————————————————————————–

# Excel 2003 Vs Excel 2007

If you are a regular Excel 2003 user, you will probably have recently become aware of increasing numbers of people using Excel 2007. You may even have been sent Excel 2007 workbooks and had problems opening them. Whatever the case, it is likely that you will, at some point, consider switching to Excel 2007. But what are the main benefits of Excel 2007 vs Excel 2003, and how much effort will be involved in making the switch?

www.updatexp.com/excel-2003-vs-excel-2007.html

——————————————————————————————————————–

# Calculate the Coefficient of Variation in Excel

Microsoft Excel is a powerful tool for crunching statistics. You may want to learn how to calculate the coefficient of variation, which is simply the standard deviation divided by the mean. Read more…

www.updatexp.com/calculate-the-coefficient-of-variation-in-excel.html

——————————————————————————————————————–

# How to Wipe and Clean Excel Spreadsheets Thoroughly

Given the increasing availability of large amounts of data, Excel users are now processing larger and larger data sets within individual files (or workbooks, as they are called in Excel). In addition, people may use the same file over and over again over a period of months or even years, adding, moving, changing and deleting data on a weekly or even daily basis. These, among other factors, can lead to the need to effectively wipe and clean a spreadsheet (or a range of cells). Read more…

www.updatexp.com/wipe-clean-excel-spreadsheets.html

——————————————————————————————————————–

# 5 Excel Mortgage Amortization Formulas

Here are 5 Excel mortgage amortization formulas. (note: see the Variable Key below to understand the meaning of each variable used in these formulas). Read more…

www.updatexp.com/5-excel-mortgage-amortization-formulas.html

——————————————————————————————————————–

# Microsoft Excel 2003 – Official Help and How-to

http://office.microsoft.com/en-us/excel/FX100646961033.aspx

——————————————————————————————————————–

# Microsoft Excel 2007 – Official Help and How-to

http://office.microsoft.com/en-us/excel/FX100646951033.aspx

——————————————————————————————————————–

Filed under: Windows Newsletter
Tagged:

Windows 7 Launches TODAY

October 22, 2009 by admin · Leave a Comment

Its finally here!

Windows 7 has launched TODAY.

There were Windows 7 Launches and Press events around the world yesterday – I was privileged to attend the one in London!

You can discover more about Windows 7 here:

http://www.microsoft.com/windows/windows-7/default.aspx

and

http://www.microsoft.com/windows/windows-7/what-is-windows-7.aspx

Here is Microsoft CEO Steve Ballmer talking about Windows 7 on launch day:

Regards

Marc Liron – Microsoft MVP

Filed under: Windows Newsletter
Tagged: windows 7, windows 7 launch, Windows Newsletter

Windows Newsletter #210

October 2, 2009 by admin · 1 Comment

Welcome to edition #210 of my fortnightly Windows Newsletter !

I hope you get something out of the articles and please do leave a comment below with any suggestions for the next Windows newsletter I am publishing on the 30th October. (A little later than normal!) Currently I am planning the main topic to be Microsoft Excel…

——————-

Microsoft XP Mode RTM

Microsoft has released Windows XP Mode to manufacturing on October 1, company officials said, and it will be generally available on Microsoft.com on October 22, the launch day for Windows 7.

http://blogs.zdnet.com/microsoft/?p=4133

Microsoft’s NEW Data Centre in Dublin

This photo gallery offers a look inside the new Dublin facility, offering a closer look at the design innovations driving its efficiency, including a “free cooling” system that uses outside air to cool the data center, and a server pod design that employs hot aisle containment to support warmer operating temperatures inside the server space.

http://www.datacenterknowledge.com/inside-microsofts-dublin-mega-data-center

Watch TV on the Internet

With Satellite Direct, you get unlimited 24/7 access to over 3,500 channels. That’s thousands more than cable TV, including dozens of hard to find international channels. and NO SUBSCRIPTION!

http://www.updatexp.com/watch-tv-on-the-internet.html

Sheraton Tries Windows 7 Touch Technology Out on Customers

One of the earliest adopters of Windows 7 touch-screen machines is Sheraton Hotels, which three weeks ago installed HP TouchSmart computers running Windows 7 in its Link@Sheraton workstations. These recreational spaces are in most Sheraton lobbies and contain comfortable chairs, tables and computers.

http://news.idg.no/cw/art.cfm?id=CE466C09-1A64-6A71-CE870B4D4AAF906E

Microsoft SongSmith

Microsoft SongSmith is a musical accompaniment application for Windows, launched in early 2009. Read more here and watch Microsoft’s excruciatingly yet hilarious video for the software!!!:

http://blog.marcliron.com/microsoft/microsoft-songsmith

Windows 7 DVD Maker

Microsoft have updated the DVD maker in Windows 7. For most users they will not need to purchase additional software as the DVD maker will meet their needs to create DVDs for playback on PCs or stand alone DVD players. Read more here:

http://www.win7articles.com/windows-7-dvd-maker.html

Adobe Reader Security Updates

Adobe have released 29 security patches for their Acrobat reader and Adobe Acrobat products. As these are critical it is important you have the latest versions installed. Read more here:

http://blog.marcliron.com/security-issues/adobe-reader-october-security-update

Microsoft Outlook Connector

Outlook Connector provides a free solution for managing your Windows Live Hotmail e-mail and contacts from within Outlook. With the new release of the Outlook Connector, you can connect your Windows Live Hotmail account in Microsoft Office Outlook 2007 or Outlook 2003 free of charge. Read more here:

http://office.microsoft.com/en-gb/outlook/HA102225181033.aspx

Update a driver for Hardware that isn’t Working Properly

If you have a hardware device that isn’t functioning properly, or you’re installing a program or game that states it requires newer drivers than you currently have installed, you should check Windows Update for updated drivers. You might also want to set Windows Update to check automatically for recommended driver updates.. Read more here:

http://windows.microsoft.com/en-us/windows-vista/Update-a-driver-for-hardware-that-isnt-working-properly

Windows 7 Upgrade Advisor 2.0

Download and run the Windows 7 Upgrade Advisor to see if your PC is ready for Windows 7. It scans your hardware, devices, and installed programs for known compatibility issues, gives you guidance on how to resolve potential issues found, and recommends what to do before you upgrade. Read more here:

http://go.microsoft.com/fwlink/?LinkId=161223

Office Live

Online file sharing gives you the ability to: Access and share files from anywhere, Simplify online collaboration, Store up to 5GB online, Work with programs you know—Word, Excel, PowerPoint.. Read more here:

http://www.officelive.com

See you on the 30th October 2009 for the next newsletter.

Enjoy!

Kind Regards

Marc Liron
Microsoft MVP – Windows Desktop Experience
2004/2005/2006/2007/2008/2009

Filed under: Windows Newsletter
Tagged: Windows Newsletter