Subscribe
Tutorial search

Excel Word 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:
Prevent Case Sensitivity in VBA Code
Prevent Case Sensitivity in VBA Code
By default, Excel VBA code is case sensitive and uses what is known as binary comparisons. This means that it sees Cat and cat as two different words.
Difficulty:
Run Procedures on Protected Worksheets
Run Procedures on Protected Worksheets
Excel macros are a great way to save time and eliminate errors. However, sooner or later you might try to run your favorite Excel macro on a worksheet that has been protected, with or without a password, resulting in a runtime error. Avoid that problem with the following tutorial.
Difficulty:
Password-Protect a Worksheet from Viewing
Password-Protect a Worksheet from Viewing
Keep prying eyes from viewing a worksheet, unless they have the password.
Difficulty:
Count Words in a Cell or Range of Cells
Count Words in a Cell or Range of Cells
To get a word count of any cell or range of cells, we'll use a combination of SUBSTITUTE and LEN function/formulas.
Difficulty:
Password-Protect and Unprotect All Excel Worksheets
Password-Protect and Unprotect All Excel Worksheets
Password-Protect and Unprotect All Excel Worksheets
Difficulty:
Extract Specified Words from a Text String
Extract Specified Words from a Text String
In this tutorial, we'll show how to extract the last word, the first word, and the nth word from a string of text.
Difficulty:
Excel Graphics, Shapes WordArt and Text Boxes
Excel Graphics, Shapes WordArt and Text Boxes
Microsoft Excel has extensive tools for drawing graphic objects.
Difficulty:
Protecting and unprotecting all the sheets in your spreadsheet
Protecting and unprotecting all the sheets in your spreadsheet
How to protect and unprotect all the sheets in yout spreadsheets in one go using the same password with the AssumeIT macros
Difficulty:
TRIM Function in Excel
TRIM Function in Excel
Using the TRIM function to remove unnecessary spaces in cells i.e. only have a single space between words and no spaces before or after the text
Difficulty:
How to Create Mailing Labels Merge Using Microsoft Excel and Word
How to Create Mailing Labels Merge Using Microsoft Excel and Word
Learn to create labels you can use for mailings and export from Excel to Word.
Difficulty:
How to Create a Mail Merge Using Microsoft Excel and Word
How to Create a Mail Merge Using Microsoft Excel and Word
Learn how you can easily manage addresses using mail merge through Excel and Word.
Difficulty:
Microsoft Excel 2003 Help and Tips
Microsoft Excel 2003 Help and Tips
Microsoft Excel 2003 advice including formulas, analysis operations, adjusting macro security level, changing AutoRecover options, workbook password protection, visual tweaks, and manual spreadsheet calculation.
Difficulty:
Built-In Means Of Password Protection In Microsoft Excel Documents
Built-In Means Of Password Protection In Microsoft Excel Documents
The recent versions of the MS Excel provide their users with advanced features for organizing various variants of protecting MS Excel documents against being cracked and information stored in them against being accessed. They include completely blocking access to a document, forbidding saving changes to it and protecting separate sheets and cells. Now let us study the means of protecting MS Excel documents in a more detailed way.
Difficulty:
Formatting Text
Formatting Text
Spreadsheets can be pretty dry, so we need some tools to dress them up a little. We can use most of the tricks in our word processor to do the formatting of text. We can use : bold face, italics, underline, change the color, align (left, right, center), font size, font, etc.
Difficulty:
Search Term(s) (1): word