Zipped (compressed) files take up less storage space and can be transferred to other computers more quickly and easily than uncompressed files. The amount of compression varies depending on the types of files included in the zipped folder. Some types of files, including JPEG images, are already highly compressed. Because of this, zipping several JPEG images will make little difference to overall size. Here’s how to zip and unzip files in Windows 11. How to Zip a File (Compress) Locate the file or folder that you want to compress. 1 – Right-click on it, select “Compress to Zip file”. Windows…
Author: novus01@skill
Excel spreadsheets are sometimes complicated and difficult to understand. Using charts to show your data in a graphical representation makes visualizing data much easier for most users. This is especially true if you are producing data for audiences who aren’t as familiar with it as you are. Here’s how to create a chart in Excel. In This Lesson… Creating a Chart Using Quick Analysis The first thing you need to do is add the raw data to the Excel Worksheet. The chart will be created from the data, so you can’t begin creating the chart until the data is at…
OneDrive is Microsoft’s cloud storage service, available to anyone with a Microsoft account. OneDrive is pre-installed with Windows 11, but will require a bit of setup before you can start using it. When you sign up for a OneDrive account, you are given 5GB free, but it is possible to increase the storage to 100GB or even 1TB for a monthly subscription fee. What is Cloud Storage? Cloud Storage is essentially a non-local or off-site storage system, where your files are uploaded to external servers, often in multiple locations. Rather than taking up space on your computer, your cloud-stored files…
The storage in your computer is the space where all files are kept, from the operating system files to the photos you have uploaded and the Word documents you have created. This space is obviously finite, and while you shouldn’t have any storage issues on a new computer, it doesn’t take long for space to be used up if you do things like photo and video editing. Learning how to manage your storage spaces is an essential part of keeping your computer running smoothly. In This Guide… Checking Your Storage Before you can manage your storage, you need to know…
There are hundreds of Excel functions available to use, but most users won’t ever need to know more than a handful. Knowing and understanding the most-used Excel functions will go a long way to making the software easier to use. Here are the 10 most-used functions in Excel and what they are used for. SUM Function Often the first function users encounter when starting to learn Excel, the SUM function is used to add values. One of the most common uses is to output a total at the end of a column/row of figures. SUM can be written to add…
Since it switched to using Chromium as its base, the Microsoft Edge browser has quickly become one of the best ways to explore the Internet. If you aren’t already using it, we really recommend giving it a try. In this Complete Guide to Using Microsoft Edge, you will learn how to do everything from customising the Start Page to importing bookmarks and blocking unwanted sites. In This Guide… Customise the Edge Start Page Layout The start Page of Microsoft Edge, the page that displays when you first open the browser, is completely customisable, and can be great for making your…
The AVERAGE function in Microsoft Excel is used to find the average of a range of values in a Worksheet. For example, if you have sheet containing different revenue figures for 12 months, you can use AVERAGE to display what the monthly average revenue is. In This Lesson… AVERAGE Syntax The AVERAGE function always includes at least one argument. Arguments can be numbers or names, ranges, or cell references that contain numbers. A formula that uses AVERAGE can contain up to 255 of them. Arguments are separated with a comma (,) within the formula. Example: =AVERAGE(A2:A10,B2:B10). This formula would return…
Creating a drop-down list in a Workbook can make the task of entering data from a set range of options much quicker, both for yourself and for anyone else who has to work with the document. How you create a drop-down list in Excel isn’t immediately obvious, but once you know the process, it will become an Excel skill you will always have at hand. In This Lesson… Create Your Drop-down List In this example, we will be creating a simple spreadsheet for recording bookings at a nail salon, with a drop-down list used to enter some of the booking…
The SUM function in Microsoft Excel is not only incredibly useful, but also often one of the first functions you will need to use when you start working with Excel documents. It is both a very simple and a very adaptable tool for adding up values in your Workbooks. In This Lesson… Simple Addition in Excel You can use Excel to do additions by typing a simple formula such as =B2+B3, which will add up the values in the named cells. But if you have a large range of values, it is much easier to use the SUM function, rather…
Learn how to create and manage your first Workbook in Excel, how to add additional Worksheets to your document, and how to start working with cells, rows and columns. Every Excel document is known as a Workbook, and every page or section of that workbook is called a Worksheet or Sheet. You can have an Excel Workbook that contains hundreds of sheets, although the limit is 255 for a newly started Workbook. Once a Workbook is created and saved, the number of sheets you can have is only limited by your available system memory. In This Lesson… Creating a New…