Tutorial search
Excel Tutorials
Tutorials
Stuff
Affiliates
Excel Tags
Excel Pivot Tables
Excel Circle
Excel Xml
Excel 2003
Excel Macros
Excel Table Of Contents
Excel Table
Excel Log
Excel Macro
Excel Video
Excel Vlookup
Excel Link
Excel Chart
Excel Irr
Excel Vba
Excel Filter
Excel Color
Excel Exercise
Excel Lock
Excel Pivot Table
Photoshop Templates
Featured Photoshop templates - professional ready to use designs for your next project.
View all templates
Excel Tutorials
We hope that you will enjoy our Excel tutorials. Feel free to contact us if you would like to be a tutorial hero and contribute your own Excel tutorial to our site. Thank you !
This Excel 2007 tutorial here can really help you to save plenty of your precious time when using the program. Here are the tips:
Tip 1: Always name your workbook and save it to a location that you will be able to find and open it later.
When saving the workbook, you need to give a meaningful, descriptive file name that can represent the contents of the workbook. If you never save the workbook, you will be unable to view the workbook in the future.
Also, you must aware the location (folder) where you saved the file because once saved, you may need to re-open the file for viewing or editing.
Tip 2: You should know the different between Save and Save As when saving your workbook.
The Save As command will ask you – where to save the file as well as the file name – every time you try to save a file.
The Save command will only ask you on the first time you save a file. If you open an old file, it will save to the location where you open the file with the same file name.
Tip 3: Knowing the different data entry techniques such as AutoFill, AutoComplete, and Pick List can save your time when entering data into the Excel worksheet.
Knowing those techniques can really save lots of your time. With AutoFill, you can easily type days of a week, months of a year within seconds.
The AutoComplete and Pick List help you quickly and easily insert a same data within the range of cells. The limitation in AutoComplete can be overcome using the Pick List.
Tip 4: Always name your worksheets so that you can identify amongst the various worksheets.
This is different from naming the workbook. By default, a workbook contains 3 worksheets, namely Sheet1, Sheet2 and Sheet3. You can increase the numbers of worksheets as you wish.
Give a proper worksheet name is as important as the workbook name. This will allows you to easily determine the contents of a worksheet. To change the worksheet name, just right click on the worksheet tan and choose Rename.
Tip 5: Always use the Excel Help as your personal assistant when you encounter Excel related tasks/problems.
Trust me that the Microsoft Office Excel Help act like your personal portable coach. You can found most of your solutions to your problems here. So, if you’re not utilising it before, please start using it now.
To get help, click on the Microsoft Office Excel Help icon (top-right of the screen) or you also can press the keyboard F1 button to launch the Excel Help window.
To discover more Excel secrets, I would like to invites you to claim your free 2 ebooks when you go to http://www.msoffice-tutorial-training.com
From Wong Hing.
Difficulty: 


Here is an illustrated tutorial, showing you step by step how to create a drop down list inside a cell, from a given list written in the worksheet.
Difficulty: 


The Sumif function is explained and illustrated, in easy language and simple examples.
Difficulty: 


In this tutorial Find out how to create charts in Excel 2007.
Difficulty: 


The following lists the most useful shortcut keys available in Excel. The shortcuts are arranged by context.
Difficulty: 


This tutorial brings together the most important ways to work efficiently and design the best possible spreadsheets as you start to work on your own.
Difficulty: 


In this tutorial you will learn how to print workbooks in Excel 2007.
Difficulty: 


This tutorial will teaches you what are templates in ms-excel Xp.
Difficulty: 


A useful guide which you will learn how to managing workbooks in Excel 2007.
Difficulty: 


Everyone needs to perform simple math. Businesses need to keep track of sales and profits, and individuals need to keep track of budgets.
Difficulty: 


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.
Difficulty: 


By the end of this module, learners should be able to:
Set page margins
Change page orientation and paper size
Create headers and footers
Create sheet settings
Difficulty: 


When you collect and analyze sales data, you can see how you`re doing now as well as predict future sales. With Excel`s forecasting functions, you can do all this and then publish your data on the Web or a local intranet.
Difficulty: 

Total Tutorials in Category: 330


