Category Archives: Excel

Creating a Chart in Excel When Data is Not Next to Each Other

Excel has some great features for creating charts, I remember when I first started using it and saw how easy it was to create one. You would not believe what I had to do to create a chart before then … Continue reading

Posted in Excel, Microsoft Office | Leave a comment

How to Enter a Series of Dates in Excel That Are Only Weekdays

Do you have to enter data for a bunch of dates but only need weekdays? Excel has the answer for you using the Autofill feature. It allows you to create a series of dates that only include the weekdays.  All … Continue reading

Posted in Excel, Microsoft Office | Tagged , , , , , | 1 Comment

Excel: How to Enter the Same Day but Different Month and Year

We all want faster ways to enter data and you’re probably already aware of the autofill feature in Excel. To enter a series of consecutive dates you just need to enter the one date and then click and drag on … Continue reading

Posted in Excel, Microsoft Office | Tagged , , , , | Leave a comment

How to Select Visible Cells in Excel

If you have every copied cells in a range that has some hidden rows our columns you soon discover that the hidden data gets copied too. Same applies to other features including subtotals. What would help is a command or … Continue reading

Posted in Excel, Office 2010 | Tagged , , , | Leave a comment

Getting Started with Charts for Excel for Mac 2011

Charts are a really useful way to present data and to analyse it. Aside from being good at doing calculations Excel is also good at creating charts. There are lots of different options for creating the charts and what you … Continue reading

Posted in Charts, Excel | Tagged , , , | Leave a comment

Copying Excel Data into a Word Document

If you use both Excel and Word you may well want to copy data from Excel into Word and what would be really convenient is if the data in Word updated when you change it in Excel. Well that is … Continue reading

Posted in Excel, microsoft word, productivity | Tagged , , , , , , , | Leave a comment

Selecting Data in Non-Adjacent Cells to Create Excel Chart

Creating charts in Excel is pretty straightforward and you can see how to that in this video, getting started with charts. What normally happens is you select a group of cells and then insert a chart but what do you … Continue reading

Posted in Excel, Microsoft Office | Tagged , , , , , , | Leave a comment