All articles with 'tricks' Tag

31 Excel Tutorials – Learn and Be Awesome in Excel

Published on Mar 11, 2010 { 10 Comments }
31 Excel Tutorials – Learn and Be Awesome in Excel
Continue »

How to Print Excel Comments

Published on Dec 16, 2009 { 4 Comments }
How to Print Excel Comments
Continue »

Use Shapes and Images to make Prettier Charts [Dashboard Tricks]

Published on Dec 3, 2009 { 11 Comments }
Use Shapes and Images to make Prettier Charts [Dashboard Tricks]
Continue »

Group Smaller Slices in Pie Charts to Improve Readability

Published on Dec 2, 2009 { 10 Comments }
Group Smaller Slices in Pie Charts to Improve Readability
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 »

Transpose Excel Rows and Columns [Quick Tip + Video]

Published on Nov 18, 2009 { 2 Comments }
Transpose Excel Rows and Columns [Quick Tip + Video]
Continue »

How to get tick marks in Excel? [custom cell formatting]

Published on Sep 15, 2009 { 9 Comments }
How to get tick marks in Excel? [custom cell formatting]
Continue »

Pin Frequently Used Documents to File Menu to Save Time

Published on Sep 4, 2009 { 2 Comments }
Pin Frequently Used Documents to File Menu to Save Time
Continue »

Using Combo Charts to Group Related Time Events [Charting Goodness]

Published on Aug 26, 2009 { 7 Comments }
Using Combo Charts to Group Related Time Events [Charting Goodness]
Continue »

Use ROWS() and COLUMNS() formulas to generate numbers in a sequence [quick tip]

Published on Aug 17, 2009 { 2 Comments }
Use ROWS() and COLUMNS() formulas to generate numbers in a sequence [quick tip]
Continue »

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 »

Do you know these Double-click Tricks in Excel?

Published on Jun 12, 2009 { 73 Comments }
Do you know these Double-click Tricks in Excel?
Continue »

Array formula to check if a number is prime [just for fun]

Published on May 29, 2009 { 19 Comments }
Array formula to check if a number is prime [just for fun]
Continue »

Intraday Candlestick Charting [Stock Charts]

Published on May 28, 2009 { 0 Comments }
Intraday Candlestick Charting [Stock Charts]
Continue »

Excel Tips Submitted by You [Part 1]

Published on May 11, 2009 { 5 Comments }
Excel Tips Submitted by You [Part 1]
Continue »
Page 1 of 5[1]2345