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.
Program
Page 136 of Latest Articles
Program
Excel 2019 (Part 18): Sorting Data
You can quickly reorganize your spreadsheet by sorting your data.
Program
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 worksheet.
Program
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.
Program
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.
Program
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.
Program
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.
Program
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.
Program
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.
Program
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.
Program
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 understand.
Program
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.
Program
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.
Program
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.
Program
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.
Program
Excel 2019 (Part 1): Getting Started with Excel
Microsoft Excel is a spreadsheet program that allows you to store, organize, and analyze information.
Program
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.
Program
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.
Program
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.
Program
How to create a shadow border in Photoshop
This tutorial will show you how to add empty space on the canvas and add shadows to an image in Photoshop to create a simple yet stylish image border.