Subscribe
Tutorial search

Excel Read Tutorials


Sort by:
Excel Solver
Excel Solver
Excel has a clever and handy tool called solver that helps you find optimal solutions for many decision-based problems in your spreadsheets.
Difficulty:
How to insert cells in Excel
How to insert cells in Excel
When we work with spreadsheet sooner or later we will need to insert Cells into existing sheet.
Difficulty:
Excel formulas and functions.
Excel formulas and functions.
A formula is an expression which calculates the value of a cell. Functions are predefined formulas and are already available in Excel.
Difficulty:
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:
Making Efficient Cell Selections
Making Efficient Cell Selections
Because cell selection is one of the most basic and regularly performed worksheet task, knowing how to efficiently select ranges of cells in the spreadsheet can go a long way toward making you a truly effective worker.
Difficulty:
Spreadsheets with Graphics
Spreadsheets with Graphics
Usually when one thinks of spreadsheets, art is the last thing that comes to mind. When used with some self-restraint - graphic images can not only add interest to your otherwise mundane tables and list of numbers but also make their data read better.
Difficulty:
Controlling When Certain Formats Are Used Controlling When Certain Formats Are Used
Controlling When Certain Formats Are Used Controlling When Certain Formats Are Used
This tutorial looks at ways you can use conditional formatting to alert yourself when certain key values change in your spreadsheet (for better or worse).
Difficulty:
Long Data Entries with AutoCorrect
Long Data Entries with AutoCorrect
AutoCorrect is Excel's attempt to save you time when doing data entry in a spreadsheet. It anticipates what you enter and, if necessary, corrects it or converts it into special types of data such as live hyperlinks and smart tags
Difficulty:
Sending Workbooks Out for Review
Sending Workbooks Out for Review
Excel makes it easy to send out spreadsheets for review by clients, coworkers, and managers who need to give you their input or approval after reviewing their contents.
Difficulty:
Quick Insertion and Deletion
Quick Insertion and Deletion
This tutorial looks at all three aspects of spreadsheet security, giving you pointers on the best ways to preserve the integrity of your spreadsheet as well as guard against its more sensitive information from falling into the wrong hands.
Difficulty:
Customizing Number Formats
Customizing Number Formats
This tutorial covers how to create custom number formats for your spreadsheets and how to assign them to Excel custom styles and toolbars for easy access.
Difficulty:
Instant Range Formatting
Instant Range Formatting
Right after data entry comes formatting. When building a new spreadsheet, you don't stop to take the time to assign formats to the data entries you make (by typing dollar signs, commas, and the like).
Difficulty:
Spreadsheet Security
Spreadsheet Security
This tutorial looks at all three aspects of spreadsheet security, giving you pointers on the best ways to preserve the integrity of your spreadsheet as well as guard against its more sensitive information from falling into the wrong hands.
Difficulty:
Alignments for Data Entries
Alignments for Data Entries
This technique looks at several of these less standard alignment options that you can apply to both text and numeric entries in the tables in your spreadsheets.
Difficulty:
Excel Error Checking to Your Needs
Excel Error Checking to Your Needs
Anyone with any experience building Excel worksheets knows that formula errors, the bane of all spreadsheets, are inevitable. Whenever Excel cannot successfully calculate one of your formulas according to its internal rules.
Difficulty:
Search Term(s) (1): read