Excel

Review: Add more operations to Excel with Solver for Excel 2011 for Mac

Mac users with Excel may want add-on applications for more functionality. Solver for Excel 2011 for Mac integrates well into the existing Excel program and performs additional operations on spreadsheet data.

The program is available for free and is actually included in later versions of Microsoft's Excel spreadsheet program for Mac. Solver for Excel 2011 for Mac downloads and installs directly onto the Excel program without any problems or user input required. After opening Excel, the user must go to the add-in area and select the Solver program. It then imports and installs a button in Excel's Data … Read more

ExcelReader read MS Excel file 1.06 Review

Smartphones and tablets are standard-issue in the business world, but they don't come with great Office software. This software, however, gives your smartphone the magical ability to read Excel spreadsheets from your phone. That is, if you can see through the numerous ads.

This is a reader app, which means it doesn't let you make any edits to the documents you read. The app doesn't actually work with the .xls format in Excel; instead in converts Excel files to PDF format to display them. That means you'll end up with two copies of the file, with … Read more

My Google spreadsheet fail

I'm a cloud-computing, Chrome OS fanboy for the most part. But today was one of of those days I was glad to have old-school Mac and Windows PCs lying around my home office.

I'm no power user, but Google Docs suits me for word processing, while Google Sheets works fine for creating spreadsheets. However, when it comes to importing and editing files from the incumbent power, Microsoft Office, Google just isn't meeting even my low-end needs.

Google handles such documents -- in either the older .doc and .xls formats, and the newer .docx and .xlsx formats -- … Read more

Help! My program is truncating my numbers!

If you use popular computational programs such as spreadsheet workhorses Microsoft Excel and Apple Numbers, you might run into an issue in which, when using large number values, the system will appear to truncate the values of numbers entered.

For instance, if you open Excel and enter the value "12345678901234567890" into a cell, the program will change this to "12345678901234500000," where every value past the 15th character is set to zero. This happens in Apple's Numbers spreadsheet and other programs as well.

While the significance of the last numbers is perhaps questionable, it does limit … Read more

Bing rolls out five apps for Office 365 and Office 2013

Microsoft launched five new free Bing apps for Office 365 and Office 2013 today. These apps are geared toward integrating work templates with search functions. The apps include Bing Finance for Excel, Bing Maps for Excel, Bing Image Search for Word, Bing News Search for Word, and Bing Dictionary for Excel and Word.

The software giant released its 2013 version of Office and its subscription-centric version of Office -- Office 365 Home Premium -- just this week. The latter of these two products is downloadable and can be locally installed on versions of Office 2013. Users are charged annual or monthly fees … Read more

Microsoft serves up 60-day trial version of Office 2013

People who want to take Office 2013 for a spin can download a 60-day evaluation edition.

The version available is the full Microsoft Office Professional Plus 2013 suite, which includes Word, PowerPoint, Excel, Outlook, OneNote, Access, Publisher, and Lync. The software contains all the features in the paid edition, so you won't miss out on anything.

You will need a Microsoft account in order to access the download page, but otherwise there are no strings attached.

Here's how you can grab the free trial version:

Head over to the Office Professional Plus 2013 download page on TechNet. Click … Read more

Microsoft Office for iOS, Android could debut early next year

iOS and Android users may finally see a mobile version of Microsoft Office designed for their devices.

Citing "several sources close to Microsoft's plans," the Verge said today that the new apps are set to pop up early next year.

Office Mobile, as it's dubbed, would let Microsoft account users view Word, PowerPoint, and Excel files on their mobile devices. But, the Verge added, editing the documents would require an Office 365 subscription. The apps would reportedly provide basic editing functionality but nothing close to that of their desktop counterparts.

Last month, a press release from … Read more

Office 2013 Web Apps final version now live on SkyDrive

Microsoft's Office 2013 Web Apps suite is now a final and official part of SkyDrive.

The online Office suite has been available for SkyDrive users since July. But it's been in a customer preview mode still being tweaked by Microsoft. A tweet yesterday from Omar Shahine, a SkyDrive group product manager, confirmed that the final edition is now live.

SkyDrive users who create or open a Word, Excel, PowerPoint, or OneNote file will see it pop up in the completed 2013 edition of Office Web Apps. Opening a file created under the previous version triggers a message that … Read more

Handy loan calculator for Excel

Loan Amortization Schedule for Excel is, no surprise, an XLS file that has loan amortization formulas embedded in it. Distributed as a ZIP file with the XLS sheet and a couple of text files (release notes and license agreement), there's no installation process to follow. Just open the XLS file with Excel (or compatible program) and you're good to go.

The layout of the first sheet is simple: space at the top for loan mount, interest rate, term, and a few other details like payment frequency and compounding period. You just enter your information to see the monthly … Read more