Using Pivot Charts For Displaying Data
Conventional charts are mostly used for displaying rather “static” data from excel sheets – i.e. if you have a table where you have manually entered data and you want to make a chart, go for the conventional excel chart.
Averaging The 5 Lowest Values In Your Data!
Let’s assume you are a math’s teacher interested in finding the average of the math’s score of last five students – he is interested in finding why they are performing poor. How will he proceed?
How To VLOOKUP From Tables In Different Sheets In Excel
We often have sheets with similar tables and with similar layout.
Finding if a Number if Prime!
Prime Numbers are numbers that are only divisible by their selves. In this small tutorial we will guide you how to find if a number is prime or not.
Using SUMPRODUCT() To Validate Multiple Criteria In Columns
We have studied and used SUMIFS() and SUMPRODUCTS() function with their appropriates use. Just to recall, SUMIFS() work great when our data is in the shape of list or is in column.
.png "Getting Data From A Pivot Table – Using Getpivotdata()")
Getting Data From A Pivot Table – Using Getpivotdata()
If you have a large pivot and want to create a report based on that pivot, it is time to revert to a function dedicated for it – GETPIVOTDATA().
Understanding Optimization With Excel 2010
In real life, resources are scarce and wants are unlimited. This fact leads us to optimize our resources to get best out of available resources
Developing And X And R Chart For Quality Control
We do create different type of charts to fulfill our charting needs – quite a few of them are related to quality control purposes.
Understanding Time Format And Operation On Time In Excel 2010
Amongst the various format that number takes, time is the one of the most commonly used formats, after currency and accounting number formats.
.png "Extracting Meaningful Information From Raw Data – An Example Of Using Sales Data To Get Meaningful Insights")
Extracting Meaningful Information From Raw Data – An Example Of Using Sales Data To Get Meaningful Insights
If you are running a business and wants to see how much do you sale and what is the breakup and effect of each product on your profits, this post is for you!
 Function To Repeat Values Certain Number Of Time.png "How To Use MOD() Function To Repeat Values Certain Number Of Time")
How To Use MOD() Function To Repeat Values Certain Number Of Time
MOD() function has variety of uses. One of the most basic one is that it is used to find the remainder from a division
How To Calculate Average Absolute Difference For You Data With Negative Value!
A recent question on a website requested for calculating the average of absolute differences for a year-over-data.
Calculating Workdays With Different Methods
Networking days are important for both an employee and the employer.
5 Ways To Handle Or Prevent Errors In Excel
To human is err, the same is true for excel. Whenever you are writing a formula, you are prone to commit error.
How To Use MINIFS Function In Excel
The MINIFS function is an advanced statistical function, which is only available in the latest version of Office (EXCEL 2016, Excel Online and latest mobile excel versions).
Looking Up Number Values
There are five methods you can use to look up number values in excel. These include SUMPRODUCT, SUMIF, AGGREGATE, LOOKUP and a combination of INDEX & MATCH.
How To Use IFS Function In Excel
IFS function is a new function added to Excel and only available in the latest version of Office (EXCEL 2016, Excel Online and latest mobile excel versions).
How to Insert Cent Symbol In Excel
Some may think it is a very simple thing to insert a Cent symbol (¢) in Excel. It is easy if only you know it.
Using Hyperlink () With Vlookup () To Jump To A Specific Cell
Excel model can be as simple as adding up two values in cell or so complicated to cover multiple sheets or even multiple workbooks
Basic Tax Rate Calculation
MS Excel has been used in many diversified areas; one of them is accounts and finance.
Using COUNTIF To Count!
COUNTIF() family of functions is amongst the most frequency used family of functions in Excel.
Removing Duplicates In Excel
We frequently encounter data while working with lists. It is a common problem caused by human error as well as duplication of data due to common practices – copy and paste procedure for consolidation of data.
Understanding And Doing Better With SUMIF Function
SUMIF() functions is among the most commonly used functions in excel. Whenever ever we have to sum against a given criteria we revert to this function, be the criteria be only one or more then one (for more then one criteria’s we use SUMIFS(), just another function of this family).
How To Show Changing Performance With Stock Exchange Tickers!
The up and down arrows on stock exchange information board is the life line of trading business.
How To Sum Using Logical Functions - An Example Of Using AND () And OR() In Excel
MS Excel offers seven logical functions, today we will discuss how to use AND () when summing up values.
Excel Training
The world has been growing rapidly over the past few decades. Today modern technology has completely changed our lifestyle and is adding a lot to our daily lives
Creating Word Clouds In Excel!
One have seen different types of graphics that display information, ranging from simple charts, to dashboards and miniature charts like spark lines and so on, but one of them that appealed me a lot from artistic point of view is a word cloud.
Using Wild Cards To Count Last Names – A Quick Tutorial
Whenever we have data, we want to extract meaningful information from it.
A 10 Min Tutorial On How Goal Seek Works
Businesses are all about decision making. If you are working for a firm, whether it is producing goods or providing services, you must have come across situation where you need to do the “What-If” Analysis. One of the most helpful tools in this context is “Goal Seek”.
Free Training Of Excel To Make Your Life Easier
What the companies are expecting from the employee these days is that they should know everything about Excel ribbons, capability to enter and format data, the complete use of formulas to calculate total and stuff, highlighting the main data, developing reports and charts, formatting data and knowing the details about shortcuts and tricks to enhance the productivity.
Displaying Large Data Sets With Sparkline In Excel
Our paper is designed to accommodate two-dimensional charts, or at best 3 dimensional charts. But those charts are produced at the expense of understandability and appearance of them. What if you want to produce so many to them to accommodate cross-tabbed data?
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.
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.
How To Find Text With A Formula
What formula will tell you that a specific cell contains a specific text?
Show The Percent of Row Total With Excel Pivot Tables
Excel has pivot tables that offer different types of calculations. You can start off with it by selecting the ‘Show Values As’ option. Then you can get the calculation of the ‘Percent of Row Total’ as well.
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.
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.
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.
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.
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.
How To Extract A URL From A Hyperlink On Excel
Many of the people find it difficult to extract the URLs from the list of text. It is as easy as anything. There are two different ways of doing it.
Using Excel To Create Histogram
In business, several tools are used to analyze data. One of such tools is the histogram. The histogram is a chart, which has chart columns that signify how frequent a variable is present.
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.
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.
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
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 use MAXIFS function
MAXIFS function is considered to be one of the advanced statistical functions available in Excel.
How to Use Counta Function
The COUNTA function is usually used for counting the non-empty cells in a given cell range.
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 SUMIFS (Multiple Criteria)
The SUMIF function is used to conditionally sum values based on certain criteria. Another version of that function is SUMIFS
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.
.png "COUNTIFS Function (multiple criteria)")
COUNTIFS Function (multiple criteria)
The COUNTIFS() function is an extended version of the COUNTIF() function which is used to conditionally count items/ cells based on certain criteria.
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.
.png "How To Use SUMIF Function (WS)")
How To Use SUMIF Function (WS)
The SUMIF function is used to conditionally sum values based on a single criteria. The Syntax of this SUMIF function can be explained as follows:
Making the characters uppercase and lowercase
Using UPPER(), LOWER() and PROPER() functions with NESTED IF().
 function.png "IFERROR() function")
, ISTEXT(), ISNUMBER() and ISBLANK() functions.png "Operation with IF(), ISTEXT(), ISNUMBER() and ISBLANK() functions")
Operation with IF(), ISTEXT(), ISNUMBER() and ISBLANK() functions
Using IF(), ISTEXT(), ISNUMBER() and ISBLANK() functions.
.png "Operation with nested IF()")
 function.png "Operation with COUNTIF() function")
, AND() and OR() formulas.png "Operation with IF(), AND() and OR() formulas")
.png "Operation with two conditions")
Latest
-
Understanding How HYPERLINK Works In Excel
Excel has a built in function to create hyperlinks &...
-
Understanding how MS Excel Query Works
“Query” in MS Excel has same meaning as ...
-
An Introduction To Excel Power Map
Our today’s post is about “Power Map&rdq...
-
Using Pivot Charts For Displaying Data
Conventional charts are mostly used for displaying r...
-
Using “Calculated Items” For Analyzing A Pivot Table
In our last post, we explored how to use calculated ...
