Excel Essentials and Formulas Course

Excel Level One on 12^th March Course Content for Excel Part 1

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)

Subsidised Cost €99 which is more than 50% less than RRP

Your selected course can delivered via our Online LIVE Training Platform, which allows delegates to do the training in real time from their own workplace or from their home, so no need to travel.

Online LIVE is an integrated learning experience, using the internet to provide live, interactive lessons between an instructor and students. Although separated by geography, instructors and students share active discussions, practice labs, simultaneous document viewing, and virtual rooms for breakout groups.

Remote students are able to HEAR and SEE the instructor’s lecture, presentations, and demonstrations, as well as perform labs by remotely controlling the in-classroom student computer. The instructor has the ability to take control of your in-classroom computer if assistance is needed with any lab work. Students may ask questions at any time via chat or voice.

You can interact live with the instructor and complete all the labs in real time.

Benefits of Online Live:

• 6 Months Access to Course Recording – to review after the course to reinforce knowledge gained from the course

• • Reduce travel costs and time
  • Live access to instructors with industry experience
  • Participation in a LIVE classroom environment
  • Attend the course from anywhere with internet access
  • Practice labs in a virtual environment for hands-on experience

In order for us to continue to bring you subsidised content we will require you to fill out a profile sheet during booking – full completion of this sheet guarantees you a place on the training. Please complete a separate booking for each individual attending the training.

Please note our training courses are only available for people residing in the Republic of Ireland