Resources

134 Resources for

Microsoft Excel

Subscribe to this listing via:
RSS
Email

Did you mean Microsoft Excel 2003 (10 results), Microsoft Excel 2007 (9 results), Microsoft Excel 2002 (3 results)

BNET Resources

Three Tricks to Boost Your Excel Productivity: Even if you spend a lot of time using Excel, you may not be taking full advantage of the spreadsheet program's power. Productivity501 sheds some light on three of Excel's lesser-known, but extremely useful, capabilities. They are: Transpose copy function Validate entries to a list ...; Tags: Productivity501, Microsoft Excel, Microsoft Office, Office Suites, Software, Rick Broida; Blog posts 2008-07-03
How To Use XML In Excel 2003: One of the most powerful features of Microsoft Office Excel 2003 is one you can't really see: support for user-defined XML schemas. In plain English, that means you can add XML schemas a schema is just a structure and data to your workbooks, regardless of where the XML originated. Excel...; Tags: Microsoft Office, Microsoft Corp., XML schema, Microsoft Excel 2003, XML, Microsoft Excel, knowledge; White papers
Use An Excel Template To Help Capture New Business: The Value Analysis Calculator template is a pre-built Excel template that lets you quickly show the bottom-line impact that your product or service will have on your customer's business. The calculator calls out Benefits, Investments and Net Value over a year's time and enables you to generate and show figures...; Tags: Microsoft Office, Microsoft Corp., Microsoft Excel, ROI, benefit; White papers
How Excel Can Streamline Accounting Tasks: Business accounting practices have come a long way, thanks to technology. So have spreadsheets, the stalwart finance-tracking and analysis tool of the modern era. Whether you use spreadsheets in your business to track expenses, cash flow and inventory or to project tax and capital requirements or analyse lease/purchase options, the...; Tags: PRODUCTIVITY, Microsoft Office, Operational accounting, Microsoft Corp., spreadsheet, Microsoft Excel, analysis tool, small business, finance, tax, accounting, tool; White papers
Automating the Loan Life Cycle Process: The client, which is a leading financial services company with a diverse customer base of corporate and institutional clients, small business and retail clients, required to automate its loans systems. Infosys designed and implemented a robust, web-based IT solution to give the client more flexibility, security, efficiency and ease-of-use in...; Tags: Financial Planning, Channel management, Infosys Technologies Ltd., financial service, small business, Web, financial, security; Case studies

Using Excel Payroll Sheet to Make Payroll System Easier: Microsoft Excel is a software developed by Microsoft. It is a spreadsheet program that features an instinctive interface and highly capable calculations, which can be used with graphing tools. It has been the dominant spreadsheet used for the last decade and has continued to grow with additional features and have...; Tags: PRODUCTIVITY, payroll solutions, Operational accounting, payroll, spreadsheet, Microsoft Corp., tool, computer, software; White papers
Calculating Subtotals And Working With Levels In Excel: You can have Excel calculate subtotals or totals for portions of your worksheet data. For example, in a worksheet with sales data for three different product categories, you can first sort the products by category, and then select all the cells that contain data and open the Subtotal dialog box...; Tags: Microsoft Office, Microsoft Corp., Microsoft Excel, dialog box, sales; White papers
Creating Your Own Smart Tags In Excel: A smart tag is a button in the user interface in Excel or Microsoft Word 2002 that allows users to accomplish simple tasks or connect to the Web from within an application. Microsoft Excel provides two smart tag recognizers that allow users a convenient interface for accomplishing tasks or linking...; Tags: Microsoft Office, Microsoft Word, Word processors, Smart Tags, Microsoft Excel, Web, Microsoft Corp.; White papers
Enable Autofilter Functionality For A Protected Worksheet: By default, the AutoFilter functionality in Excel becomes unavailable when you protect part or all of a spreadsheet. If you use Microsoft Office Excel 2003 or Excel 2002, you can restore that functionality manually. If you use Excel 2000, you need to use a few lines of Microsoft Visual Basic...; Tags: Microsoft Office, Microsoft VBA, Microsoft Excel, spreadsheet, Microsoft Corp.; White papers
Repairing Corrupted Files In Excel: Microsoft Excel provides automatic recovery for a corrupted file by attempting to reopen and simultaneously repair the file. Excel identifies what it changed while repairing the file. If the repair fails, Excel again tries to open the file but instead of attempting a repair, Excel extracts cell values and formulas...; Tags: Microsoft Office, Microsoft Corp., Microsoft Excel; White papers
Using XML In Excel: Microsoft Office Excel 2003 makes it easy to import Extensible Markup Language XML data created from other databases and applications, map XML elements from an XML schema to worksheet cells, and export revised XML data for interaction with other databases and applications. Think of these new XML features as turning...; Tags: Microsoft Office, Microsoft Corp., Microsoft Excel 2003, XML-Data, XML, Microsoft Excel, XML schema, database; White papers
Make Lists In Word, Excel, And Access: Have you ever wondered which Office program to use to make a list? Word, Excel, and Access each have advantages, depending on what type of list you want to create - a text list, flat file list, or relational list. This paper will help you to understand which program is...; Tags: Word processors, Microsoft Office, Microsoft Corp., Microsoft Access, Microsoft Word; White papers
You Asked For It: Crabby's Top 5 Excel Tips And Tricks: You use Excel for analyzing data, getting data from the Web, building formulas and functions, and even creating calendars. You know that Microsoft Excel is a handy program for accomplishing all sorts of tasks. In this article you can, get the scoop on five neat little tricks you may not...; Tags: Microsoft Office, Microsoft Corp., Microsoft Excel, Web; White papers
Explore Histograms: A histogram is a chart that takes a collection of measurements and plots the number of measurements that fall within each of several intervals. You can create a histogram in Excel by using the Histogram tool of the Analysis ToolPak, an add-in module that provides a collection of functions and...; Tags: Microsoft Office, Microsoft Corp., Microsoft Excel, analysis, tool; White papers
Clarify And Emphasize Data In An Excel Chart: You can choose different options in an Excel chart to emphasize your data in different ways. For example, when you're measuring sales revenue along with number of units sold, you can add a second axis to measure a portion of values differently from another portion. This paper gives some examples...; Tags: Microsoft Office, Microsoft Corp., Clarify, Microsoft Excel, sales; White papers
Excel Shortcut And Function Keys: This paper gives various excel shortcut and function keys. This paper also gives information and explanation regarding each shortcut keys and it also explains how to use it with examples. This paper also focuses on various function keys and its usage in excel. This paper contains various combination shortcut keys,...; Tags: Microsoft Excel, Microsoft Corp.; White papers
Crabby Goes Chart Crazy With Excel 2007: Summing up large quantities of information used to be time-consuming and daunting if you were unfamiliar with how to put it all together, particularly if you had to do it with a chart. Excel 2007 has made such huge improvements in the area of charts that you may find yourself...; Tags: Microsoft Office, Microsoft Corp., Microsoft Excel 2007, Microsoft Excel; White papers
Copy Excel Data Or Charts To Powerpoint: There may be times when you want to present your Microsoft Office Excel worksheet data, or a chart that you created in Excel, in a Microsoft Office PowerPoint presentation. You can simply copy selected data or charts in Excel and then use the Paste or Paste Special commands in PowerPoint...; Tags: Microsoft PowerPoint, Microsoft Excel, Microsoft Office, Microsoft Corp.; White papers
Use Office Excel 2007 With Earlier Versions Of Excel: After you've installed Microsoft Office Excel 2007, you may want to know how you can continue working with workbooks that are created in an earlier version of Excel, how you can keep these workbooks accessible for users who don't have the current version of Excel installed, and how the differences...; Tags: Microsoft Office, Microsoft Corp., Microsoft Excel 2007, Microsoft Excel, compatibility mode; White papers
Four Ways To Publish External Data Ranges To The Web: An external data range is data from a separate source, such as a Microsoft Access or SQL Server database, that you've brought into Microsoft Excel. You can format the data in Excel and add formulas in adjacent columns to perform calculations on the data. You can publish an external data...; Tags: Channel management, Microsoft Office, Databases, Microsoft SQL Server, Microsoft Excel, Web, Web page, Microsoft Corp., database; White papers