Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • Conditional Formatting Rules in Excel
  • How To Sort One Column or Multiple Columns in Excel
  • How to count table rows in Excel
  • How to create a Histogram in Excel
  • How to Create Column Chart in Excel

References

  • Lookup entire row in Excel
  • Extract data with helper column in Excel
  • Perform case-sensitive Lookup in Excel
  • How to use Excel INDIRECT Function
  • Get nth match with INDEX / MATCH in Excel

Data Validations

  • Excel Data validation exists in list
  • Excel Data validation allow weekday only
  • Excel Data validation date in next 30 days
  • Excel Data validation specific characters only
  • Prevent invalid data entering in specific cells

Category: Excel VBA

Excel VBA  (Visual Basic for Applications)  is an event driven, object oriented programming language. It is widely used for developing automated programs in excel worksheet.

List sheet names with formula in Excel

by

To list worksheets in an Excel workbook, you can use a 2-step approach: (1) define a named range called “sheetnames” with an old macro command and (2) use an INDEX formula to retrieve sheet names using the named range. Formula =GET.WORKBOOK(1)&T(NOW()) Note: because this formula relies on a macro command, you’ll need to save as a macro-enabled workbook …

Continue Reading

Understanding VBA Function and Sub in Excel

by

Excel Visual Basic: A set of commands to perform a specific task is placed into a procedure, which can be a Function procedure or a Sub procedure (also known as functions and subroutines). The difference between a function and a sub in Excel VBA is that a function can return a value while a sub cannot. …

Continue Reading

Password Protect Macro in Excel

by

Just like you can password protect workbooks and worksheets, you can password protect a macro in Excel from being viewed (and executed). Place a command button on your worksheet and add the following code lines: 1. First, create a simple macro that you want to protect. Range(“A1”).Value = “This is secret code” 2. Next, click Tools, VBAProject Properties. 3. On the …

Continue Reading

Sales Calculator in Excel

by

Below we will look at a program in Excel VBA that calculates the total sales of each employee over a period of three years. Situation: The other two sheets have the same setup, but with different combinations of months and employees, and different sales numbers. There are several ways to calculate the total sales of each employee in Excel, …

Continue Reading

Loop through Books and Sheets Excel

by

Below we will look at a program in Excel VBA that loops through all open workbooks and worksheets, and displays all the names. Situation: Add the following code lines to the command button: 1. First, we declare two objects and one variable. One object of type Workbook we call book, one object of type Worksheet we call sheet, …

Continue Reading

Close and Open Excel Workbooks Through VBA

by

The Close and Open Method in Excel VBA can be used to close and open workbooks. Remember, the Workbooks collection contains all the Workbook objects that are currently open. Place a command button on your worksheet and add the following code lines: 1. The code line below closes close-open-workbooks.xls. Workbooks(“close-open-workbooks.xls”).Close 2. The code line below closes the first opened/created workbook. Workbooks(1).Clos 3. The …

Continue Reading

Path and FullName property in Excel VBA

by

The Path property in Excel VBA returns the complete, saved path to the workbook (Excel file). The FullName property in Excel VBA returns the complete, saved path, including the name of the workbook. Download path-fullname.xls and add it to “C:\test\” Place a command button on your worksheet and add the following code lines: 1. The following code line returns the complete path to …

Continue Reading

Create One-dimensional and Two-dimensional Array

by

This tutorials show how to create One-dimensional and Two-dimensional Array using Excel VBA. An array is a group of variables. In Excel VBA, you can refer to a specific variable (element) of an array by using the array name and the index number. One-dimensional Array To create a one-dimensional array, execute the following steps. Place a …

Continue Reading

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others

Logical Functions

  • Invoice status with nested if in Excel
  • IFERROR function: Description, Usage, Syntax, Examples and Explanation
  • OR function: Description, Usage, Syntax, Examples and Explanation
  • IFNA function: Description, Usage, Syntax, Examples and Explanation
  • XOR function: Description, Usage, Syntax, Examples and Explanation

Date Time

  • How to get workdays between dates in Excel
  • Get month name from date in Excel
  • Get day name from date in Excel
  • Calculate total hours that fall between two times in Excel
  • Add months to date in Excel

Grouping

  • How to randomly assign people to groups in Excel
  • Map text to numbers in Excel
  • Group numbers at uneven intervals in Excel
  • Group times into unequal buckets in Excel
  • Group times into 3 hour buckets in Excel

General

  • Excel Autofill Cell Ranges, Copy, Paste
  • Cell References: Relative, Absolute and Mixed Referencing Examples
  • AutoFit Column Width, AutoFit Row Height in Excel
  • Index and match on multiple columns in Excel
  • How to Delete Cells, Row and Rows in Excel
© 2025 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning