Learning Excel 2016

Go to class
Write Review

Free Online Course: Learning Excel 2016 provided by LinkedIn Learning is a comprehensive online course, which lasts for 1-2 hours worth of material. The course is taught in English and is free of charge. Upon completion of the course, you can receive an e-certificate from LinkedIn Learning. Learning Excel 2016 is taught by David Rivers.

Overview
  • Get started with Excel 2016. Learn how to create, format, share, and print workbooks in Excel.

Syllabus
  • Introduction

    • Welcome
    • Using the exercise files
    1. Getting Started with Excel 2016
    • What is Excel?
    • Creating new workbooks and touring the UI
    • Adding text and numbers
    • Adding formulas and functions
    • Understanding cell references when copying and pasting
    • Using Auto Fill
    • Saving workbooks
    2. Modifying Worksheets
    • Formatting text
    • Formatting numbers
    • Formatting dates and times
    • Managing rows and columns
    • Freezing panes
    • Merging cells
    • Inserting recommended charts
    • Inserting pictures
    • Applying themes
    3. Sharing and Printing Workbooks
    • Sharing workbooks using online options
    • Sending workbooks as email attachments
    • Printing workbooks
    Conclusion
    • Next steps