Quick Guide to Master Advance Excel
4.7 (6 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
38 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Quick Guide to Master Advance Excel to your Wishlist.

Add to Wishlist

Quick Guide to Master Advance Excel

Build real skills on Excel 2016 and master advance functions for data analysis
4.7 (6 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
38 students enrolled
Last updated 4/2016
English
Learn Fest Sale
Current price: $10 Original price: $40 Discount: 75% off
4 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 4 hours on-demand video
  • 9 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Master new features in the latest version of Excel
  • Become an Excel poweruser
  • Learn to work with advance and exotic excel features
View Curriculum
Requirements
  • Basic knowledge of excel assumed by the author
Description

Getting the data is actually the easy part. Now that you have the data, the hard part is to analyze it. Data is often found in a mess and the job of sorting it and maintaining it, along with analyzing it was once a difficult task. This is before Microsoft Excel came along – making it easier to store, organize, sort, filter and even analyze the data.
Our Excel 2016 course is a complete online tutorial designed to not only familiarize you with the Excel program, but to also teach you all the things that Excel is capable of performing. Our tutorial will also cover the differences between Excel 2013 and the latest version – the Excel 2016, teaching you all the new features that are available with the 2016 version.
Microsoft Excel is an interactive spreadsheet that allows users to organize, analyze and store data in a tabular form. Originally designed as an alternative for accounting worksheets, Excel has since then evolved into a more complex piece of software. It has enabled users to easily record and analyze information and offers numerous tools to help along with this process. 
Excel comes in a grid of cells that are arranged in numbered rows and letter-named columns. It allows arithmetic operations and also caters to statistical, engineering and financial requirements. 
Excel 2016 is a part of the Microsoft Office 2016 suite is the successor to Excel 2013. However, many functions in Excel 2013 are similar to the functions found in Excel 2016.
The course will cover topics such as If statements, Vlookup, Round functions, Time functions, Data lookups, Sparklines, Outlining and even Scenarios. From basic formulas and simple functions to complex statements and operators, this course includes it all. It breaks down all aspects of Excel 2016 to give you a complete understanding of this amazing and useful software. 
To give you an optimum learning experience, each section also comes with working files, practice exercises and even quiz questions and answers to help you along on your learning journey. 
In this course, you will learn:

  • Learn how to use the basic formulas – SUM, COUNT, MIN, and MAX functions
  • Understand how to use the SUMIF function for selective counting, 'AVERAGEIF' for Mean of selected cells, Multiple Criteria Within 'SUMIF', 'COUNTIF', and 'AVERAGEIF'
  • Learn how to use the 'VLOOKUP' function and its various features
  • Understand what is Sparkline, how to create a sparkline, altering the design of Sparklines, comparing sparklines and removing sparklines.
  • How to perform calculations using time in a worksheet
  • How to create, edit and remove an outline
  • Understand how to create and compare different scenarios
  • What are Custom Views, how to create a Custom View and how to edit and delete a Custom View.

There is so much more that you can do with your excel sheet. From simply a tool for organizing, excel can now help with simple calculations to performing complex functions, including creating charts, tables and graphs. Enroll now and learn how Excel can simplify your life. 

Who is the target audience?
  • Students who want to master the use of advance and professional excel features will love this course
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 54 Lectures Collapse All 54 Lectures 03:48:02
+
Introduction
5 Lectures 29:15



What you should know before you start the course Part B
09:14

What is new in Excel 2016
08:44
+
Mathmatical functions
6 Lectures 30:31
Creating basic formulas
09:56




Area and Volume Calculations
04:13

Practice Exercise
01:22
+
If Functionality
8 Lectures 37:33
IF Syntax and Uses
05:39

SUMIF for selective Counting
06:40

COUNTIF for Selective Counting
02:54

AVERAGEIF for the Mean
06:37

Nesting the IF Statement
03:47

Using the AND and OR Operators in an IF statement
06:28

The NOT Operator within AND and OR statements
03:27

Practice Exercise
02:01
+
Performing Data Lookups
6 Lectures 25:44
Creating a VLOOKUP
05:06

Creating an HLookup
02:36

Working with Data Validation
07:52

Dealing with missing data in a Lookup
04:37

Lookups Nested within Lookups
04:14

Practice Exercise
01:19
+
Sparklines
6 Lectures 18:15
What is a Sparkline
03:14

Creating a Sparkline
03:36

Altering the design of Sparklines
06:07

Dealing with empty cells in Sparklines
02:21

Removing Sparklines from a Worksheets
01:44

Practice
01:13
+
Other Mathematical Functions
7 Lectures 30:48
Working With Time In Excel
02:03

Calculations Using Time
06:41

Rounding Decimal Places
02:49

MOD and INT Functions and Uses
03:28

Generate and Use a Random Number
02:17

Loan and Investment Calculations
09:56

Forecast Function
03:34
+
Outlining
5 Lectures 17:21
Creating an Outline
02:14

Creating an outline Manually
03:37

Editing and Removing an Outline
04:27

Outlining and Functions
05:39

Practice
01:24
+
Scenarios
5 Lectures 21:41
Scenarios
02:39

Setting Up a Set of Scenarios
06:21

Scenario Summary
06:09

Scenario sand Pivot Tables
03:55

Practice
02:37
+
Custom Views
5 Lectures 15:56
Introduction to Custom Views
02:52

Creating a Custom View
04:48

Use of Outlining to Create Custom Views
03:46

Editing and Deleting Custom Views
02:54

Practice
01:36
+
Wrap up
1 Lecture 00:58
Closing Video
00:58
About the Instructor
Eduonix Learning Solutions
4.3 Average rating
41,282 Reviews
726,939 Students
172 Courses
1+ Million Students Worldwide | 200+ Courses

Eduonix creates and distributes high quality technology training content. Our team of industry professionals have been training manpower for more than a decade. We aim to teach technology the way it is used in industry and professional world. We have professional team of trainers for technologies ranging from Mobility, Web to Enterprise and Database and Server Administration.

Eduonix-Tech .
4.3 Average rating
39,475 Reviews
704,448 Students
140 Courses