All articles with 'spreadsheet' Tag

Create a number sequence for each change in a column in excel [Quick Tip]

Published on Jun 29, 2009 { 4 Comments }
Create a number sequence for each change in a column in excel [Quick Tip]
Continue »

Use Enter to Paste Copied Values in Excel [Quick Tip]

Published on Oct 17, 2008 { 8 Comments }
Use Enter to Paste Copied Values in Excel [Quick Tip]
Continue »

Sorting a list of items in random order in excel – using formulas

Published on Sep 23, 2008 { 6 Comments }
Sorting a list of items in random order in excel – using formulas
Continue »

Management Dashboards – Highlight Values Based on Percentile [Part 3 or 6]

Published on Sep 3, 2008 { 15 Comments }
Management Dashboards – Highlight Values Based on Percentile [Part 3 or 6]
Continue »

6 charts you will see in hell

Published on Sep 3, 2008 { 10 Comments }
6 charts you will see in hell
Continue »

Aligning charts, objects on spreadsheet [excel layout tip]

Published on Aug 28, 2008 { 11 Comments }
Aligning charts, objects on spreadsheet [excel layout tip]
Continue »

Creating KPI Dashboards in Microsoft Excel [Part 2 or 6] – Adding One Click Sort

Published on Aug 27, 2008 { 48 Comments }
Creating KPI Dashboards in Microsoft Excel [Part 2 or 6] – Adding One Click Sort
Continue »

Excel Links of the week – What do you dream about? [Aug 19]

Published on Aug 19, 2008 { 0 Comments }
Excel Links of the week – What do you dream about? [Aug 19]
Continue »

Beyond If and Sum, 15 really useful excel formulas for everyone

Published on Aug 13, 2008 { 49 Comments }
Beyond If and Sum, 15 really useful excel formulas for everyone
Continue »

Excel Links of Week – Who is Obama edition? [Aug 12]

Published on Aug 12, 2008 { 2 Comments }
Excel Links of Week – Who is Obama edition? [Aug 12]
Continue »

Use min-max charts to show the spread of data – Charting Best Practice

Published on Aug 11, 2008 { 18 Comments }
Use min-max charts to show the spread of data – Charting Best Practice
Continue »

Excel Basics: How to add drop down list to validate data

Published on Aug 7, 2008 { 14 Comments }
Excel Basics: How to add drop down list to validate data
Continue »

Excel links of the week : ‘what can excite you most’ [Aug 4]

Published on Aug 4, 2008 { 2 Comments }
Excel links of the week : ‘what can excite you most’ [Aug 4]
Continue »

Excel can be Exciting – 15 fun things you can do with your spreadsheet in less than 5 seconds

Published on Aug 1, 2008 { 56 Comments }
Excel can be Exciting – 15 fun things you can do with your spreadsheet in less than 5 seconds
Continue »

11 very useful excel keyboard shortcuts you may not know

Published on Jul 29, 2008 { 25 Comments }
11 very useful excel keyboard shortcuts you may not know
Continue »
Page 1 of 2[1]2