Excel Cell References Explained
Microsoft Excel has two types of cell reference - Absolute and Relative, and an understanding…
Using Accented Characters In Excel
Adding accented characters into your Excel workbook is commonly achieved by using the Insert --> Symbol menu options to…
Using The Info Function In Excel
Microsoft Excel provides a very handy function called the 'Info' function which allows Workbook designers…
Handling Dates In Excel
Because the standard Gregorian calendar used by the majority of the world doesn't lend itself…
Longer Undo Lists In Excel
In Microsoft Office, the Excel undo list has a limit of sixteen entries, which for…
Excel Keyboard Shortcuts
Here is a selection of some of the most often used keyboard shortcuts, along with…
Excel Glossary Of Terms
Like most programs, Microsoft Excel has certain terms and phrases that are specific to it.…
Using VBA To Find Current User Name
Sometimes it can be useful to know which user is logged on to your application,…
Using ComboBoxes To Specify Query Criteria Pt2
To use this tutorial you will need to have worked through Part 1 - click here to…