Download appDownload App

Quick Guide to Master Advance Excel

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...

  • All levels
  • English

Course 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 tu...

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.

What you’ll 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.

Covering Topics

1
Section 1 : Course Intro
2
Section 2 : Mathmatical functions
3
Section 3 : If Functionality
4
Section 4 : Performing Data Lookups
5
Section 5 : Sparklines
6
Section 6 : Other Mathmatical Functions
7
Section 7 : Outlining
8
Section 8 : Scenarios
9
Section 9 : Custom Views
10
Section 10 : Wrap up

Curriculum

      Section 1 : Course Intro
1
Welcome and Intro Preview
2
The Power of Excel Preview
3
A What you should know before you start the course
4
B What you should know before you start the course
5
What is new in Excel 2016
      Section 2 : Mathmatical functions
6
Creating basic formulas Preview
7
Using functions part2
8
Absolute Values
9
AVERAGE MODE MEAN and MEDIAN
10
Area and Volume Calculations
11
Practice Exercise
      Section 3 : If Functionality
12
IF Syntax and Uses Preview
13
SUMIF for selective Counting
14
COUNTIF for Selective Counting
15
AVERAGEIF for the Mean
16
Nesting the IF Statement Preview
17
Using the AND and OR Operators in an IF statement
18
The NOT Operator within AND and OR statements
19
Practice Exercise
      Section 4 : Performing Data Lookups
20
Creating a VLOOKUP Preview
21
Creating an HLookup
22
Working with Data Validation
23
Dealing with missing data in a Lookup
24
Lookups Nested within Lookups
25
PracticeExercise
      Section 5 : Sparklines
26
What is a Sparkline
27
Creating a Sparkline
28
Altering the design of Sparklines
29
Dealing with empty cells in Sparklines
30
Removing Sparklines from a Worksheets
31
Practice
      Section 6 : Other Mathmatical Functions
32
Working With Time In Excel
33
Calculations Using Time
34
Rounding Decimal Places
35
MOD and INT Functions and Uses
36
Generate and Use a Random Number
37
Loan and Investment Calculations
38
Forecast Function
      Section 7 : Outlining
39
Creating an outline Manually
40
Editing and Removing an Outline
41
Outlining and Functions
42
Practice
      Section 8 : Scenarios
43
Scenarios
44
Setting Up a Set of Scenarios
45
Scenario Summaries
46
Scenario sand Pivot Tables
47
Practice
      Section 9 : Custom Views
48
Introduction to Custom Views
49
Creating a Custom View
50
Use of Outlining to Create Custom Views
51
Editing and Deleting Custom Views
52
Practice
      Section 10 : Wrap up
53
Closing Video
      Section 10 : Wrap up
53
Closing Video

Frequently Asked Questions

It is an online tutorial that covers a specific part of a topic in several sections. An Expert teaches the students with theoretical knowledge as well as with practical examples which makes it easy for students to understand.

A Course helps the user understand a specific part of a concept. While a path and E-Degrees are broader aspects and help the user understand more than just a small area of the concept.

A Course will help you understand any particular topic. For instance, if you are a beginner and want to learn about the basics of any topic in a fluent manner within a short period of time, a Course would be best for you to choose.

We have an inbuilt question-answer system to help you with your queries. Our support staff will be answering all your questions regarding the content of the Course.