Free Microsoft Excel and VBA Tutorials for 2018 | Page 2 of 13

Excel XOR Function Tutorial: Step-by-Step Guide and 3 Examples to Use Exclusive Or in Formulas

By J.A. Gomez

In this Excel XOR Tutorial, you learn how to use the XOR function in your worksheet formulas for purposes of returning a logical Exclusive Or of the applicable arguments. The Excel XOR Tutorial is accompanied by an Excel workbook containing the data and formulas I use in the examples below. You can get immediate free access to this example workbook by subscribing to the … [Read more...]

Excel VLOOKUP Function Tutorial: Step-by-Step Guide and 11 Examples to Use VLOOKUP in Formulas

By J.A. Gomez

In this Excel VLOOKUP Tutorial, you learn how to use the VLOOKUP function in your worksheet formulas to: Look for a value in the first column of a table; and Return a value in the same row but from another column you specify. This Excel VLOOKUP Tutorial is accompanied by Excel workbooks containing the data and formulas I use in the examples below. You can get … [Read more...]

Excel VBA Sheets and Worksheets: Step-by-Step Guide and 16 Examples to Refer to Sheets or Worksheets in Macros

By J.A. Gomez

In this VBA Tutorial, you learn how to refer to, and work with, sheets and worksheets in macros. This includes: How to refer to all sheets in a workbook. How to refer to all worksheets in a workbook. How to refer to the active sheet. How to refer to a sheet by its index number. How to refer to a worksheet by its index number. How to refer to a sheet by its … [Read more...]

Excel Power Query (Get & Transform) Tutorial for Beginners: Import, Edit, Load and Consolidate Data with this Step-By-Step Guide

By J.A. Gomez

In this Power Query (Get & Transform) Tutorial for beginners, you learn how to use Power Query (Get & Transform) to automate the process of importing and consolidating data in Excel. The following are the main topics you learn about: What Power Query is and how it can help you. What data sources can Power Query import data from. How to import data from 3 … [Read more...]

Excel VBA InputBox: Step-by-Step Guide and 9 Examples to Create an Input Box with Macros

By J.A. Gomez

In this VBA Tutorial, you learn how to create input boxes with both the InputBox function and the Application.InputBox method. This includes: How to create an InputBox. How to create an InputBox with multiple lines. How to create an InputBox that works with a specific type of data. How to handle the cases where the user clicks the Cancel button of the … [Read more...]