IT Skills: LinkedIn Learning Video Tutorials

Get up to speed with Microsoft Excel, the world's most popular spreadsheet program. Follow along with Excel expert Dennis Taylor as he demonstrates how to efficiently manage and analyze data with this powerful program. Learn how to enter and organize data, perform calculations with simple functions, and format the appearance of rows, columns, cells, and data. Other lessons cover how to work with multiple worksheets, build charts and PivotTables, sort and filter data, use the printing capabilities of Excel, and more.

Excel for Mac is a powerful tool, but it can be intimidating for new users who either don't know where to start or don't know how to proceed beyond the most basic tasks. In this course, learn how to master the essential tasks in the Mac version of Excel for Office 365. Excel expert Curt Frye shows how to manage workbooks, work with cells and cell data, and sort, filter, and manage worksheets. Plus, learn how to summarize data using core functions and formulas; format worksheet elements; create bar, column, and line charts; work with external data and objects; create and filter PivotTables; and share your spreadsheets with others.

Learn how to work with Keynote 9, including how to create a basic presentation, work with themes, apply transitions, and prepare to deliver your presentation. Instructor David Rivers covers features that will help you create professional-looking presentations with music, effects, and more. Explore a way to see notes on your screen that are invisible to the audience, learn how to record narration, find out how to add charts and tables, and see how to export, print, and share your slides. Plus, get tips for staying organized, making your presentations more compelling, and working with others.

Discover how to work more efficiently with Microsoft Teams, the popular collaboration app in Office 365. In this concise, targeted course, Nick Brazzi shares tips that can help power users get even more use out of Teams. He goes over useful commands and keyboard shortcuts that can help you streamline your workflow, and explains how to use Teams as a hub to access information from different Office 365 apps. Plus, he demonstrates how to leverage different communication options; explores some particularly useful apps in Teams; and shares how to work with bots and messaging apps.

Discover how to store and share documents, spreadsheets, and other files with Microsoft OneDrive. Instructor Garrick Chow demonstrates how to get started with OneDrive on both Windows and Mac, then shows how to upload, organize, copy, and delete files. Learn about how to view photos in elegant galleries and slideshows, share files using links and the public folder, locate specific files, and create documents with Microsoft Office Online.

Get quick answers to your most pressing OneDrive questions. In these short, easy-to-follow videos you can learn how to be more productive and collaborative with OneDrive, the cloud storage solution that allows you to access your documents from anywhere: any device, any browser, any time. Discover how to upload and locate files and folders in OneDrive, share files and folders with internal and external contacts, change sharing options, manage file versions, sync files to the desktop, restore files, use OneDrive on mobile devices, and more. Microsoft Certified Trainer Heather Severino shares tips and tricks that will get up and running fast and help you share files with ease.

Learn how to set up and manage email, calendars, and contacts in the Office 365 version of Microsoft Outlook. Outlook has the tools you need to work as a team, track assignments, and collaborate effectively. This beginner-level course begins with a tour of the interface and shows how to connect a wide variety of email accounts to Outlook. Staff instructor Jess Stratton then shows how to quickly create, send, and read email and reduce your inbox clutter; create and share contacts; and stay on schedule with calendars and tasks. Plus, learn how to back up your Outlook data in case you need to restore it or move it to a different machine.

create a basic presentation, work with themes, apply transitions, and prepare to deliver your presentation. Instructor David Rivers covers features that will help you create professional-looking presentations with music, effects, and more. Explore a way to see notes on your screen that are invisible to the audience, learn how to record narration, find out how to add charts and tables, and see how to export, print, and share your slides. Plus, get tips for staying organized, making your presentations more compelling, and working with others.

You don't have to be a designer to create a great-looking presentation. Learn how to use Microsoft PowerPoint for Office 365 to quickly create, edit, and share professional-looking presentations. In this training course, Jess Stratton shows how to get started with PowerPoint templates and themes or build a new presentation from scratch. She explains how to change the slide layout; add and edit text, images, charts, video, and animation; format slides for consistency; and add speaker notes and comments to ensure a smooth delivery. Plus, discover how to collaborate on changes and share presentations with others. By the end of the course, you'll know how to use the PowerPoint tools and follow a few simple design rules to draw attention to your message and deliver a presentation that shines.

Learn how to create, edit, and share presentations with Microsoft PowerPoint, the powerful presentation and slideshow tool included with Office 365 for Mac. Jess Stratton begins by stepping through how to build a slideshow from scratch, as well as how to leverage PowerPoint templates and themes for quick construction. Jess then demonstrates how to add and edit text, images, charts, video, and animation; format slides for consistency; and add speaker notes and transitions to ensure a smooth delivery. Plus, discover how to collaborate on changes and then share your final presentation as a video file or PDF..

Get up to speed with Microsoft Publisher, the document-layout and publishing platform. Laura Bungarz reviews the interface basics and then dives into working with text, graphics, shapes, and backgrounds. Plus, learn how to work with multiple pages, page parts, and ads, and give your templates a custom look and feel.

Learn how to create, edit, format, and share documents with ease using the Office 365 version of Word. Follow along with David Rivers as he shows all the essential features of this powerful tool. This course covers how to edit and format text to create a stylish document with instant purpose; create numbered and bulleted lists; work with columns and tables; add images and shapes to your documents; collaborate on documents with your team; and share documents via OneDrive and email. Plus, discover how to use the proofing tools in Word to check spelling and grammar, get word counts, and more.

Learn:
-Photoshop CC 2019
-Illustrator 2020
-Lightroom Classic CC
-Premiere Pro CC 2019
-Adobe Spark

Adobe InDesign is the most important tool in publishing today. It’s an essential for magazines, newspapers, print and ebook publishers, and freelance designers around the world. This course teaches the tools and techniques that make the 2020 version of this powerful page-layout application so fun and easy to use. Instructor David Blatner gets you up to speed fast, with a quick start chapter that teaches you the basics in just 30 minutes. Then he dives into the details, including managing documents and pages, editing text and graphics, creating interactive documents and forms, and much more. Take the entire course, or focus on just the features you need to learn. Every lesson brings you one step closer to InDesign proficiency—an essential skill for any career in design or publishing.