Excel Blog by Excel Champs - Free Online Microsoft Excel Tutorials
Start from here...
- Excel Basics: A complete guide to understanding all the basics of Excel if you are just starting.
- Excel Tips and Tricks: It’s a complete list of 100 tips and tricks which you can learn and use to advance your Excel skills.
- Excel Functions List: A list of 100 Excel functions with examples and sample files to help you to master each one easily.
- Excel Keyboard Shortcuts: 82 most important keyboard shortcuts that you can learn and use easily.
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.
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.
- Random Letters Generator in Excel: This formula can help you to generate random letters in Excel.
- Extract Day from Date in Excel: A date in Excel is made of day, month, and year, and with this formula, you can get the day from it.
- Extract the Last Word from a Cell: With this formula, you can extract the last as well as the first word from a cell.
- IFERROR with VLOOKUP: By combining IFERROR with VLOOKUP you can error-proof your lookup formula.
- INDEX MATCH: A detailed guide on how to use the combo of INDEX and MATCH to lookup values.
- Add Leading Zeros in Excel: If you want to add zeros before a number then this blog post has some formulas for that.
- Excel MAX IF: With this formula, you can find the maximum value from multiple values using a condition.
- Get Month from Date in Excel: A date in Excel is made of day, month, and year, and with this formula, you can get the month from it.
- Fiscal Quarter Formula in Excel: This covers different formulas that you can use to get a quarter from a date.
- Calculate Ratio: Here you have four different ways (using different formulas) to calculate the ratio in Excel.
- How to Remove Extra Spaces in Excel: With these methods, you can remove unwanted spaces from a cell.
- Remove First Character: It’s a combination of different functions to remove the first character from the value you have in a cell.
- Sentence Case: This formula helps you to convert a normal text into a sentence case where you have the first letter as capital.
- Square Root in Excel: This blog post shows you 5 ways to calculate square root in Excel + to add a square root symbol.
- Star Rating Template in Excel: With the help of REPT function, you can create a star rating template in Excel.
- SUMIFS OR: With this formula, you can sum values using two or more conditional criteria.
- SUMIFS Wildcard: With SUMIFS you can also use wildcard characters to performing a partial match sum.
- SUMIF Between Two Dates: With SUMIFS you can sum values where you have a range of dates (start and end date).
- Convert Text to Date: To convert inconsistent dates into proper dates as per Excel, this tutorial includes different ways for you.
- Two Way Lookup in Excel: With a two-way lookup you can look up for a value in a table.
- VLOOKUP MATCH: With the combination of VLOOKUP and MATCH you create a dynamic lookup formula in Excel.
- Weighted Average using SUMPRODUCT: The best way to calculate the weighted average in Excel is to use the SUMPRODUCT function.
- VLOOKUP Wildcard: With VLOOKUP, you can also use wildcard characters to look up for a partial match.
Pivot Table Tutorials
- Rank in a Pivot Table: A step by step method to add a column in a pivot table with ranks.
- Conditional Formatting in a Pivot Table: This blog post covers the different ways to apply conditional formatting to a pivot table.
- Update Pivot Table Range Automatically: Here’s a simple technique to update the pivot table range automatically.
- Pivot Table Calculated Field: You can also add a calculated column (with formula) in a pivot table.
- Create a Pivot Table from Multiple Worksheets: This blog covers simple ways to get source data for a pivot table from multiple sheets.
- Grouping Dates in Pivot Table: To analyze data in a better way you can group dates as months, years, or quarters in a pivot table.
- Linking Multiple Pivot Tables to One Slicer: By connecting a single slicer with all the pivot tables you can filter all of them at once.
- Create Pivot from Multiple Files: If your source data for the pivot table from different files then you can use this method.
- Add a Date Timeline to the Current Pivot Table: A timeline is a special type of filter to filter dates.
- Advanced Pivot Tables: It’s a complete list of 100 pivot table tips and tricks to make a data pivot table PRO.
- Refresh All Pivot Tables: If you have multiple pivot tables in your workbook, you can use these methods to update them at once.
- Excel Running total in Pivot Table: This blog post covers different ways to add a running total column in a pivot table.
Advanced Excel Tutorials
- Excel AutoFormat: Excel AUTOFORMAT helps you to apply quick formatting your data.
- Barcode Font for Excel: This blog post shows you how to install a barcode font in Excel and how to use it.
- Excel Camera Tool: The Excel camera tool helps you to capture screenshots (live) of the worksheet and paste it back to it.
- Checkboxes in Excel: This blog post shows you how to add a checkbox in Excel and how to use it in different ways.
- Consolidate Data From Multiple Worksheets in a Single Worksheet: There’s an option in Excel to merge data from multiple worksheets.
- Excel Data Entry Form: There’s an in-built data entry form in Excel which you can use.
- Data Validation with Date: This blog shows you create a drop-down list with a date range.
- Dependent Drop Down List: In Excel, you can create a dependent drop-down list which shows value based on another drop-down.
- Dynamic Drop Down List: With a dynamic drop-down list, you don’t need to update it’s range again and again.
- Power Pivot in Excel 2010: Simple steps to activate Power Pivot Add-in in Excel 2010.
- Find and Replace Option in Excel: This blog post covers some advanced ways to use find and replace option in Excel.
- Conditional Formatting with IF Statement: Apply conditional formatting to a cell using the IF.
- Goal Seek: With goal seek you find an input value using the desired result.
- Hide Formulas in Excel: A useful Excel trick to hide formulas from the formula Bar.
- Highlight Date Range: This blog post shows you to use CF to highlight all the dates using a start and end date.
- Excel Highlight Top 10 Values: A simple conditional formatting tip to highlight top/bottom 10 Values.
- R1C1 in Excel: You can switch to the R1C1 reference style from the default A1 using these simple steps.
- Recover Unsaved Excel File: If somehow your Excel application has crashed, you can still recover the unsaved files.
- Excel Horizontal Sort: There’s an option in Excel where you can sort columns instead of rows.
- Excel Watch Window: With the watch window, you can track important cells in one single place.
- Excel Wildcards Characters: You can use wildcards in Excel (Formulas, Find and Replace, Conditional Formatting, and Filters).
- Fix Corrupt Excel Files: This post covers a simple way to recover corrupt Excel files and data from them.
- Excel for Accountants: This guide covers 20 different options that can help an accountant to get better in accounting with Excel.
- Excel Skills (Basic + Intermediate + Advanced): It's a complete list of all those Excel skills that you need to master this year.
Charting Tutorials
- Add Horizontal Line to Excel Chart: This blog post shows you a step by step way to add a horizontal line to a chart.
- Add Vertical Line to Excel Chart: With this blog post, you can learn to add a vertical line in an Excel chart.
- How to Add Secondary Axis in Excel: This blog post shows simple steps to create a chart with a secondary axis.
- Advanced Excel Charts and Graphs Templates: It’s a complete list of top 10 advanced Excel Charts with sample files.
- Excel Bullet Chart: You can use a bullet chart to present a KPI in Excel against a range of targets.
- Copy Chart Format in Excel: It’s an amazing but simple trick to copy chart formatting to another chart.
- Dynamic Chart Range in Excel: With a dynamic chart range you don’t need to update the chart range again and again.
- Excel Chart Title Formula: This blog post covers different ways to create a dynamic chart title using formula.
- Interactive Charts in Excel: It’s a simple guide to create an interactive chart which you can control with the option buttons.
- Creating a Sales Funnel Chart in Excel: A simple sales funnel chart for you to present sales funnel in Excel.
- Heatmap in Excel: A step by step guide to creating a heatmap in Excel using conditional formatting.
- Excel Histogram: It’s a complete guide to create HISTOGRAM in Excel using different ways and in different versions.
- How to Make a Pictograph: There’s an option in Excel which you can use to add an image in a chart.
- Bar Chart with Rept Function: A cool way to create an in-cell bar chart using Excel’s REPT function.
- Milestone Chart: If you are a project manager then you can use a milestone chart to track your projects.
- People Graph: It’s an add-on that you can install in your Excel application to create a cool infographic.
- Pivot Chart: A pivot chart is a chart made from the pivot table which is a dynamic chart.
- Pyramid Chart in Excel: You can use a pyramid chart to present two distribution of various groups side by side.
- Excel Speedometer: This guide can help you to create a gauge aks speedometer chart in Excel.
- Excel Step Chart: Step chart is an extended version of a line chart that can help you analyze trends with better accuracy.
- Thermometer Chart: With the thermometer chart, you can present a single point target vs. its achievement.
- Tornado Chart: The best use of the tornado chart is for performing sensitivity analysis in Excel.
- Excel Waffle Chart: Waffle chat is also called a square pie chart which you can create using conditional formatting.
VBA Tutorials
- VBA Tutorial: This is a complete (Chapter by Chapter) guide for every beginner who wants to learn VBA.
- VBA Functions List: It’s a list of top 100 VBA functions explained in detail with syntax and with example codes.
- Excel User Defined Function: With the help of VBA, you can write a function procedure to create a custom function in Excel.
- VBA IF Statement: With VBA IF, you can write conditional code to test a condition and return a value based on the result.
- VBA MSGBOX: It’s is a simple pop up to deliver a message to the user and to get a simple response with a button.
- Personal Macro Workbook: With personal.xlsb file, you can store all the VBA codes in one place.
- Developer Tab in Excel (Mac + Windows): This blog post shows you how to activate the Developer tab on the Excel ribbon.
- Excel ON-OFF Switch: An amazing trick to create an ON-OFF button in Excel (using a VBA Code).
- Extract Hyperlink in Excel: A simple user defined function to get the link used in a hyperlink.
- Macros to Highlight Duplicate Text: Four different VBA codes to highlight duplicate values in Excel.
- VBA Excel Examples: It’s a super amazing collection of top 100 Macro Examples with a PDF file to download.
- Use VBA to Open Chrome from Excel: A super useful code to open Google Chrome from Excel to search for something.
- VBA to Create Pivot Table: A step by step guide write a macro to create a pivot table in Excel.
- How to Activate Worksheet in VBA: You can use Worksheet.Activate method in a VBA code to activate a worksheet.
- VBA Comment: While writing a VBA code, it’s important to use comments to describe what that code actually does.
- VBA to Create a New Sheet: This post covers the SHEETS.ADD method to create a new sheet in the workbook (different ways).
Power Query Tutorials
- Power Query Tutorial: With Power Query, you can get data from multiple sources and then transform it.
- Merge Excel Files: Power Query is the best way to combine data from multiple workbooks into one.
- Power Query Unpivot: In the power query, there’s an inbuilt option to unpivot data with a single click.
- VLOOKUP in Power Query: Just like the worksheet, you can perform a VLOOKUP in power query as well.
Free Excel Templates
- Excel Inventory Template with Formulas: This template is fully loaded with all the features which you need to track your stock.
- Daily Sales Tracker: It’s a quick template to which you can use to track and analyze your daily sales.
- Daily Sales Tracker: It’s a quick template to which you can use to track and analyze your daily sales.
- Excel Expense Tracker: It’s a ready-to-use template for you to track your monthly expenses and get some insights about it.