Excel Notes

How to Capture Entire Screen with Snagit The Snagit is very easy and convenient to capture the screen in any size. If you are new to the Snagit capture, you may get confused because the software automatically selects a size.

How to Delete Unwanted PDF Pages without Software When the PDF document has extra pages which you do not want to keep and if you have the professional version, that is very easy. However, most users have no professional PDF software, how can you remove them? Please see the steps below to remove the extra pages with Google Chrome. Step 1: Open

3 Best Ways to Take a Screenshot A screen screenshot is a snapshot of anything on your computer screen such as the desktop or a WebPage. When working with your computer, you often need to take a screenshot to make the communication more efficient. The following are the 3 most convenient and useful tools to take a screenshot.

How to Display Tasks in Window 10 While working with Windows 10, you may need to quickly checks the files you are working on. To display all the files in one window, you need to have the tasks view. Please follow the steps below: (adsbygoogle = window.adsbygoogle ||

8 Common Errors in Excel /0! │ /A Error │ ? │ ! │ ! │ ! │ ! │ # # # # # # When working with Excel, one or more errors may appear in your data or analysis. Each error has its own reason. (adsbygoogle = window.adsbygoogle || []).push({}); 1. What is /0! Error? " /0!" appears when

How to Group a Column into Different Groups When analyzing data in Excel, you often need to categorize a column with data into different groups. The group can be many different variables, such as age group, subject scores and many others. (adsbygoogle = window.adsbygoogle ||

How to Put Count and Percentage in One Cell In many situations, you may need to put the count or cases together with the percentages into one cell in Excel. (adsbygoogle = window.adsbygoogle || []).push({}); =B2&" ("&TEXT(C2,"0%")&")" Where B2 is the count of the people

What is the New Date When Adding Two Dates Dates work different from numbers when adding together. For example, if you add January 1, 2015 to January 2, 2015, it does not come February 3, 4030. (adsbygoogle = window.adsbygoogle || []).push({}); The reason is that each date stores in Excel

How to Calculate Days in the Year of the Date There are 365 days in a common year and 366 days in a leap year in the Gregorian calendar. The leap year is exactly divisible by four, except for years that are exactly divisible by 100. However, these century years are leap years if they are exactly divisible by 400.

What will be the Dates after a Period of Time The dates store as serial numbers in Excel. If you have a list of dates and wonder what would be the dates after a period of time, you can use the DATE function, which will merge year, month and day together.

How to Get the Dates at a Certain Age It sounds very simple and easy to get the date at a certain age if you know the birth date. For example, if a child was born on January 5, 2016, the date at age of 2 would be January 5, 2018.....