Formatting--tutorial.jcwcn.com

home / Business-Applications / MS Excel / Formatting

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 predefined 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: