Mellon Training

Course Resources (Please Download the Files 🔽)

Customizing the Quick Access Toolbar

Undo, Redo and Repeat

Customizing the Ribbon

Using Keyboard to Access Ribbon

Inserting, Deleting & Hiding Columns and Rows

❓QUIZ 1: Excel Interface Hacks

Applying Document Themes in a Workbook

Saving Excel as a Read-only Webpage File

Navigate between Workbooks Quickly

Zooming In and Out Quickly

❓QUIZ 2: Excel Workbooks Hacks

Print a 2-page Worksheet on 1 page

Copying and Moving Worksheets in Various Ways

Entering Data to Multiple Worksheets at a Time

How to Set the Number of Worksheets

Learning Different Techniques for Navigating within a Given Worksheet

How to Create and Save Custom Views of a Worksheet

Hiding Scrollbars in a Worksheet

Create a Hyperlink to Other Worksheets

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

❓QUIZ 3: Excel Worksheets Hacks

Format Painter Tips

Input Messages

Format Numbers using Keystroke Shortcuts

Modify or Create a Cell Style

Add Text to a Number

Enter a Line Break into One of Your Cell’s Data

Creating a Conditional Format based on a value

Using Wrap Text and Shrink Cell Tools to Have the Size of the Cells

Solving the problem with Leading Zero

Blocking a User from Interacting Outside a Specific Range

How to Hide the Status Bar

Changing Values without Formulas

How to Highlight Formula Cells using Conditional Formatting

How to Color Rows using Conditional Formatting - Alternate Row Shading

Duplicate Records and How to Get Rid of These

Creating Bulleted List

How to insert a Watermark

Making Your Comments Stand Out

Creating a Custom List

❓QUIZ 4: Excel Formatting Hacks

(NEW 2024) 6 ways to save time using Flash Fill

(NEW 2024) How to Add a Condition to a Drop-Down List

How to Display a Print Preview using Keyboard Shortcuts

Set a Specific Print Area

Shrink your Pivot Data: Pivot Table Grouping Tool

The Paste Special Feature

Using Fill Handle to Enter Sequences of Values

How to Use FlashFill to Fill Values in a Range Rapidly

How to Select Data using Various Keystroke Shortcuts

Entering Data Quickly and Efficiently

Copying and Moving Data with Various Ways

Using Pick from Drop-down List and Enter Data Quickly

Using AutoCorrect to Enter Data Fast

How to Freeze Titles and Split Screens

How to Create a Data Entry Form

Filling non-adjacent Cells with the Current Entry

Highlighting Blank Cells and Sorting Columns with Them