PLU | Excel 2019 Essentials (2019 EN)

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

Tags:
0/5,
  1. Kanka

    Kanka Well-Known Member Loyal User

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

    Company: Pluralsight
    Author: Bill Kulterman
    Full Title: Excel 2019 Essentials
    Year: 2019
    Language: English
    Genre: Educational: Information Technology
    Skill Level: Beginner
    Price: -
    -
    Files: MP4
    Time: 02:05:04
    Video: AVC, 1280 x 720 (1.778) at 15.000 fps, 450 kbps
    Audio: AAC at 96 Kbps, 2 channels, 44.1 KHz



    In this course, Excel 2019 Essentials, you’ll learn the basics of working with Excel 2019. You’ll learn how to work with the Excel interface and begin the process of putting data into Excel and manipulating that data to gain results.

    Knowing the basics of Excel 2019 can help make you a more well rounded professional. In this course, Excel 2019 Essentials, you will learn foundational knowledge of the Excel interface and settings. First, you will learn how to work with the Ribbon interface and Backstage View. Next, you will discover how to work with worksheets, cells, columns, and rows. Finally, you will explore how to use formatting and Auto options, as well as how to save your file. When you’re finished with this course, you will have the skills and knowledge of Excel 2019 needed to begin creating your own spreadsheets (and begin preparation for the Microsoft Office exams.)


    Lessons:
    1. Getting to Know Excel 2019
    01. Getting Started
    02. The Ribbon
    03. Ribbon Tabs: Home
    04. Ribbon Tabs: Insert
    05. Ribbon Tabs: Page Layout
    06. Ribbon Tabs: Formula
    07. Ribbon Tabs: Data
    08. Ribbon Tabs: Review
    09. Ribbon Tabs: View
    10. Ribbon Tabs: Help
    11. The Quick Access Toolbar
    2. Backstage View
    12. Backstage View
    13. Backstage View: Info Option
    14. Backstage View: New Option
    15. Backstage View: Open Option
    16. Backstage View: Save and Save As Options
    17. Backstage View: Print Option
    18. Backstage View: Share Option
    19. Backstage View: Export Option
    20. Backstage View: Publish Option
    21. Backstage View: Close Option
    22. Backstage View: Account Option
    23. Backstage View: Options Option
    24. Backstage View: Feedback Option
    25. The Mini Toolbar
    3. Working with Worksheets and Data
    26. Navigating Worksheets
    27. Navigating to Named Elements
    28. Adding and Deleting Worksheets
    29. Naming Worksheets
    30. Entering and Editing Data
    31. Selecting Data
    32. Selecting Multiple Ranges of Non-adjacent Data
    33. Searching for Data
    34. Cut, Copy, Paste
    35. Undo, Redo
    36. Paste Options
    4. Working with Rows and Columns
    37. Inserting Rows and Columns
    38. Changing the Width of a Column
    39. Changing the Height of a Row
    40. Hiding and Unhiding Columns or Rows
    5. Formatting
    41. Number, Currency, and Accounting Formats
    42. Percentage Formatting
    43. Date Formatting
    44. Using Autofill and the Fill Handle
    45. Auto Fill Options
    46. Using Flash Fill
    6. Totaling Values
    47. Working with AutoSum
    48. Using Auto Fill with Formulas
    49. Using Other Auto Options
    50. Working with Auto Calculate
    7. Saving a File
    51. Using Save and Save As
    52. Working with File Formats


    -------------
     
    Kanka, Jul 28, 2019
    #1