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.
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.
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.
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
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.