Excel for Business Life, From Beginning to Advanced

[mitsumi]

Excel for Business Life, From Beginning to Advanced
Video: .mp4 (1280x720, 30 fps(r)) | Audio: aac, 48000 Hz, 2ch | Size: 8.31 GB
Genre: eLearning Video | Duration: 61 lectures (12 hour, 58 mins) | Language: English

Learn Excel, develop strategy, solve business life affairs

What you'll learn

    Excel Fundamentals
    Formats, Fonts and Design
    Worksheet Properties
    Data Management in Excel
    Data Sort
    Data Sort From Left to Right
    Data Filter
    Table
    Remove Dublicates
    Custom List
    Subtotal and Data Groups
    Pivot Table
    Pivot Table Properties and Options
    User Defined Formulas in Pivot Table
    Merge Pivot Tables
    Excel Formulas
    Structure of Excel Formulas
    Text Formulas
    Flash Fill
    Statistical Formulas
    Date and Time Formulas
    SUBTOTAL Function For Filter
    Lookup Functions
    VLOOKUP For 2 Tables
    Advanced Filter Functions
    FORMULAS Menu
    Advanced Excel
    Data Validation
    Conditional Formatting
    Special Cells (GOTO SPECIAL)
    External Data From Other Sources
    Name Manager
    Consolidation
    Watch Window and Trace Cells
    Excel Protection
    Printer Settings
    Relation of PDF and Printer
    Graphics and Charts in Excel
    Simple Graphs
    Column Graphs
    Pie Chart Graphs
    Picture Graphs
    Graphics into the Cells
    Linear Modelling in Excel
    Goal Seek
    What-if Analysis / Data Table
    Excel Solver
    Senario Analysis
    Useful Tips
    Copy - Paste Options
    F4 Key
    Fix Headers
    VIEW Menu
    ComboBox
    Trendline
    Spin Button
    Animated Charts
    Scroll Bar
    Draw Shapes
    Fix Formulas (Details of F4 Key)
    Creating Custom Menu
    Watch Movie and Listen Music in Excel

Requirements

    You just need to know that you need Excel to take this course.

Description

This course is ideal for anyone who wants to learn Excel. The course is designed with an understandable and easy in English. The main goal of the course is to teach all the requirements you need in business life and to use Excel in the most efficient manner.

All videos here have examples and Excel files, and all of them are examples of real business life.

Who this course is for:

    Every employee that uses Excel
   

Download link:

Só visivel para registados e com resposta ao tópico.

Only visible to registered and with a reply to the topic.

Links are Interchangeable - No Password - Single Extraction