MS Excel Tutorials

Found 72 Tutorials

Most Recent Tutorials

• 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...
  • 35 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/
  • 41 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/
  • 43 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/
  • 35 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/
  • 37 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/
  • 47 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/
  • 90 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...
  • 85 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/
  • 86 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/
  • 62 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/
  • 127 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/
  • 90 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/
  • 66 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/
  • 77 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/
  • 249 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/
  • 104 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-...
  • 133 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/
  • 109 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/
  • 98 Hits
  • Rating
  • Cat:Basic Concepts
  
  

• Using Check boxes in Excel

  The following tutorial will show you how to use Check boxes in Excel. You can use check boxes are ways of displaying text or figures that can be used
  https://www.excelbuddy.com/excel-tutorial-database/using-check-boxes-in-excel/
  • 100 Hits
  • Rating
  • Cat:Basic Concepts
  
  

• Selecting All Formula Cells in a Worksheet

  Sometimes when working in Excel, it can be helpful to quickly identify or select all of the cells in a worksheet which contain formulas.
  https://www.excelbuddy.com/excel-tutorial-database/selecting-formula-cells-worksheet/
  • 107 Hits
  • Rating
  • Cat:Basic Concepts
  
  

• Print to Fit on X Number of Pages

  Sometimes when using Excel you may want to customize the way that you print the information you are working with.
  https://www.excelbuddy.com/excel-tutorial-database/print-to-fit-on-x-number-of-pages/
  • 75 Hits
  • Rating
  • Cat:Basic Concepts