best training excel intermediate - data
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 » best training excel intermediate - Data

best training excel intermediate - Data

resolvedResolved · Low Priority · Version Standard

replyReply Wed 17 Oct 2007, 15:20Delegate Mike said...

Mike has attended:
Excel Advanced course

Data

How can I put Excel functions on Access table?

For upcoming training course dates see: Pricing & availability

replyReply Mon 22 Oct 2007, 16:28Trainer Richard said...

RE: Data

Access can process data in similar ways to Excel, although there are limitations. What did you have in mind?

 

Excel tip:

Adding up time greater than 24 hours

When you add up time if it exceeds 24 hours i.e 27 hours appears as 03:00. Go to Format / Cells / Number / Custom. The format is hh:mm but if change it to [hh]:mm it will add up to the correct amount of hours.

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