A top 10 list is a common form for displaying information, especially on dashboards and summarized reports. It is easy to create the list when working with sorted data, just cell link to the top 10 items in the list… easy! It’s also relatively simple when using Auto Filter, Tables and Pivot Tables, as it Read More
How to Use FILTER function in Excel
Filtering is a common everyday action for most Excel users. Whether using AutoFilter or a Table, it is a convenient way to view a subset of data quickly. Until the FILTER function came to Excel, there was no easy way to achieve this with formulas. When Microsoft announced the changes to Excel’s calculation engine, they also Read More
How to Use DATE and EOMONTH to Get First Day and Last Day of the Month and Year.
On this page, you will find some formulas to calculate specific days automatically. Building specific dates, such as the first or last day, is always a very complex task, in Excel or any other software. The function TODAY has been used in all the examples but you can replace it with your own date value. Read More
How to Use the MONTHNAME Function (VBA)
This Excel tutorial explains how to use the Excel MONTHNAME function with syntax and examples. Description The Microsoft Excel MONTHNAME function returns a string representing the month given a number from 1 to 12. The MONTHNAME function is a built-in function in Excel that is categorized as a Date/Time Function. It can be used as a VBA function Read More
Three Best Ways to Find Last Row(Non-blank) and Column Using VBA
Finding last used row and column is one of the basic and important task for any automation in excel using VBA. For compiling sheets, workbooks and arranging data automatically, you are required to find the limit of the data on sheets. This article will explain every method of finding last row and column in excel Read More
How to Turn off the Camera Sound on iPhone
What to Know Disable the camera shutter sound using the Live Photo feature. Go to Settings > Camera > Preserve Settings and turn on Live Photo. Mute the phone’s ringer. To mute, toggle the switch on the left side of the phone. Access Control Center and lower the volume. Swipe down from the upper-right corner of the screen and move the volume Read More