Overview

Are you looking to improve your knowledge of Excel 2016? 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.

Details

With this comprehensive interactive course you will quickly become familiarised with the Excel 2016 environment and its documents and you will learn 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.

As you progress through the course you will learn to manipulate each cell and cell range, you will learn to work with worksheets and entire files. You will create a chart and learn to create calculations by basic arithmetic formulas. You will broaden your knowledge by the application of logical and text functions. You will get acquainted with the principles of referencing to the values in other cells. You will learn 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. You will examine how to split longer text entries in tables into individual data placed into several columns. You 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

Include: 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.