Quick Guide To Master Advance Excel

[LeeAndro]

Last updated 12/2018MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHzLanguage: English | Size: 927.38 MB | Duration: 3h 46m

Build real skills on Excel 2016 and master advance functions for data analysis

What you'll learn
Master new features in the latest version of Excel
Become an Excel poweruser
Learn to work with advance and exotic excel features

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 perfog. 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, eeering 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, 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 functionsUnderstand 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 featuresUnderstand what is Sparkline, how to create a sparkline, altering the design of Sparklines, comparing sparklines and removing sparklines.How to perform calculations using in a worksheetHow to create, edit and remove an outlineUnderstand how to create and compare different scenariosWhat 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 perfog complex functions, including creating charts, tables and graphs. Enroll now and learn how Excel can simplify your life.

Overview
Section 1: Introduction

Lecture 1 Welcome and Intro

Lecture 2 The Power of Excel

Lecture 3 What you should know before you start the course Part A

Lecture 4 What you should know before you start the course Part B

Lecture 5 What is new in Excel 2016

Section 2: Mathmatical functions

Lecture 6 Creating basic formulas

Lecture 7 Using functions part 2

Lecture 8 Absolute Values

Lecture 9 AVERAGE MODE MEAN and MEDIAN

Lecture 10 Area and Volume Calculations

Lecture 11 Practice Exercise

Section 3: If Functionality

Lecture 12 IF Syntax and Uses

Lecture 13 SUMIF for selective Counting

Lecture 14 COUNTIF for Selective Counting

Lecture 15 AVERAGEIF for the Mean

Lecture 16 Nesting the IF Statement

Lecture 17 Using the AND and OR Operators in an IF statement

Lecture 18 The NOT Operator within AND and OR statements

Lecture 19 Practice Exercise

Section 4: Perfog Data Lookups

Lecture 20 Creating a VLOOKUP

Lecture 21 Creating an HLookup

Lecture 22 Working with Data Validation

Lecture 23 Dealing with missing data in a Lookup

Lecture 24 Lookups Nested within Lookups

Lecture 25 Practice Exercise

Section 5: Sparklines

Lecture 26 What is a Sparkline

Lecture 27 Creating a Sparkline

Lecture 28 Altering the design of Sparklines

Lecture 29 Dealing with empty cells in Sparklines

Lecture 30 Removing Sparklines from a Worksheets

Lecture 31 Practice

Section 6: Other Mathematical Functions

Lecture 32 Working With In Excel

Lecture 33 Calculations Using

Lecture 34 Rounding Decimal Places

Lecture 35 MOD and INT Functions and Uses

Lecture 36 Generate and Use a Random Number

Lecture 37 Loan and Investment Calculations

Lecture 38 Forecast Function

Section 7: Outlining

Lecture 39 Creating an outline Manually

Lecture 40 Editing and Removing an Outline

Lecture 41 Outlining and Functions

Lecture 42 Practice

Section 8: Scenarios

Lecture 43 Scenarios

Lecture 44 Setting Up a Set of Scenarios

Lecture 45 Scenario Summary

Lecture 46 Scenario sand Pivot Tables

Lecture 47 Practice

Section 9: Custom Views

Lecture 48 Introduction to Custom Views

Lecture 49 Creating a Custom View

Lecture 50 Use of Outlining to Create Custom Views

Lecture 51 Editing and Deleting Custom Views

Lecture 52 Practice

Section 10: Wrap up

Lecture 53 Closing Video

Lecture 54 Bonus Lecture: More Interesting Stuff, Offers and Discounts

Students who want to master the use of advance and professional excel features will love this course

HomePage:

https://www.udemy.com/course/quick-guide-to-master-advance-excel/

DOWNLOAD

https://1dl.net/1uw9d9ehez1q/9mUvkOgS__Quick_Guid.rar.html