UPDATES FROM CURRENT ISSUE

• Use array constants to store static values so you can save time--and sanity! • Inject a little style into your worksheets without hours of formatting • Pinpoint data in an overwhelming data table -- no formulas necessary! • Check out a new way to perform an old VBA trick • Ensure that your email addresses follow the correct format • Squinting to read your comments? Change your default comment box text • Print only the data you want to include (2000/2002/2003/2007/2010) • Work around a common error -- and keep your comments! (2000/2002/2003/2007/2010)

Take a Free Test Drive

6 COMPELLING REASONS WHY YOU MUST JOIN ExcelSkillsSociety

Inside Microsoft Excel
You'll get, every month, a copy of the industry-trusted, Inside Microsoft Excel

Excel Spreadsheets
Simplify your business and personal tasks with our spreadsheets

Excel Dashboards
Calculate and report on complex data just by entering figures

Excel Stock Technicals
Stay a step ahead of the yo-yo-ing stock market with our technical analyzers

Excel Beginner Tutorials
Are you a beginner? Well, we've got over 200 basic tutorials for you

Access Beginner Tutorials
Are you an Excel expert who wants to move to Access? We've got Access covered too

Excel Templates

Adobe Acrobat Reader
(required to view PDFs)

Inside Microsoft Excel - Archives for year 2004

Browse Library:
2013|2012|2011|2010|2009|2008|2007|2006|2005|2004|2003|

Inside Microsoft Excel - December, 2004 Issue

Leverage data from multiple files with hyperlinks

Create stylish buttons to launch your hyperlinks

Create random number sets with worksheet functions to make realistic predictions

Automatically apply correct group borders when you change a list's sort field

Use Excel to determine how strongly data sets affect each other

Breaking down the correlation coefficient formula

Quickly size columns and rows to fit data (97/2000/2001/2002)

Inside Microsoft Excel - November, 2004 Issue

Visually group list items with formatting that adapts to your data

Measure the standard deviation to put a data set's average in perspective

Using VAR and VARP to measure distribution within a data set

View and edit remote worksheet areas with the Split feature

Forecast and test hypotheses using the Random Number Generation tool

Incorporate custom formats into the default new workbook template

Prevent startup Excel macros from running (97/2000/2001/2002)

Freeze columns and rows to keep data in context

Inside Microsoft Excel - October, 2004 Issue

Enhance worksheet form usability with VBA and combobox controls

Easily compare multiple stock attributes at once using Excel charts

Make educated generalizations about a large dataset using Excel's Sampling tool

Use custom calculations to alter how your PivotTable data is summarized

Maintain consistency between AutoShapes in an Excel worksheet (97/2000/2001/2002)

Inside Microsoft Excel - September, 2004 Issue

Add highly customized dropdown lists to worksheets with ActiveX controls

Which dropdown solution should you use?

Use the FREQUENCY function to create histograms that update with your data

Controlling whether Excel updates formula results automatically

Easily identify top or bottom records in a PivotTable using AutoShow

Preventing data in the middle of a sheet from printing

Removing unnecessary smart tag indicators (2002)

Inside Microsoft Excel - August, 2004 Issue

Create histograms in Excel to examine frequency distributions

Tips and tweaks for improving histogram readability

Express yourself quickly and correctly with AutoCorrect

Add dropdown list controls to worksheets to create efficient data collection forms

Advantages of using combobox controls for dropdown lists

Giving Excel the go-ahead to run macros on your system

Quickly size columns and rows to fit your data (97/2000/2001/2002)

Inside Microsoft Excel - July, 2004 Issue

Use in-cell dropdown lists for efficient and accurate data entry

Using shading to represent intensity when comparing data values

Explain and emphasize data in attractive ways using callout AutoShapes

Comparing Excel's annotation tools at a glance

Formatting callouts, comments, and other shapes to get exactly the look you want

Referencing cells to build COUNTIF and SUMIF criteria

Adjusting the field width in Excel forms (97/2000/2001/2002)

Inside Microsoft Excel - June, 2004 Issue

Use custom lists to eliminate repetitive data entry and meet unique sorting needs

Importing data containing numeric values into a custom list

Present and compare data with compelling visuals using pictographs

Straighten out circular references to fix broken formulas

Use formulas to calculate ages in relation to the current date

Fill a cell with characters regardless of its size (97/2000/2001/2002)

Inside Microsoft Excel - May, 2004 Issue

Grab attention and create an impact when presenting data using 3-D charts

Get the latest Excel patches to squash bugs and close security holes

Take advantage of variable data to create flexible lookup formulas

Use Excel spreadsheet formulas to determine your company's break-even point

Sorting PivotTable items to present data in a meaningful order

Use conditional formulas to fill gaps in data

Set up custom headers for chart objects (97/2000/2001/2002)

Inside Microsoft Excel - April, 2004 Issue

Create quick mini charts and pictographs with fonts and formulas

Construct your own character map

Six easy date-labeling macros to format worksheets faster

Ensure PivotTable accuracy by using the right refresh techniques

Creating named formulas with VBA and building dynamic range references

Scale sheets to a variable length or width (97/2000/2001/2002)

Inside Microsoft Excel - March, 2004 Issue

Manipulate a single criterion to return multiple values from a lookup table

Change a chart's data orientation without rearranging worksheet data

Automatically close a workbook after a set period of user inactivity

Simplify comparison tasks by synchronizing worksheet windows

Easily convert uppercase text to mixed case

Keep formula details hidden from users (97/2000/v. X/2002/2003)

Inside Microsoft Excel - February, 2004 Issue

Quickly reveal a consolidated result's details when you need more than a summary

Office 2003 service pack now available

Tackle tasks faster: Use templates to reduce workbook setup time

Quickly access online workbook templates

Merge cells without losing any data

Print a worksheet using portrait and landscape page orientations simultaneously

Switching between grid and line borders (2002/2003)

Inside Microsoft Excel - January, 2004 Issue

Build an interactive table of contents to simplify navigating among worksheets

Take advantage of property enhancements to streamline hyperlink creation

Patch Excel for correct calculations and smoothly running systems

Use the right reference to prevent calculation mistakes in copied formulas

Summarize and analyze data from several ranges without complex formulas

Overriding Excel's default comment box appearance

Searching for text stored in cell comments (97/2000/2001/2002)

Browse Library:
2013|2012|2011|2010|2009|2008|2007|2006|2005|2004|2003|

Your Name: *
Email Address: *
Phone Number: *	(i.e.: xxx-xxx-xxxx)
Company Name:
Your Question/ Query: *
Type verification image: *

Have a query? Let our experts guide you!

Inside Microsoft Excel - Archives for year 2004