More

MS Excel 2013: Complete

PRICE
£39.00 (inc VAT)
£32.50 (ex VAT)
Credit cards
Quantity
Details

Buying for business and need more details? Find out how eCourses can help.

DISCOUNTS ARE AVAILABLE FOR THIS COURSE
Buy 5 or more copies of this course to qualify for a bulk discount. Simply select the number of people who require training, and your discount will be applied when you check out.

Overview

Are you looking to improve your knowledge of Excel 2013? This course is ideal if you're a beginner or want to increase your knowledge. It will take you through the full range of functionality, from beginner level to using the advanced features and applications. Learn how to perform tasks at your own pace by following easy step-by-step actions and complete your training in bitesize chunks. Bookmarking allows you to dip in and out, so you can learn whenever suits you, plus you can jump directly to specific topics of interest quickly and easily.

MS Excel 2013: Complete

Details

With this comprehensive interactive course you will quickly become familiarised with the Excel 2013 environment and its documents and how to control them. Using exercises and software simulations, you will find out how to enter values correctly into the cells and how to set the cell formatting, including conditional formatting.

The course also covers how to manipulate each cell and cell range, work with worksheets and entire files. You will create a chart and learn to create calculations by basic arithmetic formulas as well as broaden your knowledge by the application of logical and text functions. You will become acquainted with the principles of referencing to the values in other cells and how to fill cells with series of data.

You will also familiarise yourself with the advanced options of sorting and filtering data or searching for specific values in extensive tables and examine how to split longer text entries in tables into individual data placed into several columns. The course will also familiarise yourself with the usage of macros, including their creation and editing and you will examine the options of macro security.

Modules

The course modules are:

Create and manage worksheets and workbooks
Includes: manipulating worksheets, find and replace, file properties, hyperlinks, themes, columns, customising toolbar and ribbon, macros, panes, publishing to web.

Create cells and ranges
Includes: data entry, moving/copying, text series, custom lists, alignment, formatting, cell styles, advanced paste.

Create tables
Includes: advanced work with tables, filtering, sorting, duplicate data.

Apply formulas and functions
Includes: cell ranges and references, formulas, AutoSum, logical functions, conditional calculations, text functions.

Create charts and objects
Includes: chart creation and design, chart formatting, shapes, SmartArt, pictures in Excel

Certificate

A learndirect certificate will be emailed to you when you have successfully completed the course.

Quantity
Details

Buying for business and need more details? Find out how eCourses can help.

DISCOUNTS ARE AVAILABLE FOR THIS COURSE
Buy 5 or more copies of this course to qualify for a bulk discount. Simply select the number of people who require training, and your discount will be applied when you check out.

×