• home
  • forum
  • my
  • kt
  • download
  • this:1/5 25records  total:110    start  Previous  Next  Last    goto:
    Auto Fill
    ON: 2009-07-20 09:44:52
    This technique enables excel to copy text/data into multiple cells. You can't work in Excel without knowing this basic procedure.
    3 times | category: [Functions]
    Upper to Lower Case Function “=PROPER()”
    ON: 2009-07-20 09:41:43
    The following formula easily tranforms a list of data from Upper to Lower case. This is has come in handy several times.
    1 times | category: [Functions]
    Current Date & Time
    ON: 2009-07-20 09:32:24
    The following two forumula are extremely useful. As simple as they may seem, they can play a vital role in many Excel documents.
    1 times | category: [Functions]
    Data Validation - Dependent Lists
    ON: 2009-07-20 09:10:36
    This tutorial will show you how to create a dependent list on Excel. This technique is extremely useful when categorizing data. In the example below, the user will select the State in cell A3. Cell B3 (City) will pull a city based off of the users selection.
    2 times | category: [Functions]
    Creating Charts in Excel 2007
    ON: 2009-07-20 08:59:52
    In this tutorial Find out how to create charts in Excel 2007.
    1 times | category: [Charts and Graphs]
    How To Get the Weekday as Text in Excel VBA
    ON: 2009-07-20 08:43:32
    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.
    2 times | category: [Macros]
    VBA: Find Text in a String (instr)
    ON: 2009-07-20 08:39:22
    You can use the instr function in VBA to test if a string contains certain text. The result is the number of times the specified text appears in the string.
    4 times | category: [Macros]
    Conditonal Formatting - Shading Alternate Rows
    ON: 2009-07-20 08:25:30
    This Excel function is very useful when dealing with long lists of data. However, it is extremely easy to use once you know the simple formula.
    5 times | category: [Formatting]
    Removing #DIV/0! errors from your spreadsheets
    ON: 2009-04-21 12:52:14
    Shows how to remove #DIV/0! errors from your spreadsheets permanently using the AssumeIT macros
    11 times | category: [Macros]
    IRR Calculator
    ON: 2009-04-21 12:48:05
    A tutorial on how to use the Excel IRR Calculator which can be downloaded from our site with some explanation how IRR works
    4 times | category: [Functions]
    Double The Value of The Recently Used File List
    ON: 2009-03-12 09:30:36
    You routinely open the same six workbooks. The File menu shows only the last four workbooks that you opened or saved. It sure would be nice if it showed at least the last six workbooks.
    9 times | category: [Formatting]
    Add A Close Button To The Standard Toolbar
    ON: 2009-03-12 09:28:46
    Experiment with adding new buttons so that any task that you perform regularly has a one-click option.Your efficiency with Excel would increase if you had a one click option for closing workbooks.
    4 times | category: [Formatting]
    HOW To See Headings As You Scroll Around a Report
    ON: 2009-03-12 09:15:53
    You want to be able to scroll through the data and always see the headings.
    8 times | category: [Basics]
    Automatically Move The Cell Pointer In A Direction After Entering a Number
    ON: 2009-03-12 09:13:57
    You can have the cell pointer move in any direction after using Enter by changing this setting on the Edit tab of the Options menu.
    28 times | category: [Basics]
    Remember Workbooks To Open Using A Workspace
    ON: 2009-03-12 09:09:21
    To reduce the time in opening more than one workbook.You need to open seven files in order to prepare a weekly report. It is tedious to open all seven workbooks.
    5 times | category: [Basics]
    Show Full Toolbars All The Time
    ON: 2009-03-12 09:06:12
    While learning Excel, use the Tools Customize feature to show the complete version of Standard and Formatting toolbars.Microsoft only show the most common menu choices from Excel’s two most important toolbars: Standard and Formatting.
    6 times | category: [Basics]
    Show Full Menus All The Time
    ON: 2009-03-12 09:05:12
    You are trying to learn Excel. Microsoft only shows you the most common menu choices under each menu. While learning Excel, use the Tools Customize feature to show the complete list of commands on each menu.
    6 times | category: [Basics]
    Superscript and subscript in Microsoft Excel
    ON: 2008-12-30 11:29:27
    Words like "1st" and "2nd" use superscript format for the letters. Learn how to apply this format to text in Microsoft Excel.
    40 times | category: [Formatting]
    Style Formatting
    ON: 2008-12-30 11:28:53
    MS Office styles are pre-selected combination of colors, fonts, and effects that you can apply to a workbook. Use styles to give your work a particular look: professional, playful, or creative.
    11 times | category: [Formatting]
    Insert Data from Excel to SQL Server
    ON: 2008-12-30 11:24:26
    Shows how to read data from an Excel spreadsheet and insert it into a SQL Server database using VBA and ADODB.
    42 times | category: [Macros]
    Advanced Charts
    ON: 2008-12-30 11:18:51
    Its easy to chart and list that contains two columns you want to graph one with text labels and one with numeric data. But in real life, you'll need to deal with many different types of data that occupy many different configurations on your worksheet
    46 times | category: [Charts and Graphs]
    Chart Printing
    ON: 2008-12-30 11:16:27
    Depends on the type of chart you've created. You can print embedded charts either with worksheet data or on their own. Standalone charts, which occupy separate worksheets, always print on separate pages.
    9 times | category: [Charts and Graphs]
    Chart Type Examples
    ON: 2008-12-30 11:13:07
    After you select the data to use in a chart, the next step is to select the type of chart. Learn which chart type is suitable for your chart.
    85 times | category: [Charts and Graphs]
    Basic Tasks with Charts
    ON: 2008-12-30 11:12:19
    Charts float above your data, locked inside special box-like containers. To take advantage of these chart boxes, you need to understand a little more about how they work.
    16 times | category: [Charts and Graphs]
    What Is a Chart?
    ON: 2008-12-30 11:09:46
    A chart is a visual representation of numeric values. Charts (also known as graphs) have been an integral part of spreadsheets since the early days of Lotus 1-2-3.
    21 times | category: [Charts and Graphs]
    this:1/5 25records  total:110    start  Previous  Next  Last    goto:

    Category

      Basics (41)
      Charts and Graphs (13)
      Formatting (27)
      Functions (18)
      Macros (11)