Blog

  • 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…
  • Sharing a document to Edit together

    One of the great advantages of Office 365 is how easily you can share a document and work collaboratively with colleagues to edit together. Instead of attaching a copy of a file to an email, you can share it instead and colleagues can work collaboratively in the same document at the same time. Two minds are better than one! Imagine working quickly with your whole team, combining ideas and creatively producing the best document together.

    Read more…
  • Excel Autofill to complete sequences

    A really simple skill that we teach on our Excel Level 2 Ninjas course is Autofill. I find most people who use Excel don't know how to do this - or only know part of what it can do.

    Watch my short 'how to' video to find out more.

    Read more…
  • OneNote for note-taking

    Microsoft OneNote is an extremely useful piece of software – not just for anyone in an office based occupation. In this blog I’ll show you how one engineer I trained to use the program kept his work organised and saved himself hours of time using OneNote on his phone whilst mobile then opening the program on his desktop when he returned to the office to do his ‘paperwork’. Not only did he have a record of every job he’d done that day,…

    Read more…