Annual Computer Clean by HPC Solutions
I am offering an annual Computer Spring clean for £60.00 Even if the amount of time for one computer exceeds […]
Information
Information
Computers, Information
What is the difference between Access and Excel?
In simple terms Excel can be used to represent a Flat data structure Access is used to represent a relational
Computers, Information
Excel Lookup
I am asked this many times, so here is a sample. 1. How can an excel spreadsheet lookup a value
Computers, Information
Excel hashes
Why do the columns in my Excel spreadsheet display hashes? Sometimes when displaying numbers in an Excel spreadsheet the number
Computers, Information
Excel display filetype or all chars after last full stop
Useful formula to display all text after the last full stop =RIGHT(A1, LEN(A1)-(FIND(\”#\”,SUBSTITUTE(A1,\”.\”,\”#\”,LEN(A1)-LEN(SUBSTITUTE(A1,\”.\”,\”\”)))))) How does this work? Let\’s look at
Computers, Information
Excel Change Cell Color on Condition
How to change the color of a cell based on the value of another cell This example changes the color
Computers, Information
Excel 2007 Compatibility How to unhide worksheet
When opening a 2003 version of an Excel Spreadsheet in Excel 2007 I could reference but not unhide a sheet
Computers, Information
Excel 2007 Autofit
PAUL MILLS ASKS Microsoft \”Why the bloody hell did you move it?!!!!!\” Where has Autofit moved to in Office 2007?
Computers, Information
Office 2007 Compatiblity Pack
Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint 2007 This is required to read Microsoft Office 2007 files if