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 and modifying tables
SUMIF, AVERAGEIF functions
Querying data with a Lookup table
Inserting automatic subtotals
Creating and manipulating outlines
Using date & time functions
Manipulating text and using text functions