All articles with 'learn' Tag

Excel Formula for Finding Repeated Words in a Cell

Published on Nov 11, 2008 { 8 Comments }
Excel Formula for Finding Repeated Words in a Cell
Continue »

15 MS Excel Tips to Make you a Productivity Guru

Published on Oct 16, 2008 { 20 Comments }
15 MS Excel Tips to Make you a Productivity Guru
Continue »

Display decimals only when the number is less than 1 [Excel number formatting tip]

Published on Oct 2, 2008 { 5 Comments }
Display decimals only when the number is less than 1 [Excel number formatting tip]
Continue »

Excel KPI Dashboards – Adding Micro Charts [Part 4 of 6]

Published on Sep 10, 2008 { 22 Comments }
Excel KPI Dashboards – Adding Micro Charts [Part 4 of 6]
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 »

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 »

Date with my sheet – 10 tips on using date / time in excel

Published on Aug 26, 2008 { 12 Comments }
Date with my sheet – 10 tips on using date / time in excel
Continue »

Creating KPI Dashboards in Microsoft Excel [Part 1 of 6]

Published on Aug 20, 2008 { 58 Comments }
Creating KPI Dashboards in Microsoft Excel [Part 1 of 6]
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 »

Want to Feed RSS to your Excel Sheet? Read this!

Published on Jul 30, 2008 { 18 Comments }
Want to Feed RSS to your Excel Sheet? Read this!
Continue »

Shuffle a list of numbers / items in excel spreadsheet

Published on Jul 28, 2008 { 13 Comments }
Shuffle a list of numbers / items in excel spreadsheet
Continue »

Changing Sort Orientation in Excel – Sorting across columns instead of rows

Published on Jul 22, 2008 { 5 Comments }
Changing Sort Orientation in Excel – Sorting across columns instead of rows
Continue »

Excel Bullet Graphs

Published on Jul 21, 2008 { 11 Comments }
Excel Bullet Graphs
Continue »

Bingo / Housie Ticket Generator in Excel

Published on Jul 16, 2008 { 35 Comments }
Bingo / Housie Ticket Generator in Excel
Continue »
Page 1 of 2[1]2