- Excel 2019 (Part 20): Grouping and Subsummary

Excel can organize data into groups, allowing you to easily show and hide different parts of a spreadsheet.
- Excel 2019 (Part 19): Filtering Data

Filters can be used to narrow down the data in a spreadsheet, allowing you to view only the information you need.
- Excel 2019 (Part 18): Sorting Data

You can quickly reorganize your spreadsheet by sorting your data.
- Excel 2019 (Part 17): Fixing Rows/Columns and Viewing Options

Excel includes several tools that make it easy to view content from different parts of a workbook simultaneously, including the ability to freeze rows/columns and split the
- Excel 2019 (Part 15): Functions

Excel includes many common functions that can be used to quickly find the sum, average, count, maximum, and minimum values for a range of cells.
- Excel 2019 (Part 14): Relative and Absolute Cell References

There are two types of cell references: relative and absolute. Relative and absolute references behave differently when copied and filled into other cells.
- Excel 2019 (Part 13): Creating Complex Formulas

When there is more than one operation in a formula, the order of the operations tells Excel which calculation should be performed first.
- Excel 2019 (Part 12): Introduction to Formulas

One of the most powerful features in Excel is its ability to perform numerical calculations using formulas. Just like a calculator, Excel can add, subtract, multiply, and divide.
- Excel 2019 (Part 11): Layout and Printing

Once you've selected your page layout settings, it's easy to preview and print your workbook from Excel using the Print panel.
- Excel 2019 (Part 8): Working with Multiple Worksheets

When working with large amounts of data, you can create multiple worksheets to help organize your workbook and make searching for content easier.
- Excel 2019 (Part 7): Understanding Number Formats

The number formats for spreadsheets tell you exactly what type of data you're using, such as percentages (%), currency ($), time, dates, etc.
- Excel 2019 (Part 6): Formatting Cells

The basic formatting allows you to customize the look and feel of your workbook, enabling you to draw attention to specific sections and make the content easier to view and
- Excel 2019 (Part 5): Modifying Columns, Rows, and Cells

Microsoft Excel allows you to modify column widths and row heights in various ways, including applying the Text Wrapping feature and merging cells.
- Excel 2019 (Part 4): Cell Basics

You will need to understand the basics of cells and cell contents to calculate, analyze, and organize data in Microsoft Excel.
- Excel 2019 (Part 3): Saving and Sharing Workbooks

Whenever you create a new workbook in Excel, you'll need to know how to save it so you can access and edit it later.
- Excel 2019 (Part 2): Creating and Opening Workbooks

Excel files are called workbooks. Whenever you start a new project in Microsoft Excel, you will need to create a new workbook.
- Excel 2019 (Part 1): Getting Started with Excel

Microsoft Excel is a spreadsheet program that allows you to store, organize, and analyze information.
- PowerPoint 2016: Sharing Presentations Online

Instead of presenting it as a slideshow, you can choose to present it as a video or even online so others can view it remotely.
- PowerPoint 2016: Getting Started with Microsoft PowerPoint 2016

In this lesson, you will learn how to work within the PowerPoint environment, using tools including the Ribbon, Quick Access Toolbar, and Backstage view.
- How to create stunning 3D pop-out effects in Photoshop

Creating 3D pop-out effects in Adobe Photoshop is an ideal way to draw attention to your work on social media posts or as a creative photography project.