Tutorial search

All categories3DS MaxAccessAdobe AcrobatAdobe AuditionAdobe FlexAdobe PremiereAfter EffectsArchiCADArchitectural DesktopASPASP.NETAutoCADAutodeskBlender 3DBodyPaintBryce 3DBuzzsawC++CATIACinema 4DCivil 3DColdfusionCorel DrawCSSDelphiDreamweaverDWF ViewerExcelFireworksFlashFreehandFrontpageFruity LoopsGimpGoLiveHTMLIllustratorImage ReadyInDesignIntelliCADInventorJavaJavaScriptLand DesktopLightwave 3DLinuxMac OS XMapMaya 3DMechanical DesktopMicroStationMySQLOutlookPagemakerPaint ShopPainterPhotographyPhotoshopPHPPoserPowerPointPro/ENGINEERPythonRaster DesignRevitRhino 3DRuby on RailsSEOSolid EdgeSolidWorksSwift 3DSwish MaxTerragenValve EditorVectorWorksVisual BasicVIZWeb DesignWindowsWordXML

When creating charts in Excel, you are limited to generic colors and themes. However, by exporting the graph into Photoshop, you can easily transform a once boring graph into a stunning masterpiece.

In this tutorial, you find out how to use all three of these procedures to save time in a worksheet that you access and edit on a somewhat regular basis.

This technique introduces you to the process of sorting worksheet data. It begins by covering the basic sorting of the records in a data list using one, two, or even three fields in the list.

Adjusting time scale on x-axis in standard line chart could be a headache. It is kind of a trial and error process to make the time scale fit in, distribute the labels properly and last date being shown correctly at the end of x-axis.

Excel can manipulate your data by using formulas. Formulas can be as simple as adding two or more numbers together or as complicated as determining the calculation of a second-order differential equation.

When using a built-in Excel function is impractical, you can use a custom macro to change any existing text to uppercase or proper case.

This calculator can be used by a borrower or lender to establish a payment amount based on an initial loan amount, annual interest rate, repayment term and periods.

Instead of giving every button its own macro, it's sometimes more convenient to create a single macro that manages all the buttons.

Although referencing data by name is convenient, it's sometimes more helpful to store a constant value or even a formula, especially if you've been creating custom functions in VBA.

Wouldn't it be useful if you could give users a list of options to select that decreases as options are used? You can create this nifty feature with the use of Data Validation and some Excel VBA code.

You can easily manipulate the Data Validation feature of Excel to ensure that you have no blank cells within your list.

Sometimes it's difficult to make choices with checkboxes. Fortunately, you can simplify this process using a basic bit of code.

If you are familiar with Excel's AutoFilter tool, you also are familiar with its limitations. If you require extensive data manipulation, using Excel's Advanced Filter tool is the way to go.

Using this tutorial, you can spare yourself the trouble of removing them by hand.

When working with multiple lists, you can force a list to change by using a combination of option buttons plus a ComboBox.