Skip to content

Microsoft Excel Level 1 Worksheet Fundamentals (Live Online)

Gain confidence and develop skills that can be transferred immediately to the workplace. Introductory level course.


Media Tek Training Solutions

Summary

Price
£55 - £205 VAT exempt
Study method
Online + live classes
Duration
1 day · Part-time
Certification
Microsoft Office Specialist (MOS)
Professional certification What's this?
Additional info
  • Tutor is available to students

Overview

Solid Excel spreadsheet skills are essential in today’s business world. Learn the basics of Excel spreadsheets with this comprehensive introductory course. Gain confidence and develop skills that can be transferred immediately to the workplace with this ‘hands-on’ training.

The course is run by an experienced Data Analyst and Microsoft Master Instructor. Each participant will receive a manual and completion certificate.

Certification

Microsoft Office Specialist (MOS)

Awarded by Microsoft

Description

This one day course will give you a solid foundation, with an emphasis on developing practical, real-world skills. It is suitable for people in any type of business.

Topics covered:

  • Excel Application window
  • Enter labels and values into a worksheet
  • Enter a formula into a worksheet
  • Adjust column width and row height in a worksheet
  • Open a new workbook
  • Use the Spelling Checker
  • Use an Excel template to create a workbook
  • Automatically fill a range
  • Copy and move cells
  • Automatically compute a row or column total
  • Insert and delete rows and columns
  • Realign cell entries
  • Reset font options for cell entries
  • Reset the number format of cell entries
  • Add borders and shading to a worksheet
  • Sort the records of a list
  • Filter the records of a list
  • Excel Tables
  • Insert comments into a worksheet
  • Split the Worksheet window into panes
  • Freeze the Worksheet window
  • Hide rows and columns of a worksheet
  • Change the page setup for a worksheet
  • Preview a worksheet
  • Insert a manual page break into a worksheet
  • Print selected worksheet entries
  • Use Excel functions (SUM, AVERAGE, MAX, MIN and COUNT)

Who is this course for?

This course is suitable for anyone who wishes to learn Microsoft Excel or become more proficient in the program.

Requirements

Basic keyboard and mouse skills. No prior knowledge of Microsoft Excel is required.

Career path

Microsoft Office Specialist (MOS) Excel.

Questions and answers

Reviews

Currently there are no reviews for this course. Be the first to leave a review.

FAQs

Study method describes the format in which the course will be delivered. At Reed Courses, courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on Reed Courses, many of which can be completed online.

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body's logo if they wish. Certain awarding bodies - such as Quality Licence Scheme and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.