Blog

  • Nesting Excel Formula – MATCH, ISNA and IF to find which items are missing from a list

    Here’s a video I’ve recorded for our delegates who have completed Excel Level 3 Gurus course. It shows how to ‘nest’ 3 formulas to find if an item appears in a different list. That’s a useful thing to be able to do, so I take you step by step through how to build the formula. Try it yourself!

    Read more…
  • 3D Animations in PowerPoint have arrived!

    A leap forward in the way we use animations in PowerPoint has been developed by Microsoft. In this short video I show you what you can achieve using animations to move text or pictures in your presentation, then how you can rotate 3D images. We teach animations on our PowerPoint Professional course, but you can only use 3D images if you have an Office 365 subscription.  

    Read more…
  • ECMS new venue

    Read more…
  • Excel – Adding a new Window to view your spreadsheet

    Opening a New Window in your document means you can work in different places at the same time. This is handy if you have figures which feed into a cumulative sheet, such as totals for different regions or products, or even a 12 monthly totals sheet. In this short ‘how to’ video I’ll show you how to do it and why it is useful. If you want to learn this and other skills to manipulate your data, give us a few details and…

    Read more…
  • Select to the last cell

    This video explains how to the use some of the many shortcut techniques to move and select data on your spreadsheet. If you want to format a section of your Excel spreadsheet, click on the cell you want to select from and use the keyboard shortcut described in my short ‘How To’ video below. I’ll also share a tip for what to do if the selection ‘overshoots’ the range you want to select. These tips are part of our…

    Read more…
  • Excel BI Training Courses

    Watch the clips below as I show you some of the things you can learn on our higher level Excel courses. We provide Excel Business Intelligence (BI) Level 4 where we look at how to cleanse data quickly and combine files just by dropping them into a folder, repeatedly, Excel Dashboards Level 5 (full of advanced formulas and techniques to make a Dashboard within your spreadsheet, and Excel Visualizations Level 6 where you will learn your first DAX…

    Read more…
  • Word – Autofit your tables

    One frustration I had with Word was when you pasted a table of data into your document but it overflowed the right hand margin. In this short how to video I’ll show you how to quickly correct this! Learn More Or give us a call on 01952 581550

    Read more…
  • PowerPoint Morph transitions

    Microsoft is always bringing out new features and you may wonder if they’re going to be useful to you? PowerPoint Morph can be used to smoothly transition between two different pictures using this simple technique. Watch my short ‘How To’ video now

    Read more…
  • Are you Unconsciously Incompetent?

    One of the things that fascinates me about teaching is how to make the learning ‘sticky’ – in other words, stick in the mind of the person I’m training. I thought I’d share something that may help you understand what’s going on when you learn a new skill – and perhaps inspire you to try harder to integrate that new learning into your every day routine at work, ensuring that all those good ideas…

    Read more…
  • Word – Editor helps you improve your writing

    Screenshot of Word Editor

      Word Editor is a great tool that helps you strengthen your writing, teaching you “why” it suggested a change of word or grammar. The short video below shows you it in action Learn More Or give us a call on 01952 586465

    Read more…