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