Excel’s Text Import Wizard, insert symbols in cells, Vlookup and IfError, Excel specialists

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