Mellon Training

Welcome to the FREE Excel Course!

Course Resources (Please Download the Files 🔽)

4 Ways To Protect Excel Workbooks, Worksheets And Cells

Applying Document Themes in a Workbook

Inserting, Deleting & Hiding Columns and Rows

Navigate between Workbooks Quickly

How to Create a Hyperlink to Other Worksheets

How to Prevent Someone from Unhiding a Worksheet – Very Hidden Property

Hiding Scrollbars in a Worksheet

How to Create and Save Custom Views of a Worksheet

Copy and paste visible cells only (not hidden cells)

Solving the problem with Leading Zero

How to Add Text to a Number

Creating a Conditional Format based on a value

Blocking a User from Interacting Outside a Specific Range

Changing Values without Formulas

The Paste Special Feature

Using Fill Handle to Enter Sequences of Values

Shrink your Pivot Data: Pivot Table Grouping Tool

Using Pick from Drop-down List and Enter Data Quickly

How to Create a Data Entry Form

Highlighting Blank Cells and Sorting Columns with Them

Combine LEFT and FIND Functions

Meet the new FILTER function

Filling Random Values into every cell in a selection

How to Generate Random Decimal Numbers between 0 and 1

How to use COUNTIF and Data Validation to Prevent Duplications

The AutoSum Magic