excel

Fri
29
Jan
Dennis Faas's picture

How to: Convert Quattro Pro files (and more) to Excel Format

Infopackets Reader Howard R. writes: " Dear Dennis, I have some really old family Quattro Pro spreadsheets from 1994-98. I would like to be able to view these spreadsheets on my Windows 10 system, and if possible, convert the Quattro Pro files to ... Excel files. The Quattro Pro files are using the .WB1 file extension. While the current version of Open Office can read .WB2 files, it won't read these .WB1 files. Do you know of a program that can read and convert the .WB1 files to Excel? I look forward to hearing from you. " My response: After researching Howard's question, I suggested he try ... (view more)

Tue
22
Sep
John Lister's picture

MS Office 2016: Features and Pricing Summary

Microsoft Office 2016 goes on sale today (September 22, 2015). Here is what's new and how it fits into the new Windows 10 setup, with cloud and collaboration the key focus. How much does Office 2016 cost? When it comes to cost, there are two options ... for Office 2016. The first is as an outright purchase, which is $149 for the "Home & Student" edition and $229 for the "Home & Business" edition. In this scenario, MS Office is installed on the computer as with past editions. The only updates are security fixes to the program. (Source: venturebeat.com ) The second ... (view more)

Mon
05
May
Brandon Dimmel's picture

MS Office No Longer Essential at Work: Report

A new report finds that fewer business workers are using Microsoft's Office software package. It's also suggested that many firms are wasting money by shelling out thousands of dollars in licensing fees each year in order to use the software. The ... report comes from online application analytics firm SoftWatch, and is based on a three-month study involving 51 companies and roughly 150,000 employees. Most Workers Only View Documents Using Office SoftWatch's major finding suggests that roughly seven in ten workers are not relying on any one of Microsoft's various Office ... (view more)

Wed
15
Apr
Dennis Faas's picture

23 Security Fixes Just Released: Experts Astounded

Microsoft's Patch Tuesday came and went yesterday, bringing 23 fixes for a number of issues with its popular Office programs Excel and Word. At least several of these have been marked critical and most users should certainly consider the download. ... (Source: theregister.co.uk ) The most critical of the patches fixes an Excel flaw that could potentially allow a hacker to take remote control of an unpatched system. If an unprotected user opens a malicious and specially crafted Excel file, they could find their computer controlled by someone else effectively exploiting something called an ... (view more)

Thu
19
Mar
Dennis Faas's picture

Ashampoo Office 2008 Review

Update 2011/06/30: Links updated for our readers: save 42% off the retail price of Ashampoo Office 2008! A full 30 day money back guarantee is offered if you're not completely delighted with this marvelous program. Proceeds from this sale support ... our web site and staff of writers. Details at the very bottom of page . Offer ends July 14, 2011 at 11:59PM EST! The full review of Ashampoo Office 2008 is below. Quick! What's the name of the software you use most often to write letters, do financial calculations, create presentations, and all the rest? If you're like 95% of people using personal ... (view more)

Fri
06
Mar
Dennis Faas's picture

Microsoft to Patch Critical Flaw, Still no Excel Fix

Microsoft is currently readying another slew of fixes for Windows operating systems dating all the way back to 2000. Unfortunately, the software giant has still not yet addressed an Excel security hole that raised eyebrows over a week ago. Although ... Microsoft is remaining quiet about the fixes for its upcoming patch, the company has revealed that at least one issue is considered "critical" and two more have been classified as "important." In other words, most business and home users will want to pay attention this coming Tuesday, March 10, when more details regarding the three Security ... (view more)

Tue
26
Aug
Dennis Faas's picture

Create a Macro in MS Excel Using MS Visual Basic

This is a different method for creating a macro in MS Excel 2007. You can use this method if you want to write your own script or if you want to copy and paste a part of another macro into an existing macro. You can also use this method to copy and ... paste a new macro. Follow the steps below:If the Developer tab is not available, do one of the following to display it: Click the Microsoft Office Button, and then click Excel Options. In the Popular category, under Top Options for working with Excel, select the Show Developer tab in the Ribbon check box. Click OK. To set the security level ... (view more)

Wed
18
Jun
Dennis Faas's picture

Canceling a Command in MS Excel

If you start to perform a command or action within MS Excel, you may sometimes find that you did it by mistake or want to cancel it for whatever reason. To accomplish this, the general rule is to click the ESC key. This should cancel any command or ... action that Excel is processing. You can also use this to close just about every dialog box that could possibly pop up in MS Excel. (view more)

Wed
28
May
Dennis Faas's picture

Converting Dates in MS Excel

A reader asked if there was any formula in Excel that would convert a date shown in the European format of day-month-year to the U.S. version of month-day-year. Technically, it may not be necessary to do this. Excel maintains dates as numeric values ... and displays them using various formats. If the dates are numeric values in your worksheet, then you can simply change the format and the dates will be displayed in the U.S. format. The day you see in a worksheet could instead be a text value rather than a numeric value. To see if the date is truly an Excel date or text value, you can change the ... (view more)

Fri
09
May
Dennis Faas's picture

Excel Can E-Mail Your Weekly Reports For You!

Many times, in an office setting, you have an Excel spreadsheet that has to be sent to different departments on a weekly basis. Even if you have a distribution list setup in MS Outlook, it still takes some time to setup your e-mail and proof it ... before sending it out. Why not let MS Excel do it for you? Follow the steps below to lighten your workload: Launch MS Excel if it is not already open. Open the workbook containing the report you want to send. Click ALT + F11. The Visual Basic Editor will open. In the Project-VBA Project pane, double-click ThisWorkbook. Go to Insert | Procedure. Click ... (view more)

Pages

Subscribe to RSS - excel