It is currently Mon Sep 06, 2010 6:54 am


 Forum 
 Forum   Topics   Posts   Last post 
No new posts Excel - Tips and Tricks

Shortcuts, tit-bits and those time savers that you never knew existed.

8

9

Tue Jun 02, 2009 11:13 am

Damo View the latest post

No new posts Excel - Charts

Your charts need never be boring blocks of colour. (btw - pink charts are just wrong)

2

2

Tue Jun 02, 2009 10:21 am

Damo View the latest post

No new posts Excel - Functions (Standard)

Standard built-in functions are sometimes elegant, sometimes ugly, but calculate faster than Custom/VBA.

2

2

Tue Jun 02, 2009 8:32 am

Damo View the latest post

No new posts Excel - Functions (Custom/VBA)

When you can't find the function that you need, why not make one? It really isn't that difficult.

2

4

Fri Jan 08, 2010 9:58 am

Damo View the latest post

No new posts Excel - Connecting to Access

Excels limit is 65536 rows per sheet. Why not store your data in Access then create refreshable links.

0

0

No posts

No new posts Excel - VBA code examples

Cool stuff that excel does not normally do

1

2

Wed Oct 21, 2009 11:03 am

Damo View the latest post

No new posts Excel - Custom Cell Formats

Correct cell formatting can help to create that polished professional look.

1

2

Mon Jun 01, 2009 3:13 pm

Damo View the latest post



Who is online

Users browsing this forum: No registered users and 1 guest


Jump to:  
cron
Powered by phpBB © phpBB Group.
Designed by Vjacheslav Trushkin for Free Forums/DivisionCore.