Event box

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

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 2010, 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 2010. Please contact Staff Development if you have any questions about suitability or the MOS certification.

 

 

 

 

 

Date:
Wednesday, October 11, 2017
Time:
9:30am - 12:30pm
Location:
Room CD113, Academy House
Campus:
Hendon
Categories:
Utilising Technology & University Systems
Registration has closed.

Event Organizer

Staff Development

More events like this...