Quick Guide To Master Advance Excel

[mitsumi]

Last updated 12/2018
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: 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 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 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 time 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 performing 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: Performing 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 Time In Excel
Lecture 33 Calculations Using Time
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

Download link

rapidgator.net:

https://rapidgator.net/file/463b065418c21d18ca2a9b37830cae74/sdrpb.Quick.Guide.To.Master.Advance.Excel.rar.html

uploadgig.com:

https://uploadgig.com/file/download/82968f26E297836A/sdrpb.Quick.Guide.To.Master.Advance.Excel.rar

nitroflare.com:

https://nitroflare.com/view/8D864BD02F09A7C/sdrpb.Quick.Guide.To.Master.Advance.Excel.rar

1dl.net:

https://1dl.net/0h6cihdhtvf5/sdrpb.Quick.Guide.To.Master.Advance.Excel.rar.html