|
| Title
|
Difficulty
|
Link
|
How do I find the last used cell in a column?
Two part series on using vba to find the last used cell in a column.
|
Medium
|
Part I
(23 KB)
Part II
(26 KB)
|
| How to Display Formulas in an Excel Worksheet
|
Beginner
|
Read tutorial
(46 KB)
|
| Using Excel to Solve Simultaneous Linear Equations
|
Medium
|
Read tutorial
(62 KB)
|
| How to use Conditional Formatting
|
Beginner
|
Read tutorial
(49 KB)
|
| How to use Names
|
Beginner
|
Read tutorial
(39 KB)
|
| How to Manually Install an Add-in to Excel
|
Beginner
|
Read tutorial
(36 KB)
|
| How to use Goal Seek
|
Beginner
|
Read tutorial
(43 KB)
|
Useful Worksheet Functions
A description of some useful worksheet functions. This page will be expanded from time to time.
Some of the current functions include:-
- counting the number of values between two numbers,
- adding cells on consecutive worksheets,
- determining the last day of a given month in a given year,
- checking for leap years, etc.
|
Beginner to Advanced
|
Read article
(23 KB)
|
|
|
|
|
 UltraSleuth
|
|
Compare, check, analyze and document your Excel projects with UltraSleuth.
|
|
Gain confidence in your spreadsheet results
|
|
|
Speed up your spreadsheet development
|
|
|
Understand third party spreadsheets
|
|
|
Create an audit trail
|
 Learn More...
|
|
|
|
