PrintDURATION: 1 day
|TIME: 09:00 to 16:00 GMT|
With 20 years experience and working with a wide range of clients, we have created our highly effective Microsoft Excel 2016 starter course. The aim of our course is to improve confidence while exploring the features in Excel. The basics of Microsoft Excel are covered in an informal environment and you will gain the necessary skills and shortcuts to start using Excel efficiently and confidently.
This covers the widely used basic functions of Microsoft Excel at introduction level. Prior knowledge of Excel is not essential but is beneficial. The course is informal but structured and you will be encouraged to ask questions as the course develops. The training will be delivered using the latest version of Microsoft Excel 2016 on our computers. The lessons are structured using sample data that relates to your course handbook. 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.
This course is aimed at those who are new to Microsoft Excel or those who are finding it challenging to use Excel at work and have had no formal training. It is also for those who want to consolidate their understanding of Excel at this level, prior to progressing onto level 2.
Onsite: £650+VAT for up to eight delegates on the same course. Minimum charge: £540+VAT for four delegates.
Scheduled course: £135+VAT per delegate, discount for groups.
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.
By the end of this course you will be able to:
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.
Learn common mistakes – Use different techniques to create formulas – BODMAS – AutoSum – Insert Function – Formulas tab – Percentage calculations – Validate simple formulas – Referencing cells – Managing sheets.
Learn how to use a range of formatting techniques to create structure in your spreadsheet.
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.
Learn how to use important selection techniques – chart options – create and edit charts
Understand how to: Print lists – Print charts – use Page Break Preview
There are many useful time saving shortcuts included in the course
Feedback from recent course delegates.