0345 363 1130
info@xchangetraining.co.uk
Bespoke Microsoft Excel - Introduction
Key Course Details:
Level:
Introduction
Duration:
1 Day (10am-5pm)
Price:
From £449 + VAT
Dates:
Dates to suit you
This hands-on one day training course is designed to teach delegates how to identify the components of the Excel environment, create spreadsheets, working with data, printing worksheets and more. Enhance your Microsoft Excel spreadsheets as we show you how to add a professional polish to your projects.
This course can be based around our base outline or part/fully customised according to your level & requirements. Our bespoke Microsoft Excel training is offered either Online, Onsite at your offices or at one of the XChange centres in London, Manchester and Glasgow.
This hands-on one day training course is designed to teach delegates how to identify the components of the Excel environment, create spreadsheets, working with data, printing worksheets and more. Enhance your Microsoft Excel spreadsheets as we show you how to add a professional polish to your projects.
This course can be based around our base outline or part/fully customised according to your level & requirements. Our bespoke Microsoft Excel training is offered either Online, Onsite at your offices or at one of the XChange centres in London, Manchester and Glasgow.
-
Bespoke Microsoft Excel - Introduction
Course Details
Microsoft Excel is the standard spreadsheet application, an essential component of the Microsoft Office Suite. Excel provides comprehensive tools to help you create, analyse, and share spreadsheets, and its powerful, enhanced formatting features allow users to analyse and visualise data through the creation of graphs and charts.
XChange Training offer a core training course in Microsoft Excel, covering the foundations of spreadsheet skills: how to set up and format a spreadsheet, how to work with data in spreadsheets, and how to produce professional graphs and charts using Excel.
By the end of this course you will be comfortable setting up and using spreadsheets in Excel and will be able to manipulate your data using formulae. You will also be proficient in creating professional graphs and charts, enabling you to visualise and better analyse your data.
Course Target Audience and delegate prerequisites:
You will need basic PC or Mac skills, including a solid understanding of a computer's operating system (Windows or Mac OS). You will also need to know how to launch a program, create and save files, and copy files from CDs and other media. No previous knowledge of Excel is required.
-
Full Course Outline
The following is a general outline. The range of topics covered during your training is dependent upon student level, time available and preferences of your course booking.
Overview- Overview of Excel
- The workbook environment
- Quick Access toolbar and ribbons
- Navigation and zooming
- Entering text, numbers, dates and percentages
- Copying and pasting
- Using Autofill and Autofill options
- Working with ranges
- Calculations and formulas
- Using absolute references
- Working with functions
- The AutoSum function
- Using Average(), Min(), and Max() functions
Formatting Options- Font, alignment and number formatting
- Using Cell Styles and the Format Painter
- Working and designing a list
- Sorting data
- Excel print options
- Printing large worksheets, and all or part of a worksheet
- Creating headers and footers
- Chart basics
- Modifying charts
- Printing charts
-
Training Location Options
Online ↓ London ↓ Manchester ↓ Glasgow ↓ Onsite ↓This course is offered for your convenience at one of our bespoke training centres in London, Manchester and Glasgow, Remote Online, or Onsite at your offices anywhere in the UK. Just let us know what would work best for you or your team.
Remote Online
Delivered Online to your location
Live online training offers an extremely flexible and convenient way of covering the same content as our bespoke classroom based courses. You will receive professional, certified design training from one of our experienced instructors direct to your screen, offering the perfect solution for those wishing to learn without having to travel.
Click to view Full details of our
Remote Online Training CoursesCentral London
5 St John’s Lane, Clerkenwell, EC1M 4BH
St John’s Lane is located in the heart of Clerkenwell close to the junction of Farringdon and Clerkenwell Road. Farringdon tube & train station is just a few minutes away and the training centre can also be accessed from Chancery Lane and Barbican tubes in about 10 minutes. There is also easy direct access by bus from Waterloo (243) and West End (55) with nearby stops.
Click to view Full details of our
London Training CentreCentral Manchester
Piccadilly House, 49 Piccadilly, M1 2AP
Piccadilly House is located in central Manchester directly next to the Piccadilly Gardens transport interchange with excellent bus and tram connections and is easily accessed from Piccadilly train Station (5 mins). Victoria station is also close by (around 10 mins).
Click to view Full details of our
Manchester Training CentreCentral Glasgow
Centrum Business Centre, 38 Queen Street, G1 3DX
The Queen Street training centre is located in central Glasgow within easy walking distance of the 3 local train options of Central Station, Queen Street and Argyle Street offering excellent transport connections.
Click to view Full details of our
Glasgow Training CentreOnsite
Onsite at your Offices/Premises
If you have the required set up and would prefer to have the training at your location we will be able to deliver the same session onsite at your premises as in our training centres. This will provide you with the same tailored training but without the need to travel and less disruption to you or your teams work schedule.
Click to view Full details of
Onsite Training -
Related Courses
Below are related bespoke courses for alternative tailored training options.
Bespoke Microsoft Project Training Courses
Microsoft Project - Introduction 1 Day Training CourseBespoke Microsoft Visio Training Courses
Microsoft Visio - Introduction 1 Day Training CourseBespoke Microsoft Outlook Training Courses
Microsoft Outlook - Introduction Training CourseBespoke Microsoft Word Training Courses
Microsoft Word - Introduction Training CourseBespoke Microsoft Powerpoint Training Courses
Microsoft PowerPoint - Introduction Training Course -
Client Reviews
''Good interactive training. Trainer was excellent. Thanks''
Andy Doust, RRG Group, Microsoft Excel VBA 1 Day Introduction
''Good pace and very clear directions. I will definitely be recommending XChange Training in the future. ''
Charlotte Green, AXA Investment Managers, Powerpoint & Excel - Bespoke Introduction
''I have done similar excel courses before but I felt I learnt a lot more on this one due to the way the trainer covered the material and explained everything very clearly.''
Romilly Evans, Leo, Excel - 1 Day Intermediate
''Very impressed with the training. Very informative and feel confident in going away with the knowledge of being able to complete the tasks that I have to do.''
Niki Taylor, Floramedia, PitStop Pro - 1 Day Introduction
''The course gave a great overview of HTML and CSS - a brilliant basis to continue onwards from. ''
Corin Rogerson, Tesco, HTML & CSS - 2 Day Introduction
''Excellent service and a great place to be trained with superb and well presented facilities. Trainer couldn't have been better - we will definitely invest in another training course.''
Ben Ellis, National Lottery, Photoshop - 2 Day Advanced
''The trainer was wonderful and imparted a great deal of personal experience as well as delivering a superb course in a friendly, intelligent and comprehensive manner. I've learned so much in just 2 days!''
Tony Crowther, Classic American, InDesign - 2 Day Introduction
''I thoroughly enjoyed the course. The training was highly relevant and interactive. The instructor was enthusiastic and engaging and I would have no hesitation in recommending the day to others.''
Rebecca Leese, Blackbridge Communications
''Had a very interesting 2 days within pleasant surroundings with a friendly, knowledgeable instructor. Perfect C4D training course.''
Darren Mael, Billington Cartmell, Maxon Cinema 4D - 2 Day Intermediate
''The instructor was fantastic - very easy going and very knowledgeable. I really enjoyed the course and will definitely look to have more training in future through XChange Training.''
David Merritt, DSM Services, SketchUp - 1 Day Introduction
Frequently Asked Questions:
What dates are available for this course?
As a bespoke course the date arrangement is based around your requirements and availability in our schedule. With your guide of when you are looking for the training we will advise suitable date options ahead of finalising the planned date(s).
Can the content be tailored to my requirements?
Yes we are flexible about tailoring content and can adapt to be fully based on your requirements, a mixture of content from different levels of our base courses or a base outline with some additional focus areas.
Can this course be delivered live online?
Yes we can provide the same bespoke course as a live online session connecting to you or your group with either Zoom or Microsoft Teams if preferred.
What is the cost to deliver the course onsite?
We are equally able to deliver our bespoke training onsite at your premises and the cost to deliver this is the same structure as classroom with the addition of basic expenses depending on your location. Onsite courses in and around London, Manchester and Glasgow are usually without additional costs.
Can the course include my work samples?
It is often possible to review and include consideration towards sample files however the main course content is usually structured around prepared examples which are best suited to the planned content and structure of teaching the required skills in the best format.
Bespoke Training Prices:
1 Delegate: £449
2 Delegates: £549
3 Delegates: £599
4 Delegates: £649
5 Delegates: £699
6 Delegates: £749
7 Delegates: £799
8 Delegates: £849
Additional costs may apply for onsite training and specialist requirements. Prices exclude vat.
Over 15 years of providing certified Microsoft Excel training courses UK wide
5/5 Stars
Mark is an excellent communicator and instructor, it was an enjoyable training session with humour but expert advice and instruction along with an element of patience on his behalf.
28/10/2020
5/5 Stars
We'd like to use your company in the future, and I think this is the best feedback I can give.
28/10/2020
5/5 Stars
Very clear and great trainer. Great pace.
05/08/2020
5/5 Stars
The training course today was excellent. The information provided was explained in detail and i will take a lot of information away. I really enjoyed gaining more knowledge.
03/12/2019
5/5 Stars
Rob, was excellent in his knowledge and explanation of Excel. The course was well tailored to my needs.
03/12/2019
5/5 Stars
Great instructor, very patient
19/07/2019
5/5 Stars
I have done Excel classes in the past however Usha's class was very engaging and I learnt so much in the class
19/07/2019
5/5 Stars
Usha was a Fab teacher, myself and the others felt that we had learnt a lot from todays training. We really liked the structure of the class and the training tasks we had to complete throughout the day
19/07/2019
5/5 Stars
Paul was very helpful and knowledgeable. I would definitely like to be trained by him again in the future.
11/07/2019
5/5 Stars
Rob was fantastic, made sure we understood the topics and answered any questions we had
//
5/5 Stars
Rob worked at a good pace, gave clear instructions and put me at ease, Excel was something I was nervous about but this was not the case once Rob started the training.
//
5/5 Stars
Excellent course and very informative. Rob was very helpful and happy to answer any questions.
//
5/5 Stars
Excellent training. Very structured and friendly!
//
5/5 Stars
Really helpful learning about V & H Lookup and also Macros. Also worked with the trainer on some of the spreadsheets that I use day to day for tips etc on them. Very useful day. Thank you
//
5/5 Stars
The course was incredibly informative and will benefit me daily within my job. Usha was incredibly knowledgeable.
//
5/5 Stars
Very informative and easily digestible information focused on your specific area of working. Very good that you can put the information into action immediately.
//
Whats Included:
Tailored course content 
Online, Onsite or Classroom 
Choice of dates to suit you 
Certified hands-on training 
Multiple delegate discount 
Authorised Course Certificate 
6 months post course support