Excel Blog by Excel Champs - Free Online Microsoft Excel Tutorials

Join Us on YOUTUBE

Start from here...

Basic Tutorials

Automatically Add Number Column in Excel: This tutorial includes 14 ways to insert a serial number column in Excel.
Bullet Points in Excel: There’s no default option to add bullet points in a cell but this tutorial shows you 8 different ways.
Convert a Negative Number to Positive: It covers 7 methods to deal with negative numbers in an Excel spreadsheet.
Check Mark in Excel: In this tutorial, you can learn different ways to add a check-mark symbol in a cell.
Concatenate Range in Excel: This tutorial shows you different ways to combine values from a range of cells.
Convert Formula to Value in Excel: If you want to convert formulas to values you can use one of these methods explained here.
Degree Symbol in Excel: If you are work with data where you have temperature values then do need to use degree symbol.
Delta Symbol in Excel: A delta symbol can be used to represent the difference between two values.
Paste Special Multiply: There’s an option in paste special that you can use to perform simple calculations, quickly.
Excel Fill Justify: With fill justify, you can merge values from multiple cells into a single cell with a single click.
Format Painter in Excel: You can use it to copy and paste formatting from one cell or range to another.
Highlight Blank Cells in Excel: This tutorial includes 3 different ways to highlight blank cells from a range.
Select Non-Adjacent Cells in Excel: This tip is a smart way to select non-contiguous cells.
Strikethrough in Excel: You can use strikethrough in different ways and this blog post explains 5 unique ways to apply it.
Timestamp in Excel: A timestamp is a combination of the current date and the current time which you can use in different ways.
What is a Function in Excel: A quick short guide to understanding what is an Excel function and its types.
Excel Quick Access Toolbar: It’s a bar on which you can add a button for all the options that you use frequently to access them easily.
Excel Formula Bar: It's a thin bar below the ribbon that you can help you control your cell's content.

Formula Tutorials

Average Highest Values in Excel: This formula is a combination of average function and large function.
Calculate Time Difference in Excel: This blog post covers different ways to calculate the time difference between two-time values.
IF AND: A combo formula to evaluate more than one condition using the AND logic.
IF OR: A combo formula to evaluate more than one condition using the OR logic.
Excel Daily Compound Interest Calculator: It’s a simple formula based calculator for calculating compound interest.
Concatenate with Line Break in Excel: By using this simple formula trick you can combine values with a line break from a range.
Excel RANK IF: It’s a conditional ranking formula that helps you to rank values using specific criteria.
SUMPRODUCT IF: This is a conditional SUMPRODUCT formula where you can multiply and them SUM values with a condition.
Count Cells with Text: Here you have six different methods to count cells with text that can be used in different situations.
COUNTIF OR: With this formula, you can count values using two or more conditions using OR logic.
Count Unique Values in Excel: These are the six different ways to count unique values from a list of values in Excel.
Count Words in Excel: There’s no option in Excel to count words, but with these methods, you can count words in different ways.
Total Days in a Month: With this simple formula you can calculate the total number of days in a month from a date.
Get End of Month Date in Excel: This blog post covers different ways to find the end of the month date dynamically.
Excel 3D Range: With 3D reference, you can refer to the same range from the multiple worksheets in a formula.