1 reply to this topic

[saurabhjain]

Sharing with you Microsoft Excel Video Tutorial for Beginners.If you found it useful, kindly share with your friends.


Microsoft Excel Tutorial for Beginners #1
http://spicyflavours...s&do=view&id=28
A quick look at setting up a simple spreadsheet in Excel complete with a chart. More tutorials to follow that will go into more detail on how to use the different features of MS Excel.

Microsoft Excel Tutorial for Beginners #2 - Get Started
http://spicyflavours...s&do=view&id=29
This video covers a number of basics including entering data, editing data, changing column widths and Autofill.

Microsoft Excel Tutorial for Beginners #3 - Calculations
http://spicyflavours...s&do=view&id=30
Tutorial #3 introduces calculations and explains the basic mathematical operators in Microsoft Excel.

Microsoft Excel Tutorial for Beginners #4 - Functions
http://spicyflavours...s&do=view&id=38
In part 4 you will learn about creating basic functions in Excel and using the Paste Function feature.

Microsoft Excel Tutorial for Beginners #5 - Number Formats
http://spicyflavours...s&do=view&id=39
Tutorial #5 shows how to do basic number formatting using the toolbar or menu options. The video also introduces the Format Painter and shows how to select non-adjacent cells.

Microsoft Excel Tutorial for Beginners #6 - Formatting Pt.1
http://spicyflavours...s&do=view&id=40
This is the first of 2 videos looking at formatting. Effective formatting will add a professional look to your spreadsheets. In this video learn how to modify text and add colours to your spreads...

Microsoft Excel Tutorial for Beginners #7 - Formatting Pt.2
http://spicyflavours...s&do=view&id=41
The guide to Excel formatting continues with a look at changing text colour, border styles, print preview and an introduction to Conditional Formatting.

Microsoft Excel Tutorial for Beginners #8 - Formatting Pt.3
http://spicyflavours...s&do=view&id=42
Learn how to combine conditional formatting with Excel functions.

Microsoft Excel Tutorial for Beginners #9 - Charts Pt.1
http://spicyflavours...s&do=view&id=43
In this tutorial, looking at Excel charts, learn how to create and format a simple column chart. Hope you find it useful. These tutorials are made using Excel 2000 but everything you see can be achieved in all versions of Excel.

Microsoft Excel Tutorial for Beginners #10 - Charts Pt.2
http://spicyflavours...s&do=view&id=44
Find out how to update your charts when new data is added to the spreadsheet and how to relocate your charts to another sheet.

Microsoft Excel Tutorial for Beginners #11 - Charts Pt.3
http://spicyflavours...s&do=view&id=45
Create a Pie Chart using the Excel Chart Wizard and learn how to format the completed chart.

Microsoft Excel Tutorial for Beginners #12 - Printing
http://spicyflavours...s&do=view&id=46
A look at the basics of printing in Excel. Learn how to position and resize objects on your printouts and how to print only selected ranges. Hope you find it useful.

Microsoft Excel Tutorial for Beginners #13 - Updating Calculations
http://spicyflavours...s&do=view&id=47
In this update to the beginners series you will learn how to update calculations linked to atable of data as new data is added to the table. The tutorial covers manual and automatic updating.

Microsoft Excel VLOOKUP Function Tutorial Part 1
http://spicyflavours...s&do=view&id=48
A short guide to using the VLOOKUP function in MS Excel. One of many functions that helps you to automate your spreadsheets and save you a lot of time & effort. If you find this useful then ook out for the 2nd part of the VLOOKUP tutorial with a few more tips for getting the best out of this feature.

Microsoft Excel VLOOKUP Function Tutorial Part 2
http://spicyflavours...s&do=view&id=49
In the 2nd part of the MS Excel VLOOKUP tutorial you will learn about fixing possible problems and using the Paste Function feature to create your VLOOKUP results.

Microsoft Excel VLOOKUP Function Tutorial Part 3
http://spicyflavours...s&do=view&id=50
This third VLOOKUP tutorial show you how to retrieve 'close' matches from your data table and also how to incorporate the IF and ISBLANK functions to make
your VLOOKUP results more user friendly.

Microsoft Excel Repeat (REPT) Function Tutorial
http://spicyflavours...s&do=view&id=52
A look at the Repeat (REPT) function in Microsoft Excel. This tutorial waa made with Excel 2000 but it works just the same in Excel 2003 & 2007 versions. Hope you find it useful!


Regards
Saurabh Jain

[Alex K]

I was working with my xls document at 9 o'clock yesterday. After that I saved my data and closed the doc. But I have opened today. I was shocked because of my info was lost. I called my friend up, but he couldn't assist me. And I by chance decided to enter the Google. I found out - Microsoft Excel file fix. It determined my issue within the scope of a minute and quite easy. What is more the program could work on a very important report, with statistical data, graphics, tables and a lot of critical information and it is lost at once.