MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Skill Level: Beginner + Intermediate | Genre: eLearning | Language: English + srt | Duration: 1h 17m | Size: 221.9 MB
Excel, the popular spreadsheet program from Microsoft, is an essential tool for many professional roles. In this course, Jess Stratton shows you the ins and outs of the 2021 release. Jess begins with how to navigate Excel and how to create, open, and save a file. Next, she shows you how to enter, format, autofill, and edit text, as well as how to copy and delete cell data, merge cells, and more. Jess explains how to work with sheets, then dives into the myriad adjustments and customizations you can apply to rows and columns. Formulas are at the heart of Excel's ability to perform text or number calculations, so Jess concludes by walking you through formulas and functions, including AutoSum and the very useful XLOOKUP.

MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Skill Level: Beginner + Intermediate | Genre: eLearning | Language: English + srt | Duration: 2h 32m | Size: 507.5 MB
Explore how to create, edit, format, and share documents with ease, using Microsoft Word 2021. Nick Brazzi, LinkedIn Learning staff instructor, walks you through all the essential features of this powerful tool. Nick goes over creating, editing, and saving documents, with topics like working with ribbons and the Backstage View, using templates, finding tools, and more. He covers ways to shrink and enlarge your document view, manage dark mode, and use the immersive reader. After explaining ways to write and format text, Nick dives into a variety of tools you can use to format paragraphs. He demonstrates how to use text boxes, shapes, drawing tools, and tables to insert and format pictures and other objects. Nick goes into formatting pages and entire documents, as well. After describing how to check and correct the spelling and grammar in your documents, he finishes up with a discussion of ways you can share and collaborate on your Word files.