LinkedIn Learning
Excel Essential Training (Microsoft 365)
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. Plus, check out Excel’s newly revamped Accessibility Checker that helps you adjust fonts and colors to be more readable and add alt-text for images, to make your workbooks more accessible to people with disabilities. Other lessons cover how to work with multiple worksheets, build charts and PivotTables, sort and filter data, print in Excel, use Microsoft Copilot with Excel, and more.
Estimated Time: 2 hours
This session is available immediately via LinkedIn Learning.
Excel 2021 Essential Training
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.
Estimated Time: 2 hours
This session is available immediately via LinkedIn Learning.
Excel: Intro to Formulas & Functions
To unlock the power of Excel, you need to use formulas and functions. These calculation tools help you bring information to the surface and make better decisions. Excel: Introduction to Formulas and Functions shows beginner-level users how to summarize and analyze data with these powerful data analysis features. Instructor Curt Frye shows how to create formulas with mathematical operations such as addition, subtraction, multiplication, and division, and how to use cell references in your formulas. He explains how to summarize data with functions like SUM and AVERAGE, and work with data in named ranges and Excel tables. Curt also covers procedures to ensure data integrity, such as data validation, and demonstrates auditing techniques to ensure formulas are correct.
Estimated Time: 2 hours
This session is available immediately via LinkedIn Learning.
Excel Formulas and Functions Quick Tips
The myriad formulas and functions in Excel are a large part of what makes it such a uniquely powerful program. But for many users, figuring out how to apply these formulas and functions to solve everyday problems can seem overwhelming. In this course, staff instructor Jess Stratton demystifies these powerful features, sharing bite-sized tips designed to help you work faster and more efficiently in Excel. Jess begins by covering the fundamental concepts you need to get started with functions and formulas, such as how to programmatically reference cells located in other worksheets and combine cell data with other characters. She goes over identifying values, then digs into a variety of useful Excel functions. Jess highlights how to count cells that meet a specific set of criteria using COUNTIF, extract characters with LEFT and RIGHT, use INDEX and MATCH to retrieve a value, and much more.
Estimated Time: 37 minutes
This session is available immediately via LinkedIn Learning.
Excel: Creating Business Budgets
A sound business budget can help you effectively manage resources as your organization changes and grows. Microsoft Excel is uniquely suited to the task of business budgeting, as it boasts a slew of features that make it easy to create budget models, as well as apply ongoing updates as your business evolves. In this course, Joshua Rischin shows business owners, managers, and their staff how to use Excel to design, create, and maintain robust business budgets. Joshua demonstrates how to use an Excel model to build business budgets in a logical and structured manner, as well as how to forecast income and expenses based on various scenarios. He also shows how to collate inputs from various sources to create structured Excel input sheets, visualize your projected results, prepare summary reports, and more.
Estimated Time: 1 hour
This session is available immediately via LinkedIn Learning.
Excel: Tracking Data Easily and Efficiently
Too often, Excel users struggle to effectively track data in Excel because they start with the final report in mind. While this seems intuitive, setting up a spreadsheet in this way limits what a person can get from their data. In this course, follow along with Excel MVP Oz du Soleil as he shows how to use Excel features and functions—including Power Query and dynamic arrays—to build and organize basic spreadsheets and transform them into robust tracking systems for any kind of data that is regularly updated. Learn how to create a tracker in Excel that you and your team can use to easily track any kind of data: sales, donations, inventory levels, project statuses, student progress, household spending, and more. Oz wraps up with challenges that invite you to pull together everything you've learned.
Estimated Time: 4 hours
This session is available immediately via LinkedIn Learning.
Excel: PivotTables for Beginners
PivotTables don't have to be scary! This powerful Excel feature cuts the time you spend on formulas in half. In this concise course, Excel trainer Dave Ludwig demystifies PivotTables and shows you how to get started using them to analyze your data. Dave begins by explaining two PivotTable basic building blocks: value fields and row fields. Then he shows you how to adjust a PivotTable by adding fields, filters, and formatting. Dave shows you how to use special filter buttons which are known as slicers, and he also demonstrates how to use timelines. Plus, he goes over the basics of refreshing and updating a PivotTable. Finally, he’ll show you how to use AI in Excel to generate PivotTables automatically for you.
Estimated Time: 27 minutes
This session is available immediately via LinkedIn Learning.
Excel: Pivot Table Tips
Go from beginner to power PivotTable user. Learn how to use Excel PivotTables and PivotCharts for powerful data analysis. Chris Dutton leads this practical guide, filled with lots of hands-on exercises and real-world use cases. He shows how to structure your data; change table layouts and styles; leverage design controls; perform sorting, filtering, and grouping; and create interactive dashboards. Use the PDF cheat sheets and the Excel solution file to follow along as you learn. Note: The instructor uses Office 365 ProPlus. Some features may not be available in all versions of Excel.
Estimated Time: 2 hours
This session is available immediately via LinkedIn Learning.
Excel PivotTable Quick Tips
Excel PivotTables–which allow you to quickly calculate and analyze large amounts of data–are one of the most powerful features of Microsoft’s ubiquitous spreadsheet tool. But many users have only a basic understanding of how PivotTables work. In this course, instructor Jess Stratton offers a plethora of bite-sized tips designed to deepen your understanding of how PivotTables work and how to use them more effectively. Learn how to properly format data and create a basic PivotTable in Excel. Discover ways to adjust, rearrange, and group data to calculate and summarize values that you can put to use on the job. Get tips on data filtering and sorting, conditional formatting, and using PivotCharts and slicers. Along the way, Jess shows how to deal with common PivotTable error messages, such as invalid field names and overlapping reports. By the end of this course, you’ll be able to create more robust PivotTables in minutes—just in time for that next meeting.
Estimated Time: 16 minutes
This session is available immediately via LinkedIn Learning.
Excel PivotTables: Mastering PivotTables and Pivot Charts
While the power and time-saving value of PivotTables appeals to anyone who analyzes data in Excel, many users are too intimidated by the feature to add it to their workflow. In this course—the first installment in a two-part series—instructor Chris Dutton breaks down how to use PivotTables, as well as how to add PivotCharts to the mix to summarize your data visually. Throughout the course, Chris shares practical tips and demonstrations that help you grasp how these tools are used in the real world, as well as how PivotTable values are actually calculated and displayed. Learn how to prepare your raw data for analysis; leverage formatting, sorting, filtering, and grouping options; display values in multiple ways; create PivotCharts; and much more.
Estimated Time: 4 hours
This session is available immediately via LinkedIn Learning.
Excel: PivotTables in Depth
PivotTables are one of the most powerful features in Excel, yet many users are barely scratching the surface of what they can do. In this course, Excel power user Curt Frye shows you how to navigate the complexity of PivotTables while taking advantage of their power. Curt explains how to build PivotTables from single or multiple data sources, pivot and configure a PivotTable, define a default PivotTable layout, and more. He demonstrates ways to summarize your data, add calculated fields, filter your results, and format your layout to make it more readable. Learn how to sort and filter PivotTable data, format your PivotTable, and apply conditional formats. Curt also explains how to create PivotCharts to visualize your data, enhance PivotTables with macros, and use the Data Model feature to build PivotTables from related tables. Note: This course was recorded in Microsoft 365. However, anyone using a recent standalone version of Excel (Excel 2021, 2019, or 2016) should be able to follow along with the course contents.
Estimated Time: 4 hours
This session is available immediately via LinkedIn Learning.
Excel: Productivity Tips
Supercharge your productivity, work more efficiently, and become an Excel power user by mastering the same tools and techniques used by the pros. In this course, analytics expert and instructor Chris Dutton guides you through demos and case studies designed to help you add powerful productivity tools to your Excel skill set. Learn how to navigate worksheets with keyboard shortcuts, remove blank rows quickly, apply fill patterns, protect cells and formulas, apply advanced sorting and filtering tools, and more. Follow along from home with downloadable PDF cheat sheets, practice workbooks, and solution files. Note: Chris uses Microsoft Office 365 ProPlus (Microsoft 365 Apps) throughout the course, so some tips may not apply to all versions of Excel. This course was created by Chris Dutton. We are pleased to offer this training in our library.
Estimated Time: 1 hour
This session is available immediately via LinkedIn Learning.
Excel Tips Weekly
This tips-based course will show Excel users productivity-boosting tricks, cool hidden features, need-to-know functions, and advanced content on subjects such as using PivotTables for data analysis. Tune in every Tuesday for a new tip from expert Dennis Taylor. Each tutorial is a short, self-contained lesson guaranteed to give you new insights into Excel. Note: Because this is an ongoing series, viewers will not receive a certificate of completion.
Estimated Time: Varies
This session is available immediately via LinkedIn Learning.
Excel Quick Tips
The most common questions about using Excel now have timely video answers. This set of quick tips offers helpful, condensed steps you can readily apply to keep on task—whether you're running calculations, setting up a new workbook, applying conditional formatting, fixing a sheet, collaborating with your team, removing sensitive information from a file, getting tables ready for a presentation, and more. Join LinkedIn Learning staff instructor Garrick Chow as he provides on-the-spot solutions for some of the most common questions in Excel. Each video is about one minute long, so you can jump in and get some helpful insights in no time.
Estimated Time: 44 minutes
This session is available immediately via LinkedIn Learning.
Excel Weekly Challenge (LI #72867)
There are countless books and courses that teach Microsoft Excel. However, true mastery requires practice. You have to apply what you've learned in order to make it stick. This series, with Excel MVP Oz du Soleil, provides weekly Excel challenges taken from Oz's experience helping clients with real-world problems. Each video begins with a challenge, such as inconsistent cell formatting, duplicate line items, or incomplete data. Pause the video and download the related exercise file to work out your own solution using the powerful features built into Excel. When you're ready, you can restart the video to see how Oz solves the challenge. In just a few minutes a week, you can learn the most popular and useful Excel formulas, functions, and features. Tune in every Friday for a new technique. Note: Because this is an ongoing series, viewers will not receive a certificate of completion.
Estimated Time: Varies
This session is available immediately via LinkedIn Learning.
How to Find an Extra Hour in Your Day
Has it ever occurred to you that you might be managing your time and productivity incorrectly? In this course, join instructor Samantha Bennett and she shows you how to identify what needs to get done, make important changes to your workflow, and quit procrastinating on the stuff that really matters. Along the way, gather insights on making the most of your time so you can go out and redeem that extra hour. From starting with 15 minutes to using five-minute transitions, permanently erasing calendar commitments, putting down your phone, and more, this course equips you with quick, easy-to-use tips to manage your time more effectively, in any field or role. This course was created by Madecraft.
Estimated Time: 32 minutes
This session is available immediately via Workday.
How to Manage Feeling Overwhelmed
Feeling overwhelmed is common. It’s a sign that the demands on your time and energy have surpassed your ability to cope with them. Sometimes overwhelm is temporary; other times, it can lead to persistent and unhealthy pressure and strain. The good news is that with the right mindset you can make the unmanageable feel manageable again. In this course from stress expert and performance coach Heidi Hanna, you can learn how to identify and conquer that overwhelmed feeling—so you can remain focused, productive, and in control in the face of whatever comes your way. Discover how to disrupt the stress circuit, cultivate calm and positive emotions, and take small, imperfect steps toward resolution. Heidi also provides tips for recognizing and preventing the overwhelm, so it doesn’t get out of control the next time you have too much to do.
Estimated Time: 43 minutes
This session is available immediately via Workday.
How to Organize Your Time and Your Life
Looking for an organizational system that fits your specific needs? Don’t just follow the trendiest new productivity hacks. In this course, adapted from the podcast How to Be Awesome at Your Job, join organization guru Julie Morgenstern as she discusses how to manage your time for greater productivity and build a system tailored to your needs. Julie goes over the importance of considering your goals and personality when designing your system. Figuring out what works best for you will ensure your system feels natural and functions optimally. Julie also covers how to troubleshoot your organizational systems in order to narrow down what’s working and what’s not, reclaim your creative time, keep your inbox from taking over your day, and more. This course was created by Pete Mockaitis of How to Be Awesome at Your Job.
Estimated Time: 24 minutes
This session is available immediately via Workday.
How to Set Goals When Everything Feels Like a Priority
Sometimes it can feel like you’re working on everyone's else's to-do list instead of your own. How can you make space for accomplishing the goals that are important to you? Join best-selling business author and consultant Dorie Clark as she shares practical advice on how to prioritize effectively so that you can get meaningful things done. Dorie shares techniques that you can leverage to get clarity on what to prioritize, as well as how to take action when you find yourself unsure of your next steps. She explores well-known frameworks, including the Eisenhower matrix and the Pareto principle, that can help you become more effective. Along the way, she shares how to find the motivation to get yourself going, maintain your momentum, and make it all the way to your goal.
Estimated Time: 15 minutes
This session is available immediately via Workday.
Leading When You’re Not In Charge
Have you ever looked at your work situation and thought about how things might be different if you were the one in charge? In reality, it’s possible to lead from a spot of influence rather than a position of authority. In this audio-only course, Pete Mockaitis speaks with Clay Scroggins, author of How to Lead When You’re Not in Charge, about how to lead without being in the top position. Clay speaks about the lessons learned from his own experiences, and how powerful leadership begins with leading yourself well. He details important questions to ask your team that can enhance and improve the way you collaborate, and offers helpful advice on topics like making time for reflection, how to show your boss that you care, and focusing on the authority you do have. This course was created by Pete Mockaitis of How to Be Awesome at Your Job.
Estimated Time: 30 minutes
This session is available immediately via Workday.
Leading Without Formal Authority
Leadership isn't just a skill for managers. Demonstrating leadership is important for employees at every level of an organization. There are opportunities to lead every day, whether you hold a formal leadership position or not. In this course, leadership and personal development experts Lisa Earle McLeod and Elizabeth Lotardo outline how individual contributors or SMEs can exhibit leadership by influencing, inspiring, mentoring, and motivating others. They also help you overcome unique challenges such as how to communicate when you think your boss or team is headed in the wrong direction.
Estimated Time: 58 minutes
This session is available immediately via Workday.
Mindfulness: A Critical Skill for Project Managers
In the field of project management, there has been heightened attention on the value of interpersonal skills. The foundation of these skills is an increased awareness of oneself and others—and that begins with mindfulness. In this course, instructor Ruth Pearce explores what mindfulness is (and is not), challenging popular misconceptions about the practice of mindfulness and its importance in managing projects. Ruth explores the links between mindfulness and the skills of a standout project manager, including leadership, decision-making, and communication. Learn how mindfulness can help you counteract cognitive bias and respond appropriately to both positive and negative stress. Get tips for transitioning from task to task mindfully. Plus, discover how to incorporate mindfulness practices into your everyday life.
Estimated Time: 38 minutes
This session is available immediately via Workday.
Time Management Fundamentals
What would you do if you had an extra 10 hours per week? Sounds impossible? In this course, productivity expert Dave Crenshaw shows you how to get more done in the shortest time possible and give you more of that precious free time. The course lays out the theoretical and practical foundations for being more productive and explains the obstacles that can get in the way. It then gives practical strategies for increasing productivity in three main areas: How to develop habits to be more organized and reduce the clutter in your workspace; how to stay mentally on task and eliminate the to-dos you have floating in your head; and how to develop a time budget to get the most done during your workday and focus on your most valuable activities. If you’ve been looking for strategies to help you manage your time more efficiently, this course may be well worth your time.
Estimated Time: 2 hours
This session is available immediately via Workday.