Microsoft Office Excel 2016 - East Coast College

Course: Microsoft Office Excel 2016

Price (exc. VAT):


£ 40

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

AAT Access Award in Accounting Software

AAT Access Award in Accounting Software: View Course

AAT Access Award In Bookkeeping

AAT Access Award In Bookkeeping: View Course

AAT Access Award In Business Skills

AAT Access Award In Business Skills: View Course

AAT Advanced Diploma in Accounting (Level 3)

AAT Advanced Diploma in Accounting (Level 3): View Course

AAT Foundation Award in Accounting Software (Level 2) – Sage 50

AAT Foundation Award in Accounting Software (Level 2) – Sage 50: View Course

AAT Foundation Award in Accounting Software (Level 2) – Sage Business Cloud

AAT Foundation Award in Accounting Software (Level 2) – Sage Business Cloud: View Course

AAT Foundation Certificate in Accounting (Level 2)

AAT Foundation Certificate in Accounting (Level 2): View Course

AAT Level 2 Foundation Certificate in Bookkeeping

AAT Level 2 Foundation Certificate in Bookkeeping: View Course

AAT Level 4 Professional Diploma in Accounting

AAT Level 4 Professional Diploma in Accounting: View Course

Access to Accounting with AAT

Access to Accounting with AAT: 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 Fitness and Health Science

Access to Fitness and Health Science: View Course

Access to Humanities & Social Science

Access to Humanities & Social Science: View Course

Access to Life Sciences

Access to Life Sciences: 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 and Inclusion

Access to Social Care and Inclusion: View Course

Active IQ Level 2 Certificate in Gym Instructing

Active IQ Level 2 Certificate in Gym Instructing: View Course

Active IQ Level 3 Diploma in Personal Training

Active IQ Level 3 Diploma in Personal Training: 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

Advanced Communication and Language Skills (preparation for IELTS)

Advanced Communication and Language Skills (preparation for IELTS): View Course

AgilePM Foundation and Practitioner – Training & Exams

AgilePM Foundation and Practitioner – Training & Exams: 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

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

Automotive (Motor Vehicle)

Automotive (Motor Vehicle): View Course

Award in Education and Training

Award in Education and Training: 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) Arts Practice (Progression Route)

BA (Hons) Arts Practice (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 and Commercial Writing*

BA (Hons) Creative and Commercial Writing*: 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) Person-Centred Counselling

BA (Hons) Person-Centred Counselling: View Course

BA (Hons) Social Science

BA (Hons) Social Science: View Course

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

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

Beach School Practitioner

Beach School Practitioner: View Course

Beauty Therapy Level 2

Beauty Therapy Level 2: View Course

Beauty Therapy Level 2 (Evening)

Beauty Therapy Level 2 (Evening): View Course

Beauty Therapy Level 3

Beauty Therapy Level 3: View Course

Bench Joinery Level 2

Bench Joinery Level 2: View Course

Bench Joinery Level 3

Bench Joinery Level 3: 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) Computer Technologies (Software Development) (Progression Route)

BSc (Hons) Computer Technologies (Software Development) (Progression Route): View Course

BSc (Hons) Crime, Justice and Society

BSc (Hons) Crime, Justice and Society: 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

Carpentry and Joinery Level 1

Carpentry and Joinery Level 1: View Course

Certificate in Skills for Sport and Active Leisure

Certificate in Skills for Sport and Active Leisure: View Course

Certificate/Diploma in Progression

Certificate/Diploma in Progression: 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 Health and Social Care Level 1

Childcare and Health and Social Care Level 1: View Course

Childcare Level 2

Childcare Level 2: View Course

Childcare Level 3

Childcare Level 3: View Course

Community ESOL (All Levels)

Community ESOL (All Levels): View Course

Construction Skills – Plastering

Construction Skills – Plastering: View Course

Creative Media Production and Technology Level 2

Creative Media Production and Technology Level 2: View Course

Creative Media Production and Technology Level 3

Creative Media Production and Technology 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

Digital Media and VFX Level 3

Digital Media and VFX Level 3: View Course

Digital Media Technologies Level 1

Digital Media Technologies Level 1: View Course

Digital Skills for Work

Digital Skills for Work: View Course

Diploma for the Early Years Workforce (Early Years Educator)

Diploma for the Early Years Workforce (Early Years Educator): View Course

Diploma in Education and Training

Diploma in Education and Training: View Course

Dog Grooming Level 2

Dog Grooming Level 2: View Course

Early Years Educator Level 3 Diploma

Early Years Educator Level 3 Diploma: View Course

Electrical Installation Level 2

Electrical Installation Level 2: View Course

Electrical Installation Level 3

Electrical Installation Level 3: View Course

Employment Law Certificate

Employment Law Certificate: View Course

Engineering Level 2/3

Engineering Level 2/3: 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 Computer Technologies (Software Development)

FdSc Computer Technologies (Software Development): View Course

FdSc Environment and Sustainable Energy

FdSc Environment and Sustainable Energy: 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 Wildlife Conservation and Animal Management

FdSc Wildlife Conservation and Animal Management: View Course

Food and Beverage Service Level 2

Food and Beverage Service Level 2: 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

GCSE English Language

GCSE English Language: View Course

Hairdressing Level 2

Hairdressing Level 2: View Course

Hairdressing Level 3

Hairdressing Level 3: View Course

Health and Safety Reps 1

Health and Safety Reps 1: View Course

Health and Social Care Level 2

Health and Social Care Level 2: View Course

Health and Social Care Level 3

Health and Social Care Level 3: View Course

HNC General Engineering

HNC General Engineering: View Course

HNC International Travel and Tourism Management

HNC International Travel and Tourism Management: View Course

HNC Public Services (Civil Protection)

HNC Public Services (Civil Protection): View Course

Intermediate Digital Photography (Evening course)

Intermediate Digital Photography (Evening course): View Course

Introduction to Digital Photography (Evening course)

Introduction to Digital Photography (Evening course): View Course

Introduction to Forest School

Introduction to Forest School: View Course

Introduction to the Hair Level 1

Introduction to the Hair Level 1: View Course

Introduction to the Hospitality Industry Level 1

Introduction to the Hospitality Industry Level 1: View Course

IOSH – Managing Safely – Training & Exam

IOSH – Managing Safely – Training & Exam: View Course

IOSH – Working Safely – Training & Exam

IOSH – Working Safely – Training & Exam: View Course

ITIL® Foundation

ITIL® Foundation: View Course

Level 3 Teaching Assistant (Supporting Teaching and Learning in Schools) (Aged 19 or over)

Level 3 Teaching Assistant (Supporting Teaching and Learning in Schools) (Aged 19 or over): View Course

Level 4 Diploma Inspired by Reggio Emilia

Level 4 Diploma Inspired by Reggio Emilia: View Course

Media Hair and Make-Up Level 2

Media Hair and Make-Up Level 2: View Course

Merchant Navy Deck Cadet Programme

Merchant Navy Deck Cadet Programme: View Course

Microsoft Office Excel 2016

Microsoft Office Excel 2016: View Course

Microsoft Office Outlook 2016

Microsoft Office Outlook 2016: View Course

NEBOSH Accredited – International General Certificate in Occupational Health & Safety

NEBOSH Accredited – International General Certificate in Occupational Health & Safety: View Course

NEBOSH Accredited – National General Certificate in Occupational Health & Safety

NEBOSH Accredited – National General Certificate in Occupational Health & Safety: 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 Wind Turbine Foundation Course

Offshore Wind Turbine Foundation Course: View Course

Offshore Wind Turbine Transition Course

Offshore Wind Turbine Transition Course: 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

Performing Arts (Musical Theatre) Level 2

Performing Arts (Musical Theatre) Level 2: View Course

Performing Arts (Musical Theatre) Level 3

Performing Arts (Musical Theatre) Level 3: View Course

Personal and Social Skills

Personal and Social Skills: 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

PRINCE2® Foundation

PRINCE2® Foundation: View Course

PRINCE2® Foundation and Practitioner

PRINCE2® Foundation and Practitioner: View Course

Professional Cookery Level 3

Professional Cookery Level 3: View Course

Professional Cookery or Kitchen Services Level 2

Professional Cookery or Kitchen Services Level 2: View Course

Professional Diploma in Digital Marketing – Online

Professional Diploma in Digital Marketing – Online: View Course

Site Carpentry Level 2

Site Carpentry Level 2: View Course

Site Carpentry Level 3

Site Carpentry Level 3: View Course

Specialist Professional Diploma in Digital Strategy & Planning – Online

Specialist Professional Diploma in Digital Strategy & Planning – Online: View Course

Specialist Professional Diploma in Search Marketing – Online

Specialist Professional Diploma in Search Marketing – Online: View Course

Specialist Professional Diploma in Social Media Marketing – Online

Specialist Professional Diploma in Social Media Marketing – Online: View Course

Sport and Physical Activity Level 3

Sport and Physical Activity Level 3: View Course

Sport and Public Services Level 1

Sport and Public Services Level 1: View Course

The Chartered Manager Degree Apprenticeship Standard (which includes the BA (Hons) Business Management Degree)

The Chartered Manager Degree Apprenticeship Standard (which includes the BA (Hons) Business Management Degree): View Course

Travel and Tourism Level 3

Travel and Tourism Level 3: View Course

Uniformed Public Services Level 2

Uniformed Public Services Level 2: View Course

Uniformed Public Services Level 3

Uniformed Public Services Level 3: View Course

Welding and Fabrication Level 2/3

Welding and Fabrication Level 2/3: View Course

Welding Evening Classes

Welding Evening Classes: View Course

START HERE with East Coast College.

Request a Prospectus Visit an Open Day