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 […]

Excel Combo Box without VBA – How to create a drop-down list

About this tutorial: Video duration: 5:12 Get the full course: Find out how you can insert and use the combo box form control in Excel. This way you can easily insert a drop down box in Excel to add more interactivity to your Excel reports. Your Excel reports will also become more user-friendly. Just make […]

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 […]

Link Page Header to Cell Value with Excel VBA

About this tutorial: Video duration: 8:31 You’ll learn how to link the page header to a specific cell with Excel VBA. The Excel macro is very simple. Best part is it runs automatically every time you print the page or save your Excel workbook or worksheet as PDF. ★★ Links to related videos: ★★ Excel […]

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 […]

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 […]

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 […]

Have You Tried These PowerPoint Presentation Tips?

About this tutorial: Video duration: 5:34 How can you make a great PowerPoint presentation? Make sure you follow these 3 tips to inform, impress and captivate your audience. How much should you fit on a slide? What if you have a lot of information and you can’t fit it on one slide? Do I need […]

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

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 […]

Excel Regression Analysis TREND Function And GROWTH Function For Data Analysis in Excel 2019 ( 365 )

About this tutorial: Video duration: 3:48 Advance Excel Essential Training Series. Learn Excel Regression Analysis With TREND Function And GROWTH Formula For Data Analysis in Excel 2019. Checkout Some Other Cool Excel Tutorials: ✔️Excel TRANSPOSE Function, CTRL + SHIFT + ENTER To Flip Rows and Columns Data, Excel Array Formulas ✔️Excel Frequency Distribution & Table […]

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 […]