Microsoft Excel
Have you ever copied from a website and tried to paste it into Excel? It isn't a pretty picture. Excel has a new keyboard shortcut coming out soon. Using CTRL + SHIFT + V will paste plain text. Paste with Ctrl + V Paste Values with CTRL + SHIFT + V The current
Microsoft Excel
Updated: November 1, 2022 For potential homeowners, one year makes a HUGE difference. In 2021, we saw some of the lowest mortgage rates in the last 30 years. In July 2021, the average rate on 30-Year Fixed-Rate Mortgages was 2.87% (source FreddieMac). Today, November 1, 2022, we
Microsoft Excel
Excel has two new image-related features coming out. In this video, a preview of my teaching session at the ASAP (American Society of Administrative Professionals) Virtual Event in November, I walk you through these two new Excel functions. IMAGE Function in Excel The IMAGE Function inserts images into cells
Microsoft Excel
The new Excel IMAGE function enables you to insert images into cells with a formula. This great function allows you to sort, filter, and rearrange images. Excel IMAGE function IMAGE Function syntax =IMAGE(source, [alt_text], [sizing], [height], [width]) IMAGE Function Arguments * [Required] source is the URL path of the
Microsoft Excel
Conditional Formatting in Excel allows you to highlight every 2nd, 3rd, 4th, or 5th row. Writing a formula using the MOD function and ROW function together allows us to do this. **Excel - Highlight every 3rd row** The MOD Function has two required arguments and shows the remainder after dividing two
Microsoft Excel
When you share a PivotTable in Excel, even if you delete the data source worksheet, the data source is still attached to the PivotTable.It is called PivotTable cache. It is possible to share PivotTable results without the underlying data. You need to use Paste Special along with Paste Formats.
Microsoft Excel
The GCD Function in Excel finds the Greatest Common Divisor. We will use GCD to show Ratios in Excel. GCD Function in Excel GCD finds the greatest common divisor, which is an integer, and it will divide into the numbers without a remainder. Examples of GCD function 1. The GCD
Microsoft Excel
A liquidity ratio is a type of Financial Ratio that determines if a company can pay its short-term debt and obligations with its current assets. The higher the liquidity ratio, the better. What are Current Assets? Current Assets consist of cash and other assets expected to be converted to
Microsoft Excel
The Status Bar in Excel is the area at the bottom of the windows that shows your zoom control in the right corner and Ready in the left corner. **Excel Status Bar** The Status Bar show calculation such as Sum, Average, and Count. The number of worksheets can also be
Microsoft Excel
The COUNTIF function in Excel allows you to only count the number of cells that meet certain criterion. For example, the number of cells that the HR department appears in. With COUNTIF, you can do a wildcard search by using \* (asterisk). **COUNTIF with wildcard search and cell reference** The asterisk
Microsoft Excel
Excel has a powerful SORTING engine. SORT is the most popular function in Excel, and it can sort by many types of data, many attributes, and even custom sorting configurations. **Sort data in Excel - 7 tips** In this article and video, I walk you through **7 major SORT feature tips*
Microsoft Excel
If you need to compare two lists or columns in Microsoft Excel, you can either use Conditional Formatting or you can you an empty column and use Countif function. You can even use both. This is handy when you want to compare 2016 customers to 2017 customers or a list