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

800+ Excel Resources: The Epic Power Spreadsheets Resources List

By J.A. Gomez

My main purpose at Power Spreadsheets is to help you become an Excel Power User. I work (and will continue to work) very hard to achieve this purpose. However, Excel is a massive topic. Therefore, I'll probably won't be able to cover absolute everything about Excel. I'm also aware that I don't have all the answers. I'm constantly learning new things about Excel. This … [Read more...]

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