Learn with Video Tutorials

These instructional videos are available for you to watch and learn, and as often as you want. It doesn't come with a paid subscription and you don't have to give us your personal information. My wish is that you may find these resources useful and practical in order for you to overcome your everyday Excel challenges.
You can find more tips and techniques on the 'Blogs' page.

You can also subscribe to my YouTube channel and get all the latest video updates at Excel in 365 with Raphael Chalvarian.


26 Keyboard Shortcuts for Excel Users

Download
26 Keyboard Shortcuts for Excel
Click the download button below to download/print a copy.
Excel Keyboard Shortcuts.pdf
Adobe Acrobat Document 1.5 MB

What can I enter in a cell? Or how many things can I enter in a cell?


Mail Merge in Microsoft Excel

Download
Six Easy Steps to Mail Merge
Click the download button below to download/print a copy.
Mail Merge with Microsoft Word.pdf
Adobe Acrobat Document 515.6 KB

Excel Mouse Pointers

Download
Excel Mouse Pointers
Click the download button below to download/print a copy.
Excel Mouse Pointers.pdf
Adobe Acrobat Document 213.6 KB

Formulas and Functions. What is the difference?


Nested functions. What are they?


POWER QUERY for the novice - an introduction to Excel's Power Query


The VLOOKUP and the HLOOKUP functions


The Status Bar


Cut, Copy & Paste in Excel


STOCKHISTORY function


Same Date Format for Two Different Countries


How to use Sort Orientation in Excel

Download
Microsoft Excel Data Sort
Click the download button below to download/print a copy.
Data Sort.pdf
Adobe Acrobat Document 784.3 KB

The Subtotal Function


5 Ways to Find and Remove Duplicates in Excel


Consolidate Data to Create a PivotTable

Download
Consolidate Data to Create a PivotTable
Click the download button below to download/print a copy.
Consolidate Data for a PivotTable.pdf
Adobe Acrobat Document 588.7 KB