Free Online Tutorials on Spreadsheets

Free Microsoft Excel Training Tutorial

You can use Excel for every type of data to perform financial, mathematical, and statistical calculations. You can learn here Excel basic for beginners, formulas, and techniques, free with easy examples provided by Explainry.

Click here for easy examples of Excel mostly used functions.

Basic
This section is for beginners with no knowledge of Excel.
Status Bar provides a quicker way to see the average, count, numerical count, minimum, maximum or sum of selected cells.
Percentage Formula is used to get the relationship between two numbers in percentage.
Percentage Change Formula in Excel is used to find out percentage difference between two numbers.
The Paste Options appear in Excel when you paste data into cells:
Copy and paste values only help to prevent formatting.
Keep source formatting helps to keep source formatting (like column width even formulas etc. of copied data) in pasted section.
Merge and unmerge cells combine more than one cells to a large one.
Ranges
Fibonacci sequence is a series of numbers in which each number is the sum of two proceeding numbers like 1, 1, 2, 3, 5, 8, etc.
Custom Lists option is used to create or delete your own lists.
Comments are used to add additional information about the cell’s value.
Skip blank option skips blank cells while data paste.
Transpose function helps to rotate a row into a column and vice versa.
Use Flash Fill and Auto Fill to automatically add repetitive information.  
Design & Format Workbook/ Worksheet
You can save a lot of time by performing tasks in different worksheets at the same time by group worksheets feature.
Instead of summarizing different workbooks one by one in a master worksheet, you can use consolidate workbooks to summarize at once.
Correct your spelling by using Spell Check feature.
Hide/ show columns and rows feature is used to hide/ show a column and a row.
Freeze Panes feature is used to keep a row or a column visible while scrolling down to another area of the worksheet.
If you want to view different distant parts of a worksheet at once, you can utilize split command.
Move or copy worksheet command is used to move or copy a sheet to the same workbook or another workbook.
Zoom in and out command in Excel is used to change the view of a spreadsheet.

Selecting cells, ranges, rows or columns.
Round a number to required decimal places, to disappear ###### symbols in cells.
Currency vs Accounting formats.
Date and time formats.
Convert text to numbers.
Convert numbers to text format.  
Data Analysis
Excel provides useful features when it comes to data analysis, click here to learn how these features are useful.
Functions & Formulas
In this section, you will understand the important Excel functions and save your time by performing these functions.
Count Functions: Learn how to count blank cells or count cells based on single or multiple criteria etc.
Date & Time Functions: Excel has useful date & time functions, you can add a date in any cell by using “/” or “-” characters.
Financial Functions: In this chapter, you will learn about investment, interest rate, and, payment functions.
Information Functions: Learn about an error, numerical, and general information related functions.
Web Function: Learn how to convert URL to coded form.
Statistical Functions: For easy understanding of important statistical functions in Excel.
Sum Functions: Learn how to sum based on one or multiple criteria.
Text Functions: Excel offers multiple text functions to manipulate text strings based on your need.
Round Functions: Round a number to the decimal places.
Logical Functions: Understand how to perform logical functions like AND, IF, and OR.
For alphabetical categorization of functions, click here.
 




Copyright © 2016 - 2019 Explainry.com | All Rights Reserved