How to Sort Data in Excel 2019
Sort complete Excel records safely by text, numbers, dates, custom lists, or multiple columns without separating related cells or including headers.
Program
Page 143 of Latest Articles
Program
How to Freeze Rows and Columns in Excel 2019
Keep headers visible with Freeze Panes, freeze rows and columns together, compare workbook views in new windows, and split one worksheet into scrollable panes.
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
Relative vs. Absolute Cell References in Excel
Learn how relative, absolute, and mixed cell references behave when formulas are copied, with step-by-step examples for worksheets and cross-sheet references.
Program
How to Create Complex Formulas in Excel
Understand Excel's order of operations and build multi-step formulas correctly with clear examples using parentheses, cell references, and arithmetic operators.
Program
Introduction to Excel Formulas: A Beginner's Guide
Learn how to create, copy, and edit Excel formulas using operators and cell references, with practical examples and tips for checking results.
Program
How to Print an Excel Workbook: Layout and Scaling
Prepare an Excel worksheet for printing by choosing the print range, orientation, margins, scaling, repeated headings, and page breaks before you print.
Program
How to Manage Multiple Worksheets in Excel
Organize an Excel workbook by adding, copying, renaming, moving, coloring, grouping, and navigating worksheets without losing track of your data.
Program
Excel Number Formats: Dates, Percentages, Currency, and Text
Learn how Excel number formats affect the display of dates, percentages, currency, decimals, and identifiers while preserving the underlying cell value.
Program
How to Format Cells in Excel
Format Excel cells with readable fonts, colors, borders, alignment, cell styles, and Format Painter while keeping the worksheet clear and consistent.
Program
How to Resize, Insert, Move, Hide, and Merge Cells in Excel
Manage Excel rows, columns, and cells with AutoFit, insert and delete controls, hiding, text wrapping, merging, and the safer Center Across Selection option.
Program
Excel Cell Basics: Select, Enter, Copy, Move, and Fill Data
Learn the essentials of Excel cells and ranges, including addresses, data entry, clearing, deleting, copying, moving, paste options, and the fill handle.
Program
How to Save, Export, Recover, and Share an Excel Workbook
Save Excel workbooks safely, create copies with Save As, recover unsaved changes, export PDF or CSV files, and share cloud-based workbooks with permissions.
Program
How to Create, Open, and Convert Excel Workbooks
Create a blank Excel workbook, open or pin an existing file, start from a template, and convert older files while checking compatibility.
Program
Getting Started with Excel: Interface, Ribbon, and Views
Learn the main parts of the Excel window, including the Ribbon, formula bar, Name Box, worksheet tabs, Quick Access Toolbar, views, and Backstage options.
Program
PowerPoint 2016: Export a Presentation as Video or Share It Online
Export a PowerPoint presentation as a video with narration and timings, then choose a current sharing method for live or on-demand viewing.
Program
PowerPoint 2016 Basics: Interface, Ribbon, Views, and Tools
Get familiar with the PowerPoint 2016 interface, including the Ribbon, Quick Access Toolbar, alignment guides, slide views, zoom controls, and Backstage view.
Program
How to Create a 3D Pop-Out Photo Effect in Photoshop
Create a Photoshop pop-out effect by combining a frame and subject image with selections, clipping masks, layer masks, careful scaling, and a subtle shadow.
Program
How to Add a Border and Drop Shadow to a Photo in Photoshop
Create an adjustable photo border in Photoshop with Canvas Size and a Solid Color layer, then add and customize a nondestructive Drop Shadow layer style.
Program
How to Turn a Photo into a Pencil Sketch in Photoshop
Create an editable pencil-sketch effect in Photoshop with Color Dodge, Gaussian Blur, Levels, and optional original-color, solid-color, or gradient treatments.