Cost: €110.00 funding applied 

Date: 6th December 2017

Location: New Horizions Ireland Stand House 24th Strand Street Great Dublin 1

1 day from 9:30am until 5pm

 

This course is intended for students who wish to gain the foundational understanding of Excel 2016 that is necessary to create and work with electronic spreadsheets. Excel 2016 can help you organise, calculate, analyse, revise, update, and present your data.

Target Audience

To ensure success, students will need to be familiar with using personal computers and should have experience using a keyboard and mouse. Students should also be comfortable working in the Windows 10 environment and be able to manage information on their computers.

Course Objectives

Upon successful completion of this course, you will be able to create and develop Excel 2016 worksheets and workbooks in order to work with and analyse the data that is critical to the success of your organization.

Course Outline

1 – Getting Started with Excel 2016

Navigate the Excel User Interface

Use Excel Commands

Create and Save a Basic Workbook

Enter and Edit Cell Data

Fill Cells with Series of Data (AutoFill and Flash Fill)

Use Excel Help

 

2 – Performing Calculations

Create Worksheet Formulas

Insert Functions and use Autocomplete

Reuse Formulas and Functions

Create an Absolute Reference

 

3 – Modifying a Worksheet

Insert, Delete, and Adjust Cells, Columns, and Rows

Move and Copy Data between Cells

Search for and Replace Data

Use Spellcheck and Proofing

 

4 – Formatting a Worksheet

Apply Text Formats

Apply Number Formats

Align Cell Contents

Apply and Copy Cell Styles

Apply Basic Conditional Formatting

 

5 – Printing Workbooks

Preview and Print a Workbook

Controlling Page Layout

Adding Headers and Footers

Set Print Titles and Print Ranges

 

6 – Managing Workbooks

Manage Worksheets

Insert and Delete Worksheets

Manage Workbook and Worksheet Views

Manage Workbook Properties

 

 

Benefits of training with New Horizons include:

 

1)       A Learning Guarantee. We believe so strongly in the quality of our courses that we are prepared to offer you a Learning Guarantee. If a student didn’t feel they absorbed all the information on the day, they are welcome to sit on the same Public class within 6 months at no charge.

 

2)       3 month subscription to online course tutorials.

 

3)       60 day email or telephone help desk support for job/project specific problems you encounter.

 

Menu