Tags
Language
Tags
October 2025
Su Mo Tu We Th Fr Sa
28 29 30 1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30 31 1
    Attention❗ To save your time, in order to download anything on this site, you must be registered 👉 HERE. If you do not have a registration yet, it is better to do it right away. ✌

    ( • )( • ) ( ͡⚆ ͜ʖ ͡⚆ ) (‿ˠ‿)
    SpicyMags.xyz

    Quick Guide To Master Advance Excel

    Posted By: ELK1nG
    Quick Guide To Master Advance Excel

    Quick Guide To Master Advance Excel
    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