Topic
Excel Tutorial
Everything we have published on Excel Tutorial — 31 articles.
Start here
Excel Tutorial Online: Learn from basic to advanced
Microsoft Excel comes with various tools and functions that help you to gather, analyze, and visualize data. This will enable you to generate valuable insights and actionable information. Excel is one of the most powerful tools that can be used on Windows, Android, Mac, and iOS devices. If you want
More in Excel Tutorial
All Excel Tutorial articles
Regression Analysis in Excel [Linear Regression]
Whenever we want to estimate the relationship between variables then we think of using regression analysis. There are different types of regressions that you can perform. Here we are going to tell you how to use regression analysis in excel to understand which of the independent variable are related
Pareto Chart in Excel: Steps to create (Drive more customers)
If you are hotelier or you have any other business then this excel chart is very useful for you. For hotelier, grocery shop owner, tiffin center, take away service provider, the excel charts can help you to double your business. You might be wondering how it can help you grow your business. Take a l
How to Make Histogram in Excel (Windows, Mac)
An Excel histogram is a bar chart that organizes data points in the user-specified ranges. Here we have provided the steps to create the histogram in excel for both Windows and Mac devices. Check the steps properly and follow every step to create histogram online. Histogram in Excel A histogram char
Excel Count, CountA, CountBlank, CountIf, CountIfs functions
The COUNT function will count the total number of cells containing the total number of cells within the list of arguments. The excel count function will return the total number of entries that come under the range or array of numbers. Different Types of Excel Count There are four main count function
Excel Logical Test Using Multiple If Statements [OR/AND]
To test certain conditions, people use If statement. The If() function is used to perform logical tests and to evaluate conditions that will show two outcomes. This excel if statement is used to analyze a condition that will show two outcomes. Basically, excel logical test is used to evaluate the co
How to Compare Two Columns in Excel using If, Conditional Formatting, Vlookup
Recently, one of my students raise the query “How to compare two columns in excel?” There are many ways to perform compare two columns in excel including Vlookup function in excel, Conditional formatting, If Statement, and other simple methods. Depending on your requirements, you need to use the app
How to Use SumIfs Function in Excel [Multiple Criteria]
The SumIf function returns the summation of all the numbers who met the particular criteria. You have to use this SUMIF function in Excel which is also known as worksheet function. The function is used to add the value of all the cells depending on date, text, and numbers. It also supports the logic
Excel Functions List: You Must Know
Microsoft Excel has many in-built Excel functions list that let you perform calculations and return information about the spreadsheet. These in-built functions are used for performing complex calculations. Here you can see in-built functions for MS Excel that you can use for modifying text, date and
Excel Formulas Basic Functions like Sum, Average
Excel Formulas Basic Function: The formula is a unique code which you can enter into the cell. The formulas will let you perform calculations and will give you an exact outcome. In formulas, you will find various operators and functions that you can use on values and text. Here in this post, you can
How to use Excel If statement multiple conditions range [OR/AND]
To perform complicated and powerful data analysis, you need to test various conditions at a single point in time. The data analysis might require logical tests also within these multiple conditions. For this, you need to perform Excel if statement multiple conditions range that includes various If f
Create Dropdown List in Excel Cell [Best 1]
With the drop-down list, you can help people work efficiently. He or she can pick items from the list easily. So if you want to create dropdown list in excel, then do follow the step-by-step process and create the drop-down list easily. In fact, you can add and remove items also from the drop-down l
Excel Tables Tutorial for beginners – How to create table?
The table converts your data list into Excel tables that consist of many features by which you can sort or filter data set according to your preference. You can organize your data efficiently as well as view your data whenever you want to see. This is an excellent source to create excel pivot table.
How to Lock Cells in Excel in Mac and Windows
If you are protecting a worksheet, then that means you are locking all the cells. You cannot perform any editing on those cells. To perform the editing of the cells, you need to unlock those cells. Now you must be in a hurry to know how to lock cells in Excel so they don’t move […]
Excel If Statement: Step by Step process to use
When you want to perform any decision-making task then you always thought of If statement. If the statement is used to make the decision on the basis of certain criteria, it evaluates an expression and gives you an outcome. In the post, you will be going to see how to use Excel If statement. Excel [
Excel Match Function to retrieve data with examples
If you want to locate the placement of the lookup value then you need to use Excel Match function. The Match function will offer you an approximate and exact match whereas wildcards are used for partial matches. When you want to retrieve the value of the position which is returned by the MATCH funct
INDEX Function in Excel: Step by Step Guide
In our previous post, we have already cover Excel Match function. The Match function in excel returns the position of an item in array whereas the Index function in Excel returns the value present in that position in the array. Hence if you want to extract any value from an array then you need to [&
Find Duplicates in Excel (Filter / Count If / Conditional Formatting)
Here we have provided the step by step process on how to find duplicates in excel. When you are working on a large number of data then you will encounter few duplicate entries. Sometimes these duplicate values are very useful but many times you want to remove the duplicate data. If you have 1000 of
Excel Subtraction Formula: How to use Subtract Function
There are various excel formulas basic including excel subtraction formula and advanced available in Microsoft Excel that you can use for different purposes. You might have used sum and average functions in excel as its icon is available at Excel ribbon. But you will not find an icon for subtraction
Bullets in Excel: How to Insert Bullet Points in Excel
Here you can see how to insert bullets in Excel. If you are a daily user of Microsoft tools, then surely, you must have seen bullets in MS Word. Like bullet points in Word, Excel does not offer a direct and bullet point shortcut method to add a bullet. But to add the bullet in […]
Excel Slicer: Easy Tricks to FILTER DATA [In Pivot Table]
To know everything about excel slicer, continue reading this page. In Excel, you will find numerous functions and formulas available like excel macros, vlookup, hlookup, and many others. Slicers are basically used to filter pivot tables easily and quickly. The Slicer is the visual filters that filte
Excel Hyperlink Functions and Formulae [With Examples]
There are various ways to use Excel Hyperlink. Similarly like MS Word or a website, you can also create a hyperlink in Excel. The hyperlink is used whenever you want to switch the sheet or you want to show things that are not available at the same place. Here you can check everything about excel [&h
How to do Filtering in Excel to find data [Sorting Data]
Here you can check how you can perform filtering in excel to sort the data and to find the data. You can filter your excel data whichever meet the certain criteria and displays the records that you want to show. Along with filtering of data, you can also check the sorting of data to sort […]
How to merge cells in excel [Shrink to Fit / Wrap Text]
Here we have commuted steps that will tell you how to merge cells in excel. In Excel, you can merge more than two cells together. Merging two cells together doesn’t mean combining the cell content together but you are combining cells together that has the same space. Check all the steps and follow e
How to open excel file online free
When you open excel file online, you will find a new workbook automatically displayed. The workbook contains various worksheets that hold actual data and information. Initially, workbook opens up with three worksheets, but you can add and delete worksheets whenever you want. Depending on the Excel v
Excel Tutorial Step by Step [FREE] Guide for Beginners
If you are a beginner in Excel and looking for an Excel Tutorial online, then you are at the right place. Excel is used for many purposes. You can store your confidential financial data as well as numerical data. Apart from storing the data, you can also retrieve and manipulate data. Here we have li
Common and Useful Excel Shortcuts [KEYBOARD] for Mac & Windows
To speed up your work and to make your life easier, use these keyboard shortcuts and save your time. Not only in excel, but you can use keyboard shortcuts anywhere you want. Here we are giving you details about these useful excel shortcuts that you can use for windows and mac. Excel Shortcuts Add Cu