Ctrl
205 Stories
Determine the sum of sales for a particular day using one Excel formula
Techguide You can build an Excel formula that makes it easy to track sales. Here's how.
Tags: Microsoft Office, Frame, Document, Animation, Frown, Smile, Sales, Property, F5 Networks Inc., Figure
Space controls evenly across an Access form
Techguide Access offers a handy command that makes it easy to give your forms a more polished look. See how equally spacing controls can improve the effect.
Tags: Building Block, Document, Feature, Goto, F5 Networks Inc., Figure E, Figure B, Figure C, Figure D, Microsoft Excel
Add information from related tables to your Access totals queries
Techguide Totals queries can be a little limited in the information they include. Here's a trick that will make them a little more useful.
Tags: Microsoft Office, Microsoft Corp., Field, Products Tests, Database, database window, product id, Design, Microsoft Excel Use Excel, Microsoft Word 2007
10+ lesser-known shortcuts for formatting Word text
Techguide Some common Word formatting tasks don't come with handy built-in toolbar buttons--that's when knowing a few shortcuts can be a real timesaver.
Tags: Microsoft Office, Microsoft Corp., keyboard shortcut, font, Figure C, Ctrl, keyboard, Microsoft Excel, toolbar, Microsoft Access
Use Excel's DGET function to zero in on information you need
Techguide You can save your users considerable time--and eyestrain--by setting up a handy formula that tells Excel to display a specific cell entry for them.
Tags: Microsoft Office, Microsoft Corp., Cell, Database, data entry, font, Tools Menu, Ctrl, DGET, Replace
The 10 most useful Word shortcuts
Techguide How many Word shortcuts do you remember and use on a regular basis? Fifty? Twenty? How about just 10 solid go-to shortcuts?
Tags: Microsoft Office, Positioning, Tool, Mouse, Microsoft Excel 2007, Ctrl, keyboard, Microsoft Excel, Microsoft Access, camera
Toggle between date values and serial values in Excel
Techguide When working with time and date values, it can be beneficial to know a value’s serial value. Fortunately, Excel makes it easy to take a quick peek.
Tags: Microsoft Windows, Microsoft Corp., Box, font, Ctrl, Microsoft Excel, Microsoft Word 2007, leader, toolbar, Microsoft Access
Garbage HTML: Five theories why developers write it
Techguide Garbage HTML appears to be alive and well. Is the situation hopeless?
Tags: Web 2.0, Authoring, Software engineering/development, Web sites, Tool, Developer, CSS, font, Ctrl, Authoring
Customize the Joe text editor
Techguide The Linux text editor Joe has easy-to-remember keystrokes and allows you to customize it to suit your needs. Vincent Danen tells you how to tweak the configuration file to create keybindings and map your favorite commands.
Tags: Open source, Operating systems, Command, GUI, text editor, Ctrl, Joe, Keystroke, F-keys, Linux Distribution
How to display pictures that appear to be partially hidden
Techguide Sometimes, an in-line text picture doesn't display completely--you can see just the bottom of the image. Find out what you can do to correct the problem.
Tags: Microsoft Office, Slide, Cell, Training, Microsoft Excel 2007, Microsoft PowerPoint, Microsoft Office 2007, Microsoft Excel, Microsoft Office, Microsoft Word
10+ things that are broken in Access 2007
Techguide If you switch to Access 2007, you'll encounter more than just a radical new interface--some things are just plain broken. See what you can hotfix and what you'll have to live with.
Tags: Microsoft Office, Field, Slide, Microsoft Windows Vista, Tool, shortcut menu, Microsoft VBA, Microsoft PowerPoint, printer, toolbar
Getting your Windows 7 fix in Linux with VirtualBox
Techguide VirtualBox will allow you to stretch your budget farther, test your software more securely, and train your users more safely, and more.
Tags: Open source, Innotek VirtualBox, Installation, Operating System, Virtual Machine, Microsoft Windows 7, remote access, RAM, hard drive, Microsoft Windows
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
Add sounds to your Access form events
Techguide Access lets you play a sound for any form event. Find out how to do it in this step-by-step guide.
Tags: Microsoft Office, keyboard shortcut, shortcut menu, Mouse, Microsoft Excel, toolbar, Microsoft Access, dialog box, window, Microsoft Office
Insert a line above a Word table at the top of the page
Techguide If you've ever gotten stuck trying to add text above a table at the beginning of a document, this tip's for you--and you won't believe how easy it is.
Tags: Microsoft Office, Microsoft Corp., Table, Cell, Positioning, font, Mouse, Microsoft Excel, mouse pointer, Microsoft Outlook
