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 2006

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

Inside Microsoft Excel - December, 2006 Issue

Download

Unveil the point where your revenue exceeds your costs

Nail your project planning every time with a few essential date functions

Always creating the same PivotTable? Do it in seconds with a macro

Expand your chart's possibilities with a little filtering ingenuity

Free your PivotTable data of summary calculations

An alternative way to convert data from text to number formatting (2002/2003/2004

Inside Microsoft Excel - November, 2006 Issue

Jog your memory with a list of the criteria used to filter data

Chart statistics with a box and whisker chart even though Excel doesn't offer it

Translate your box and whisker chart into meaningful data analysis

Get around VLOOKUP's limitations by combining two powerhouse functions

Coding goes fast when you turn your to-do steps into comments

Preview a PowerPoint presentation before you open it with a clickable thumbnail

Customize chart axis labels even if they aren't in your source data (2000/2002/2003/2004)

Inside Microsoft Excel - October, 2006 Issue

Grant a formula flexible data ranges without error-prone manual changes

Make your VBA code easy to read and edit by using proper indenting

Add a group of related macros to the menu bar for quick-and-easy access

Show off your data analysis with Xcelsius interactive visual aids

Stop printing data you don't need! Show the data that's really important

Think commenting slows down your code? Think again!

Isolate your 3-D chart's data points with drop lines (2000/2002/2003/2004)

Inside Microsoft Excel - September, 2006 Issue

Create crystal clear printouts by repeating column or row headers (2000/2002/2003/2004)

Eliminate time-consuming data hunts with the VLOOKUP function

Take matters into your own hands when mail merge values don't translate correctly

Let users choose the (file) name and you choose the (file) place

Find the difference between two dates with this overlooked and underappreciated function

Key tricks to avoid getting mired in cluttered code

Double the underline in half the time (2000/2002/2003/2004)

Inside Microsoft Excel - August, 2006 Issue

Always include the most recent data in your calculation without making daily changes

Avoid confusion among coworkers: Regulate the way a workbook displays on the network

Cover all your bases: Disable the Close button to ensure your dialog box gets the attention it needs

Create a simple frequency chart without trying to grasp confusing histograms

Compare data produced with two variables just by typing one formula!

Write like a programmer: Use a naming standard in your VBA code and raise eyebrows

Show off big profits in an AutoShape and keep the formatting intact

Inside Microsoft Excel - July, 2006 Issue

Increase your PivotTable's power with error-free custom calculations

Use visual aids to enhance your data without taking up valuable worksheet space

Image file types: What to use and when

4 macros to generate consistent, unforgettable workbook names

Avoid wasted hours figuring out code by writing effective comments

Formulas have you running in circles? 5 foolproof steps to correcting errors

Solve the mystery of the invisible workbook so you can finally see your data

Rearrange your toolbar buttons on the fly (2000/2002/2003/2004)

Inside Microsoft Excel - June, 2006 Issue

Grant your chart the intelligence to update automatically when you add or remove data

Piece together a PivotTable from several locations without sacrificing flexibility

Identify and apply different font types to just the right characters

Let Excel store static values so you can save time and sanity!

Give your worksheet the feel of a website with pictures that also serve a purpose

Seamlessly synchronize new Sarbanes-Oxley compliance demands with your work in Excel

Inside Microsoft Excel - May, 2006 Issue

Allow for data that's always changing Create self-adjusting named ranges

3 cases in which all data is not created equal and how to still get accurate averages

Kiss the eternal hunt goodbye! Find and edit data across worksheets with a custom form

3 ways to customize Excel so your whole department is on the same page

Get the inside scoop on correcting VLOOKUP errors when data formatting doesn't match

Inside Microsoft Excel - April, 2006 Issue

You may be missing an easier route: Demystify arrays and look like an expert

Test your new knowledge of arrays with a short quiz

Consolidate the minute details: 3 ways to group data in a PivotTable

Help users enter data more efficiently while still prohibiting certain dates

What Excel's XML future means for you

Find out how to leave comments right where you want them in a way you never thought possible

Eliminate vague toolbar buttons by assigning a more memorable picture (2000/2002/2003)

Inside Microsoft Excel - March, 2006 Issue

Marry Word's mail merge with an Excel form so you only enter data once

3 ways to keep VBA code from getting too dense to work with effectively

Create picture-perfect data tables without hours of formatting in Excel 2007

Watch your AutoFilter's details change right now without running the macro again

Breathe some life into your PivotChart by making it 3D (2000/2002/2003/2004)

Inside Microsoft Excel - March, 2006 Issue

3 ways to generate random numbers for pain-free statistics

Keep your procedures and functions straight with some fundamental terminology

EGO award winner credits Excel mastery for landing promotion

Highlight important numbers with a style all your own

Make sure your data keeps its number formatting when you do a mail merge

Trick Excel's conditional formatting into giving you what you want (2000/2002/2003/2004)

Inside Microsoft Excel - January, 2006 Issue

Take your programmatic PivotTable to the next level with formatting and structure

Justify crucial business decisions by testing for strong data relationships

Achieve a Stock chart look even if you don't meet the Stock chart requirements

Maintain flexible data ranges even across several fiscal years

Never type a decimal point again (2000/2002/2003)

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 2006