Microsoft Excel 2016 Basic and Advanced Skills and Tools

Microsoft Excel 2016 Basic and Advanced Skills and Tools
Video: .mp4 (1280x720, 30 fps(r)) | Audio: aac, 48000 Hz, 2ch | Size: 1.98 GB
Genre: eLearning Video | Duration: 04:37:50 | Language: English

Functions, Tables, Charts, Shapes, Data Tools and more

What you'll learn

In this course you will learn about the basic skills needed to use Excel and advanced tools and functions.
Learn how to use cells, the ribbon and work with rows and columns.
Learn how to make tables and charts, how to filter information and use formatting.
Formulas for functions such as sum, sumif, countif, average, index, match, and more.
Learn how to sort information on tables or on different sheets.
Learn how to use shapes and edit imported pictures.
Learn multiple shortcuts and how to review your work.
Instructions will be spoken and there will also be text on screen for each step.

Requirements

Know how to open Excel and the basics of using a computer. The course will even show you how to open a new workbook in Excel.

Description

Learn about the basics, such as opening a new workbook, using the ribbon and using cells and sheets.

Learn the commonly used formulas and functions.

Learn how to use Tables, Pivot Tables, Charts, Pictures, filtering information and formatting cells.

Learn about Text tools and Effects.

Learn many of the Data Tools.

Learn about reviewing your work and using basic features like zoom and checking spelling.

Learn a few shortcuts that allow you to do work quicker.

Includes Practice Assignments and Quizzes.

Course is in English with English text instructions on screen during videos.

Who this course is for:

Beginner and Intermediate Excel users. Those who want to learn about using spreadsheets to store and edit information.