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

In this tutorial, you get a chance to practice creating formulas that automate table lookup, including looking up a single value....

When using VBA to code the Colorindex (or background color) of a cell it is useful to know what integer will equal what color. Below is a reference picture which shows the color and lists it’s respective Colorindex. aka VBA Color Palette

The IF statement is excel is very useful, but can become a little complicated. The following explanation will explain how to easily and properly use this function.

This tutorial explains how to get the weekday as text in Excel, using VBA, and giving a function to do the job. We also give a method which avoids using macros, for comparison.

This Excel 2007 tutorial here can really help you to save plenty of your precious time when using the program. Here are the tips: Tip 1: Always name your workbook and save it to a location that you will be able to find and open it later. When saving the workbook, you need to give a meaningful, descriptive file name that can represent the contents of the workbook. If you never save the workbook, you will be unable to view the workbook in the future. Also, you must aware the location (folder) where you saved the file because once saved, you may need to re-open the file for viewing or editing. Tip 2: You should know the different between Save and Save As when saving your workbook. The Save As command will ask you – where to save the file as well as the file name – every time you try to save a file. The Save command will only ask you on the first time you save a file. If you open an old file, it will save to the location where you open the file with the same file name. Tip 3: Knowing the different data entry techniques such as AutoFill, AutoComplete, and Pick List can save your time when entering data into the Excel worksheet. Knowing those techniques can really save lots of your time. With AutoFill, you can easily type days of a week, months of a year within seconds. The AutoComplete and Pick List help you quickly and easily insert a same data within the range of cells. The limitation in AutoComplete can be overcome using the Pick List. Tip 4: Always name your worksheets so that you can identify amongst the various worksheets. This is different from naming the workbook. By default, a workbook contains 3 worksheets, namely Sheet1, Sheet2 and Sheet3. You can increase the numbers of worksheets as you wish. Give a proper worksheet name is as important as the workbook name. This will allows you to easily determine the contents of a worksheet. To change the worksheet name, just right click on the worksheet tan and choose Rename. Tip 5: Always use the Excel Help as your personal assistant when you encounter Excel related tasks/problems. Trust me that the Microsoft Office Excel Help act like your personal portable coach. You can found most of your solutions to your problems here. So, if you’re not utilising it before, please start using it now. To get help, click on the Microsoft Office Excel Help icon (top-right of the screen) or you also can press the keyboard F1 button to launch the Excel Help window. To discover more Excel secrets, I would like to invites you to claim your free 2 ebooks when you go to http://www.msoffice-tutorial-training.com From Wong Hing.

This tutorial brings together the most important ways to work efficiently and design the best possible spreadsheets as you start to work on your own.

Everyone needs to perform simple math. Businesses need to keep track of sales and profits, and individuals need to keep track of budgets.

Microsoft Excel 2003 is a spreadsheet application in the Microsoft Office Suite. A spreadsheet is an accounting program for the computer. Spreadsheets are primarily used to work with numbers and text. Spreadsheets can help organize information, like alphabetizing a list of names or ordering records, or calculate and analyze information using mathematical formulas.

Why create a new invoice each time you bill a different client? Use Excel to make a single invoice template, and then adapt that template for each of your clients. When billing time rolls around, you can either fill out the invoice electronically and e-mail it, or you can print and then mail or fax it.

Document themes are a new feature in Excel 2007 that allows you to add a professional and uniform style to your Excel workbooks.

Edit data in Excel 2007 by using options in the shortcut menu and your keyboard to make simple editing changes to existing data.

By the end of this module, learners should be able to: Understand definition of a function Use Excel 2003 functions in calculations Access Excel 2003 functions Find the sum of a range of data

By the end of this module, learners should be able to: Understand the parts of an Excel formula Create a simple addition formula Create a simple subtraction formula using the Point-and-Click Method Create simple multiplication formulas Create simple division formulas

Shows how to use the ADDRESS function to generate a reference that Excel will understand. Very useful with the INDIRECT function

Shows how to hide and unhide multiple sheets at the same time using the AssumeIT macros