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

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

☑️How to Monetize your Knowledge with Microsoft Excel & Virtual Forms

About this tutorial: Video duration: 3:21 Virtual Forms Framwork extend your Microsoft Excel to the next level. It gives you the functionality and the easy of use like the users in Access have. Create your Userforms in Microsoft Excel and VBA in minutes not days. See how you can benefit from learning Microsoft Excel & […]

How to Uninstall Office 2016 on Windows 10?

About this tutorial: Video duration: 3:36 TRY this best uninstall tool@ if U R having issue uninstalling Office 2016 and/or any other unwanted programs on Windows. If you can’t remove the Mac version of Office 2016 yourself, you can try the following app remover Pro@ instead. Extra info: Office 2016 for Windows was produced by […]

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

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

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

#Advanced Filter in ms excel || how to use advanced filter in excel in hindi

About this tutorial: Video duration: 6:23 #AdvancedFilter in ms excel , you can lean how to use advanced filter in excel in hindi. this will save you time and efforts. must watch and share #filter option in #excel. ***************************************************************** Don’t forget to subscribe my channel get more related video notification. SUBSCRIBE – *****************************FOLLOW ON************************* Facebook […]

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 365 – Advanced Dashboard Charts (Tutorial Videos Teaser)

About this tutorial: Video duration: 1:6 To view my tutorial videos for advanced dashboard creation, the link is Channel link for more videos: Incoming search terms:advanced dashboard excel

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