Microsoft Office Excel 2016 – East Coast College

Course:Microsoft Office Excel 2016

Price (exc. VAT):


£ 34

Course Type:


Classroom

Prerequisites

Course Content

This package is made up of three courses:
MS Excel 2016: Introduction

  •    Follow 34 lessons with approx. 17 study hours
  •    Familiarise yourself with MS Excel 2016, its documents and controls
  •    Learn to create tables step by step
  •    Find out how to enter values correctly into the cells
  •    Learn how to set up cell formatting, including conditional formatting
  •    Study the manipulation of each cell and cell range
  •    Learn to work with worksheets and entire files
  •    Discover how to create a chart
  •    Learn to create calculations using basic arithmetic formulas
MS Excel 2016: Intermediate
  •    Follow 35 lessons with approx. 18 study hours
  •    Follow interactive lessons focused mainly on performing calculations
  •    Broaden your basic knowledge by the application of logical and text functions
  •    Understand the principles of referencing to the values in other cells
  •    Learn to fill cells with a series of data
  •    Familiarise yourself with the advanced options of sorting and filtering data
  •    Study searching for specific values in extensive tables
  •    Examine how to split longer text entries in tables into individual data placed into several columns
MS Excel 2016: Advanced
  •    Follow 29 lessons with approx. 15 study hours
  •    Focus on the creation of charts and automation of the work in the program using macros
  •    Also, examine the insertion of various graphical elements into worksheets i.e. shapes or SmartArt graphics
  •    Learn to prepare a table or entire worksheet before printing
  •    Familiarise yourself with the options of protecting and sharing the workbook content
  •    Look at the usage of macros, including their creation, editing and the options of macro security
What does the MS Excel 2016 course cover?
This official Microsoft exam could include questions based on the following topics:
  •    Creation of worksheets and workbooks - including importing data from a delimited text file, adding worksheets to existing workbooks, and copying or moving a worksheet
  •    Navigating around worksheets and workbooks - this could look at searching for data in a workbook, navigating to specific cells, range or a workbook element, or inserting and removing hyperlinks
  •    Formatting topics - renaming a worksheet, changing tab colours, modifying page setups or worksheet orders, or inserting and deleting columns/rows. You may also be tested on workbook themes and how to change them, altering the height or width of rows and columns, and inserting headers and footers into a worksheet
  •    Different customisation and view options - this could be hiding or un-hiding columns and rows, customising the popular quick access toolbar or modifying document properties. Other topics could focus on changing workbook and window views, different uses of the zoom tool, and display formulas
  •    Configuration of worksheets and workbooks - this topic is all about setting up spreadsheets for distribution, so may include setting print areas and scaling, saving workbooks in alternative file formats and inspecting workbooks for accessibility or compatibility issues
  •    Managing data cells and ranges - could test you on replacing data, special paste options for data, using AutoFill, and deleting cells
  •    Formatting cells and organising data - testing your knowledge on topics such as modifying cell alignment, using format painter, and applying number formats and cell styles. Also, look out for inserting sparklines and outline data, and applying conditional formatting
  •    Creating tables - you could be examined on creating Excel tables from cell ranges, inserting or removing rows or columns, filtering records, and removing duplicate records
  •    Performing tasks using formulas and functions - this could include performing calculations using the SUM, COUNT or AVERAGE functions, performing logical operations using IF, SUMIF, or COUNTIF functions, and formatting text using a variety of tools
  •    Creating charts and objects. Become familiar with creating charts, adding additional data, switching between elements in the source data, and analysing data using Quick Analysis. You may also be tested on formatting charts and their elements, applying layouts and styles, or inserting and formatting objects
Key features
Delivery Method: Online
Assessment Included
Tutor Support Included
Course Access: 12 months
Freedom & flexibility to learn in your own time
24/7 access


Number of Places

Add To Cart

Related Courses

18th Edition of BS:7671:2018 IEE Wiring Regulations – C&G2382-18 Full Course

18th Edition of BS:7671:2018 IEE Wiring Regulations – C&G2382-18 Full Course: View Course

Abrasive Wheels Regulations

Abrasive Wheels Regulations: View Course

Access to Care, Learning and Development

Access to Care, Learning and Development: View Course

Access to Counselling

Access to Counselling: View Course

Access to Humanities and Social Science

Access to Humanities and Social Science: View Course

Access to Life Sciences

Access to Life Sciences: View Course

Access to Maritime

Access to Maritime: View Course

Access to Medicine

Access to Medicine: View Course

Access to Science and Health

Access to Science and Health: View Course

Access to Social Care

Access to Social Care: View Course

Access to Teaching

Access to Teaching: View Course

Accounting Level 3

Accounting Level 3: View Course

Adult Care Level 2 Diploma

Adult Care Level 2 Diploma: View Course

Adult Care Level 3 Diploma

Adult Care Level 3 Diploma: View Course

Adult Care Level 4 Diploma

Adult Care Level 4 Diploma: View Course

AgilePM Foundation

AgilePM Foundation: View Course

AgilePM Foundation and Practitioner

AgilePM Foundation and Practitioner: View Course

Air Cabin Crew Level 2

Air Cabin Crew Level 2: View Course

Animal Care Level 1

Animal Care Level 1: View Course

Animal Care Level 2

Animal Care Level 2: View Course

Animal Management Level 3

Animal Management Level 3: View Course

Applied Psychology, Law and Criminology Level 3

Applied Psychology, Law and Criminology Level 3: View Course

Art & Design Level 1

Art & Design Level 1: View Course

Art & Design Level 2

Art & Design Level 2: View Course

Art & Design Level 3

Art & Design Level 3: View Course

Art & Design Level 3 Foundation Diploma

Art & Design Level 3 Foundation Diploma: View Course

Art & Design Level 4 Foundation Diploma

Art & Design Level 4 Foundation Diploma: View Course

Automated External Defibrillation (AED) and Annual Refresher

Automated External Defibrillation (AED) and Annual Refresher: View Course

Automotive Level 2/Level 3 (Motor Vehicle)

Automotive Level 2/Level 3 (Motor Vehicle): View Course

Award for Customer Service for Health and Social Care Settings

Award for Customer Service for Health and Social Care Settings: View Course

Award in Education and Training

Award in Education and Training: View Course

Awards in Drawing Level 2

Awards in Drawing Level 2: View Course

BA (Hons) Applied Care Practice (Adult Support Needs) (Progression Route)

BA (Hons) Applied Care Practice (Adult Support Needs) (Progression Route): View Course

BA (Hons) Applied Care Practice (Children & Families) (Progression Route)

BA (Hons) Applied Care Practice (Children & Families) (Progression Route): View Course

BA (Hons) Applied Care Practice (Mental Health Support) (Progression Route)

BA (Hons) Applied Care Practice (Mental Health Support) (Progression Route): View Course

BA (Hons) Business Management

BA (Hons) Business Management: View Course

BA (Hons) Children’s Care, Learning and Development (Progression Route)

BA (Hons) Children’s Care, Learning and Development (Progression Route): View Course

BA (Hons) Creative Arts Practice (Progression Route)

BA (Hons) Creative Arts Practice (Progression Route): View Course

BA (Hons) Crime, Justice and Society

BA (Hons) Crime, Justice and Society: View Course

BA (Hons) Cultural Studies

BA (Hons) Cultural Studies: View Course

BA (Hons) Inclusive Practice and Integrated Working (Progression Route)

BA (Hons) Inclusive Practice and Integrated Working (Progression Route): View Course

BA (Hons) Literary Studies with Creative Writing

BA (Hons) Literary Studies with Creative Writing: View Course

BA (Hons) Person-Centred Counselling

BA (Hons) Person-Centred Counselling: View Course

BA (Hons) Social Science

BA (Hons) Social Science: View Course

BA (Hons) Visual Art

BA (Hons) Visual Art: View Course

BA (Hons) Visual Effects and Post-Production (Progression Route)

BA (Hons) Visual Effects and Post-Production (Progression Route): View Course

Barbering Level 2

Barbering Level 2: View Course

Barbering Level 3

Barbering Level 3: View Course

Beach School Practitioner

Beach School Practitioner: View Course

Beauty Therapy Level 2

Beauty Therapy Level 2: View Course

Beauty Therapy Level 3

Beauty Therapy Level 3: View Course

Bench Joinery Level 2

Bench Joinery Level 2: View Course

BEng (Hons) Operations Engineering (Progression Route)

BEng (Hons) Operations Engineering (Progression Route): View Course

BEng Operations Engineering (Control Technical Support Engineer Degree Apprenticeship)*

BEng Operations Engineering (Control Technical Support Engineer Degree Apprenticeship)*: View Course

Brickwork Level 1

Brickwork Level 1: View Course

Brickwork Level 2

Brickwork Level 2: View Course

BSc (Hons) Applied Psychology

BSc (Hons) Applied Psychology: View Course

BSc (Hons) Practical Life Sciences (Progression Route)*

BSc (Hons) Practical Life Sciences (Progression Route)*: View Course

BSc (Hons) Sport, Health and Exercise (Progression Route)

BSc (Hons) Sport, Health and Exercise (Progression Route): View Course

BSc (Hons) Sustainable Futures (Progression Route)*

BSc (Hons) Sustainable Futures (Progression Route)*: View Course

Business Administration Level 4

Business Administration Level 4: View Course

Carpentry and Joinery Level 1

Carpentry and Joinery Level 1: View Course

Certificate in Beauty Therapy (Massage Route) Level 3

Certificate in Beauty Therapy (Massage Route) Level 3: View Course

Certificate in Education/Professional Graduate Certificate in Education (PGCE)

Certificate in Education/Professional Graduate Certificate in Education (PGCE): View Course

Certificate in Nail Treatments (VTCT) Level 2

Certificate in Nail Treatments (VTCT) Level 2: View Course

Certificate in Photography Level 2

Certificate in Photography Level 2: View Course

Challenge East (Team Building)

Challenge East (Team Building): View Course

Challenging Behaviours Level 2

Challenging Behaviours Level 2: View Course

Chief Mate/Master STCW REG II/2 (Unlimited) Certificate of Competency

Chief Mate/Master STCW REG II/2 (Unlimited) Certificate of Competency: View Course

Childcare and Education Level 3

Childcare and Education Level 3: View Course

Childcare and Health and Social Care Level 1

Childcare and Health and Social Care Level 1: View Course

Childcare Level 2

Childcare Level 2: View Course

City & Guilds Fundamental Inspection, Testing and Initial Verification (2392)

City & Guilds Fundamental Inspection, Testing and Initial Verification (2392): View Course

Clean Energy Foundation Programme

Clean Energy Foundation Programme: View Course

Community ESOL (All Levels)

Community ESOL (All Levels): View Course

CompEx EX01 – EX04 Hazardous Area – Full

CompEx EX01 – EX04 Hazardous Area – Full: View Course

CompEx EX01 – EX04 Hazardous Area – Refresher

CompEx EX01 – EX04 Hazardous Area – Refresher: View Course

Construction Skills – Plastering

Construction Skills – Plastering: View Course

Control Room Operator – Controlling Emergencies Training & Assessment

Control Room Operator – Controlling Emergencies Training & Assessment: View Course

Control Room Operator – Controlling Emergencies Training & Assessment – Refresher

Control Room Operator – Controlling Emergencies Training & Assessment – Refresher: View Course

Creative Media (Film, TV, Animation and VFX) Level 3

Creative Media (Film, TV, Animation and VFX) Level 3: View Course

Creative Media Level 1

Creative Media Level 1: View Course

Creative Media Level 2

Creative Media Level 2: View Course

Cyber Security Level 3

Cyber Security Level 3: View Course

Digital Design and Photography Level 2

Digital Design and Photography Level 2: View Course

Digital Design and Photography Level 3

Digital Design and Photography Level 3: View Course

Diploma in Management Practice and Advanced Techniques in the Hair and Beauty Sector – Theatrical and Media Make-Up Level 4

Diploma in Management Practice and Advanced Techniques in the Hair and Beauty Sector – Theatrical and Media Make-Up Level 4: View Course

Dog Grooming Level 2

Dog Grooming Level 2: View Course

Dog Grooming Level 3

Dog Grooming Level 3: View Course

Dynamic Positioning Introduction

Dynamic Positioning Introduction: View Course

Early Years Educator Level 3 Diploma

Early Years Educator Level 3 Diploma: View Course

ECDIS (Electronic Chart Display & Information Systems)

ECDIS (Electronic Chart Display & Information Systems): View Course

Efficient Deck Hand (EDH)

Efficient Deck Hand (EDH): View Course

Electrical Installation Level 2

Electrical Installation Level 2: View Course

Electrical Installation Level 3

Electrical Installation Level 3: View Course

Elementary First Aid (EFA) – Maritime

Elementary First Aid (EFA) – Maritime: View Course

Engineering Level 2/3

Engineering Level 2/3: View Course

Engineering Technologies Level 2 Diploma

Engineering Technologies Level 2 Diploma: View Course

Equality and Diversity

Equality and Diversity: View Course

ESOL Access Programme – All Levels

ESOL Access Programme – All Levels: View Course

Essential Digital Skills

Essential Digital Skills: View Course

Fashion & Textiles Level 3

Fashion & Textiles Level 3: View Course

Fashion, Theatre and Media Hair and Make-Up Level 3

Fashion, Theatre and Media Hair and Make-Up Level 3: View Course

FdA Children’s Care, Learning and Development

FdA Children’s Care, Learning and Development: View Course

FdA Children’s Health, Play and Wellbeing

FdA Children’s Health, Play and Wellbeing: View Course

FdA Creative Arts for Health and Wellbeing

FdA Creative Arts for Health and Wellbeing: View Course

FdA Fashion and Textiles

FdA Fashion and Textiles: View Course

FdA Professional Photographic Practice

FdA Professional Photographic Practice: View Course

FdA Social Welfare, Advice & Guidance

FdA Social Welfare, Advice & Guidance: View Course

FdA Supporting Inclusive Learning and Practice

FdA Supporting Inclusive Learning and Practice: View Course

FdA Visual Effects and Post-Production

FdA Visual Effects and Post-Production: View Course

FdSc Conservation Science and Animal Management (Wildlife and Zoo)

FdSc Conservation Science and Animal Management (Wildlife and Zoo): View Course

FdSc Environment and Sustainable Energy

FdSc Environment and Sustainable Energy: View Course

FdSc Forensic Science*

FdSc Forensic Science*: View Course

FdSc Nautical Science

FdSc Nautical Science: View Course

FdSc Practical Life Sciences

FdSc Practical Life Sciences: View Course

FdSc Practical Life Sciences (Higher Apprenticeship)

FdSc Practical Life Sciences (Higher Apprenticeship): View Course

FdSc Sport, Health and Exercise

FdSc Sport, Health and Exercise: View Course

FdSc Sport, Health and Exercise – Dereham Town Football Club Academy Pathway

FdSc Sport, Health and Exercise – Dereham Town Football Club Academy Pathway: View Course

First Aid at Work

First Aid at Work: View Course

First Aid at Work Re-Qualification

First Aid at Work Re-Qualification: View Course

Functional English – Entry Level 3 – Level 2

Functional English – Entry Level 3 – Level 2: View Course

Functional Maths – Entry Level 3 – Level 1

Functional Maths – Entry Level 3 – Level 1: View Course

Gateway Customer Care Skills

Gateway Customer Care Skills: View Course

Gateway Train the Trainer

Gateway Train the Trainer: View Course

GCSE English Language

GCSE English Language: View Course

Get into Construction, Retail, Care, Hospitality or Security

Get into Construction, Retail, Care, Hospitality or Security: View Course

GMDSS General Operating Certificate (GOC)

GMDSS General Operating Certificate (GOC): View Course

GMDSS Restricted Operating Certificate (ROC)

GMDSS Restricted Operating Certificate (ROC): View Course

GMDSS Short Range Certificate (VHF Marine Band)

GMDSS Short Range Certificate (VHF Marine Band): View Course

Groom Your Dog in a Day

Groom Your Dog in a Day: View Course

Hairdressing Level 2

Hairdressing Level 2: View Course

Hairdressing Level 3

Hairdressing Level 3: View Course

Health and Social Care ‘Care Cadets’ Level 2

Health and Social Care ‘Care Cadets’ Level 2: View Course

Health and Social Care ‘Care Cadets’ or ‘Health Trainees’ Level 3

Health and Social Care ‘Care Cadets’ or ‘Health Trainees’ Level 3: View Course

Health and Social Care Academy

Health and Social Care Academy: View Course

Helping Skills Level 2

Helping Skills Level 2: View Course

HNC Applied Sciences (Forensic Science)

HNC Applied Sciences (Forensic Science): View Course

HNC General Engineering

HNC General Engineering: View Course

HNC Public Services (Civil Protection)

HNC Public Services (Civil Protection): View Course

HND Engineering (General Engineering)

HND Engineering (General Engineering): View Course

Hospitality Services (Food and Beverage Route) Level 2

Hospitality Services (Food and Beverage Route) Level 2: View Course

Human Element Leadership & Management (Management Level) HELM M

Human Element Leadership & Management (Management Level) HELM M: View Course

Human Element Leadership & Management (Operational Level) HELM O

Human Element Leadership & Management (Operational Level) HELM O: View Course

In-Service Inspection and Testing of Electrical Equipment (PAT Testing) C&G 2377-22

In-Service Inspection and Testing of Electrical Equipment (PAT Testing) C&G 2377-22: View Course

Information, Advice and Guidance Level 2

Information, Advice and Guidance Level 2: View Course

Initial & Periodic Inspection & Testing of Electrical Installations C&G 2391-52 Level 3

Initial & Periodic Inspection & Testing of Electrical Installations C&G 2391-52 Level 3: View Course

Introduction to Forest School

Introduction to Forest School: View Course

Introduction to Health, Social Care and Children’s and Young People’s Settings

Introduction to Health, Social Care and Children’s and Young People’s Settings: View Course

Introduction to the Hospitality Industry Level 1

Introduction to the Hospitality Industry Level 1: View Course

Introduction to the Role of the Professional Taxi and Private Hire Driver

Introduction to the Role of the Professional Taxi and Private Hire Driver: View Course

Introduction to the Wind Sector

Introduction to the Wind Sector: View Course

IT User Skills Level 2 and Level 3

IT User Skills Level 2 and Level 3: View Course

Kitchen Services Level 2

Kitchen Services Level 2: View Course

Level 4 Diploma Inspired by Reggio Emilia

Level 4 Diploma Inspired by Reggio Emilia: View Course

Master (200GT) Oral Preparation Course

Master (200GT) Oral Preparation Course: View Course

Master Unlimited STCW Reg 11/2 Oral Exam Prep course

Master Unlimited STCW Reg 11/2 Oral Exam Prep course: View Course

MCA Approved Engine Course (AEC 1)

MCA Approved Engine Course (AEC 1): View Course

MCA Small Workboat Stability Course

MCA Small Workboat Stability Course: View Course

Media Hair and Make-Up Studies Level 2

Media Hair and Make-Up Studies Level 2: View Course

Medical Care Aboard Ship

Medical Care Aboard Ship: View Course

Medical Care Aboard Ship Refresher

Medical Care Aboard Ship Refresher: View Course

Medical First Aid Aboard Ship

Medical First Aid Aboard Ship: View Course

Merchant Navy Deck Cadet Programme

Merchant Navy Deck Cadet Programme: View Course

NAEST Operational (Navigation Aids & Equipment Simulator Training)

NAEST Operational (Navigation Aids & Equipment Simulator Training): View Course

NCFE Dementia Awareness

NCFE Dementia Awareness: View Course

NCFE Infection Control

NCFE Infection Control: View Course

NCFE Learning Disabilities

NCFE Learning Disabilities: View Course

NCFE Mental Health

NCFE Mental Health: View Course

Officer of the Watch (Deck) STCW REG II/1 (Unlimited) Certificate of Competency

Officer of the Watch (Deck) STCW REG II/1 (Unlimited) Certificate of Competency: View Course

Offshore Installation Manager Controlling Emergencies Training & Assessment

Offshore Installation Manager Controlling Emergencies Training & Assessment: View Course

Offshore Installation Manager Controlling Emergencies Training & Assessment – Refresher

Offshore Installation Manager Controlling Emergencies Training & Assessment – Refresher: View Course

Painting and Decorating Level 1

Painting and Decorating Level 1: View Course

Painting and Decorating Level 2

Painting and Decorating Level 2: View Course

Painting and Decorating Level 3

Painting and Decorating Level 3: View Course

Painting and Decorating Skills Level 3

Painting and Decorating Skills Level 3: View Course

Performing Arts Level 2

Performing Arts Level 2: View Course

Performing Arts Level 3

Performing Arts Level 3: View Course

Personal Safety & Social Responsibilities (PSSR)

Personal Safety & Social Responsibilities (PSSR): View Course

Personal Survival Techniques (PST)

Personal Survival Techniques (PST): View Course

Personal Survival Techniques (PST) Update

Personal Survival Techniques (PST) Update: View Course

Pilot Transfer Training

Pilot Transfer Training: View Course

Postgraduate Certificate in Leadership & Management in Health, Social Care and Educational Organisations

Postgraduate Certificate in Leadership & Management in Health, Social Care and Educational Organisations: View Course

Pre-Cadet (Maritime Deck Cadet) Level 3

Pre-Cadet (Maritime Deck Cadet) Level 3: View Course

Preparation for the Military Level 2

Preparation for the Military Level 2: View Course

Preparation for the Military Level 3

Preparation for the Military Level 3: View Course

Professional Cookery Level 2

Professional Cookery Level 2: View Course

Professional Cookery Level 3

Professional Cookery Level 3: View Course

Professional Taxi and Private Hire Driver Refresher Course

Professional Taxi and Private Hire Driver Refresher Course: View Course

Progression Entry Level 3

Progression Entry Level 3: View Course

Progression Level 1

Progression Level 1: View Course

Progression to Creative, Hospitality, Employability or Construction

Progression to Creative, Hospitality, Employability or Construction: View Course

Shipboard Safety Officer

Shipboard Safety Officer: View Course

Site Carpentry Level 2

Site Carpentry Level 2: View Course

Site Carpentry Level 3

Site Carpentry Level 3: View Course

Sport and Active Leisure

Sport and Active Leisure: View Course

Sport and Physical Activity Level 3

Sport and Physical Activity Level 3: View Course

STCW Proficiency for Seafarers with Designated Security Duties

STCW Proficiency for Seafarers with Designated Security Duties: View Course

STCW Proficiency in Security Awareness

STCW Proficiency in Security Awareness: View Course

STCW Ship Security Officer

STCW Ship Security Officer: View Course

Supporting Teaching and Learning in Schools Level 3

Supporting Teaching and Learning in Schools Level 3: View Course

T Level in Design, Surveying and Planning for Construction Level 3

T Level in Design, Surveying and Planning for Construction Level 3: View Course

T Level in Digital Production, Design and Development Level 3

T Level in Digital Production, Design and Development Level 3: View Course

T Level in Education and Childcare Level 3

T Level in Education and Childcare Level 3: View Course

T Level in Health Level 3

T Level in Health Level 3: View Course

T Level in Healthcare Science Level 3

T Level in Healthcare Science Level 3: View Course

T Level in Maintenance, Installation and Repair for Engineering and Manufacturing Level 3

T Level in Maintenance, Installation and Repair for Engineering and Manufacturing Level 3: View Course

Tanker Familiarisation

Tanker Familiarisation: View Course

Teaching Assistant Level 3

Teaching Assistant Level 3: View Course

The Chartered Manager Degree Apprenticeship Standard (including BA (Hons) Business Management Degree)

The Chartered Manager Degree Apprenticeship Standard (including BA (Hons) Business Management Degree): View Course

Travel and Tourism with Event Planning Level 3

Travel and Tourism with Event Planning Level 3: View Course

UAL Art & Design Diploma Level 2

UAL Art & Design Diploma Level 2: View Course

Understanding Autism Level 3

Understanding Autism Level 3: View Course

Understanding Climate Change

Understanding Climate Change: View Course

VRQ Level 2 Certificate in Hairdressing Services

VRQ Level 2 Certificate in Hairdressing Services: View Course

Welding and Fabrication Level 2

Welding and Fabrication Level 2: View Course

Welding and Fabrication Level 3

Welding and Fabrication Level 3: View Course

Welding Evening Classes

Welding Evening Classes: View Course