Microsoft Excel - Beginner to Advanced

Quickly learn A-Z of Excel 2016 - Pivots, Charts, Functions, Data Analysis!
Enroll Now $199 $12.00

Why Enroll?

Check out just a few key highlights for:
Microsoft Excel - Beginner to Advanced.

7,160 Students

Join a community of other students taking this course.

Duration

Each lecture is recorded in HD 1920x1080p with clear audio.

4.8/5 Stars

All courses are rated by fellow community members.

More Benefits

Learning with YouAccel has several exciting benefits.

Clear HD Video

All YouAccel courses are recorded and produced in 1920x1080p HD Quality.

Live Support

Have a question? Contact our support team at any time using our chat feature, or built-in messaging console.

Certification

All YouAccel courses come with a Certificate of Completion. This helps Showcase your proficiency in a subject to prospective employers.

Lifetime Access

All YouAccel courses include lifetime on-demand access. Class lecture are also available for offline viewing.

Community

Join a community of over 600,000 learners. Connect & Communicate through YouAccel's networking tools.

Job Pool

YouAccel's integration with Indeed makes it easy to search through thousands of jobs and apply with just a click.

Course Outline

A comprehensive list of all sections & lectures for this course can be found below.

Module 1: Introduction

This lecture lists down all the contents of this course - 04:42 [Play]

Building Blocks - 06:45

Toolbar - 17:35

Worksheet Operations - 08:18 [Play]

Cells & Ranges - 06:57

Tables - 06:14

Formats - 15:42 [Play]

Conditional Formatting Part 1 - 15:08

Conditional Formatting Part 2 - 16:25

Formulas - 15:19 [Play]

Logical Functions - 10:25

Text Functions - 16:29

Date & Time Functions - 04:24

Lookup Functions - 09:06

Math Functions - 07:08

Statistics Functions - 11:52

Data Protection - 13:37 [Play]

Validation - 11:40

Introduction to Charts - 20:26 [Play]

Line Charts - 08:02

Pie - 06:52

Doughnut, Bubble, Stock Charts - 11:10

Sparkline Charts - 09:25

Structure of a Pivot Table - 09:47 [Play]

Pivot Table Calculations - 23:23

Pivot Table Options - 09:39

What-if Analysis - 17:54 [Play]

Solver - 10:45

Descriptive Statistics, Ranks - 19:14 [Play]

Statistical Tests and Regression - 15:59

Basic Building Blocks Part 1 - 11:19 [Play]

Basic Building Blocks Part 2 - 13:04

Basic Building Blocks Part 3 - 08:28

Conditional and Looping Constructs - 10:39

Custom Functions - 04:54

Error Handling - 14:55

Introduction to Form Controls - 10:29

Introduction to Workbook & Worksheet Events - 19:04

Creating a Userform Part 1 - 24:56

Creating a Userform Part 2 - 04:30

Locking cells for Functions - 03:22 [Play]

SUM, SUMIF, SUMIFS - 04:48

Importing Data in Excel - 02:08

Custom Sort in Excel - 02:09

Conditional Formatting to highlight duplicate values - 03:17

Course Description

This course is your complete guide to mastering Microsoft Excel. It covers all aspects of working on Excel, starting from basic concepts like creating worksheets, rows, columns, and tables. From there students learn Standard and Conditional Cell Formatting.

The course also covers intermediate topics like Functions where students will master Statistical, Math, Text, Logical, and Lookup Functions. Students are then introduced to Data Protection and Validation which is used to secure data.

This course offers a comprehensive section on Pivot tables in which students will learn to effectively sort and organize data. The theoretical concepts are coupled with case studies to ensure effective comprehension of course content.

In the Charts module, students learn to work with various types of charts and chart analysis. Students will perform advanced trend analysis using charts. Statistical concepts will also be explored which are essential for any data analyst. For example:

  • What if Analysis
  • Data Interpretation using the Data Analysis Toolbox
  • Basics of VBA Script
  • Creating Custom functions using VBA
  • UserForm function to automate work processes


By the end of this course you will have a solid understanding of Excel. You will also see first-hand why previous students refer to this course as the Microsoft Excel Bible!

There are helpful quizzes included in all sections that will help you cement the concepts explored.

The instructors are committed to add new practice activities so that you gain valuable hands-on experience.

Why should you enrol today?

  • Jobs in Excel – Almost every organization uses Excel for data entry. Having a solid understanding of Excel will put you well ahead of the competition in just about any field of work.
  • Demand is significantly increasing – As organizations have started to understand the importance of data the demand for more people being comfortable in Excel will only go up. And for a Data Analyst, it is THE backbone!
  • Easily comprehend advanced topics, with expert instructors.

Microsoft Excel - Beginner to Advanced

All course reviews are written by students who have completed the course or are currently enrolled.

Course Instructor - Sachin Dean

Sachin Dean
Teaching 4 Courses

Sachin Dean is currently teaching 4 courses. All courses are currently open for enrollment.

10,235 Enrollments

Sachin Dean currently has 10,235 global enrollments across 4 courses that are active on the platform.

4.5 Star Rating

Sachin Dean has an average rating of 4.5/5 stars, across 4 courses.

Whether you're looking to launch your first career initiative or you are looking to enhance your library of skills, we offer an extensive range of data analysis courses to skyrocket your career in analytics!



All Courses include a 30-Day Satisfaction Guarantee.

You have nothing to lose. Give the course a try. If it's not what you expected, get a full refund within 30 days of purchase.