Excel AND Function Tips

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

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

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.

Excel Charts And Logarithmic Scales

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

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.

Using Excel’s Multiple Criteria In VLOOKUP Function

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

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.

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? 

How To Disable Scroll Lock In Excel

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

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.

Transpose Data In Excel Quickly

In case you need to transpose a dataset in Excel, that is, you want to convert the columns into rows and vice versa, it is very hard to do that manually.

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.

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.

Excel 2016 And Its Power Pivot Tool

Power Pivot is basically an Excel tool that was first introduced to the public in the year 2010. What exactly is meant by Power Pivot?

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.

Using Measures Power Pivot

Measures is a very powerful and vital feature in Power Pivot. Measures are fields that have been calculated in the 2013 version of Microsoft Excel and have been included in a Pivot Table.

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.

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 Use Sparkline

The Sparkline in Excel is a tiny chart, which can be included within the background a cell. This is used to provide visual representation of data, showing the variations, minimum/ maximum values and data trends.

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.

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.

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 use CONCAT function

The CONCAT function was recently introduced by replacing CONCATANETE function and the CONCAT is only available with the latest version of Office (EXCEL 2016, Excel Online and latest mobile excel versions).

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.

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.

 

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.

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.

Making the characters uppercase and lowercase

Using UPPER(), LOWER() and PROPER() functions with NESTED IF().

Getting power and logarithm of a number

Using POWER() and LOG() formulas.

Getting the row and column number of a cell

Using ROW() and COLUMN() functions.

Getting real random numbers with RAND() function

Using RAND() function

Getting random numbers

Getting random numbers with RANDBETWEEN() formula.

Operation with IF(), ISTEXT(), ISNUMBER() and ISBLANK() functions

Using IF(), ISTEXT(), ISNUMBER() and ISBLANK() functions.

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.

Finding minimum, maximum and average number in a list and counting the number of cells. 

Using the MIN(), MAX(), COUNT() and AVERAGE() functions on a list