Computing

Microsoft Office Specialist (MOS) Excel

In Brief

Start Date / Duration

The course runs at various times throughout the year. You will study for eight hours in total

Entry requirements

A core-level candidate for the Microsoft Office Specialist course/exam should have a fundamental understanding of the Microsoft Office subject environment and the ability to complete tasks independently.

You will achieve

Microsoft Office Specialist (MOS) Excel.

Last updated: 1st May 2018

Course overview

Whether you’re an established professional or new to the field, Microsoft In-Person IT training will give you the expertise you need in a specific product or technology. When you learn from our Certified Trainers, you can be confident that what you learn will be accurate, complete and up-to-date.

Set in a traditional classroom training setting in the IT Academy Fujitsu Innovation Suite, you will make the most of up-to-date technology in a relaxing atmosphere. All our tutors are fully qualified teachers and have an excellent knowledge of all subjects relating to IT and in particular the Microsoft Qualifications. Each MOS training course lasts approximately 6-8 hours. This can be attended as a one day course, or alternatively broken into 4 sessions of 2 hours which will be delivered in the evening to accommodate businesses.

Our training also comes with the option to sit a Microsoft Certified Exam in a chosen field. The exam package (for both qualifications) includes 100 online practice exams for you to take to prepare for the exam. This includes practice tests, training material and eBooks. The exam is valid for 1 year and the exam can be taken at any point with the one year period.

When you pass a Microsoft Certification exam, you become a member of the Microsoft Certified Professional (MCP) community, with access to all of the benefits provided through the Microsoft Certification Program. You can use your Microsoft account to access your benefits and exams dashboard and to find lots of ways to keep your skills relevant, applicable and competitive.

Exams you pass and certifications you earn become part of your official transcript, which you can allow potential employers to access directly. A Microsoft Certification is an industry standard which is recognised worldwide and which can help open doors to potential job opportunities.

Course content

You will study the following units;

Microsoft Excel

  • Create worksheets and workbooks
  • Creating new blank workbooks
  • Creating new workbooks using templates
  • Importing files
  • Opening non-native files directly in Excel
  • Adding worksheets to existing workbooks
  • Copying and moving worksheets

Navigate through worksheets and workbooks

  • Searching for data within a workbook
  • Inserting hyperlinks
  • Changing worksheet order
  • Using Go To
  • Using Name Box

Format worksheets and workbooks

  • Changing worksheet tab colour
  • Modifying page setup
  • Inserting and deleting columns and rows
  • Changing workbook themes
  • Adjusting row height and column width
  • Inserting watermarks
  • Inserting headers and footers
  • Setting data validation

Customise options and views for worksheets and workbooks

  • Hiding worksheets
  • Hiding columns and rows
  • Customising the Quick Access toolbar
  • Customising the Ribbon
  • Managing macro security
  • Changing workbook views
  • Recording simple macros
  • Adding values to workbook properties
  • Using zoom
  • Displaying formulas
  • Freezing panes
  • Assigning shortcut keys
  • Splitting the window

Configure worksheets and workbooks to print or save

  • Setting a print area
  • Saving workbooks in alternate file formats
  • Printing individual worksheets
  • Setting print scaling
  • Repeating headers and footers
  • Maintaining backward compatibility
  • Configuring workbooks to print
  • Saving files to remote locations

How will I be assessed?

Practical (Exam. if required).

What equipment will I need?

You will require a pen and notebook.

Where will I study?

Fujitsu Suite, Barnsley College, SciTech Building, Falcon Street, S70 2EY

What can I do next?

Employment, careers or further study.

How much does the course cost?

Course fees: £100 full fee payable.

If you wish to take the exam, the fee will be an additional £50.

Extra information

Full Fee Payable

If the course is listed as full fee payable, you will have to pay for the course.

Contact the Information Unit

For further information please contact our friendly Information Team on +44 (0)1226 216 123 or email info@barnsley.ac.uk

Disclaimer

Please note we reserve the right to change details without notice. We apologise for any inconvenience this may cause.

Microsoft Office Specialist (MOS) Excel