Special Offers: Big Summer Discounts on All On-Site Microsoft Excel Training Courses
£75 Off Microsoft Excel Training Throughout July 2010
During the summer months we will be discounting a range of Microsoft courses starting with the popular MS Excel. We specialise in on-site training and all our courses can be delivered at your offices anywhere in the UK. We can even provide your with laptops if necessary so all you need is a suitable office. Our daily rate includes personal training manuals and qualified tuition. We can also customise any of the following courses to suit your exact needs:
Discounted Training Rates
- 1 - 3 learners: was £400, now £325
- 4 - 6 learners: was £450, now £375
- 7 - 10 learners: was £400, now £425
Daily rate includes personal Microsoft Excel training reference manuals & qualified intructor-led tuition. We can also provide you with laptops if required.
Call: Freefone 0800 2922842
Email: info@pbatraining.co.uk
What Our Clients Say...
A big thankyou for the Microsoft Excel and Word courses you recently delivered to a group of Managers studying for a degree in World Class Manufacturing. Initially this course was planned for two sessions however your enthusiasm, knowledge and teaching style resulted in a unanimous decision to invite you back for a third session.
Any would be clients will be happy to learn that your teachings are aimed at persons with varied IT competencies, encompassing beginners to advanced levels. I would not hesitate in recommending your services and on behalf of the group, thankyou for raising our competence levels in Microsoft Excel and Word.
Steven Smith
Shift Manager
Corus UK
"Paul delivered several Microsoft Excel one day training courses, at varying levels to a variety of our personnel ranging from operational firefighters to office based staff.
The feedback from those attending the courses was extremely positive. All delegates greatly enjoyed the sessions and felt that they had gained much from their attendance. They also felt that the delivery of the training was matched to their needs and that the manner and level of instruction encouraged them to take part and fully enjoy the session."
Leslie Butcher
Learning & Development Co-Ordinator
Humberside Fire & Rescue Service
Microsoft Excel Foundation 1 Day Training Course
The Course Includes:
- Introduction to spreadsheets
- Overview of Excel menus and toolbars
- Entering and editing data & text
- Adjusting column & rows
- Inserting and deleting columns & rows
- Selecting & formatting data
- Copy and pasting data & text
- Using Auto sum for quick calculations
- How to build formulas to perform calculations
- Introduction to Excel functions
- Printing Excel spreadsheets
Microsoft Excel Intermediate 1 Day Training Course
The Course Includes:
- Excel overview refresher
- Understanding absolute cell addresses
- Linking data between workbooks
- Using advanced formulas & functions
- Highlighting values with conditional formatting
- Understanding Conditional Logic: Using IF statements
- Finding records using VLookup & HLookup functions
- Creating subtotals & working with levels
- Sorting data using advanced filters
- Sorting data using pivot tables and charts
- Creating and using macros
- Protecting workbooks, worksheets & individual cells
- Consolidating data in multiple worksheets & workbooks
- Data validation: creating drop-down lists
- Embedding spreadsheets in Word & PowerPoint documents
- Using charts and graphs to display data
Microsoft Excel Advanced 1 Day Training Course
The Course Includes:
- Advanced Conditional Logic: nested IF, AND, OR & NOT functions
- The Maths Functions: using SUMIF, COUNTIF & AVERAGEIF
- New Excel 2007 Functions: using SUMIFS, COUNTIFS & AVERAGEIFS
- Working with Data: the TRIM, FIND, MID & VALUE functions
- Finding Data Records: using the MATCH & INDEX functions
- Advanced Database Functions: the DSUM, DAVERAGE & DCOUNT functions
- Analytical Tools: using Goal Seek & Scenarios