Tinytutes - Free Excel Tutorials And More...
Welcome here to access quality and Important Excel tutorials, Word tutorials and Other computer related topics and that is absolutely free. We provide example excel files and templates to download free.
Here you can find excel tutorials on formulas and functions, Programming in Excel using Macros and VBA, Data Analysis, and very useful tips on excel. We even offer you tutorials on interesting applications like our highly popular soccer prediction model based on the Poison distribution.
In addition, we are covering some important topics on word and computer related tips.
Formulas and Functions
Excel function NETWORKDAYS
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.
How to use IF function in excel
Learn in how to use IF function in two minutes!. Video Lesson includes.
PMT function in Excel – 5 Minute Easy Guide
PMT function in excel can be easily used to get total loan payment per period assuming equal payment and constant interest rate.
How to get Excel column letter from match
Easily find and return the column letter of an Excel cell with the COLUMN() function or CELL() function combined with the MATCH() function or a logical expression
Excel obtiene el número de fila de un valor coincidente o según un criterio
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
How to return row number of a matching cell
Easily find and return the row number of an Excel cell with the ROW() function or CELL() function combined with the MATCH() function or a logical expression
Learn how to use VLOOKUP function
VLOOKUP function can be used to lookup and retrieve data from a given column referenced by a value of the first column. Learn More...
Data Analysis
How to use Excel Analysis ToolPak and How to Activate
Get a quick overview on Excel Analysis ToolPak where you can do ANOVA test, descriptive statistics, generating histograms and regression analysis.
Sorting and Filtering Data in Excel
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.
How to create a Pivot Table in Excel?
This guide will be very easy and useful for you to understand the essential steps of how to create a Pivot Table
Importing and Exporting in Excel- beginner's guide for data analysts
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.
What is Pivot Table feature in Excel ?
Learn to use power of Pivot Table feature available in Excel for data analyzing and summarizing.
Single variable data table in excel - Sensitivity Table with examples
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
Regression analysis in Excel- Simply Explained [With Examples]
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.
Two Variable Data Table In Excel – Easy 4 Step Guide
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...
Excel Tips
Tips on how to copy formulas acurately in excel
Learn every method to copy formula in excel either with absolute or relative references, down a column, to another column without changing references etc.
How to install Custom functions and Addins in Excel
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.
Excel Drop Down Menu - Best Practices in creating a drop down menu in Excel
Learn to add a drop down menu to select inputs to a cell from a predefined list by using data validation feature.
Keyboard Shortcuts in Excel
Learn shortcuts that will improve your excel skills and save your time
Most useful Excel Tips
Learn 15 excel tips that will improve your excel skills and save your time
Quickest ways to switch between excel sheets or tabs
Learn various strategies for fast switching between sheets in Excel starting from manual selection, to more complicated options such VBA .
Excel Applications
Health plan comparison with Actuarial Value Calculator (AV Calculator)
Introduction This calculator helps you to compare different health plans and decides what is more beneficial to you
Build your own soccer prediction application
If you are betting on soccer matches, I will guide you to build a simple soccer prediction application for yourself in Microsoft Excel.
Macros and VBA
How to Change Case in Excel
There are functions in Excel for UPPER, LOWER and PROPER Cases. Here you add the capability to change strings to the SENTENCE case also.
Let's learn the correct way to create an Excel Macro
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!.
View code in excel macro and easily modify as you wish
There are three methods to view the the Macro Code in Excel. If you follow any of the method then you can view and edit macro code in Excel
Write excel macros using VBA – A simple Guide
In this tutorial you will learn how to write a excel macro using vba codes.
Computer and Hardware
How Does Ransomware Threaten Your Information?
How to be safe against Ransomware Attacks based on my personal experience!
Insert a USB Plug Super Efficiently!
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!