Tutorial search

All categories3DS MaxAccessAdobe PremiereAfter EffectsASPASP.NETAutoCADBlender 3DBodyPaintBryce 3DC++Cinema 4DColdfusionCorel DrawCSSDelphiDreamweaverExcelFireworksFlashFreehandFrontpageFruity LoopsGimpGoLiveHTMLIllustratorImage ReadyInDesignJavaJavaScriptLightwave 3DLinuxMac OS XMaya 3DMySQLOutlookPagemakerPaint ShopPainterPhotoshopPHPPoserPowerPointPythonRuby on RailsSEOSwift 3DSwish MaxTerragenValve EditorVisual BasicWeb DesignWindowsWordXML

Excel Tutorials

• Excel tutorials

Tutorials

• 3DS Max tutorials
• Access tutorials
• Adobe Premiere tutorials
• After Effects tutorials
• ASP tutorials
• ASP.NET tutorials
• AutoCAD tutorials
• Blender 3D tutorials
• BodyPaint tutorials
• Bryce 3D tutorials
• C++ tutorials
• Cinema 4D tutorials
• Coldfusion tutorials
• Corel Draw tutorials
• CSS tutorials
• Delphi tutorials
• Dreamweaver tutorials
• Excel tutorials
• Fireworks tutorials
• Flash tutorials
• Freehand tutorials
• Frontpage tutorials
• Fruity Loops tutorials
• Gimp tutorials
• GoLive tutorials
• HTML tutorials
• Illustrator tutorials
• Image Ready tutorials
• InDesign tutorials
• Java tutorials
• JavaScript tutorials
• Lightwave 3D tutorials
• Linux tutorials
• Mac OS X tutorials
• Maya 3D tutorials
• MySQL tutorials
• Outlook tutorials
• Pagemaker tutorials
• Paint Shop tutorials
• Painter tutorials
• Photography tutorials
• Photoshop tutorials
• PHP tutorials
• Poser tutorials
• PowerPoint tutorials
• Python tutorials
• Ruby on Rails tutorials
• SEO tutorials
• Swift 3D tutorials
• Swish Max tutorials
• Terragen tutorials
• Valve Editor tutorials
• Visual Basic tutorials
• Web Design tutorials
• Windows tutorials
• Word tutorials
• XML tutorials

Stuff

• Most Popular Tutorials
• Best Rated Tutorials
• Random Tutorial

• Tutorial submission tool
• Photoshop Templates
• Flash Templates
• Forum signatures
• Free Video Tutorials
• Best Scripts

• Contact

Total Tutorials: 45452

Affiliates

A simple tutorial video teaching how to use the countif function in Microsoft Office Excel.

Formulas and worksheet functions are essential to manipulating data and obtaining useful information from the Excel workbooks. This tutorial present a wide variety of formula examples that uses many of Excel's functions.

Want to get the most out of Microsoft Office 2007? Maybe a shortcut or two (or 20) that will let you focus on task at hand? Microsoft Office 2007 is so powerful that you need our Tips and Tricks course to make full use of its abilities. You need to be familiar to Microsoft Office 2007 applications already and want to fine tune your work with them.

Let's say we want to enter data such as Part1, Part2, Part3, Part4, Part5, up to several hundreds (e.g. Part200) with numeric number increment. The following will be what you want to enter: Part1 Part2 Part3 Part4 . . . Part200

Merging two Excel files using VLOOKUP function is very powerful and convenient for Data Analysis when manual matching of two files is very time consuming because of size of data.

In this tutorial, you will learn how to use the formulas........

This video tutorial shows how to use the imaginary function in Excel.

The find replace tool is more commonly used in MS Word. However, it is extremely useful in Excel and can be used to quickly make changes to a spreadsheet.

The Paste Special command has a number of useful tools built into it. Besides allowing you to Paste values, it also allows you to transpose lists (columns to rows or rows to columns), multiply, add, skip blanks and paste links.

The watch window allows you to continuously view cells that interest you (no matter where they are on the spreadsheet) while making changes to inputs in the model.

Offset allows you to refer to cells above, below, left or right of a reference cell. Very useful for cash flow forecasts where the receipt or payment of money can move between periods.

The function wizard allows you to use any of Excels functions in a very user friendly way. You therefore do not need to remember the complex syntax of any of the commands.

Formulas and functions provide the logic that powers spreadsheets. Managing programming logic is always a challenge, but keeping track of programming logic across multiple cells, sheets, and workbooks can be particularly difficult, especially as spreadsheets grow and are reused. What's more, the formula and function capabilities built into Excel might not always be what you want, further complicating the situation. Fortunately, there are a lot of ways you can keep your formulas and functions sane.

Since Excel XP, Excel has included an XML export option. SpreadsheetML provides an XML representation of your spreadsheets, complete with formatting and formula information.

In Excel there is a help tool for functions called the Function Wizard. Learn how to easily use functions with the function wizard.

1