€275

Excel - Excel Essentials and Formulas

Event Information

Share this event

Date and Time

Location

Location

New Horizons Ireland

22-24 Strand Street Great, Strand House

D01 W1W4 Dublin 1

Ireland

View Map

Refund Policy

Refund Policy

Refunds up to 30 days before event

Event description

Description

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.

More details click below:

https://www.nhireland.ie/training-and-certifications/course-outline/id/1020884114/c/excel-2016-excel-essentials-and-formulas


Share with friends

Date and Time

Location

New Horizons Ireland

22-24 Strand Street Great, Strand House

D01 W1W4 Dublin 1

Ireland

View Map

Refund Policy

Refunds up to 30 days before event

Save This Event

Event Saved