by laramellortraining | Jun 4, 2020 | Excel Hints and Tips
In the third of a series of guest blogs, Alan Sawyers of A.S. Design, Web & Marketing looks at his top five tips for tidying up customer email lists in Excel... I look after several ecommerce sites. Some of them my own, some of them for clients. And one of the...
by laramellortraining | May 6, 2020 | Excel Hints and Tips
Excel date functions can be used to manipulate dates in many different ways. You may need to know how many days it is since you sent an invoice or analyse when your sales take place in the month. You may need to summarise your data based on the month or calculate...
by laramellortraining | Mar 26, 2020 | Excel Hints and Tips, General, Microsoft Office Hints and Tips, PowerPoint Hints and Tips, Word Hints and Tips
The majority of the Microsoft suite of products have these options when you are saving. Although the default options of Excel Workbook, Word Document, PowerPoint presentation etc are used most of the time these other Save As options are extremely useful in certain...
by laramellortraining | Feb 27, 2020 | Excel Hints and Tips
Did you know that you don’t have to put up with many of the default settings you get with Excel if they don’t fit with the way you work. Here are 8 of my favourites. All these options are available from the File menu and options. 1. Changing the default save...
by laramellortraining | Jan 30, 2020 | Excel Hints and Tips
When you have a large document it can become tricky to move around but with a few special tools it can become a lot easier to navigate Excel. Navigating to the top and bottom of the document There are some great keyboard shortcuts that can help you with this. CTRL +...
by laramellortraining | Jan 16, 2020 | Excel Hints and Tips
How many times have you ended up using loads of VLOOKUPs to show data from 2 or more different tables together? Although this works it is very memory intensive which on large spreadsheet can cause delays in updating at best or crashes at worst. Have you always...
