Skip to content

MS Excel 2013 Package – Introduction, Intermediate And Advanced


City Business Library

Summary

Price
£40 inc VAT
Study method
Online
Duration
1 year · Self-paced
Qualification
No formal qualification

Overview

Develop your Microsoft Excel 2016 skillset with this three course package.

Description

MS Excel 2013 Introduction

  • Get to grips with the MS Excel 2013 user interface.
  • Learn how to create tables using easy step by step methods.
  • Try entering values into cells correctly.
  • Look at cell formatting, including conditional formatting.
  • Begin manipulating cells and cell range.
  • Become familiar with working in a worksheet and an entire file.
  • Learn how to turn your data into a chart.
  • Try making calculations using basic MS Excel formulas.

MS Excel 2013 Intermediate

  • This course delves further into making calculations.
  • Look into logical and text functions.
  • Broaden your knowledge of referencing principles.
  • Try entering a series of data into worksheet cells.
  • Get to grips with advance filter and sort data options.
  • Use the search function to find specific values in bigger tables.
  • Learn how best to split longer text entries into separate columns within a table.

MS Excel 2013 Advanced

  • Learn more about creating charts and how to use them.
  • Look at how to automate your work in Excel by using macros.
  • Become familiar with inserting graphics into worksheets.
  • Look at SmartArt Graphics and shapes and how to use them.
  • Prepare a table or work sheet for printing.
  • Examine the different ways you can share and protect workbook data.
  • Go more in-depth into using macros, especially how to create and edit them.
  • Look at the different options for macro security.

Who is this course for?

This course is for anyone who wants to learn the features and functions of the latest version of Microsoft Excel.

Requirements

There are no prerequisites for this course.

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.