See, and play with the Excel data when PowerQuery editor is open Jun 18, 2019
A method to see, and play with the Excel data when PowerQuery editor is open or open 2 PowerQuery windows at the same time.
Home // Blog & Excel Tips // 4
Blog & Excel Tips
Free Tips & Tricks Newsletter Please fill in your details below to get regular Excel tips and tricks and a free Quick Reference Download!
Blog entries covering the latest Excel tricks and tips based on queries from clients and practical knowledge from our consultants.
Request info on training dates, prices and venue
The European Spreadsheet Risk Interest Group Conference (EuSpRIG 2019) Jun 17, 2019
The European Spreadsheet Risk Interest Group Conference (EuSpRIG 2019) will be held on 11-12 July 2019 in London. Real life case studies of EUC control and deep dive into data analysis,
Temporarily disable print areas in Excel Jun 1, 2019
Occasionally you may want to print everything again but you don't want to clear the print areas and then reset them once you have a full print.
Reverse Homework MS Excel Training May 21, 2019
The Reverse Homework MS Excel Training is a way to get the best out of combining online and classroom training. It is ideal for MS Excel.
Change Excel Save screen back to original May 16, 2019
Change Excel Save screen back to original method instead of using the new Backstage method.
Copying email addresses from outlook to excel May 16, 2019
Ideas on copying email addresses from outlook to excel in the easiest way
Removing line breaks from cells (the ALT ENTER’s) Apr 23, 2019
Removing line breaks from cells (ALT + ENTER's) so that the cell shows a continuous row of data without the breaks.
Excel Spreadsheet Comedy! Apr 23, 2019
Excel Spreadsheet Comedy showing how pervasive Excel is, even to the point of being in every digital image you have.
Consulting
We aim to provide the ultimate, one stop shop for all Excel users requirements, within South Africa and worldwide.
Live Training
"Recently we had a most successful in-house training session at our company. I would like to extend my thanks and gratitude."
Free Excel Tips & Tricks delivered straight to your mailbox. Sign up today.
