MS Excel--tutorial.jcwcn.com

home / Business-Applications / MS Excel

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.; 6 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.; 4 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.; 11 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.; 9 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.; 6 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.; 8 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.; 12 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.; 7 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; 19 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; 12 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.; 12 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.; 6 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.; 11 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.; 31 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.; 8 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.; 9 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.; 9 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.; 50 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.; 14 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.; 49 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; 50 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.; 11 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.; 91 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.; 19 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.; 26 times | category: [Charts and Graphs]

this��1/5 25records total:110 start Previous Next Last goto: