SUMIF FUNCTION
Test Yourself Understanding SUMIF Formula The SUMIF function calculates the total number of cells in a range that satisfy a …
COUNTA FUNCTION
Test Yourself Understanding COUNTA Formula In Excel, we use the COUNT function to count numeric values in a specified range …
MINIMUM FUNCTION
Test Yourself Understanding Minimum Formula Minimum formula is used when we want to find the minimum value within a range …
Features of Pivot Tables
Pivot table helps the user to expand, isolate, sum, and group the particular data in real time. It can show …
Excel Layout: Insert Page, Layout and Formulas, Data Review, View and Help
Microsoft Excel inserts automatic page breaks based on the paper size, margin, settings and scale options. You can manually set a page …
Excel Layout: Insert Page, Layout and Formulas, Data Review, View and Help Read More »
EOMONTH function in Microsoft Excel
EOMONTH function in Excel The EOMONTH function in excel returns the last date of a month by giving inputs for …
Editing Multiple Sheets and Naming Cells
Working with Multiple Sheets And simultaneously editing the sheets You can select multiple sheets to work simultaneously saving you a …
Setup Dynamic Chart titles and table headers in Microsoft Excel
Dynamic Chart titles Do you always forget to change the chart title? Do you have a dynamic chart whose title …
Setup Dynamic Chart titles and table headers in Microsoft Excel Read More »
Customizing the Layout of Pivot Table in Excel
Pivot table helps the user to expand, isolate, sum, and group the particular data in real time. It can show …
DATA MANAGEMENT in Excel
Data Management is one of the key features provided by Microsoft Excel. There are various techniques which promotes efficient data …
