All articles with 'Microsoft Excel Formulas' Tag

Data Validation using an Unsorted column with Duplicate Entries as a Source List

Published on Feb 2, 2010 { 7 Comments }
Data Validation using an Unsorted column with Duplicate Entries as a Source List
Continue »

Flu Trends Chart in Excel [Yes, we can edition]

Published on Jan 22, 2010 { 11 Comments }
Flu Trends Chart in Excel [Yes, we can edition]
Continue »

Use “Script” font to make your incell charts realistic [quick-tips]

Published on Jan 21, 2010 { 16 Comments }
Use “Script” font to make your incell charts realistic [quick-tips]
Continue »

Dr. Scroll-bar Mortgage Calculator or: Why you should not be borning and use form controls

Published on Jan 20, 2010 { 11 Comments }
Dr. Scroll-bar Mortgage Calculator or: Why you should not be borning and use form controls
Continue »

Extract usernames from E-mail IDs [using LEFT and FIND formulas in Excel]

Published on Jan 19, 2010 { 17 Comments }
Extract usernames from E-mail IDs [using LEFT and FIND formulas in Excel]
Continue »

Product Recommendation – Excel Dashboard Training Kit

Published on Jan 14, 2010 { 9 Comments }
Product Recommendation – Excel Dashboard Training Kit
Continue »

A New Year Resolutions Template that Kicks Ass

Published on Jan 7, 2010 { 14 Comments }
A New Year Resolutions Template that Kicks Ass
Continue »

Highlighting Repeat Customers using Conditional Formatting [Part 2 of 2]

Published on Jan 6, 2010 { 8 Comments }
Highlighting Repeat Customers using Conditional Formatting [Part 2 of 2]
Continue »

Conditionally Formatting Dates in Excel [Part 1 of 2]

Published on Jan 5, 2010 { 6 Comments }
Conditionally Formatting Dates in Excel [Part 1 of 2]
Continue »

Sales Dashboards – Visualizing Sales Data – 32 Dashboard Examples & Implementations

Published on Jan 4, 2010 { 34 Comments }
Sales Dashboards – Visualizing Sales Data – 32 Dashboard Examples & Implementations
Continue »

How to Find Dates of Public Holidays using Excel

Published on Dec 24, 2009 { 4 Comments }
How to Find Dates of Public Holidays using Excel
Continue »

2010 Calendar – Excel Template [Downloads]

Published on Dec 11, 2009 { 9 Comments }
2010 Calendar – Excel Template [Downloads]
Continue »

How to pick a random date? [Formulas]

Published on Dec 8, 2009 { 3 Comments }
How to pick a random date? [Formulas]
Continue »

Christmas Gift List – Set your budget and track gifts using Excel

Published on Dec 7, 2009 { 10 Comments }
Christmas Gift List – Set your budget and track gifts using Excel
Continue »

Findout Thanksgiving Day’s Date for Any Year [Excel Formulas]

Published on Nov 25, 2009 { 17 Comments }
Findout Thanksgiving Day’s Date for Any Year [Excel Formulas]
Continue »
Page 1 of 6[1]23456Next »