Solutions

How to Use Advanced Filter to Filter Data with Complex Criteria in Your Excel

You will always use the feature of filtering data in Excel. Today we will show you how to filter data with complex criteria by advanced filter in Excel. Suppose now you need to filter data in the two columns. You can certainly filter data through the feature of “Sort & and Filter”. But if your criteria are complex, you can also use advanced filter in the worksheet. And we will show you how to use the advanced filter to filter data in Excel. Filter Data with Complex Criteria ...

Read more »

How to Insert Pictures into Cells in Your Excel Worksheet

It is easy to insert pictures into Excel worksheets. In this article, we will show you how to embed pictures into cells. In general, you cannot insert an image into a cell directly. But with additional settings, the image can stay in the designated cell. Insert Pictures into Worksheets Here we will demonstrate the steps to insert an image into the worksheet. Click the tab “Insert” in the ribbon. Next click the button “Picture” in the toolbar. In the “Insert Picture”...

Read more »

5 Effective Ways to Insert a Picture into Your Word Document

This article will mainly focus on showing you to insert a picture which can automatically update itself in Word document. Inserting picture into Word document has been a common tip for users to make their file attractive. However, when you modify the picture, the one you insert into Word file fails to update accordingly. So you may have to delete the original image and insert the new one into your Word file again. This is definitely not a pleasing way to conduct your work. Therefore we will...

Read more »