Excel OR Function Tips

Excel Learn It For Free!

Excel is one of the tools most of us use in our lives. It is almost impossible to tell how many things you can do with Excel.

How To Use Excel?

If you want to learn excel and use it for work, then you should be wondering about the common usage of this extremely innovative and powerful software.

Four Tips To Make Your Charts More Readable!

You must have come across charts that are overloaded and you find them a pain to read. Yes these are charts that look quite pretty initially but they are read and interpreted, they become unbearable.

Online Training For Excel

A spreadsheet is a sheet consisting of rows and columns which intersect with each other to form cell. Data are entered in each cell for calculation, storage or manipulation. Excel is collection of electronic spreadsheets

A 3 Step Guide To Make Your First Excel Based Model

There are a lot of resources available for modeling on internet, available from books to tutorial to boot-camp trainings; this one focuses more on the concept of modeling rather then discussing details of any particular field.

How To Learn Excel Sheets?

Excel sheets can surely make your work a lot easier.  Undoubtedly, excel sheets is one of the professional tools for working with information available in raw form.

Generating Random Data In 5 Minutes

When we are developing a model or trying to test some formula, we need data and when we don’t have one, we have to create it to suit our needs. This is frequently called dummy data.

How To Learn Excel Formulas?

What is a formula? Talking generally, a formula is a way to calculate a mathematical equation. It is used to calculate both simple as well as complex equations.

How To Learn Excel For Free?

Lots of people are looking to learn Excel these days. It is one of the most demanded skills in all sorts of businesses, no matter whether they are small or large.

How To Learn Excel? Start And Master With These Resources

A spreadsheet is an electronic document formed by the combination of rows and columns marked with a grid. Excel is a matrix and powerful platform and a massive program.

Unique Entries in Userform Dependent Listboxes

The relationship listbox template has been used exactly zero times. One can build their classes from start along with names which actually reflect the objects of the business they are aimed at representing.

Reversing Rows with Power Query Feature In Excel

 

Power Query allows the execution of several steps in series for the basic purpose of transformation of data present in Excel.

How To Use Excel Pivot Tables For Showing Percent Of Column Total?

The “Show Values As option” can be used for performing several calculations in Excel Pivot tables

COUNTROWS In Excel Power Pivot

Measures is amongst the most important and highly powerful features in Power Pivot. Measures are actually the calculations or formulas you add to the Pivot Table. Below is an example of it.

Using Excel’s TRIM Formula To Clean Data

The TRIM formula introduced by Microsoft Excel allows us to remove all the unwanted spaces that are present within a text, other than any singular spaces in between different words.

Excel Charts And Logarithmic Scales

Graphing collected data makes the interpretation of the accumulated information much easier to read, comprehend, and share with others.

How To Find Text With A Formula

What formula will tell you that a specific cell contains a specific text?

Free Online Training For Excel

Excel is a life saver at work and there is always a free online training for Excel in the internet. At Sheetzoom, we offer free excel training using Excel Online and you can learn by doing. The key to Excel learning is actually solving real problems with Excel.

The Importance Of INDIRECT Function

INDIRECT Function yields a reference to a range. The range being referred can be a named range, a range of cells or can be a cell. 

Using Excel’s Multiple Criteria In VLOOKUP Function

Microsoft Excel’s VLOOKUP function is a popular feature amongst office personnel and data processor positions.

Keyboard Shortcut Metrics

Majority of people working with computer systems love shortcuts on keyboard. Few of the shortcuts which are custom made can help you to clean Undo Stack, which is quite painful.

Convert Text To Numbers In Excel – A Step By Step Tutorial

We often see numbers stored in Excel as text which leads to wrong calculations, especially while using the cells in the functions i.e.

Extracting Data With Excel’s LEFT Formula

Left formula? What does it returns? Well, it gives back the first character in a string. The amount of characters is given as an input and result is extracted on basis of that.

Group Rows And Get Counts Using Power Query

Power Query is a very strong tool available in Excel. It allows you to perform different types of transformations on your data.

INDIRECT Function For Dependent Dropdown Lists In Excel

The INDIRECT function is a powerful function as it allows you to carry out different tasks that come in very handy.

Power Pivot Tables In Microsoft Excel

Microsoft Excel has many powerful functions which are very useful in manipulating data into meaningful information for all kinds of purposes.

How To Set A Default Template In Excel

Do you need to create new workbooks all the time and then making similar changes to all of them? 

Grouping Numbers In Excel With Pivot Table

Grouping of numbers can be done for creating a frequency distribution table in a Pivot Table.

How To Disable Scroll Lock In Excel

You are working on Excel and you need to submit work within an hour.

Displaying Percentages Using Pivot Tables In Microsoft Excel

There are many useful functions for Pivot Tables that are available in Microsoft Excel. 

Conversion Of Date To Text In Excel

Both date as well as time is stored in the form of numbers in Excel. This allows the user to utilize these dates as well as times for the purpose of calculations.

Replace Values Using Power Query

Power Quey is a strong command used in Microsoft Excel. It allows you to perform different steps in order to transform the data within your Excel sheets.

How To Create A Pareto Chart Using Microsoft Excel 2016

Microsoft Excel 2016 introduces a lot of new Charts for us to use in presentations.

Using RANDBETWEEN For Dates In Microsoft Excel

The RANDBETWEEN function is available for use in Microsoft Excel. The function is used to generate randomized dates between a specified start date and end date.

Creating Linked Tables in Excel Using Power Pivot

Working with Microsoft Excel to produce multiple tables that are linked together is easy.

How To Use The MOD Function To Repeat Values

Have you ever used the MOD function in Excel? Well, the function actually performs modulo operation.

Microsoft Excel: Using Conditional Formatting To Make Heat Map

A data set’s comparative view can easily be represented visually with the aid of a heat map

New Power Pivot updates in the 2016 version of Microsoft Excel

The Office 365 subscription comes with new Power Pivot updates for the features in the 2016 version of Microsoft Excel.

Use Excel 2016 and Design Your Box and Whisker Chart

Among the numerous new charts available on the new Excel 2016 is the Box and Whisker Chart. This chart was originally created by John Tukey in the 1970s

Microsoft Excel: How To Make Step Chart

It is possible to apply step chart if you intend to monitor changes that occur at different times. This could include interest rates, tax rate, petrol and milk products.

Easily Transforming and Shaping Data in Microsoft Excel 2016 Version

Raw data in most cases, are often in a form that is of no major benefits to the users due to the fact that they are messy.

Top Formulas for Analysts

If you are wondering what the top ten formulas are, then you should really consider acknowledging the fact that there is no standard list of the perfect ten formulas for each individual.

Excel And Big Data

Excel does not only have the ability to handle small data but also very big data as well. Big data can be described as data that has a high variety, high velocity or high volume. High variety entails huge shape of data which changes quickly over a period of time.

Creating a Case Sensitive VLOOKUP

Normally, the VLOOKUP function lookup function is normally not sensitive to case

Use the CLEAN Formula and Clear Excel’s Unprintable Data

The CLEAN formula assists you in erasing and removing all characters that cannot be printed from the text.

How To Randomize A List In Excel

Suppose you want to randomize a list, for this you have to have a list of random (or shuffled) numbers, which can be used to randomize the list you want.

Use Cluster Values to Generate Sequence Numbers

If you are wondering if it is possible to create sequence numbers from clustered values, then you should definitely consider reading ahead to find out more

Most Popular Excel Shortcuts

Based on surveys, we have compiled a list of the most popular Excel shortcuts you will find.

Five Shortcuts to Keep in Mind

Here you will find some very useful shortcuts that you can use throughout your term of using Excel. Each shortcut has been given for each day of the weekday.

How to Set Up Dashboards

If you are wondering what exactly is a dashboard, then in simple words a dashboard is basically a report of data that allows the manager or a business analyst to gain an overview of what the business is doing and assist them in making the right decisions.

Countif Greater Than

COUNTIF() function is used for counting cells with unique values in a range that meet a certain criterion, or condition.

Remove Spaces in Excel Leading, Trailing, and Double

At first instance, you may wonder why we would need to remove spaces in Excel. If you have unnecessary spaces it may prevent working of some functions, filtering etc.

How to Revert Back to Original Sort

The sorting facility is an important and highly useful feature provided in Excel. Which can be used to handle and retrieve data from large databases.

How to Enable Conditional Data Entry in Excel using Data Validation

Sometimes when you are creating worksheets with data inputs, you may want to restrict the data input format (i.e. numbers, decimals, date, text etc.) and their range.

Outline data in Excel

Outlining data is a useful fuanction provided in Excel, which facilitate better organizing of data tables. It will also enable gropuing of simmilar data and collapsing.

When to use SWITCH function in Excel

The SWITCH function is a highly useful function which can be used for various applications with conditional splitting logic.

How to use SWITCH function in Excel

The SWITCH function is a highly useful function which can be used for various applications. This is newly introduced to Excel and it is only available in the latest version of Office (EXCEL 2016, Excel Online and latest mobile excel versions).

Excel Practice Exercises and Tests

You know the functions and formulas but need to practive your Excel skills? Or do you need Excel Practice Tests online? Well you are at the right place. We have free excel practice tests where you can sharpen your skill. These are not multiple choice questions in fact you learn by doing.

 

4 Ways to Learn Excel

Excel is best learned by actually doing stuff. You can open the Excel software desktop or online, try writing formulas. 

How to Type Degree Symbol in Excel

You may need type degree symbol for number of uses, for example to show degree values, Celsius, Fahrenheit etc. However, this symbol cannot be directly entered from the key board.

How to Use Counta Function

The COUNTA function is usually used for counting the non-empty cells in a given cell range.

Spell Check in Excel – Where is it and How to Use it

In Excel, spell checker is a tool that used to recognize errors incorrectly-spelled words. Which is highly useful since you don’t have to manually check all the words that you typed in excel.

Count Unique Values in Excel Using COUNTIF Function

COUNTIF() function is used for counting cells with unique values in a range that meet a certain criterion, or condition.

How to use COUNTIF greater than

COUNTIF() function is used for counting cells with unique values in a range that meet a certain criterion, or condition.

How to Count Cells that Contain Text Strings

When you have a large data set with text strings, you may need to find or count data based on their text content. You may know to do this with numerical values, but also know that this can be done to ant cells that contain text strings.

VLOOKUP for dummies

The simplest way to retrieve data in a database using a one criteria is use of VLOOKUP function. It is good to know that VLOOKUP function can be used with two or more criteria columns.

What's new in Excel 2016 for Windows(Infographic)

Check out the What's new in Excel 2016 for Windows(Infographic) to know about:

Format numbers in Indian Grouping

Format numbers according to the Indian number formatting so that 100,000 displays as 1,00,000

8 Excel 2016 New Functions

This new function allow to add handwritten equations to text, so you can add mathematical equations more easily to excel documents. The sketches of the equations can be made using a mouse or a digital/fingers.

How to use Vlookup with Exact Match

Vlookup can be considered as one of the most beneficial functions offered in Microsoft Excel, which has become much useful in data analysis and data processing work.

How to Insert Multiple Rows in Excel

Inserting rows in between selected rows, is one of the most necessary and important functions we require when working in excel worksheets.

How to Make a Drop-Down List in Excel

Drop-down list is the ideal option for selecting an item from a list. So that the user does not have to type it and can select from the available list. It also then allows not entering invalid data.

How To Merge Cells In Excel

Merging is a useful function in MS Excel which is used more often to make title/larger cells or also to combine

Conditional Formatting in Excel

Conditional Formatting is a widely used tool of Excel that provides pre-determined formatting to be applied to a cell or range of cells. The formatting may depend on the cell value or the content of it

Getting power and logarithm of a number

Using POWER() and LOG() formulas.

Getting random numbers

Getting random numbers with RANDBETWEEN() formula.

Finding whether a number is even or not

Using ISEVEN() or ISODD() functions.

Making words proper

Using PROFER() formula.

Finding a character in a text with SEARCH() function

Using SEARCH() formula.

Finding a character in a text with FIND() function

Using FIND() formula.

IFERROR() function

Using IFERROR() function

Operation with IF(), AND() and OR() formulas

Using IF(), AND() and OR() formulas.

Operation with condition according to the average

Using AVERAGE() and IF() formulas.

Operation with two conditions

Using IF() and AND() formulas.

Getting the rank of a desired number in a list

Using the RANK() formula on a list.