Professional Training

Microsoft Excel 2016 - Introduction

Cosensa Learning and Development, In Belfast (+15 locations)
Length
1 day
Price
245 GBP excl. VAT
Next course start
30 April, 2024 (+5 start dates)
Course delivery
Virtual Classroom
Length
1 day
Price
245 GBP excl. VAT
Next course start
30 April, 2024 (+5 start dates)
Course delivery
Virtual Classroom
Leave your details so the provider can get in touch

Course description

This introduction to Excel supports delegates at a basic level, providing them with the tools to become confident enough to try working with Excel features themselves. On completion of this course, delegates will be independently familiar enough with Excel to use what they learn from the course back in the workplace.

Upcoming start dates

Choose between 5 start dates

30 April, 2024

  • Virtual Classroom
  • Online
  • English

11 July, 2024

  • Virtual Classroom
  • Online
  • English

27 September, 2024

  • Virtual Classroom
  • Online
  • English

11 December, 2024

  • Virtual Classroom
  • Online
  • English

Enquire for more information.

  • Virtual Classroom
  • Online
  • English

Suitability - Who should attend?

This course is for those who desire to gain the skills necessary to create, edit, format, and print basic Microsoft Excel 2016 worksheets.

Outcome / Qualification etc.

Upon successful completion of this course, students will be able to:
  • Explore the Excel 2016 environment
  • Work with an Excel worksheet by entering and selecting the data in it, as well as saving the data in the worksheet
  • Modify a worksheet
  • Perform calculations
  • Format a worksheet
  • Develop a workbook
  • Print workbook contents
  • Customise the layout of the Excel application window
  • Create charts

Training Course Content

Module 1 – Entering Data, Selection

  • Familiarisation 
  • Selection techniques 
  • Insert/Delete/Resize Rows & Columns 
  • Copy/Cut/Paste/ Find & Replace 
  • Worksheets 
  • Autofill 
Module 2 – Formatting data
  • Font /Alignment Formatting 
  • Number Formatting 
  • Format Painter 
  • Conditional Formatting
Module 3 – Formulas & Functions
  • Creating Formulas 
  • Operators 
  • Relative & Absolute Ref 
  • Named cells 
  • Creating Functions 
  • Sum/Average/Max/Min/Count 
  • Autosum 
  • Error messages 
Module 4: (2hrs) (Optional for In-house training)
  • Printing 
    • Views 
    • Headers & Footers 
    • Worksheet Margins, Orientation, Page size  
  • Backstage 
    • Info 
    • Share/Export 
    • Options 
  • Case Study – Consolidation of all modules

Course delivery details

This course is one of a series of courseware titles that addresses Microsoft Certified Application Specialist skill sets. The Application Specialist program is for individuals who use Microsoft’s business desktop software and who seek recognition for their expertise with specific Microsoft products. Certification candidates must pass one or more proficiency exams in order to earn Application Specialist certification. 

Continuing Studies

MS Excel IntermediateMS Excel Advanced
Other MS Courses:MS WordMS ProjectMS AccessMS Powerpoint

Request info

Contact course provider

Fill out your details to find out more about Microsoft Excel 2016 - Introduction.

  Contact the provider

  Get more information

  Register your interest

Country *

reCAPTCHA logo This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Cosensa Learning and Development
Innovation Factory
385 Springfield Road
BT12 7DG Belfast

Cosensa Learning and Development Training Courses

Cosensa Learning & Development offers training courses for professionals and organisations throughout the public, private and third sectors. All Cosensa trainers are highly qualified, with extensive experience in training and coaching. Cosensa's wide range of open courses are delivered throughout...

Read more and show all courses with this provider

Ads