1948 results for learn excel
- All Tutorials
- Video Tutorials
- Quick Tutorials
- All
- Spreadsheet
- Presentation
- Writer
1948 results for learn excel
Learn pivot table from the beginning
04:27Learn pivot table from the beginning
A PivotTable has a flexible operation interface. We can change the layout of various types of reports only with mouse operation. It can help us better search for information and make decisions.Take this table as an example. This is the sales data of a certain company over a period of time. If we want to count the total sales of products sold by each branch, we can use the pivot table to count it quickly. This is the completed pivot table. 1. First, select any cell with data in this tab....
Learn PivotTable from scratch
04:21Learn PivotTable from scratch
PivotTable enables us to create various tables by changing its fields on each area as a kind of interactive table. With PivotTable, we can analyze and process complex data tables quickly. Take this raw data sheet as an example, which displays the sales of each branch of a brand. Now we can start to analyze its data. For example, we can analyze the total sales of each branch, the total sales of each item sold in each branch, the total sales of each item sold in each branch in each sales....
Quick to learn the time and dates functions
11:58Quick to learn the time and dates functions
1. How to correctly express the time and date in the function formula2. Share the function formula to extract the year, month, day and hour, minute and second3. Real case: how to use the DATEIF function to calculate the length of service of employees4. How to convert different time units to each other
How to convert Excel to PDF
02:50How to convert Excel to PDF
PDF is a highly compatible format that occupies little space and is easy to transfer. Converting a table into a PDF file is often needed in daily study and work. Here are the steps. Take this table as an example. Click the Tools tab, then click the Export to PDF button. A dialog box Export to PDF will pop up, where you can select the small icon to the right of the file name to rename it. We can choose Active sheet for multi-page tables to set the export range.When we want multiple tabl....
Learn how to create template in word
Learn how to create template in word A template in Word is usually a master or model document that you can open whenever you want to create new documents with excellent default formatting. For this, it is important that you learn everything about how to create template in word. The spreadsheets must-have titles or subtitles, with an excellent header to attract attention. You will be impressed with the amount of how you can create template in word. With ease and without complications. F....
Resume template in Excel: Learn how to make a spreadsheet to get a job
Resume template in excel: Learn how to make a spreadsheet to get a job The excel resume template can be adapted to all types of profiles, whether you are a recent graduate, an inexperienced professional, intern, or a manager. You must have this type of spreadsheet when looking for work because it will give you the needed presence. Excel currently offers you a variety of excel resume templates for whatever you need. Because of this, you can learn to make an excellent resume easily and w....
Learn to use an agenda meeting template in Word
Learn to use an agenda meeting template Word The agenda meeting template Word is perfect if you need to keep track of your appointments, commitments, and events. You can find various meeting templates to keep your meetings running smoothly. They are easy-to-use templates that can be useful for anyone wanting to run an agency for their meetings. Below is a complete list of free download agenda meeting Templates in Word. 1. Simple Black and White Meeting Agency Agenda meeting template Wo....
How to view two sheets side by side
01:09How to view two sheets side by side
When checking data in WPS Spreadsheet, we frequently need to check and edit multiple sheets at the same time. We'll learn how to see two pages on the same screen today.· Step one: Create and view two sheets side by sideFirst, let's open an Excel file containing multiple worksheets. Click New window in the View tab. At this time, another identical Excel document window will appear. These two windows are presenting the same file. No matter which one is edited, the changes can be....