MS Excel Tutorials

Found 75 Tutorials

Most Recent Tutorials

• MAX Function Usage

  The Excel MAX function returns the largest numeric value in a range of values.
  https://www.excelbuddy.com/excel-tutorial-database/max-function/
  • 803 Hits
  • Rating
  • Cat:Functions
  
  

• INDIRECT Function

  The INDIRECT Function converts a text string into a cell reference.
  https://www.excelbuddy.com/excel-tutorial-database/indirect-function/
  • 675 Hits
  • Rating
  • Cat:Functions
  
  

• Rank Function Numeric Value Rank

  The Excel Rank function returns the numeric value when compared to a list of numeric values.
  https://www.excelbuddy.com/excel-tutorial-database/rank-function/
  • 654 Hits
  • Rating
  • Cat:Functions
  
  

• Lookup Use a Letter to Represent a Value in Excel

  This tutorial will show you how to use a letter to represent a specific value.
  https://www.excelbuddy.com/excel-tutorial-database/how-to-use-a-letter-to-represent-a-valu...
  • 805 Hits
  • Rating
  • Cat:Functions
  
  

• VBA Color ColorIndex

  ColorIndex, which has 56 colors, and Color, which has millions of colors and makes it possible to use any color at all.
  https://www.excelbuddy.com/excel-tutorial-database/vba-color-colorindex/
  • 742 Hits
  • Rating
  • Cat:Macros
  
  

• VBA Formatting Cells

  You can use a macro in formatting cells, which involves using the Range Properties discussed earlier on.
  https://www.excelbuddy.com/excel-tutorial-database/vba-formatting-cells/
  • 633 Hits
  • Rating
  • Cat:Macros
  
  

• VBA Selection Method

  Selection is a method in Excel VBA that performs an action. You use the Select method to select a single cell or a range of cells.
  https://www.excelbuddy.com/excel-tutorial-database/vba-selection/
  • 679 Hits
  • Rating
  • Cat:Macros
  
  

• Range Object Formatting Cells

  Majorly, all the programming or task you do in Excel requires you using Cells, or focuses on Cells.
  https://www.excelbuddy.com/excel-tutorial-database/vba-range-object-formatting-cells/
  • 589 Hits
  • Rating
  • Cat:Macros
  
  

• SUMPRODUCT and EXACT Formula

  Learn to use the sumproduct and exact formulas.
  https://www.excelbuddy.com/excel-tutorial-database/sumproduct-exact-formula/
  • 756 Hits
  • Rating
  • Cat:Functions
  
  

• EXACT Function in Excel

  The exact function compares two strings of text.
  https://www.excelbuddy.com/excel-tutorial-database/exact-function-excel/
  • 758 Hits
  • Rating
  • Cat:Functions
  
  

• AVERAGEIFS Arithmetic Mean Multiple Criteria

  In this example, we will be using the AVERAGEIFS function. We will be finding the average of a data set if it meets multiple criteria.
  https://www.excelbuddy.com/excel-tutorial-database/averageifs-arithmetic-mean-multiple-cri...
  • 717 Hits
  • Rating
  • Cat:Functions
  
  

• Index Function Learn how to use in Excel

  The Index Function returns the value of an array given a specific row and column.
  https://www.excelbuddy.com/excel-tutorial-database/index-function/
  • 722 Hits
  • Rating
  • Cat:Functions
  
  

• Index and Match Replace vlookups in Excel

  Before reading this tutorial, please make sure you understand how to use the INDEX and MATCH function.
  https://www.excelbuddy.com/excel-tutorial-database/index-match-replace-vlookups/
  • 694 Hits
  • Rating
  • Cat:Functions
  
  

• Writing Your First Macro

  We will write and run our first simple Macro, just to have a feel of how it looks like.
  https://www.excelbuddy.com/excel-tutorial-database/writing-first-macro/
  • 752 Hits
  • Rating
  • Cat:Macros
  
  

• What is a Macro

  Macro is just the name given to the codes written in VBA. So our codes, henceforth, will be referred to as Macro.
  https://www.excelbuddy.com/excel-tutorial-database/what-is-a-macro/
  • 674 Hits
  • Rating
  • Cat:Macros
  
  

• Getting VBA Installed in Excel

  Setting up VBA does not require any special software installation. The VBA development software is included with each package of the Microsoft Office
  https://www.excelbuddy.com/excel-tutorial-database/getting-vba-installed/
  • 610 Hits
  • Rating
  • Cat:Macros
  
  

• What is a Macro Learn the Basics

  VBA which stands for Visual Basic for Application is a programming language developed to work with Microsoft Office.
  https://www.excelbuddy.com/excel-tutorial-database/what-is-vba/
  • 656 Hits
  • Rating
  • Cat:Macros
  
  

• Pivot Tables Learn how to use in Excel

  Pivot tables are one of the most versatile and powerful tools available in Excel.
  https://www.excelbuddy.com/excel-tutorial-database/pivot-tables-learn-how-to-use-in-excel/
  • 1855 Hits
  • Rating
  • Cat:Basic Concepts
  
  

• Find And Replace

  Learn how to use the find and replace feature in Excel.
  https://www.excelbuddy.com/excel-tutorial-database/find-replace/
  • 944 Hits
  • Rating
  • Cat:Basic Concepts
  
  

• Data Filtering Single and Multiple Filters in Excel

  Data filtering is a fast and easy approach of sorting work with a portion of data so that you are able to display only the rows in your spreadsheet th
  https://www.excelbuddy.com/excel-tutorial-database/data-filtering-single-multiple-filters-...
  • 990 Hits
  • Rating
  • Cat:Basic Concepts
  
  

• Calculate Compound Annual Growth Rate

  Calculating the compound annual growth rate (CAGR) is an essential function regardless of industry. Excel makes this calculation extremely easy.
  https://www.excelbuddy.com/excel-tutorial-database/calculate-compound-annual-growth-rate/
  • 820 Hits
  • Rating
  • Cat:Basic Concepts
  
  

• Calculate Annual Growth Rate

  Calculating the annual growth rate is very easy in Excel. To calculate the annual growth rate, use the following formula.
  https://www.excelbuddy.com/excel-tutorial-database/calculate-annual-growth-rate/
  • 805 Hits
  • Rating
  • Cat:Basic Concepts