Loading Events

« All Events

Excel Part 1: Excel Essentials and Formulas

May 8 @ 9:00 am - 5:00 pm

Course Content  

Module 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 (fill handle)

Module 2: Performing Calculations  

  • Create Worksheet Formulas
  • Insert Functions and use Autocomplete
  • Reuse Formulas and Functions
  • Create an Absolute Reference

Module 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

Module 4: Formatting a Worksheet

  • Apply Text Formats
  • Apply Number Formats
  • Align Cell Contents
  • Apply Cell Styles

Module 5: Printing Workbooks  

  • Preview and Print a Workbook
  • Controlling Page Layout
  • Adding Headers and Footers
  • Set Print Titles and Print Ranges

Module 6: Managing Workbooks  

  • Manage Worksheets
  • Insert and Delete Worksheets
  • Worksheet Views (freeze pane)

IA Members €140

Book your place by emailing maureen@dppskillnet.ie

Details

Date:
May 8
Time:
9:00 am - 5:00 pm
Event Categories:
, , ,

Organiser

Design, Print & Packing Skillnets
Email:
maureen@dppskillnet.ie
Website:
http://dppskillnet.ie/index.php/events/adobe-photoshop-cs6/

Venue

New Horizons
22 – 24 Great Strand Street
Dublin 1, Ireland
+ Google Map

Skip to toolbar