Tag: Excel

Excel:  Print Right

Excel: Print Right

| February 22, 2012 | 1 Comment

  If you’re like me, you have a litany of Excel printing horror stories to tell. It seems that when things go wrong when printing an Excel worksheet they never go wrong by halves – it is usually a spectacular disaster. Hit the big red switch Well your printer probably doesn’t have a big red [...]

Continue Reading

5 Cool Excel Chart Tips

5 Cool Excel Chart Tips

| February 22, 2012 | 2 Comments

See how to tame unruly data by: – using multiple axes in Excel – adding pictures to charts – resize chart bars – add data to charts -deal with missing data Creating a basic chart in Excel is simple but when your data requires just a little bit extra attention to look its best, you’ll [...]

Continue Reading

7 Cool ‘Must Know’ Excel functions

7 Cool ‘Must Know’ Excel functions

| February 22, 2012 | 0 Comments

At its heart, Excel 2010 is a great tool for making calculations and Excel functions are the key to getting the work done fast. Here I’ll show you some of the most effective functions that Excel has to help you make calculations using worksheet data. 1          Calculating workdays To calculate the number of days between [...]

Continue Reading

Word form data to Excel

Word form data to Excel

| February 8, 2012 | 0 Comments

Learn how to create a form in Word and how to import its saved data into Excel. Creating a form in a Word document is one half of a data collection process. Once the form is completed, you will need to extract the data so you can do something with it. Here I will show [...]

Continue Reading