# Excel Blog by Excel Champs - Free Online Microsoft Excel Tutorials

## Start from here...

- An Introduction to Microsoft Excel | Basics Knowledge + Components + Examples
- Top Excel Tips and Tricks (101) – Basic + Advanced + Free PDF to Make You a PRO this Year
- Excel Functions List - Top 100 Excel Functions with Examples + Sample Files
- The Only 82 Keyboard Shortcuts for Excel YOU Need to Know + (PDF Cheat Sheet)

## 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.