Microsoft Excel 2000 Intermediate

Excel Training Courses

· Excel 2010 Introduction
· Excel 2010 Intermediate
· Excel 2010 Advanced
· Excel 2010 VBA Intro Intermediate
· Excel 2010 VBA Advanced
· Upgrade to Office 2010

· Excel 2007 Introduction
· Excel 2007 Intermediate
· Excel 2007 Advanced
· Excel 2007 VBA Intro Intermediate
· Excel 2007 VBA Advanced
· Upgrade to Office 2007

· Excel 2003 Introduction
· Excel 2003 Intermediate
· Excel 2003 Advanced
· Excel 2003 VBA Intro Intermediate
· Excel 2003 VBA Advanced

· Excel 2002 XP Introduction
· Excel 2002 XP Intermediate
· Excel 2002 XP Advanced
· Excel 2002 XP VBA Intro Intermediate

· Excel 2000 Introduction
· Excel 2000 Intermediate
· Excel 2000 Advanced
· Excel 2000 VBA Intro Intermediate

· Excel 97 Introduction
· Excel 97 Intermediate
· Excel 97 Advanced

· Excel Training On-site UK
· Excel Consulting Services
· Microsoft Excel Training
· Excel Tips, Tools and Resources

London's widest choice in
dates, venues, and prices

Training formats available

On a public schedule at one of our
London training venues.
On-site at your company office UK wide
Near-site, at a location close to you
Bespoke one-to-one basis
Tailored training courses
to your requirements
See all formats...

Promotions

Excel training london

Training is available in one of our 6 London centres, on-site or tailored training courses

How to Book :: Training Schedule :: Contact Us

Other Excel training courses

Microsoft Excel 2000 Intermediate

Duration: 1 Day
Level: Intermediate
Prerequisites: A working knowledge of Excel or our Excel 2000 Introduction course
Platform: PC
Leads to: Microsoft Excel 2000 Advanced course

Syllabus includes:

Working with Large Worksheets
Viewing options
Hiding and displaying data
Printing large worksheets

Working with Multiple
Worksheets and Workbooks
Using multiple worksheets
Linking worksheets by using 3-D formulas
Consolidating data
Linking workbooks
Managing workbooks

Customising Excel
Changing options
Customising toolbars and menus

Advanced Charting
Chart formatting options
Creating combination charts
Using graphic elements Advanced Formatting
Borders and shading
Using special number formats
Working with dates
Working with styles
Other advanced formatting

List Management
Working with lists
Sorting and filtering lists
Advanced filtering

Documenting and Auditing
Comments and text boxes
Auditing features
Protection
Workgroup collaboration

Using Templates
Built-in templates
Creating and managing templates

Some feedback from recent courses...

"I got a lot of feedback from this course, which I will start using as soon as I get into work tomorrow. I enjoyed the class and the trainer was great. Keep it up!"
- J. F, Metropolitan Police Service
[Excel Intermediate]

"Overall very good format,content and trainer.Will use skills I have learned today at work."
- B.S, CBIL
[Excel Intermediate]

"Trainer extremely friendly, course excellent."
- C.C.
[Excel Intermediate]

Click here for our client list

Providing competitively priced, qualified instructor-led, Microsoft training.
Formats: public scheduled, on-site, and tailored training.
Venues: South-west London, Central London or at a location convenient to you, UK wide.
Applications: Microsoft Project Training, Microsoft Excel training, Microsoft Access training, Macromedia Dreamweaver MX training, Microsoft Outlook training, Microsoft Visio training, Visual Basic for Applications (VBA) training, Microsoft Word training, Microsoft PowerPoint training, Microsoft FrontPage training and many other applications

Is there a simpler function I can use to calculate the number of months between two dates? I am currently using the following:

=(YEAR($K$1)-YEAR(G33))*12+(MONTH($K$1)-MONTH(G33))

Where:

$K$1 = today's date which I have situated in a cell outside ..