Event box

Microsoft Office Specialist in Excel - Foundation (MOS 1/4) In-Person

MOS – Microsoft Office Specialist certification

MOS is an IT industry recognised certification created by Microsoft to cover all the programs in its Microsoft Office Suite. Gaining the MOS certification demonstrates that you have the skills needed to get the most out of the chosen Microsoft application.

Microsoft Office Specialist in Excel – Foundation (MOS 1/4)

Brief Outline

Not only could this session contribute to your training and preparation for the MOS exam for Excel, but it can also be a stand-alone Excel session teaching you the fundamentals of the program.

In this session you will learn foundational skills to help you start to get the most out of Excel and give you a solid basis for learning more should you want or need to in the future.

Learning Outcomes

  • Printing only selected worksheets

  • Using paste special (formats,) cutting, moving and selecting cell data

  • Copying data using AutoFill; filling series using AutoFill

  • Creating a hyperlink in a cell; removing a hyperlink

  • Aligning cell content; applying a number format; wrapping text in a cell; using Format Painter

  • Using Merge & Centre, Merge Across, Merge Cells, and Unmerge Cells

  • Printing row and column headings

  • Hiding a column; unhiding a column; hiding a series of columns; hiding a row; unhiding a row; hiding a series of rows

  • Configuring page orientation

  • Applying cell styles

  • Inserting worksheets; deleting worksheets; copying, repositioning, copying and moving, renaming, grouping; applying colouring to worksheet tabs; hiding worksheet tabs; unhiding worksheet tabs

  • Using Normal, Page Layout and Page Break workbook views

  • Using basic operators; revising formulas

  • Create charts based on worksheet data (Foundation)

  • Clip Art

  • Using sort options (values, font colour, cell colour)

Pre-requisites

There are no pre-requisites for this session; it is suitable for people new to Excel 2016. Please contact Staff Development if you have any questions about suitability or the MOS certification.

 

 

 

 

 

Date:
Wednesday, June 20, 2018
Time:
9:30am - 12:30pm
Time Zone:
UK, Ireland, Lisbon Time (change)
Location:
Room CD113, Academy House, Colindeep Lane
Campus:
Hendon
Categories:
  Using Technology & University Systems  
Registration has closed.

Event Organizer

Profile photo of Staff Development
Staff Development

More events like this...