Subscribe
Tutorial search

Excel 2007 Tutorials


Sort by:
How To: Protect Your Excel Spreadsheet From Unauthorized Changes (Excel 2007)
How To: Protect Your Excel Spreadsheet From Unauthorized Changes (Excel 2007)
If you work with a team of people using Excel, you may want to protect your Excel Spreadsheet from changes. Adding a password in order for people to make changes does just that.
Difficulty:
Customizing the Office 2007 Ribbon
Customizing the Office 2007 Ribbon
This tutorial presents some techniques for making your macros more accessible. Learn how to enable your users to use familiar tools-namely, the Office 2007 Ribbon and its tabs, groups, and various buttons to run your macros.
Difficulty:
Limit the Scrolling Range of Your Worksheet
Limit the Scrolling Range of Your Worksheet
All Excel worksheets created in Excel 2007 have a column limit of 16,384 (256, A to IV, in previous versions) and a rowlimit of 1,048,576 (65,536 pre-2007).
Difficulty:
The Excel Options Dialog
The Excel Options Dialog
Microsoft has completely redesigned the Excel Options dialog for Excel 2007 (as it has the Options dialogs for the rest of Office 2007).
Difficulty:
Excel 2007 Template
Excel 2007 Template
Templates are predesigned and formatted spreadsheets, the provide consistency of layout's structure and save time and repetition of work.
Difficulty:
Creating Charts in Excel 2007
Creating Charts in Excel 2007
A chart (also known as a graph outside Excel circles) is a way to present a table of numbers visually.
Difficulty:
 Getting to know Excel 2007
Getting to know Excel 2007
The Excel 2007 interface has been completely revamped and redesigned compared to the older versions of Excel we are all used to.
Difficulty:
Excel 2007 Basics
Excel 2007 Basics
This top basics list lays out all the fundamental skills required to successfully use Excel 2007.
Difficulty:
MS-Excel 2007 Features
MS-Excel 2007 Features
What is cool in Excel 2007, look no further! Here it is some official Top Features list.
Difficulty:
5 Simple Tips to Help You Boost Your Productivity on Using Excel Program
5 Simple Tips to Help You Boost Your Productivity on Using Excel Program
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:
Create a Drop Down List in Excel 2007
Create a Drop Down List in Excel 2007
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:
Sumif Function Examples for Excel 2007
Sumif Function Examples for Excel 2007
The Sumif function is explained and illustrated, in easy language and simple examples.
Difficulty:
Creating Charts in Excel 2007
Creating Charts in Excel 2007
In this tutorial Find out how to create charts in Excel 2007.
Difficulty:
Tips for Using Excel 2007
Tips for Using Excel 2007
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:
Protecting Excel 2007 Data
Protecting Excel 2007 Data
This tutorial cover how to protect your Excel 2007 Data.
Difficulty:
Search Term(s) (1): 2007