Go Back   Wiki NewForum > Career Forum (Documents/Tutorials/Advice) > Tech Forum & Tutorial > IT Forum > MS office Tutorials (2003 & 2007) > MS Excel 2003

Sponsored Links

MS Excel 2003 Step-by-step Excel 2003 Tutorials, Tips and Training

Reply
Views: 1058 Source: CNN18.com, India-Forums, TellyChakkar, India, Times of India, Youtube, BollywoodLife, Rediff  
Thread Tools Rating: Thread Rating: 1 votes, 5.00 average. Display Modes
  #1  
Old 01-27-2010, 05:33 AM
welcomewiki welcomewiki is offline
Member
 
Join Date:
Dec 2008
Location:
India
Posts: 39,167
Default Opening Note for Excel 2003

What was the secrets there? Just follow the online Excel tutorials below!

Have you ever think…

If you've been asked to enter data in Microsoft Excel, but you've never worked with Excel.

Where and how to begin? Or perhaps you have worked in Excel a time or two, but you still not very sure how to enter formulas, edit data, add and delete extra columns and rows, etc…
Then, the Excel tutorials here can let you learn the s****s you need, quickly and with little fuss.

Microsoft Excel - A popular program that allows you to create and edit spreadsheets. Spreadsheets are designed to work well with numbers but often include text. You store data in Excel columns and rows that can then be organized and/or processed.

We can’t deny the power of Microsoft Word rich features but every program has their own purpose! Some of the task that is difficult to perform in Word can be achieve easily using Excel and vice versa. So…

Reply With Quote
  #2  
Old 01-27-2010, 05:33 AM
welcomewiki welcomewiki is offline
Member
 
Join Date:
Dec 2008
Location:
India
Posts: 39,167
Default

What YOU Can Do With Excel?

With the numerous features available in Excel, you can use it widely. Some of them are:
  • Creating invoice, purchase order, DO, etc
  • Presenting data in different types of chart formats!
  • Get the latest prices for stocks, percentage change in stock value, etc.
  • Calculate a loan due date or how many days you have been alive?
  • And lots more…
What is so different when you use the spreadsheet to create the material above?

Those materials can have a 'build-in calculator' that will automatically calculate the figure based on the pre-set formula with 100% accuracy. This is the biggest advantage of computer spreadsheet compare with manual when dealing with figures.

Thanks to the powerful Excel feature – Formulas and Functions! …and you can learn it in the online Excel tutorials help below.

If you have used the correct functions and formulas within the spreadsheet, the computer automatically re-calculate the end values.
Reply With Quote
  #3  
Old 01-27-2010, 05:34 AM
welcomewiki welcomewiki is offline
Member
 
Join Date:
Dec 2008
Location:
India
Posts: 39,167
Default

Just Few Clicks to Create Chart / Graph for YOU!!

It’s important to represent your data in chart format instead of all figures. What are the advantages of using chart or graph?

One picture worth a thousand words
  • Easy to make comparison, see the differences
With Excel, you can create different types of graph easily from the data in the spreadsheet. To tell the truth, you can transfer the intended data to produce the graph/chart with just few mouse clicks.

Still not convince, then I can show you exactly in the Excel tutorials help below!

From the graph produced, you can change the chart text color, size, position,etc so it can really achieve the objective to make the comparison.
Reply With Quote
  #4  
Old 01-27-2010, 05:34 AM
welcomewiki welcomewiki is offline
Member
 
Join Date:
Dec 2008
Location:
India
Posts: 39,167
Default

How to Edit, Sort and Filter Data?

This feature is extremely important when deal with lots of data…maybe few hundreds or even thousand records. You need to create a database to store all the data. For example, you wish to record all the books that have been purchased. You may record the book title, quantity, date purchased, price, supplier, etc.

With so many records, you still can easily add, delete, edit, filter and sort the data according to your needs. For example, in a sales company database, you can find the top 10 salesman at ease.

Of course this is just some of the features of Excel. To learn more about Microsoft Excel, see the Excel tutorials below.
Reply With Quote
Reply

New topics in MS Excel 2003

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump


Powered by vBulletin® Version 3.8.10
Copyright ©2000 - 2018, vBulletin Solutions, Inc.