Formula
436 Stories
CIOs: How to innovate during a recession
Insight perspective Downturns are no time for businesses to sit still, says an academic. Here's a plan for nurturing new ideas in any economic climate.
Tags: R&D, Innovation, E-learning, IT Budget, Investment, CRM, Innovation, CIO, recession, strategy
A quick method for counting Access records in a form
Techguide There are several ways to count the records in a form's recordset. In fact, Access forms display the record count by default.
Tags: Microsoft Office, Method, File, Tool, Tools Menu, Microsoft Excel 2007, File Menu, Microsoft Excel, Microsoft Access, dialog box
Google bringing pay-per-view to YouTube
News Professional content producers rejoice: Google plans to sell YouTube videos with micropayments and subscription services, CEO Eric Schmidt said Thursday.
Tags: Budgeting/cost control, Video, Sony Pictures, Google Inc., micropayment, Advertisement, YouTube Inc., payment, CEO, financial
Nudge paragraphs in a Word document
Techguide Sometimes you need just a little more space before a paragraph. You have to update the style to reflect a little more space before or after each paragraph.
Tags: Microsoft Office, Formula, Microsoft Corp., user-defined function, Cell, Microsoft VBA, Ingersoll-Rand, performance, keyboard, Microsoft Excel
Copy hundreds of rows of Excel formulas in three steps
Techguide Copying formulas in Excel is relatively simple, unless you need to copy down through dozens or even hundreds of cells. Here's a foolproof trick to get it done.
Tags: Microsoft Office, Cell, Real Estate, Survey, Microsoft Excel, toolbar, Microsoft Access, dialog box, window, Microsoft Visual Basic
Gunning for an elephant in Silicon Valley
News Tiny Arista, started by a Sun co-founder, is challenging Cisco with superfast networking gear.
Tags: Data Management, Database management, Data warehousing/business intelligence, Google Inc., Hewlett-Packard Co., Equinix, software, network, Andreas Bechtolsheim, Cisco Systems Inc.
IDG reinvents print media with online ad network
Insight
news analysis Publisher breaks fresh ground by selling ads for other new media properties.
Tags: Business Strategies & Functions, Online Advertising, Survey, International Data Group, ad network, Web Site, Web
Quickly delete every nth row in Excel
Techguide Susan Harkins explains how to use AutoFilter to delete specific rows in a worksheet.
Tags: Microsoft Office, Row, Column, MsgBox, Microsoft Corp., OrderID, Microsoft Word Override Word, Goto, Clear, Microsoft Excel
Calculate a conditional running total in Excel
Techguide A straight running total may be all you need to stay on top of a series of Excel values but sometimes, you have to accommodate special conditions to get useful results. Here's how.
Tags: Microsoft Office, Value, Graphics, PowerPoint Presentation, Microsoft PowerPoint, Microsoft Excel, JPEG, DPI, Microsoft Office, Microsoft Word
Consider alternatives to RDBMS
Techguide Applications are far too complex to force into the inherent limits of the relational database management systems model. Justin James encourages developers to explore their options.
Tags: Databases, Database management, Software engineering/development, RDBMS, database management system, Tool, Storage, Developer, Justin James, Programming
Eee PC maker Asus goes gadget
News Taiwanese company finds itself smack in the middle of a transition from components maker to serious contender in PCs and accessories. Could Asus could be an Acer in the making?
Tags: Components, Consumer Technology, Cellular phones, Music devices, Smart phones, Acer Inc., Motherboard, Video, Touch Screen, ASUS
Create a watermark using a Clip Art Gallery image
Techguide You can use the Printed Watermark dialog box to add a custom watermark to your document, but Word also lets you create a watermark from any graphic object by copying the image into the Header window.
Tags: Microsoft Office, Microsoft Corp., C, clip art, font, Microsoft Excel, Microsoft Word 2007, Microsoft Access, spreadsheet, Microsoft Office
Hide the Ribbon programmatically in Access and Excel 2007
Techguide All of the Office 2007 applications sport the infamous Ribbon. Unfortunately for developers, the Ribbon object isn't as easy to control as its earlier counterpart, the command bar object.
Tags: Microsoft Office, Microsoft Corp., Mouse, Microsoft VBA, Microsoft Excel 2007, software, Microsoft Excel, Microsoft Word 2007, Microsoft Access, spreadsheet
How to use the At and Ln indicators in Word's status bar
Techguide At and Ln are used in automating special format requirements. Here's what you need to know.
Tags: Microsoft Office, Form, Cell, Database, Microsoft VBA, File Menu, Microsoft Excel, Microsoft Access, window, spreadsheet
Spot invalid imported data with help of custom Excel function
Techguide Anytime you have to manually review worksheet data to look for errors, something can slip through. Here's a handy safety net: a user-defined function that will flag one type of invalid data.
Tags: Microsoft Office, Animation, ALT, Microsoft PowerPoint, Microsoft Excel, dialog box, Microsoft Office, Microsoft Word
