MP4 | Video: h264, 1280x720 | Audio: AAC, 48 KHz, 2 Ch | Duration: 8h 18m | 3.19 GB

Genre: eLearning | Language: English + .VTT | + Resource Files | Last updated 3/2018

Quickly learn A-Z of Excel 2016, Formats, Pivots, Charts, Functions, VBA, Data Analysis all in this one complete course!

What Will I Learn?

Introduction to worksheets, workbooks, and toolbar:

Learn the basics of Excel and how to navigate a spreadsheet.

Cells, Ranges, Tables, Worksheet operations:

Navigate the spreadsheet and begin to change the way cells, ranges, and tables look and function.

Formatting cells and conditional formatting:

Easily set rules and conditions for cells within the worksheet, so you stay organized.

Formulas and Functions:

Learn how to calculate complicated equations the easy way.

Charts:

Give your data a visual representation that is easier to understand and useful.

Data Protection and Validation:

Keep others from changing the cells in your worksheet through data protection and validation.

Pivot Tables:

Quickly summarise, analyse, and sort your data with easy-to-use pivot tables.

What-If Analysis:

Explore a variety of different results by comparing two sets of data within the spreadsheet.

Descriptive Statistics:

Easily and quickly produce a summary of key statistics for any given data set.

Visual Basic for Applications (VBA):

Become an Excel wizard by writing your own programmed tasks directly in Excel to automate complicated tasks.

Requirements

Basic computer knowledge and Ms Excel

Description

Do you want to be a Microsoft Excel Master? Whether you need to learn it for school, you want to manage your finances better, or you want to impress your boss, this is the course for you! Learn directly from the experts all of the basics and advanced concepts that you cannot find in other lessons.

Each tutorial is easy to follow with clear explanations of each of the topics covered. Mastering Microsoft Excel 2016 is designed for anyone that wants to know more about this powerful software platform so whether you’re a beginner, intermediate, or advanced Excel user, you can learn something from this course.

We start out with the basics, focusing on worksheets and the different basic tools that everyone should know to use Excel correctly and efficiently from the start. After that, we'll move onto more intermediate topics such as Functions, Pivot tables, different chart types, “what if” analysis, data interpretation and finally VBA!

We specifically designed this course with practicality in mind. We want to see our students using Excel in their everyday work and personal lives and excel at it. Once you complete the course and all of the quizzes and exercises, you’ll be able to confidently use Microsoft Excel 2016 to do a variety of things.

Learning Microsoft Excel doesn’t need to be difficult; learn everything you need to know with our easy, convenient course!

Who is the target audience?

The course has been developed for anyone who wants to learn MS Excel and VBA. And for even those who want to understand how Excel is used in Data Analytics