To zip (compress) files. In the search box on the taskbar, type file explorer, and then select it from the list of results.Right-click the file you want to zip, and then select Send to > Compressed (zipped) folder.. To decompress files. Open File Explorer and find the compressed folder.

Using clipboard. When you copy content on your PC, it’s automatically copied to your clipboard for you to paste. You can paste multiple items from your clipboard history, and you can also pin the items you tend to use all the time and sync your clipboard history to the cloud.

You can use data from a Excel worksheet as the basis for a PivotTable or PivotChart. The data should be in list format, with column labels in the first row, which Excel will use for Field Names.Each cell in subsequent rows should contain data appropriate to its column heading, and you shouldn't mix data types in the same column.

A team is a group of people gathered to get something big done in your organization. Sometimes it’s your whole organization.. Teams are made up of channels, which are the conversations you have with your teammates.Each channel is dedicated to a specific topic, department, or project. For example, the Mark 8 Project team has General, Design, Digital Assets Web, Go to Market Plan, and Research ...

Change the colors of your flow chart. To quickly add a designer-quality look and polish to your SmartArt graphic, you can change the colors or apply a SmartArt Style to your flow chart.

To save time on tasks you do often, bundle the steps into a macro. First, you record the macro. Then you can run the macro by clicking a button on the Quick Access Toolbar or pressing a combination of keys.

Functions LOOKUP() The LOOKUP function finds a value in a single row or column and matches it with a value in the same position in a different row or column. The following is an example of LOOKUP formula syntax: =LOOKUP(Lookup_Value,Lookup_Vector,Result_Vector) The following formula finds Mary's age in the sample worksheet:

Unlike Microsoft Word, Microsoft Excel doesn't have a Change Case button for changing capitalization. However, you can use the UPPER, LOWER, or PROPER functions to automatically change the case of existing text to uppercase, lowercase, or proper case. Functions are just built-in formulas that are designed to accomplish specific tasks—in this case, converting text case.

Ten days after you upgrade to Windows, your previous version of Windows will be automatically deleted from your PC. However, if you need to free up drive space, and you’re confident that your files and settings are where you want them to be in Windows, you can safely delete it yourself.

When you initially setup your Windows device, you might have opted to use a local account instead of a Microsoft account. The main difference between a local account and a Microsoft account is that a local account is specific to one device, while a Microsoft account can be used across multiple devices and Microsoft services.