Tinytutes - Free Excel Tutorials And More...

PMT function in excel can be easily used to get total loan payment per period assuming equal payment and constant interest rate.

VLOOKUP function can be used to lookup and retrieve data from a given column referenced by a value of the first column. Learn More...

Encuentre y devuelva fácilmente el número de fila de una celda de Excel con la función ROW() o la función CELL() combinada con la función MATCH() o una expresión lógica

You can use the NETWORKDAYS function to calculate the number of days between the start and end dates of a project, or to determine how many days are left in a certain time period.

Learn in how to use IF function in two minutes!. Video Lesson includes.

Return the column letter of a matching cell with MATCH, INDEX, COLUMN and ADDRESS. Copy the ready-made formula, or build one for your own range with the free formula builder.

Get the row number of a matching cell in Excel with ROW, INDEX and MATCH. Copy the formula, or build one for your own range with the free formula builder.

This guide will be very easy and useful for you to understand the essential steps of how to create a Pivot Table

Learn to use power of Pivot Table feature available in Excel for data analyzing and summarizing.

Excel two variable Data Tables are used to evaluate the results of a calculation formula for different combination of values for two variables. Learn More...

Simple step by step tutorial on how to do a regression analysis in Microsoft Excel and how to interpret the regression output with basic overview on regression theory.

Explore the basics of importing and exporting data in Excel, including file formats, importing data from external sources, exporting data to external sources, and best practices for data import/export.

Excel data tables can be used to get a set of outcomes for selected formulas for different values. Follow this guide and become master of data tables

Sorting can be done in ascending or descending order based on a single column or multiple columns. Filtering allows users to view specific data based on criteria, such as dates, text, or numerical values. Excel also provides advanced filtering options, such as filtering by color or by using complex criteria.

Turn on the Analysis ToolPak in Excel for Windows, Mac or the web in four clicks, then find the right tool for your job among all 19, with the worksheet function that does the same thing.

Learn shortcuts that will improve your excel skills and save your time

Learn every method to copy formula in excel either with absolute or relative references, down a column, to another column without changing references etc.

Make your own Excel Add-in! Read and learn how user-defined custom functions in excel or macros make available to each workbook you open.

Learn to add a drop down menu to select inputs to a cell from a predefined list by using data validation feature.

Learn 15 excel tips that will improve your excel skills and save your time

Learn various strategies for fast switching between sheets in Excel starting from manual selection, to more complicated options such VBA .

Find out if a CSV file is UTF-8, UTF-8 with BOM, UTF-16 or Windows-1252 in seconds, then open it in Excel without garbled characters. Free checker that runs in your browser.

Introduction This calculator helps you to compare different health plans and decides what is more beneficial to you

Calculate pipe head loss with the Hazen-Williams formula in Excel: copy-paste SI and NFPA formulas, solve for flow or diameter, and download the free calculator.

Predict soccer scores in Excel with the Poisson distribution. Try the free online calculator, download the template, and follow the step-by-step build with POISSON.DIST.

In this tutorial you will learn how to write a excel macro using vba codes.

There are functions in Excel for UPPER, LOWER and PROPER Cases. Here you add the capability to change strings to the SENTENCE case also.

The easiest method to create a macro in excel is to use the “Record Macro” feature. Alternatively, we can write macros with VBA codes Let's learn everything!.

Press Alt+F11 to see macro code in Excel, or Alt+F8, pick the macro and click Edit. Steps for Windows, Mac and Excel for the web, plus how to clean up and change a recorded macro.

How to be safe against Ransomware Attacks based on my personal experience!

Can you insert a USB plug into USB port at once every time? If you can't same as me, then this tutorial is just for US!