• home
  • forum
  • my
  • kt
  • download
  • this:1/2 25records  total:27    start  Previous  Next  Last    goto:
    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:
    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:
    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:
    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:
    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:
    How to Merge Columns in Excel
    ON: 2008-09-03 10:18:31
    You're probably used to merging cells , but did you know that merging or concatenating columns for combining data is just as easy and useful
    27 times | category:
    How to Input the Same Data into Individual Worksheets at the Same Time
    ON: 2008-09-03 10:15:59
    Don't waste time copy and pasting, learn to work with the same data within multiple sheets.
    6 times | category:
    Excel Shortcut Keys
    ON: 2008-09-03 10:07:42
    Many users have discovered that using their keyboard can often be much more efficient than using their mouse. The following lists the most useful shortcut keys available in Excel.
    9 times | category:
    Protecting Excel 2007 Data
    ON: 2008-09-03 10:06:56
    The concept of "protection" gets a lot of attention in the Excel newsgroups and forums. It seems that many users want to learn how to protect their workbooks from being copied or modified. Excel has several protectionrelated features
    4 times | category:
    How To Use The Format Painter
    ON: 2008-09-03 10:03:51
    This video tutorial shows how to use the formatting painter in Excel.
    5 times | category:
    How To Set Conditional Formatting
    ON: 2008-09-03 10:02:31

    This video tutorial shows how to set conditional formatting in Excel.
    9 times | category:
    How To Change The Cell Color Fill
    ON: 2008-09-03 10:01:26
    This video tutorial shows how to change the color fill of a cell in Excel.
    5 times | category:
    How To Create Cell Borders
    ON: 2008-09-03 09:50:32
    This video tutorial shows how to create cell borders in Excel.
    4 times | category:
    How To Format A Number To A Decimal In Excel
    ON: 2008-09-03 09:49:20
    This video tuorial shows how to format numbers to decimals in Excel.
    3 times | category:
    Working with Formulas {Tutorial for beginners}
    ON: 2007-08-30 10:58:01
    Excel is an effective tool to work with numbers and to do mathematical operations. Sometimes, for do these operations are necessary to insert formulas.....
    103 times | category:
    Pivot Data {Tutorial for beginners}
    ON: 2007-08-30 10:55:13
    With the Pivot data you can see the same information in different layouts with a few clicks.....
    182 times | category:
    Advanced Formulas {Tutorial for beginners}
    ON: 2007-08-30 10:54:20
    In this tutorial, you will learn how to use the formulas........
    68 times | category:
    Main Functions and Formula used in Excel.
    ON: 2007-08-30 10:53:23
    There are many pre-defined functions in Excel but the most important pre­defined functions
    84 times | category:
    Formula mistake may occur in Excel
    ON: 2007-08-30 10:36:20
    The common error values that could appear when creating a formula are described below
    24 times | category:
    Formatting cells and sheets {Tutorial for beginners}
    ON: 2007-08-30 10:32:39
    In this tutorial, you will apply formatting options to cells and prepare the sheet for printing....
    48 times | category:
    Excel Options {Tutorial for beginners}
    ON: 2007-08-30 10:26:00
    In this tutorial, you will learn how to configure Excel’s general options.....
    30 times | category:
    Setting column Width and Row Height
    ON: 2007-08-30 10:09:58
    The width of column and height of row can be changed very easily to properly accommodate the data in cells.
    23 times | category:
    Create Pivot Tables by Using VBA
    ON: 2007-08-30 10:00:47
    A pivot table is a great reporting tool that sorts and sums independent of the original data layout in the spreadsheet and VBA (Visual Basic for Application) is a very powerful macro language...
    2065 times | category:
    Work with Pivot Tables in Excel
    ON: 2007-08-30 09:57:22
    PivotTables are one of the wildest but most powerful features of Excel.
    We use PivotTables a lot when we develop spreadsheets for our clients. Once a client sees a PivotTable, they nearly always ask whether they can create one themselves. Although anyone can create a PivotTable...
    176 times | category:
    Formatting Text
    ON: 2007-08-30 09:56:20
    Spreadsheets can be pretty dry, so we need some tools to dress them up a little. We can use most of the tricks in our word processor to do the formatting of text. We can use : bold face, italics, underline, change the color, align (left, right, center), font size, font, etc.
    19 times | category:
    this:1/2 25records  total:27    start  Previous  Next  Last    goto:

    Category

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