microsoft+excel+training - excel
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft+excel+training - Excel

microsoft+excel+training - Excel

resolvedResolved · Low Priority · Version Standard

replyReply Tue 7 Aug 2007, 15:41Delegate Sonia said...

Sonia has attended:
Excel Intermediate course

Excel

FORMAT: What is the differnce in using a format painter and setting styles?

For upcoming training course dates see: Pricing & availability

replyReply Wed 8 Aug 2007, 14:00Trainer David said...

RE: Excel

Format painter allows you to locally change a format, a Style allows you to globally change a format.

 

Excel tip:

Counting Blanks

Some times you want to check if there are cells missing data in your range. You can use the COUNTBLANK FUNCTION to acheive this. It is =COUNTBLANK(Range). Note Cells with formulas that return "" (empty text) are also counted. Cells with zero values are not counted.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard