Microsoft Excel Training Courses

Enliten IT have an extensive range of Microsoft Excel training courses to give you the skills to ‘Excel’ at work!  Whether you are new to Excel, are self-taught or you think you know a fair bit, we've got a course for you.

We have certified Microsoft Excel trainers and consultants throughout the UK, so why not take advantage of our, cost effective, tailored onsite training options (we come to you!).  Alternatively, you can come to one of our training centers.

We train on ALL versions of Microsoft Excel and to All levels!

Microsoft Excel Training Courses
Home > Training > Microsoft Excel Training Courses > Excel 2016 Introduction course

Excel 2016 Introduction course

1 day

Enliten IT have an extensive range of Microsoft Excel training courses to give you the skills to ‘Excel’ at work!  Whether you are new to Excel, are self-taught or you think you know a fair bit, we've got a course for you.

We have certified Microsoft Excel trainers and consultants throughout the UK, so why not take advantage of our, cost effective, tailored onsite training options (we come to you!).  Alternatively, you can come to one of our training centers.

We train on ALL versions of Microsoft Excel and to All levels!

What will you learn?

Audience?

Course Contents


Basic principles

  • Understanding the screen layout – Ribbons, Icons, QAT, Zoom etc.
  • Cursor shapes and their actions
  • Cell selection techniques

Working with cells

  • Entering and Editing cells
  • Using shortcuts
  • Autofill and Flash Fill
  • Copying and Moving data
  • Undo & Redo
  • Clear formats

Formulae

  • Setting up a basic worksheet
  • Creating your own formulae (Some basic maths is covered)
  • Order of calculation – BODMAS
  • Using in-built functions e.g. sum, average, count, counta
  • Relative v Absolute referencing

Formatting

  • Text formatting
  • Inserting/Deleting rows & columns
  • Hide & Unhide Rows/Columns
  • Altering column widths and row heights
  • Adding Colours/Borders/Shading
  • Alignment & Merging cells
  • Wrapping text into paragraphs
  • Number formatting
  • Format painter
  • Add/Edit comments

Conditional Formatting

  • Use of Data bars, Colour scales & Icon sets

Printing

  • Print preview
  • Working with Page Break Preview
  • Adjusting Margins
  • Shrink to fit
  • Setting different Print areas
  • Headers and Footers
  • Repeating heading over multiple pages

Larger documents

  • Splitting and freezing
  • Zoom

Graphs

  • Insert Chart v Quick chart
  • Bar/Line/Pie charts
  • Adding/Editing: Headings, Borders, Legends, Data Table
  • Printing Charts

Course Materials

Enliten IT will provide each delegate with a workbook and other useful reference materials where applicable.  These may be either paper based or in Adobe pdf format or a combination thereof.

“”

Additional Information

Enliten IT reserves the right to modify course content and materials as required in the interests of continuous course improvement, at any time, without notification.

The suggested course duration is a guideline.  Course topics and duration may be modified by the instructor based upon the knowledge and skill level of the course participants.