Excel Secrets Everyone Should Know

101 Secrets of a Microsoft Excel Addict

This ebook from Francis Hayes gives you professional tools to help you get the most out of your Excel program. Any one of these secrets could be the only one that you ever need to know for Excel, but this ebook includes bunches of those tips and tricks! Just think of all of the useful information you can get from it! If you have ever been frustrated at your lack of progress in Microsoft Excel, this guide will teach you everything that you need to know to harness the powerful functions or time-saving elements of Microsoft Excel. Excel is used by offices all over the world, but so few people take the time to teach you anything important about it. Too much time is usually wasted searching the internet for tips on how to use it more efficiently Learn the best way to master Excel in this ebook!

101 Secrets of a Microsoft Excel Addict Summary

Rating:

4.6 stars out of 11 votes

Contents: Ebook
Author: Francis Hayes
Price: $9.97

My 101 Secrets of a Microsoft Excel Addict Review

Highly Recommended

I usually find books written on this category hard to understand and full of jargon. But the author was capable of presenting advanced techniques in an extremely easy to understand language.

All the modules inside this ebook are very detailed and explanatory, there is nothing as comprehensive as this guide.

Download Now

Welcome to Debian GNULinux

When bugs are found, fixes are released within 48 hours and update packages made available online. As a project, Debian relies on hundreds of volunteers to build and test the packages it includes. This means you tend to get someone who actually uses the software, packaging it and adding their own little tweaks to make it work better. Package maintainers are generally very receptive to suggestions and criticisms, taking great prideintheir work and spending countless hours making their packages excel. The great variety of packagers in the Debian system means that packages tend to be better configured out of the box, taking into account the average user's requirements and setting sensible defaults. Of course, you can still configure the software any way you like without Debian interfering with your setup. The other significant cool-fac-tor feature of Debian is an excellent and much-loved piece of updating software called apt. This handy tool makes upgrading and updating a Debian system...

Using Word Processors

If you've been using Microsoft Office applications such as Microsoft Word, Excel, and i IijiiiVaaSI PowerPoint, most files produced in those applications' native formats will work in OpenOffice.org. There are descriptions of supported office formats later in this chapter.

Using Microsoft Office Files on the

Microsoft Office programs are often used to create Web documents. All the standard Office programs (Word, Excel, and PowerPoint) have a Save As HTML option. This is convenient for quickly creating HTML documents, but Office tends to put non-standard characters in the HTML. These documents then look bad when viewed with a nonMicrosoft browser.

Need MS Windows for Reading Writing MS Word Documents

In a smaller environment, you can use OpenOffice.org suit (OO) that runs on Linux, MS Windows, Mac, Solaris (and more), with full file-level compatiblity. It can be downloaded and installed for free (no restrictions whatsoever) so nobody should really complain about the file format (some control freaks still will). Just to make sure, OpenOffice can import and export MS Word and Excel documents of reasonable complexity very well. The native file format in OpenOffice is fundamentally much better than Microsofts (plus it is non-propriatory). Feature-by-feature, OpenOffice can do almost anything MS Office can, plus some extras. Depending on whom you ask, the ease of use veries between 50 more difficult to 20 easier (measured on a sample of experienced MS Office users). Very complex documents are best transfered as *.pdf, and OO can make them on the fly.

Assessment Questions

Excel is a Microsoft Product that has not been ported to Linux. The others have all been created or ported to Linux. See the section File servers for more information. 3. C. The KDE-based Web browser is Konqueror. Netscape and Opera are excellent Web browsers, but they are not part of KDE neither is Internet Explorer. See the section Web browsing for more information. 14. C. Linux is least likely to provide excellent support for Fibre Channel because this is the newest hardware. See the section Hardware compatibility and Comparing Linux with other operating systems for more information.

Working with Open Officeorg Calc

The spreadsheet component of OpenOffice.org is named Calc, and is a very capable Excel alternative. Calc is used for storing numerical information that you need to analyze in some way. So, for instance, you could use it to help you budget month by month. It can take care of the calculations for you, as long as you tell Calc what you want it to do. Anyone with experience in Excel will feel right at home with Calc.

Business Applications

For our purposes, business applications are programs running on an individual PC that perform business functions. The top-selling software titles are loaded with various business applications. For instance, the top-selling Microsoft Office is a bundle of common business applications, including a word processor (Word), spreadsheet (Excel), and presentation software (PowerPoint).

Corel Word Perfect Office

Corel spent a lot of time making sure WP Office could read and write to Microsoft Office documents. Microsoft Word, Excel, and PowerPoint documents are imported into WP Office with little trouble. Later in the chapter, we will discuss importing and exporting MS Office files.

Using MS Office Documents with Star Office

Star Office has very good support for MS Word and Excel files. Although it may lose some of the formatting, you can almost always get a readable file by opening a Word or Excel document in Star Office. On the other hand, PowerPoint is listed as one of the supported formats, but Star Office is not always able to open PowerPoint files. To open an Excel or Word file, simply choose File - Open from the menu. Word files will appear with the familiar Word icon and Excel files will have the Excel icon in the file listings.

Calculating with Open Officeorg Calc

Another member of the OpenOffice.org office suite is the Calc program. Calc is a full-featured spreadsheet program similar to MS Excel. In fact, anything that you can do with Excel, you can most likely do with Calc. To start the program, click the OpenOffice.org Calc icon from the desktop panel (it looks like a pie chart on top of a spreadsheet) or choose ApplicationsOOfficeO OpenOffice.org Calc. You are presented with a blank document, as shown in Figure 3-11. OpenOffice.org Calc is a typical spreadsheet application. If you've used a spreadsheet program, you can soon master Calc. Many of the commands and formulas that you might have used in MS Excel also work in Calc. You can also save your spreadsheets in MS Excel format (.xls) so that you can share your files with Windows users or use them yourself on Windows PCs. term LinG - Live, informative, Non-cost and Genuine

Using Red Hat Linux as an Application Platform

Although you can get word processing programs, spreadsheet programs, graphics programs, and almost any other type of application that you want for Linux, many of the most popular applications in each category don't run well in Linux or don't run at all. For example, the latest Microsoft Office product will not run in Linux. If your company uses Microsoft Word for word processing or Microsoft Excel for spreadsheets, you could try converting files from those applications to run in StarOffice in Red Hat Linux. However, those files won't always convert cleanly.

Preparing Spreadsheets with Open Officeorg Calc

Calc is the spreadsheet program in the OpenOffice.org application suite. To start Calc, select Main Menu O Office O OpenOffice.org Calc from the GNOME or KDE panel. The Calc program displays its main window, which looks similar to Windows-based spreadsheets, such as Microsoft Excel. (In fact, Calc can read and write Microsoft Excel format spreadsheet files.) Use Calc in the same way you use Microsoft Excel. You can type entries in cells, use formulas, and format the cells (such as specifying the type of value and the number of digits after the decimal point). Figure 10-6 shows a typical spreadsheet in Calc. When preparing the spreadsheet, use formulas you normally use in Microsoft Excel. For example, use the formula SUM(D2 D6) to add up the entries from cell D2 to D6. To set cell D2 as the product of the entries A2 and C2, type A2*C2 in cell D2. To learn more about the functions available in OpenOffice.org Calc, select Help O OpenOffice.org Help from the menu (or press F1). This opens...

Anyware Office importexport filters

Anyware Spreadsheets enables you to import these spreadsheet formats Lotus (.wks, .wk1, .wk3, and .wk4) Microsoft Excel (versions 3.0, 4.0, 5.0, 7.0, and 97, .xls) Symbolic Link file (.slk) Data Interchange Format (.sdi, .dif, and .xdf) ASCII (any format) and Comma Separated Values (.csv).

Entering and formatting data

When entering and formatting data, use Calc in the same way you use Microsoft Excel. You can type entries in cells, use formulas, and format the cells (such as specifying the type of value and the number of digits after the decimal point). After you enter data into a spreadsheet, save it by choosing FileOSave As. A dialog box appears from which you can specify the file format, the directory location, and the name of the file. You've seen similar Save As dialog boxes a thousand times before. OpenOffice.org Calc can save the file in a number of formats, including Microsoft Excel 97 2000 XP, Microsoft Excel 95, Microsoft Excel 5.0, and a text file with comma-separated values (CSV). If you want to exchange files with Microsoft Excel, save the spreadsheet in the Microsoft Excel format (choose an appropriate version of Excel). Then you can transfer that file to a Windows system and open it in Microsoft Excel. Table 2-1 summarizes some of the common data entry and formatting tasks in Calc. I...

Improving Mozilla browsing

After you install the CrossOver Plugin, you see a nice Plugin Setup window that lets you selectively install plug-ins for QuickTime 6, Windows Media Player 6.4, Shockwave 8.5, Flash 6, and Microsoft Word, Excel, and PowerPoint viewers. You can also install other multimedia plug-ins, as well as a variety of fonts to use with those plug-ins.

Printing Your Document

OpenOffice Calc is a powerful spreadsheet program that also imports and exports other popular spreadsheet formats, including MS Excel. Spreadsheets are large tables where information is entered in individual cells that appear in rows and columns. They're ideal for accounting purposes and for creating data comparisons.

Spreadsheet Open Officeorg Calc

As with most of the packages that form the OpenOffice.org suite, Calc (Applications Office OpenOffice.org Spreadsheet) does a good impersonation of its proprietary counterpart, Microsoft Excel, both in terms of powerful features and the look and feel, as you can see in Figure 11-2. However, it has only limited support for Excel's Visual Basic for Applications (VBA) macros at present. Instead, Calc and other OpenOffice.org programs use their own macro language, called OpenOffice.org Basic (for more information, see http development.openoffice.org). Calc has a vast number of mathematical functions. To see a list, choose Insert Function. The list on the left side of the dialog box includes a brief explanation of each function to help you get started. Just as with Excel, you can access the functions via the toolbar (by clicking the Function Wizard button), or you can enter them directly into cells by typing an equal sign and then the formula code. Calc is intelligent enough to realize...

Proprietary File Formats

The most common proprietary file format is probably Microsoft Word's format (denoted by a .doc extension). Many businesses run on Microsoft Word if you work with such a business, you'll have to exchange Microsoft Word files. In some fields, the file formats associated with other Microsoft Office components, such as Microsoft Excel (.xls) spreadsheets are equally or more important. Although Microsoft retains tight control over these file formats, most competing programs make at least some effort to support them. Chapter 7 describes some of the Linux programs that can handle these files. In brief, OpenOffice.org and its commercial twin StarOffice do the best job with Microsoft Word files. Unfortunately, no Linux program handles these files perfectly, so you may need to resort to emulation in some cases.

Spreadsheets with Calc

The big name in spreadsheets these days is Microsoft Excel. The Excel application can be purchased individually for about 300, or you can get it as a bundle with the Microsoft Office suite of applications, starting at about 400. But as I mentioned in Chapter 5, Microsoft likes to update its Office products every three to four years keeping up with the latest versions can get expensive fast. But just like the OpenOffice word processor called Writer that I covered in Chapter 5, an OpenOffice equivalent to Microsoft Excel exists. It's called Calc, and it's 100 percent free with features galore.

Importing Existing Spreadsheets into KSpread

Linux folks like me tend to be Linux-centric, but that doesn't mean that we can completely ignore reality. When you're working with existing spreadsheets (and any other office-related documents, to be honest), the chances are pretty good that you created them using more common software packages, such as Microsoft Excel, that run on other operating systems, such as Mac OS X and Microsoft Windows. The folks who wrote and support KSpread couldn't ignore this reality either, so KSpread provides built-in support for opening Microsoft Excel spreadsheets and workbooks.

Working with Open Office Calc

The OpenOffice Calc application is an electronic spreadsheet similar in form and function to Microsoft Excel or Corel Quattro Pro. OpenOffice Calc can be used to perform mathematical calculations of all kinds. For example, a homeowner can use OpenOffice Calc to amortize a loan or maintain a personal budget, an engineer might use OpenOffice Calc for load calculations, and a pollster might use OpenOffice calc to maintain lists of statistics. Although electronic spreadsheet applications often seem awkward to users at first, they are an extremely powerful and commonplace tool in office environments. Because OpenOffice Calc can read and save files in Microsoft Excel format, users of OpenOffice Calc can exchange files with MS Office users everywhere.

Taking stock of Open Officeorg Calc

1 Open and edit Microsoft Excel files or convert Microsoft Excel files into Calc format. Calc uses an XML format and saves files with the .SXC extension. 1 Save documents in many different formats including Microsoft Excel 97 2000 XP, Excel 95, Excel 5.0, dBASE, StarCalc 5.0 (as well as 4.0 and 3.0), SYLK (an old Microsoft format), comma-separated values (CSV), and Web page (HTML).

Treating Local Mail Differently

The basic setup discussed here so far treats all mail equally, which isn't always what you want. For example, when user joe yourdomain.com sends an e-mail with a Word or Excel attachment to jennifer yourdomain.com, the attachment gets mangled and it probably shouldn't. Probably these two local users use viruschecking software and don't plan to harm each other. Don't mangle common document formats (such as Word and Excel) when the e-mail is initiated from within your own user domain. Just modify the etc procmailrc file like this From now on, when MAIL FROM is set to user yourdomain.com, Word (.doc) and Excel (.xls) attachments aren't mangled.

Getting Away from Windows

Home users typically have to concern themselves with maintaining access to their own documents. In a personal context, it might be rare for friends and relatives to send Excel spreadsheets, Word documents, and PowerPoint presentations. But over the years you may have accumulated term papers, recipes, letters to the editor, account spreadsheets, and other such documents that you'd like to be able to read and print. In most cases, OpenOffice.org applications will handle files in Microsoft formats just fine. Other Microsoft Office applications offer similar functionality. PowerPoint can convert presentations to HTML and general image formats such as JPEG and TIFF. Excel can save tab- and comma-delimited files that are easily importable into a large number of applications.

Have Open Officeorg save in Microsoft Office format by default

To make the OpenOffice.org programs default to MS Office file formats when saving, open OpenOffice.org Writer (Applications Office OpenOffice.org Word Processor) and then click Tools Options. On the left-hand side of the dialog that appears, expand the Load Save heading by double-clicking it, and click then General, which will appear beneath it. In the Always Save As dropdown list at the bottom right of the dialog box, select Microsoft Word 97 2000 XP. Then, in the Document Type dropdown list, select Spreadsheet, and once again click the Always Save As dropdown list and this time select Microsoft Excel 97 2000 XP. Repeat again, this time selecting Presentation, and selecting Microsoft PowerPoint 97 2000 XP. Once done, click the OK button.

Running Office Components

To run Excel, you can type EXCEL.EXE. PowerPoint is POWERPNT.EXE, Access is MSACCESS.EXE, and Outlook is OUTLOOK.EXE. Don't forget that these must be typed in uppercase, because uppercase and lowercase matter in Linux. Figure 28-2 shows an example of running Word under SUSE Linux.

Other Word Processors

The StarOffice productivity suite (http www.sun.com staroffice) from Sun Microsystems, Inc. is a commercial product that runs on Linux, UNIX, and Windows operating systems. StarOffice contains applications for word processing, spreadsheets, presentation graphics, e-mail, news, charting, and graphics. Like OpenOffice.org, StarOffice contains many features that make it compatible with Microsoft Office applications. In particular, it includes the capability to import Microsoft Word and Excel files. StarOffice Calc This is the spreadsheet program that comes with StarOffice. You can import spreadsheets from Microsoft Excel and other popular programs. You can work with a variety of document, spreadsheet, and image types not many commercial document types are supported yet. So you may need to import documents using other tools before you can read them into KWord. The KSpread program can open several different spreadsheet styles, however, such as Microsoft Excel and GNUmeric spreadsheets....

Importing Existing Spreadsheets into Calc

Linux folks like me tend to be Linux-centric, but that doesn't mean that we can completely ignore reality. When you're working with existing spreadsheets (and any other office-related documents, to be honest), the chances are pretty good that you created them using more common software packages, such as Microsoft Excel, that run on other operating systems, such as Mac OS X and Microsoft Windows. The folks who wrote and support the OpenOffice.org suite and OpenOffice.org Calc couldn't ignore this reality either, so Calc provides built-in support for opening Microsoft Excel spreadsheets and workbooks. For example, to open an existing Excel spreadsheet, simply select the File C Open command. By default, the file selection dialog that opens enables you to select files with any extension, including the .xls extension used by Microsoft Excel spreadsheets. Microsoft Excel (.xls, .xlsx, .xlt, .xlw, .xml) All of the common spreadsheet formats used by versions of Excel. Pocket Excel (.pxl) The...

Open Officeorg Star Office Suite

OpenOffice looks and acts very much like MS Office for Windows. This includes richness of features, large size (requires considerable amount of disk space, memory, and processor speed), and well-burried features (may require some careful mouse-clicking to access some items). OpenOffice may not be worth your trouble without at least 64 MB of physical memory the more memory the better. Open Office is very stable, although it sometimes displays weird artefacts ( ghosts ) on my screen. It has a good file-level compatibility with MS Office read and write MS Word, MS Excel and MS PowerPoint file formats. Natively, it uses a ground-breaking xml open file format the text and pictures are zipped together into one file. When I unzip the file (unzip my_file.sxv), I can extract the original pictures something MS Office cannot possibly do (with sometimes serious consequences for document management). OpenOffice does not look as sexy as some other Linux office alternatives. Yet, it is...

Simple Programming under Linux

Powerful and widely used scripting language, very popular among gurus. Perl looks cryptic yet it is quite straight-forward if you need to achieve simple tasks. Think of perl as a swiss-army knife for simple programming. Perl's syntax parallels that of the C language. Excellent implementation of the perl interpreter is available for MS Windows so you code can be cross-platform. Here is how Eric Reymond (famous Linux guru) describes perl Perl, of course, is the 800-pound gorilla of modern scripting languages. It has largely replaced shell as the scripting language of choice for system administrators, thanks partly to its comprehensive set of UNIX library and system calls, and partly to the huge collection of Perl modules built by a very active Perl community. The language is commonly estimated to be the CGI language behind about 85 of the vvlive'' content on the Net. Larry Wall, its creator, is rightly considered one of the most important leaders in the Open Source community, and often...

Cutting Copying and Pasting in vi

Jost of us are used to working with files in various application-specific formats, often identified by their file extension or a special icon on your graphical desktop. We're all familiar with the doc files produced by graphical word processors such as Microsoft Word, pdt files used by Adobe Acrobat and other PDF readers, xls tiles produced by spreadsheets such as Excel, tm tiles produced by FrameMaker, ppt tiles produced by PowerPoint, and so on. All ot these tiLes contain application data in a specific, often binary, format that lets the associated application make the best possible use ot these tiles, but which often makes them hard to use with any application other than the one that created them.

Running Microsoft Windows Applications Using Wine

Windows applications that you need to run because the virtual machine looks like an actual Windows system to the software. However, that seems like overkill when all you need to do is to edit a Word document that contains complex macros or tweak someone's n-dimensional Excel spreadsheet. Wouldn't it be nice to simply be able to run the one or two Windows applications that you need without the overhead and associated storage of a completely emulated Windows system from CodeWeavers (www.codeweavers.com). This version of Wine provides enhancements and bug fixes that enable it to run many more applications, such as the complete Microsoft Office suite, than the free version of Wine. The CodeWeavers folks are very good about working directly with the Wine community, are the leading commercial sponsor of the Wine project, and push all of their fixes into the open source version of Wine. CrossOver Office is an excellent investment if you need to run Office or other resource-intensive software...

Importing Existing Spreadsheets into Gnumeric

Linux folks like me tend to be Linux-centric, but that doesn't mean that we can completely ignore reality. When you're working with existing spreadsheets (and any other office-related documents, to be honest), the chances are pretty good that you created them using more common software packages, such as Microsoft Excel, that run on other operating systems, such as Mac OS X and Microsoft Windows. The folks who wrote and support Gnumeric couldn't ignore this reality either, so Gnumeric provides built-in support for opening Microsoft Excel spreadsheets and workbooks. For example, to open an existing Excel spreadsheet, simply select the File C Open command. By default, the file selection dialog that opens enables you to select files with any extension, including the .xls extension used by Microsoft Excel spreadsheets. Microsoft Excel (.xls, .xslx) The data format(s) used by Excel 2007 (xslx), and Excel 2003, and earlier Excel spreadsheets (xsl).

Using Open Calc for Spreadsheets

OpenOffice's OpenCalc (or Calc) application again provides numerous features that you would expect of a commercial application and is comparable with Microsoft Excel, the spreadsheet application within Microsoft Office. Some of the key features present are Data Pilot (this is similar to PivotTables in Excel) OpenCalc also supports compatibility with Excel, in its ability to load and save spreadsheets and templates in a number of Excel file formats, including Microsoft Excel 97 2000 XP and Microsoft Excel 4.x-5.0. Other interoperability features include the handling of VBA code and embedded objects (as we mentioned earlier in this chapter). There are other, more specific options that mimic the behavior of MS Excel, and help to make users with an MS Excel background feel more comfortable. One specific such option is the ability to indicate that OpenCalc's searching capability should behave in the same manner as Excel's. This option can be found in the Note the Search criteria and must...

Choosing the Right FTP Server

Vsftpd This server aims to excel at security, stability, and speed. In doing so, its developers have chosen to eschew some of the more advanced features of servers such as ProFTPd and WU-FTPD. If you don't need those features, this tradeoff may be more than acceptable. You can learn more from its website, http vsftpd.beasts.org. It's available with a growing number of Linux distributions.

Open Source Office Suites

The heart of Gnome Office is the spreadsheet, Gnumeric. This is a Gnome project designed to create a full-featured GPL spreadsheet. One of its goals is to clone the look and features of Microsoft Excel. AbiWord is Gnome's word processor. It doesn't have all the features of many of the other word processors, but it is very fast and has a clean interface. Gnu Image Manipulation Program (GIMP) was one of the first open source desktop applications available for Linux. GIMP is a photo and image retouching program similar to Adobe Photoshop. While its interface isn't quite as polished as Photoshop, GIMP is every bit as powerful. Dia is a drawing program similar to Visio. Dia is is quickly becoming the tool of choice for Gnome developers to do diagrams and flowcharts. Eye of Gnome (EOG) is a quick image viewer. It was designed to allow developers to quickly view image files without having to open them in a larger application like GIMP. Gnome-PIM provides the calendar and address book that is...

Binary Files vs Text Files

If you've worked with Windows or Linux (and before that, DOS) for any length of time, you may have a sense of the differences between files in terms of how you ''look at'' them. A simple text file is opened and examined in a simple text editor. A word processor file is opened in the species of word processor that created it. A PowerPoint presentation file is opened from inside the PowerPoint application. If you try to load it into Word or Excel, the application will display garbage, or (more likely) politely refuse to obey the open command. Trying to open an executable program file in a word processor or other text editor will generally get you either nowhere or screen garbage.

Using Star Office

The StarOffice suite from Sun Microsystems, Inc. (www.sun.com software staroffice) is a product that runs on Linux, UNIX, and Windows operating systems. Like OpenOffice.org, StarOffice contains many features that make it compatible with Microsoft Office applications. In particular, it includes the capability to import Microsoft Word and Excel files. Calc The StarOffice spreadsheet program. You can import spreadsheets from Microsoft Excel and other popular programs.

Conclusions

So which office suite for Linux is the best The answer depends on what you need, of course. If compatibility with MS Office is paramount, nothing currently beats WP Office. WP Office is also the most feature-rich office suite available for Linux. For a free office suite, it's hard to beat Star Office. It has a good set of features and good compatibility with Word and Excel documents.

Spreadsheets

The Microsoft Excel spreadsheet is the most popular package used in the Windows world. In the OpenOffice.org suite, the spreadsheet package is called Calc. Although not a direct replacement for Excel, Calc can perform most of the functions of Excel. The following sections take a look at OpenOffice.org Calc so that you can get to work.

Using Gnome Office

Gnumeric delivers on its promise to be Fast, Free, and Accurate. It will import your Excel files and should also handle most other popular spreadsheet formats (including OpenOffice.org Calc and Quattro Pro). It boasts of more than 100 functions that are unique to Gnumeric (that is, not available in Excel).

Gnumeric

Gnumeric is an impressive spreadsheet program. Similar considerations regarding importing other file types that we mentioned when discussing AbiWord apply, however. OpenOffice.org certainly seems to have the edge in that regard, although as a standalone spreadsheet, Gnumeric compares very well in terms of features with the OpenOffice.org spreadsheet, and with Microsoft Excel.

Available Software

Tip Although KDE and GNOME include their own specific software packages, they'll run fine within alternative desktop environments. For example, there's no reason why you can't run the KDE K3b CD-burning application under the GNOME desktop, or the GNOME Nautilus file manager under the KDE desktop. Working this way gives you an excellent choice of software for your system. Microsoft Excel

Office formats

OpenOffice.org opens almost all Microsoft Word .doc, Excel .xls, and PowerPoint .ppt files, as well as its own and StarOffice native formats. Working with Excel files Microsoft Excel files will usually open well in OpenOffice.org or Gnumeric provided that they don't include complex macros, in which case you may have difficulties. Basic for Applications), which is used by Microsoft Office. In general, this means that you will have to convert or rewrite the macros in an Excel workbook to make it work in OpenOffice.org.

Summarizing Calc

I used to be an Excel user, but the last time I purchased it was back in 2003 (Excel 2003, to be exact), and I really haven't found anything I needed Excel to do that I cannot do with Calc. Your mileage may vary, however. Calc is definitely full-featured, but there are many Excel power users out there who might have job requirements that Calc cannot fulfill. Your best bet is to open one of your existing spreadsheets in Calc and try it out see whether all the functions, formatting, and other spreadsheet tools you need are supported in Calc. If you're like me, you'll find that your typical spreadsheet usage is limited to multiplying, dividing, sorting, and formatting cells.

Gnumeric Spreadsheet

If you work in an office and use spreadsheets, the odds are that you need to share those spreadsheets with Microsoft Excel users. It's also quite probable that you have used Excel and that it is the spreadsheet application with which you are most comfortable. Those realities don't pose an obstacle to using Linux in your office, though, because Gnumeric is designed to be familiar to and comfortable for Excel users. In fact, unsuspecting observers have confused the two on more than one occasion. Gnumeric can import and export Excel files easily, and its options and data processing are quite comparable.

In Depth Calc

Calc is the spreadsheet component of OpenOffice.org. Like most modern spreadsheet programs, it contains hundreds of features, many of which few average users will ever use. However, it doesn't abandon its user-friendliness in the process and remains very simple for those who want to work on modest calculations, such as home finances or mortgage interest payments. In many regards, Calc is practically a clone of Excel, and anyone who has used Microsoft's spreadsheet program will be able to get started with it immediately.

Using KOffice

You can work with a variety of document, spreadsheet, and image types. Not many commercial document types are supported yet, so you may need to import documents using other tools before you can read them into KWord. KSpread, however, can open several different spreadsheet styles, including Microsoft Excel and GNUmeric spreadsheets.

Open Officeorg

The default office application for Kubuntu is OpenOffice.org 2.0. This version is the second major release of the suite that includes Writer, Calc, Draw, Impress, and Math. Each of these programs is easy to use and can help you switch from the Microsoft Office product line. In fact, the OpenOffice.org suite that can be installed on a Windows system comes on the installation CD to help you get comfortable and ready for a switch to Kubuntu. Each application corresponds to a similar application in the MS Product line. Calc is very similar to Excel, Writer is the same as Word, Impress is PowerPoint, and Base functions similarly to Access. OpenOffice.org can handle all but Microsoft Access files without problems, and the whole suite is ready for use in a corporate environment as well as for personal use.

Output plugins

The additional switches (beginning with timestamp, and ending with icode ) are formatting switches for the outputted data. Snort's alert information is generated in buckets like the timestamp of the alert, the source and destination IP addresses, and source and destination port numbers. The alert_csv output plugin can configure how those buckets appear in the comma-separated value text file, so columns and rows line up correctly when the log file is imported into another format (such as Excel or a database). The following example shows a few of the more important buckets in the example that follows. The barnyard.conf file has a complete list of the buckets with descriptions.

Index M

The case command filename 13.2.3. Filename Globbing for command 13.3.3.6. The for command mgetty package 12.5. Configuring a Dial-In Shell Server Microsoft Excel 8.1.1.1. Running Applixware Microsoft Office 97 8.1.2.2. Running StarOffice Microsoft Office for Linux 8.1. Linux Desktop Applications Microsoft Windows (see entries at Windows)