Your Personal MS Excel Skills Report (an example report- complete it to get your personal report).
MS Excel News
Where has the text import wizard in Excel gone and how to get it back to use the legacy methods instead of using Get&Transform
Upcoming Live and Virtual Excel Courses
If you regularly work with Excel and use it to make estimates, reports, quotes etc you may need to make use of symbols that are not available on the keyboard e.g. plus minus ( +- ), copyright ( c ), metres squared ( m2 ) etc.
Our featured online Excel course. Lifetime access, with skills assessment which allows you to match to the correct course.
One of the most common questions is how to combine IFERROR and VLOOKUP to improve the results that VLOOKUP generates. VLOOKUP is a great formula where the error message of #N/A is actually useful and tells you something about your spreadsheet. The problem is that these error messages can affect other calculations in the spreadsheet.
An example of a recent consulting job we have completed.
Feedback from recent courses
Missed a newsletter? Look at the Archive