Excel 2016 Formulas and Functions
Learning how to use Excel can be a smart investment since maximum jobs require you to have knowledge of basic Microsoft Excel.
If you are about to get in the job market or looking forward to making a change in your career, then this Excel 2016 Formulas and Functions course can exceedingly help you.
The course will be focusing on providing you with the knowledge of advanced Excel functions and how to apply these and devise them for any particular system to perform computerised tasks.
You will learn to create spreadsheets with Excel and design ranges, tables, and import and export data, and so much more. In fact, with having such knowledge employers won’t hesitate to keep you in the company.
The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace.
You are taught through a combination of
- Video lessons
- Online study materials
How is the course assessed?
This course does not involve any assessment.
Will I receive a certificate of completion?
Upon successful completion, you will qualify for the UK and internationally-recognised professional qualification and you can choose to make your achievement formal by obtaining your PDF Certificate at a cost of £9 and Hardcopy Certificate for £15.
Why study this course
Whether you’re an existing practitioner or aspiring professional, this course will enhance your expertise and boost your CV with key skills and an accredited qualification attesting to your knowledge.
The Excel 2016 Formulas and Functions is open to all, with no formal entry requirements. All you need is a passion for learning, a good understanding of the English language, numeracy and IT, and to be over the age of 16.
|Getting Started with Microsoft Excel 2016|
|Use Excel Commands||00:10:00|
|Create and Save a Basic Workbook||00:19:00|
|Enter Cell Data||00:12:00|
|Use Excel Help||00:05:00|
|Basic Formulas and Functions|
|Create Worksheet Formulas||00:15:00|
|Reuse Formulas and Functions||00:17:00|
|Formulas and Functions Activities|
|Create Formulas in a Worksheet||01:00:00|
|Activity – Create Formulas in a Worksheet||00:05:00|
|Insert Functions in a Worksheet||00:30:00|
|Activity – Insert Functions in a Worksheet||00:05:00|
|Activity – Reuse Formulas||00:05:00|
|Customize Formula Options||00:30:00|
|Activity – Customize Formula Options||00:05:00|