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 ...
In this white paper, renowned Project Portfolio Management PPM luminary, and former PMI President and Chairman, Harvey Levine discusses the newest approaches to Demand Management, and how you and your company can easily manage, evaluate, and execute on your resource demands. After reading this white paper you will have a...
Whenever I migrate to a new PC it happens more often than you might think, I immediately install the following five programs. I can't live without them, and neither should you. Copernic Desktop Search I don't know why desktop-search utilities have all but vanished, but thank goodness Copernic...
Zoho continues to one-up Google Docs. (Actually, they're more like four or five "up" at this point.) Zoho Sheet, the company's Web-based spreadsheet, just added over a dozen new features, including support for Visual Basic macros the same kind used in Excel and pivot tables/charts (which are already supported in...
"YouTube for documents" service Scribd just unveiled a fancy new viewer. It's called iPaper, and it works like a PDF viewer for embedded documents. All you do is upload a PDF, Word file, Excel spreadsheet, PowerPoint presentation, or another supported file format, then copy the iPaper embed code to your...
Nowadays there is a demand for data analysts in the market, even more than that of programmers and software developers. The demand for data analysts is very high all across the United States. To be an ideal candidate for the job of data analyst, you need to have knowledge and...
This paper provides readers and more especially business managers with an overview of moving average, exponential smoothing, trend analysis, and linear regression approaches to forecasting. The authors then provide specific examples for each approach and the Excel formulas necessary to develop effective forecasts. This is an important contribution to the...
Managing employee time and attendance in a complex working environment is a challenge that all businesses face on a daily basis. The larger the company's staff and resources, the harder it can be to manage everyone's accountability efficiently. Over the years, various methods of reporting employees' work time have evolved....
Ready to start your business? Whether an e-commerce merchant, manufacturer, retailer, wholesaler, or service firm, all businesses have one thing in common: What price should be charged to make a profit and be competitive? NeoPrice will compute product or service prices. You enter the numbers and NeoPrice tells you the...
You already know that you can use mini-spreadsheets in your Word documents through the use of Word's table feature, but tables don't come close to a replacement for the raw power of Excel. Instead of using Word's restrictive table feature, you can integrate all of the features of an Excel...
Keyboard shortcuts can shave a surprising amount of time off the process of performing various Excel tasks. This list includes all the basics, along with those 'I know there's a way to do this more quickly' shortcuts you can never quite remember. Most people have a small set of...
To effectively mitigate and manage the factors that are likely to be detrimental to a project, you need to get a handle on the degree of risk they represent. This calculator will help you identify and measure the impact of possible risk factors. Experienced project managers understand...
Cyscom e-Marketing accelerator solution bridges the gap between Microsoft Office applications such as Excel and Outlook that store customer information and sales and product data. By providing a single integration point of data to Microsoft Office applications, the Information Worker is empowered with smart workspaces to collaborate and manage key...
This paper will provide an overview of the LHP Launch Control Panel, discuss typical analysis results, and provide some guidelines on bracketing the LHP performance for stochastic phenomena such as evaporator core state. In addition it will provide information for the advanced user on how to further customize the tool...
This paper describes a small slice of a larger on-going effort to satisfy current and future demands for integrated multidisciplinary tools that can be highly customized by end-users or by third parties. Specifically, the ability to integrate fully featured thermal/fluid simulations into Microsoft's Excel and other software is detailed. Users...
"Today?s researchers are very interested in predicting the future purchasing patterns of their customers, which can then serve as an input into ?lifetime value? calculations. Among the models that provide such capabilities, the Pareto/NBD ?Counting Your Customers? framework is highly regarded. But despite the respect it has earned, it has...
Positive displacement PD flowmeters are the workhorses of today's flowmeter world. They perform many important flow measurements most people take for granted. For example, they are widely used for metering both water and gas in residential, commercial, and industrial applications. Chances are good the flowmeter that measures how much water...
If you've taken on a small to midsize project that doesn't warrant a full-scale plan in Microsoft Project, download this Excel spreadsheet template sent in by a TechRepublic member for quick and easy project management.
Excel's DATE function is essential for performing calculations using dates, but it doesn't account for weekends or holidays. Download this sample spreadsheet that uses Excel's WORKDAY function to consider only business hours.