De bloc de notas a Excel 2013.

About this tutorial: Video duration: 2:45 Ya estoy utilizando Windows 10 mil disculpas aun debo ver la forma rápida de ir reconociendo el trabajo en este sistema, el presente vídeo muestra el procedimiento para importar los datos desde el bloc de notas a Microsoft Excel 2013.

Quick Excel Trick to Unstack Data from one Column to Multiple Columns

About this tutorial: Video duration: 5:4 This trick is the easiest (or laziest) method to unstack data from one column to multiple columns. You might come across a case where you need to move data (or transpose data) from one column to multiple columns. If you Google this, you’ll find different ways of doing this […]

Undo Last Command(s) in Excel

About this tutorial: Video duration: 29 You can undo most actions taken in Excel by using the Undo icon, the second command on your Quick Access Toolbar. You can “Undo” multiple times, or click on the drop-down menu next to the “Undo” icon to undo multiple actions. Note that you CANNOT undo deleting an entire […]

Working with Pivot Tables in Excel 2013 – Part 2 – Learn Excel Training Tutorial

Get my free 3 hour Introduction to Excel 2013 course. Get 17 training videos to help you learn MS Excel 2013. Click here to get the free course: https://simonsezit.leadpages.net/free-excel-2013-course/ In this video, discover new features available in Microsoft Excel 2013 to create a and present a pivot table. Get the full course on Excel 2013 […]

Excel VBA Tutorial 19 – Declaring Public And Private Variables

About this tutorial: Video duration: 4:28 Excel VBA Tutorial Series – How to declare a Public/Private Variable and it’s purpose. Incoming search terms:michttps://products office com/en-us/compare-all-microsoft-office-products?tab=1&ocid=PROD_OfficeCom-PWA-0_BuyButton_Unknown_BuyOffice365&rtc=1rosoft com

Searchable Drop Down List in Excel (Very Easy with Dynamic Arrays)

About this tutorial: Video duration: 11: ★ Link to complete Excel Dynamic Arrays Course: This technique uses data validation and (simple) Excel formulas to create a searchable data validation drop-down list. If you have Office 365, you will get these functions soon. Don’t miss out on their potential. We use the Excel SEARCH function, ISNUMBER […]

How to change the Gridlines color in Excel 2013

About this tutorial: Video duration: 1:20 Do you want to customize your Microsoft® Excel worksheet by changing the color of gridlines as per your choice? Follow the steps given in this video to change the Gridlines color in Microsoft® Excel 2013. Content in this video is provided on an “as is” basis with no express […]

Add Custom Text to a Numerical Cell in Microsoft Excel

About this tutorial: Video duration: 44 To add text to a numerically formatted cell, right click on the cell and select “Format Cells”. From the “Number” tab, select “Custom”. Choose a listed format as a base and then add the desired text enclosed in quotes (i.e. “(estimated)”) and click “OK”. www.thinkreliability.com

How to enable Touch or Mouse Mode in Microsoft® Excel 2013

About this tutorial: Video duration: 1:36 If you are working on a touch screen device, the touch mode can create more open space on the Ribbon, making commands easier to tap with fingers. Enable Touch or Mouse Mode in Microsoft® Excel 2013 by following the steps shown in this video. To access expert tech support, […]

Create a Quick Access Toolbar Specific to a File

About this tutorial: Video duration: 50 To create a quick access toolbar specific for a particular file, click the down arrow to the right of the Quick Access toolbar. Select “More commands”. Then click on “Quick Access Toolbar” on the left-hand menu. (In 2007, select “Customize” on the left-hand menu.) From the drop down box […]

XLShare – Excel 2016 Real-time Collaboration, Sharing and Co-Authoring Spreadsheets

About this tutorial: Video duration: 11:14 A detailed tutorial on how to set up real-time collaboration, sharing and co-authoring spreadsheets in Excel 2013, 2016, Office 365 and Excel 2016 for Mac. See for the follow up video which shows you how to share your own spreadsheet. Visit: for more information

How to use DATEDIF in excel 2013 (calculate difference between dates)

About this tutorial: Video duration: 4:31 How to use datedif in excel to calculate the difference between two dates a start and end date. =DATEDIF(start_date, end_date, “unit”) Please remember to always make sure the start date is older than the end date.

Excel Sum(ifs) between dates, sum month & sum with multiple criteria

About this tutorial: Video duration: 8:44 Use the Excel SUMIFS formula to sum values between two dates. Here you’ll need to use the greater than & less than operators inside the SUMIFS formula. You’ll also learn how to sum values within a month. For example, your data set contains dates and you’d like to create […]

4 Ways To Protect Excel Workbooks, Worksheets And Cells

About this tutorial: Video duration: 6:14 $10 ONE TIME OFFER! Get the Full Udemy Course ONLY for $10 !! Click the link: ****************************************************************** In this video tutorial we will learn how to protect an entire workbook , sheets or cells. There are different methods and level of protection. For example: You can protect all the […]

Abrir Calculadora do Windows com Códigos Excel VBA

About this tutorial: Video duration: 5: Abrir Calculadora do Windows com Códigos Excel VBA. Exibe a calculadora normal do computador, chamada através de códigos Excel VBA. Permite utilizar a calculadora em formulários do Microsoft Excel em planilhas personalizadas. Como abrir calculadora utilizando a programação Excel VBA. ——————————————————————————————– Para receber a planilha, inscreva-se no canal e […]

COMO HACER UN DIAGRAMA DE PARETO EN EXCEL 2016

About this tutorial: Video duration: 11:29 Diagrama de Pareto: Facebook: Instagram: COMO HACER UN DIAGRAMA DE PARETO EN EXCEL 2016 Aprende hacer un diagrama de Pareto en Ms Excel 2016 Incoming search terms:como hacer un diagrama de pareto en visiocomo hacer un pareto en excel 2016diagrama de pareto en excel 2016hacer un pareto en excel […]

MS Excel Tutorial – Lesson 84 – PivotCharts

About this tutorial: Video duration: 3:21 In this tutorial, we will be discussing on PivotCharts in MS Excel. #excelbasics #excelformulas, #excelbeginner Learn the basics of using Microsoft Excel, including the anatomy of a spreadsheet, how to enter data, how to make your data look good so it’s easier to read and use, and more. This […]

Como MULTIPLICAR no Excel com Facilidade | Passo a Passo | Excel 2010, 2013 e 2016

About this tutorial: Video duration: 3:35 Nesta vídeoaula vamos aprender como multiplicar no Excel de forma bem simples. É um tutorial voltado para o usuário iniciante que está tendo os primeiros contatos com o Microsoft Excel. – – – – – 👉 INSCREVA-SE NO CANAL ME ENSINA?: // REDES SOCIAIS: → Facebook: → Twitter: → […]

Advanced Excel Filter (And, Or, Between conditions for criteria range)

About this tutorial: Video duration: 7:24 How does Advanced Filter work in Excel? In this quick tutorial I show you many examples that explain: 1. How to setup advanced filter 2. How to use the criteria range in advanced filter 3. How to use wildcards 4. How to setup your criteria to filter for OR […]

How to Enable the Developer Tab in Excel for Windows

About this tutorial: Video duration: 1:54 In this video I explain how to enable the Developer tab in Excel for Windows. The Developer tab in the Excel Ribbon contains buttons for Macros & VBA. This includes buttons to open: – The Visual Basic Editor (Alt+F11) – The Macros Window (Alt+F8) – The Macro Recorder (Alt,L,R) […]