Excel VBA: Referring to Ranges & Writing to Cells (Range, Cells, Offset, Names)

About this tutorial: Video duration: Referencing ranges is a common task in Excel VBA. It’s important to be aware of the different ways you can write to Excel cells with VBA or macros. The macro …

Excel VBA tutorial for beginners: The Visual Basic Editor (VBE)

About this tutorial: Video duration: This tutorial is your introduction to Excel’s Visual Basic Editor (VBE). This is the place macros from the macro recorder are recorded as well as the place you’ll be …

Remove ALL Unwanted Spaces in Excel (TRIM ALL Function?)

About this tutorial: Video duration: 7:49 Stubborn spaces can become a headache in Excel. You’ll come across extra spaces when you copy data from your email or import data from another system. Each cell value ends up having trailing or leading spaces. Sometimes they can be removed easily with the TRIM function but sometimes TRIM […]

Change CASE of text in Excel (3 ways including NO Formulas)

About this tutorial: Video duration: 7:56 Check the Excel Essentials Course: Learn 3 methods to change the case of text in Excel. This way you can quickly switch text to upper case (i.e. all caps), to lower case and to proper case (first letter of every word is in capital letter and the rest are […]

All about Excel Comments (Notes) in 8 Minutes! Shortcut Keys, Customize Background & More

About this tutorial: Video duration: 7:48 Check the Excel Essentials Course: By the end of this video you’ll learn everything about Excel comments / notes: 1. Excel shortcut keys to insert & edit a comment 0:58 2. How to show and hide Excel comments (if you don’t want your comments to disappear) 1:49 3. How […]

Excel Basic@RVM Finishing School,learn excel from scratch

About this tutorial: Video duration: 45:31 Excel Basic Functions Let’ connect on social network: facebook: Instagram : Subscribe to Blog for latest news & Updates on “learning@RVM “: If you like the video please Subscribe to our youtube channel : visit website :

Last Video in 2019

About this tutorial: Video duration: 4:41 This is the last video in 2019! Thank you for your support during the past year. For watching, for your feedback and interaction. I hope you enjoyed our Excel, PowerPoint, Power Query, and Accounting videos. We have a lot more videos coming in 2020. Me and my team wish […]

Your Excel Printing Problems, Solved!

About this tutorial: Video duration: 10:51 Complete Excel Essentials Course: When you share an Excel file with others, you never know who’d like to print it. There might be times, you intentionally format your Excel sheets for printing – for example when creating handouts for your presentation. There might be times you create Excel files […]

Microsoft Excel 2016 introduction Part 1 I Basics I Learn in 10 minutes

About this tutorial: Video duration: 11:22 Learn Microsoft Excel 2016 Basics in 10 minutes Microsoft Excel was first released for macin tosh systems in 1985. Windows version was released in 1987. Microsoft Excel is a powerful spreadsheet program developed by microsoft for windows, macOS, android, iOS. Excel’s main functions are to store , analyze and […]

SURPRISING Advanced Filter TRICK in Excel (You've Never Heard Of!)

About this tutorial: Video duration: 5:59 With Excel’s Advanced Filter feature you can filter for multiple criteria and copy the filtered results to another sheet. But did you know of the trick shown in the video? I didn’t 🙂 In this Excel tutorial we cover a few important topics rather quickly: 1. How to use […]

Эта операция была прервана из за ограничений наложенных на данный компьютер. +Не видно компонентов.

About this tutorial: Video duration: 7:17 В данном видео я поделился решением проблем которые возникли у меня при работе с Excel таблицами, а именно проблемы с гиперссылкам и при отсутствии компонентов в закладке “Включение и отключение компонентов Windows”. Надеюсь кому-то помогло. Подписывайтесь на канал и в Instagram: vlad_kot_ua

Realistic Case: Dependent Drop-Down Lists in Excel with Multiple Words & Spaces in 1st List

About this tutorial: Video duration: 7:54 Download the Workbook here: This video builds on the methods shown in a previous video: which showed how to create an Excel dynamic drop-down data validation list that was dependent on the selection of another drop-down. In that video the first list contained numbers whereas in this video we […]

Excel IF Function with PARTIAL Text Match (IF with Wildcards)

About this tutorial: Video duration: 6:37 Learn how to combine Excel’s IF function with wildcards for a partial text match. For example, you’d like to check IF a cell contains a specific word. If yes, then you’d like a specific result, otherwise you’d like another result. We also take a look at checking the data […]

Do's & Don'ts of Excel Spreadsheet Design (with Examples)

About this tutorial: Video duration: 5:28 Check out the complete Excel Essentials course: In this Excel tutorial I cover the Do’s and Don’ts when it comes to creating your next Excel Dashboard or Report. There are two main aspects when you design an Excel spreadsheet: 1. Excel Workbook Structure 2. Visual Design of Each Excel […]

Excel Solver example and step-by-step explanation

About this tutorial: Video duration: 9:57 Excel’s Solver tool is an optimization package. It finds the optimal solution to a problem by changing multiple variables. Download the workbook here: It can solve for more complex “what-if-analysis” which Goal Seek can’t. Goal seek is restricted to changing one variable, whereas with solver you can have many […]

How to create a dynamic map chart with drop-down (works with ANY Excel version)

About this tutorial: Video duration: 17:34 Create a simple but effective Excel Dynamic Map Chart with drop-down. Also Conditionally formats the largest values on the map for improved readability. Learn how to create a simple but impressive dynamic map chart that enables you to visualize specific KPI’s by geography. This method doesn’t use the relatively […]

5 Excel INTERVIEW Questions You NEED to Get RIGHT

About this tutorial: Video duration: 8:43 Want to ROCK your Next Interview? Check out the complete Excel Essentials course: To get the 40% OFF launch discount (until October 24th) use coupon code: YT_EXCEL You’ll learn dozens of quick hidden tips and tricks to showcase your knowledge. Once you get the job, you’ll have the course […]

Excel Header & Footer (& Quickly Copy to other Sheets)

About this tutorial: Video duration: 8: Check the Excel Essentials Course: Quickly learn how to insert header and footer information to your Excel sheets. This is great if you’d like to optimize your print outs of your Excel sheets or PDF files. In this Excel Basics tutorial we cover different topics such as: 1. How […]