Introduced in Excel 2010, Sparklines create charts within a cell. It can help to show one figure in context with others and illustrate trends. In this example a blank column is created for the sparklines before selecting the adjacent data. In Excel 2013 the Quick Analysis feature has now brought Sparklines to the fore. Perfect […]
One of the most common questions in PowerPoint training is “how can I see something different on my screen to the audience?” The answer is complicated and involves multiple graphics card outputs. The Presenter View was added in 2010 but has really come into it’s own in PowerPoint 2013. In Presenter View you can see […]
So many times people pick the wrong chart type for their data. There’s a time and a place for pies, and lines aren’t for everyone. Picking the right one takes a bit of thought. The Charts option in the Quick Analysis gallery, a new feature for Excel 2013, allows the user to quickly view and […]
You can add an extra “huzzah” to your presentations using this Powerpoint advanced technique. Adding narration to a presentation can be used to add variety and interest to your presentation. If you can’t be there to give the presentation or if you suffer from nerves, you can record your narration. The bonus of using narration […]
I have created a blank presentation, using the File menu, and then selected New, and Blank presentation PowerPoint gives me one slide. Now I know I’m going to need at least three slides for my presentation, so I want to add two more slides. I use the ribbon, I’m already in the Home tab, so […]
Here’s a quick way to create a check list to print out. Type your list in Word, then select all the text. Now you can add the bullet points. In the Home tab, select the down arrow next to the bullet point (located in the paragraph section of the ribbon). You can roll over the […]
You may be proofreading a huge document, and half way through, you spot a spelling error. This error may be repeated in many places in the report but you need to email the report to your manager in five minutes. You could proof read the report and try to spot each error and replacing it […]
I use Excel for planning work and setting deadlines and I always work better if I know the due date for a piece of work. I used to manually work out the number of working days between dates, using my Outlook calendar, and then switching between screens to then add the dates to my Excel […]
You can easily add a professional look to a long document by adding different headers and footers on odd and even pages. Go to Page Layout tab then select Page Set Up options. Choose the Layout tab, and tick the Different Odd & Even box and make sure you have selected to Apply to whole […]
One of the “wow” moments on my recent Microsoft Word Course was learning how to add a diagram to Word 2010. (Alright, I know, I’m easily pleased). I was worried that I’d have to try and figure out how to create boxes, get them to fit, then get the text to fit…I wasn’t looking forward to […]
Document themes are a quick way of adding a professional edge to your Word document. It saves time so you don’t have to spend time choosing the individual elements of colours, headings, fonts, and other effects. This is a bit more of an advanced word skill but it is very easy to do. You […]
I want to write a letter with a visual reminder not to send it to soon…what I need is a watermark with the word “draft”. It is no mystery and ridiculously easy… Here is a plain letter. The tab I need to use is Page Layout. I click on the watermark button and it gives me […]
Adding a screenshot to a Word 2010 document is easier than I thought and gives my work a professional edge. Here’s how to do it. Go to the screen you want take the screenshot from. Press the Print Screen button on they keyboard. (Word 2010 will save this into the gallery…) Go back to the […]
KeyTip? 5 minutes ago I had no idea what that was. So much so, that I thought, well, it can’t be that important if I haven’t heard of them before…such a little thing, but oh-so-useful. What is a KeyTip? Well, it’s another name for a keyboard shortcut using your Ribbon. In Word 2010, I can […]
Converting a list into a table for a better looking Word document I make a lot of lists. They are useful for quick references within a text, and often I used to type a list and spend too much time making it all fit. This often left the list looking a bit scrappy, almost like […]
Here’s a brief tip on how to instantly brighten up your Excel spreadsheet with very little effort. By changing the colours of the tabs, your Excel Worksheet will change from being dull and boring to exciting and colourful! It will also help in organization, being particularly useful when organizing all your Excel Worksheets relating to […]
Here’s how to view two Excel 2010 workbooks at the same time, side by side, a very useful tip when you want to compare data without having to go back and forth! 1) Open both Excel workbooks 2) Select Window then select Compare Side by Side with (Spreadsheet 2) 3) When you have finished, […]
When you have an Excel Worksheet with masses of data, it’s not going to be easy to sift through it. So, in order to view sections of data, you can use the filter tool. Select the cells you want to filter (no need to select the column headers), then click the Home tab on the […]
If you want to make your Excel Worksheet appear a little less dull, or maybe you want to draw attention to a certain section of text, why not try rotating the text. And here’s how you can do it.. – Select the cell with the text in you would like to rotate. – Click the […]
If you want to add more than one row to an Excel Worksheet, drag select the number or rows you want added to the spreadsheet. Then right click on these selected rows, choose Insert from the menu, and the new rows will be added above the rows you first selected.
If you want to add a row to an Excel spreadsheet, these are the simple steps you should take: With your mouse, right click on the row header below where you want the new row to be added. Then, click Insert. Follow exactly the same steps if you want to add a column […]
If you don’t want part of the Excel worksheet to be visible or when you don’t want certain data to appear in print outs, then a simple solution is to temporarily hide columns and rows. Hide a single column: 1) Right click on the column header of the column you want to hide (this is […]