Learn how to get the best out of the SUMIFS functions
Excel has provided us with several functions to help us make sense of huge pools of data. SUMIFS is one of them.
1604, 2019
Monthly Archives: April 2019
1604, 2019
Learn how to use the COUNTIFS function
Excel has provided us with several functions to help us make sense of huge pools of data. COUNTIFS is one of them.
1604, 2019
Learn how to use the AVERAGEIFS function
Excel has provided us with several functions, to help us make sense of huge pools of data. AVERAGEIFS is one of them.
0804, 2019
Excel Shortcuts in Mac
This is a searchable list of all the shortcuts in Mac.
0804, 2019
Categorized Excel Shortcuts in Mac
This is a categorized collection of all the shortcuts in Mac.
0504, 2019
How to Transpose cells in Excel
It is certain that at some point everybody needs to alter the form and layout of their data, in order for them to be more readable, or answer to some specific visual requirements.
The ability to transpose our data is such a need.
0504, 2019
The TRANSPOSE Function
The TRANSPOSE function transposes (rotates) a range of cells.
We can transpose our data by using the relevant Paste Special option also but it will create duplicate data.
0504, 2019
Excel Shortcuts in Windows
This is a searchable list of all the shortcuts in Windows.
0504, 2019
Categorized Excel Shortcuts in Windows
This is a categorized collection of all the shortcuts in Windows.
0404, 2019
Using the Solver add-in
In another tutorial we saw how we can find ourselves a better loan for a new car, using Goal Seek . Although Excel’s Goal Seek is a powerful tool, it has one basic limitation. It allows only one variable to be changed to help us achieve our goal.
Excel provides an even more powerful tool that bypasses this limitation. The Solver. The Solver is in the form of an add-in which must be enabled before you can use it.
