We've reduced the cost to £100 to celebrate 20 years delivering Microsoft courses across the UK. This course covers the basics of Microsoft Excel, providing you with the necessary skills and shortcuts to start using Excel efficiently and confidently.
This course will cover widely used basic functions of Microsoft Excel at introduction level. Knowledge of Excel before joining the course is not required but would be useful. The course is informal but structured and you will be encouraged to ask questions as the course develops. You will train using the latest version of Microsoft Excel 2016 on our computers. The lessons are structured using sample data that relate to your course handbooks. Free training downloads are provided to all delegates on completion of the course. There will be a 15 minute break in the morning and afternoon, with 45 minutes for lunch. Lunch on our scheduled courses is provided by IPSO FACTO. Refreshments are available throughout the course.
Is this course for you?
You are new to Microsoft Excel or you struggle with Excel at work, and have had no formal training. You may also want to consolidate your understanding of Excel at this level before moving onto level 2.
Join this scheduled course at our training centre in Whiteley, near Fareham, Portsmouth and Southampton.
Or, consider onsite training using our computers at no extra cost. £100/delegate or £650 for up to eight delegates on the same course. Minimum charge: £400 plus vat.
Link to Office 365 Microsoft Excel Download
Follow this link to Microsoft to read the capabilities of Excel 2016. You can also buy it or try it for free.
Aim & Objectives
To create and edit simple Microsoft Excel worksheets and workbooks.
To improve your confidence when using Microsoft Excel at this level.
By the end of this course you will be able to:
Create and edit simple formulas
Format spreadsheet data
Sort a list of data and quickly answer a range of questions
Filter a list of data and quickly answer and present data responding to a range of questions
Create simple but effective business charts
Print spreadsheet data and charts
Learn a range of useful short cuts
Introduction to Excel (Get to know Excel)
Learn a few important facts about Excel – Techniques for selecting cells and data – Enter spreadsheet data – use shortcuts – Prepare the quick access toolbar – Saving to local – 365 SharePoint – OneDrive.
Simple formulas (Create useful formulas)
Learn common mistakes – Use different techniques to create formulas – BODMAS – AutoSum – Insert Function – Formulas tab – Percentage calculations – Validate simple formulas – Referencing cells – Managing sheets.
Formatting techniques (Simplify your data)
Learn how to use a range of formatting techniques to create structure in your spreadsheet.
Lists of business data (Input, edit and question your data)
Interrogating and manipulating lists of business data are important skills. Learn how to input data using shortcuts, manipulate data, and quickly answer a range of questions relating to the data.
Business Charts (Create high impact charts)
Learn how to use important selection techniques – chart options – create and edit charts
Printing (Print different types of data)
Understand how to: Print lists – Print charts – use Page Break Preview
Excel shortcuts (Time savers)
There are many useful time saving shortcuts included in the course
Feedback from recent course delegates.
Name: Chelsea B.Company: More on Reviews.co.uk
APM PFQ (Introductory Certificate) course review
The PFQ (APM IC) was for me a good introduction into understanding the ‘Project Management’ world better. It helped me to identify areas and processes that I am not yet familiar with but I now have more confidence in tackling. Passing this course has further confirmed that I do want to go on to study for the APMP qualification. Chelsea B.
I attended the project management qualification in December (having already attended the PRINCE2 course in November). Although a challenging subject, I found that the training was engaging because there was adequate time to not only listen but to also give examples and hear examples from other individuals from the class. This aids to help people’s understanding or misunderstanding in some cases and help breakdown the subject into easier chunks. It also helps that IPSO FACTO have in my opinion some of the most experienced instructors in the country, meaning that if you just don’t get something they bring their personal experience into the story to help your understanding. Simon M.
I just wanted to write and say how much I enjoyed the PRINCE2 course last week. The whole Ipso-Facto experience was brilliant, from your prompt help in providing information to determine whether the course was going to be right for me and arranging for Tim to call me, through registration and the quality of the preparation materials sent out, to starting the course with Julia Gosse. Julia is a fantastic trainer who not only clearly has bags of experience in project and business management but is also a very highly skilled trainer. Whilst there was a huge amount to learn, she made it easy to absorb and tolerated enormous amounts of questions with patience and kindness.
The venue was easy to get to and we definitely appreciated the surroundings including the lovely cafe for lunch and the lake. I will definitely recommend Ipso-Facto as a local training provider and will come to you first if you are running courses I am interested in for the future.
Oh and I passed both foundation and practitioner exams! [Rebecca S]
I attended the two-day Microsoft Project Level Introduction/Intermediate. The course was delivered very professionally with plenty of time to recap and understand each aspect. The environment and facilities were also of a high standard. [Andy]
I attended the course for two days and Tim was a great trainer, clear explanation of concepts. I have learned some good techniques for better time management and using of resources. Highly recommended. [Daniel C]
I completed the PMQ course through IPSO FACTO and they were a pleasure to work with from the moment I first made an enquiry. Every piece of course administration was made simple for me and the classroom facilities were just perfect. The course instructor was professional, knew the subject very well and focused our learning in a practical way to help put it into perspective. Overall, a very professional experience and I would recommend IPSO FACTO as a quality training company. Thank you. [Scott Sellars]
The Excel Level 2 course was brilliant. Having not had much experience of using Excel, I wasn’t sure how much I’d learn but Tim the course tutor was great and went at a good pace, making sure I understood as we went along. I learnt things I wouldn’t have had a clue about before including; Conditional Formatting, Range Names, Pivot Tables, IF Functions, Vlookups and a range of shortcuts to make daily tasks much quicker. I’m looking forward to putting It into practice. Would definitely recommend! Kirsty R.
We’ve completed a range of Microsoft Office SharePoint training courses for users, super-users and developers across our organisation. The training has been highly successful and beneficial to our staff at NATS. Duncan the trainer was very patient and knowledgeable and we would recommend IPSO FACTO for all your Microsoft SharePoint training. Stuart W.