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

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

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...]

Excel VBA MsgBox: Step-by-Step Guide and 19 Examples to Create a Message Box with Macros

By J. A. Gomez

In this VBA Tutorial, you learn how to create message boxes and specify their most important characteristics, such as the following: How to specify the message displayed in the message box. How to customize or specify the buttons displayed by the message box. How to work with the value returned by the MsgBox function, and assign this value to a variable. How to … [Read more...]