Recommended LinkedIn Learning Courses

All IAS faculty, members and staff have access to the full library of online training modules through LinkedIn Learning (formerly Lynda.com).  To login, please follow the link LinkedIn Learning, and enter your IAS email address.  From there, you'll be directed to a screen to login. Please enter your normal IAS username and password.  It is not required that you have a LinkedIn account, nor if you do, that you link it to your training profile. 

The following are some recommended LinkedIn Learning courses for the following topics

Excel 2016 Essential Training (Topics include: Getting Started with Excel, Entering Data, Creating Formulas and Functions, Formatting, Adjusting Worksheet Layout and Data, Printing, Charts, Adjusting Worksheet Views, Multiple Worksheets and Workbooks, Security and Sharing, Data Analysis Tools, PivotTables, Macros)

PowerPoint 2016 Essential Training  ( Topics include: Navigating PowerPoint, Working with Presentations, Working with Slides, Adding Pictures to Slides, Adding Content to Slides, Adding Shapes, Diagrams and Charts to Slides, Adding Video, Audio, and Animation to Slides, Preparing the Presentatoin, Delivering your presentation)

Learning Word 2016  (Learn how to get up and running with Microsoft Word 2016. This short course for novice Word users will introduce the Word interface and explain how to open, save, and create documents and templates. The course then explores basic formatting and adding images, tables, and charts as well as working with styles, creating long documents, and collaborating with Track Changes.)

Below are a series of suggested courses that go beyond the very basics of using a spreadsheet.  You will need to log into LinkedIn learning first and then use the links below.  The instructor in the video may use a different computer type or different version of the software but the instructions will be very much the same no matter which version you are using.

Creating named ranges
https://www.linkedin.com/learning/excel-for-mac-2016-essential-training/creating-named-ranges

Creating and modifying tables
https://www.linkedin.com/learning/excel-for-mac-2016-essential-training/creating-an-excel-table

Removing duplicates
https://www.linkedin.com/learning/search?keywords=remove%20duplicates%20excel

Sorting data
https://www.linkedin.com/learning/excel-for-mac-2016-essential-training/sorting-worksheet-data

Filtering data
https://www.linkedin.com/learning/excel-for-mac-2016-essential-training/filtering-worksheet-data

IF function
https://www.linkedin.com/learning/excel-2010-essential-training/using-if

SUMIF, AVERAGEIF functions
https://www.linkedin.com/learning/excel-2010-essential-training/using-sumif-and-averageif

Querying data with a Lookup table
https://www.linkedin.com/learning/search?keywords=excel%20lookup%20tables

Inserting automatic subtotals
https://www.linkedin.com/learning/excel-2010-essential-training/inserting-automatic-subtotals

Creating and manipulating outlines
https://www.linkedin.com/learning/excel-introduction-to-formulas-and-functions/group-and-outline-list-data

Using date & time functions
https://www.linkedin.com/learning/excel-2010-essential-training/working-with-times-and-dates

Manipulating text and using text functions
https://www.linkedin.com/learning/excel-2016-cleaning-up-your-data/use-text-functions

Password-protecting workbooks
https://www.linkedin.com/learning/excel-2016-essential-training/protecting-workbooks
https://www.linkedin.com/learning/excel-2010-essential-training/setting-workbook-permissions