Excel Examples Excel Examples
Basics
Rows Columns Formulas Worksheets Ribbon Workbook Templates Format Cells Shortcuts Print Share Protect Find Flowcharts Formula Errors Round Range AutoFill Union and Intersect Skip Blanks Comments Lists Calculator Invoice
Functions
Text Array Formulas Count and Sum Lookup & Reference Date & Time Statistical Logical Cell References Financial Formula Errors Round Characters Count
VBA
Loop Userform String Manipulation Range Object Events Function Date and Time Macro Errors If Then Statement Array Worksheet Workbook ActiveX Controls MsgBox Variables Create a Macro Function and Sub Application Object
Data Analysis
Pivot Tables Analysis ToolPak Charts Filter What-If Analysis Sort Solver Conditional Formatting Tables
About

How to use Vlookup function in Excel

2020-11-6
Functions Lookup & Reference
The VLOOKUP function is one of the most popular functions in Excel.

How to Use WEEKDAY Function in Excel

2020-11-6
Functions Date & Time
Learn how to get the day of the week of a date in Excel and how to get the number of weekdays or workdays days between two dates.

How to use Weighted Average in Excel

2020-11-6
Functions Statistical
To calculate a weighted average in Excel, simply use the SUMPRODUCT and the SUM function.

How to use RANK Function In Excel

2020-11-4
Functions Statistical
The RANK function in Excel returns the rank of a number in a list of numbers.

How to count the number of words In Excel

2020-11-4
Functions
This example describes how to count the number of words in a cell.

How to Create a Roll the Dice In Excel

2020-11-4
Functions Logical
This example teaches you how to simulate the roll of two dice in Excel.

How to Generate Random Numbers In Excel

2020-11-4
Functions Statistical
Excel has two useful functions when it comes to generating random numbers.

How to Split a String In Excel

2020-11-4
Functions Text
This example teaches you how to separate strings in Excel.

How to use Calculate Quarter in Excel

2020-11-4
Functions Date & Time
An easy formula that returns the quarter for a given date.

How to use Offset function In Excel

2020-11-4
Functions Lookup & Reference
The OFFSET function in Excel returns a cell or range of cells that is a specified number of rows and columns from a cell or range of cells.

How to use Or function in Excel

2020-11-4
Functions Logical
The OR function in Excel returns TRUE if any of the conditions are true and returns FALSE if all conditions are false.

How to use Percent Change Formula In Excel

2020-11-4
Functions Cell References
The percent change formula is used very often in Excel.

How to use Percentiles and Quartiles In Excel

2020-11-4
Functions Statistical
This example teaches you how to use the PERCENTILE and QUARTILE function in Excel.

How to use PMT function In Excel

2020-11-4
Functions Financial
The PMT function in Excel calculates the payment for a loan based on constant payments and a constant interest rate.

How to use Search function In Excel

2020-11-4
Functions Text
Use the SEARCH function in Excel to find the position of a substring in a string.
  1. Previous Page
  2. 1
  3. 2
  4. 3
  5. 4
  6. ...
  7. 26
  8. Next Page

Recent

  • How to use no SUBSTRING function in Excel
  • How to use Substitute vs Replace in Excel
  • How to use Sum Every nth Row in Excel
  • How to use Sum Largest Numbers in Excel
  • How to use Sum Range with Errors in Excel
  • How to use Sum with Or Criteria in Excel
  • How to use Switch function in Excel
  • How to use System of Linear Equations in Excel
  • How to use Tax Rates in Excel
  • How to use Text Function in Excel

Categories

  • How To (349)
  • Tips (20)
  • Tutorial (358)
Jquery Plugins Free  |  Books Awesome  |  Windows Awesome  |  Wordpress Themes   |  Boat Cup Holders
© 2021 Excel Examples