LIN | Excel 2016 Essential Training (2015 EN)

Discussion in 'Information Technology' started by Kanka, Jul 31, 2019.

Tags:
0/5,
  1. Kanka

    Kanka Well-Known Member Loyal User

    Messages:
    16,037
    Likes Received:
    449
    Trophy Points:
    83
    [​IMG]

    Company: Linkedin Learning
    Author: Dennis Taylor
    Full Title: Excel 2016 Essential Training
    Year: 2015
    Language: English
    Genre: Educational: Spreadsheets
    Skill Level: Beginner - Intermediate
    Price: €34.99
    -
    Files: MP4
    Time: 08:40:47
    Video: AVC, 1280 x 720 (1.778) at 15.000 fps, 300 kbps
    Audio: AAC at 160 Kbps, 2 channels, 48.0 KHz



    Start mastering Excel, the world's most popular and powerful spreadsheet program, with Excel expert Dennis Taylor. Learn how to best enter and organize data, perform calculations with simple functions, work with multiple worksheets, format the appearance of your data and cells, and build charts and PivotTables. Other lessons cover the powerful IF, VLOOKUP, and COUNTIF family of functions; the Goal Seek, Solver, and other data analysis tools; and automating tasks with macros.


    Topics include:
    01. Working with the Excel interface
    02. Entering data
    03. Creating formulas and functions
    04. Formatting rows, columns, cells, and data
    05. Working with alignment and text wrap
    06. Adjusting rows and columns
    07. Finding and replacing data
    08. Printing and sharing worksheets
    09. Creating charts and PivotTables
    10. Inserting and deleting sheets
    11. Using power functions such as IF and VLOOKUP
    12. Password-protecting worksheets and workbooks
    13. Sorting data
    14. Analyzing data with Goal Seek and Solver
    15. Creating and running macros


    -------------
     
    Last edited: Jul 31, 2019
    Kanka, Jul 31, 2019
    #1