basic training excel - Excel

The UK's most regular instructor-led training courses.
Training information: basic training excel · Excel training course · Microsoft Excel Training
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Excel

Lucy has attended:
Excel Introduction course
Excel Intermediate course

by - delegate Lucy [1 post] (2007 Oct 3 Wed, 16:36) Reply

How necessary are the skills in the advanced course for everyday work?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Nov 21 Fri	Bloomsbury	3	book now	£224	£235
2007	2008 Nov 27 Thu	Bloomsbury	4	book now	£240	£245
2003	2008 Nov 28 Fri	Southwark	1	book now	£235	£240
2003	2008 Dec 3 Wed	Bloomsbury	2	book now	£235	£240
2003	2008 Dec 5 Fri	Bayswater	6	book now	£195	£205
2002/XP	2008 Dec 10 Wed	Tooting	0	FULL
Full Schedule: See all 99 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: excel

by - trainer Amanda diamond contributer [1205 posts] (2007 Oct 3 Wed, 16:51) Reply

Hi Lucy

Thanks for your question.

It depends on what you need to be able to do in Excel on a day-to-day basis. The advanced course does cover some useful functions - IF, SUMIF, Database function; along with pivot tables and macros which can also be useful (again depending on what you're doing).

The outline can be found at www.microsofttraining.net/excel-training-in-london-2003-advanced.php

Amanda

· How to Create Better Excel Spreadsheets: Part One
· Microsoft Excel's Best Kept Secret
· Tools From Advanced Excel Courses: Goal Seek and Solver
· Microsoft Excel Training - Numerical excellence for all
· Creating Smarter, Customized Invoices for your Small Business with Microsoft Excel

Excel tip:

DATEDIF function

The DATEDIF function is a worksheet function that computes the difference between two dates. This function is documented only in the help files for Excel 2000. It isn't documented in Excel 2002.
the formula function is:
=DATEDIF(Your age,Today(),"Y")
Y stands for year

View all Excel hints and tips