Page 49-excel-php.cn

Article Tags

excel

Home

Technical articles

Topics

excel

Excel function learning: Let's talk about how to use countif() (detailed case explanation)

In the previous article "How to quickly count working days by learning Excel functions, take a look at these two functions! 》, we learned two working day functions. Today we are going to learn countif() and share 5 cases of countif function checking for duplicates. Come and take a look!

Nov 03, 2022 pm 08:11 PM

Excel

Example parsing Excel: Split names mixed in the same cell into one column

This article brings you relevant knowledge about Excel, which mainly introduces the relevant content on how to split the names mixed in the same cell into one column. Let's take a look at it together. I hope it will be helpful to you.

Nov 02, 2022 pm 05:44 PM

Excel

Practical Excel skills sharing: How to divide a column into multiple rows and columns

In the previous article "Sharing Practical Excel Skills: Search, Positioning Functions, and Entry Techniques", we learned the search, positioning functions, and entry techniques in the table. Today we are going to talk about the practical skills of dividing a column into multiple rows and columns in Excel. Let’s take a look!

Nov 02, 2022 am 10:16 AM

Excel

Practical Excel skills sharing: search, positioning functions, entry skills

In the previous article "Sharing practical Excel skills: Four methods for summing across worksheets", we learned four methods for summing across worksheets. Today we are going to talk about 3 commonly used skills in excel tables: search, positioning functions, and entry skills. Come and collect them now!

Oct 04, 2022 am 07:00 AM

Excel

Excel case sharing: Use Powerquery to merge multiple sheets with one click

After sharing the Power Query merge worksheet with you last time, many friends left messages asking what should be done if the worksheet is increased or decreased? Today I will introduce to you how to use Power Query to merge workbooks, so that no matter the worksheet changes or data changes in the workbook, you can refresh the summary with one click. Come and learn now!

Sep 19, 2022 am 11:06 AM

Excel

Excel Case Sharing: Using Power Query to Merge Multiple Tables

In the previous article "Practical Excel Tips Sharing: Four Methods for Summing across Worksheets", we learned four methods for summing across worksheets. Today we are going to get to know the Power Query plug-in in excel. It turns out that summarizing worksheets is so convenient and fast!

Sep 16, 2022 am 10:07 AM

Excel

Excel chart learning: Excel bullet chart that reflects the difference between actual and target

In the previous article "Excel Chart Learning: How to Use Controls to Make Bar Charts", we learned how to use controls to make bar charts. Today we continue to share the tutorial on how to make Excel charts. The whole graph is like a bullet, so it is called a bullet chart. If you use this bullet chart to make a performance report, you will wonder whether you will get a promotion or a salary increase! The operation is also very simple, let’s learn how to make an Excel bullet chart together!

Sep 15, 2022 am 10:41 AM

Excel

Practical Excel skills sharing: Four methods for summing across worksheets

In the previous article "Excel Case Sharing: Using Function Formulas to Verify the Authenticity of the ID Number", we learned about the Excel function formula to verify the authenticity of the ID number. Today we will talk about summing across worksheets in Excel and introduce to you 4 methods. For different tables, you can quickly merge data across worksheets in Excel, faster than you can imagine!

Sep 14, 2022 am 10:29 AM

Excel

How to merge data into one cell in Excel

This article brings you relevant knowledge about Excel, which mainly introduces the related issues of merging multiple data into one cell. There are always some special needs at work, and the most troublesome ones are Put all the multiple results that meet the conditions into one cell. Let's take a look at them together. I hope it will be helpful to everyone.

Sep 13, 2022 pm 05:57 PM

Excel

Excel case sharing: Use function formulas to check the authenticity of ID numbers

In the previous article "Excel case sharing: 5 efficient techniques that can be realized by just "drag and drop"", we learned 5 efficient techniques that can be realized by "drag and drop" in Excel tables. Today we are going to talk about Excel’s function formula for checking the authenticity of ID card numbers, come and take a look!

Sep 13, 2022 am 10:15 AM

Excel

Excel case sharing: 5 efficient techniques that can be achieved by just 'drag and drag'

In the previous article "Excel Case Sharing: Calculation Methods for Year-on-Year Growth Rate and Month-on-Month Growth in Each Year", we learned the calculation methods for year-on-year growth rate and month-on-month growth in each year. Today we are going to talk about 5 commonly used skills in Excel tables. Unexpectedly, the problem that has troubled me for a long time can be solved with just drag and drop shortcut keys. To be honest, you think function charts are too difficult to learn, but today you must learn these few tips to solve problems by just dragging with the mouse!

Sep 06, 2022 am 10:19 AM

Excel

Excel case sharing: Calculation methods of year-on-year growth rate and month-on-month growth in each year

How to calculate year-on-year growth rate in Excel? How to calculate the month-on-month growth of Excel? The following article will introduce the Excel calculation method of year-on-year growth rate for each year. This is a method used by every company for data analysis.

Sep 05, 2022 am 10:22 AM

Excel

Excel chart learning: how to use controls to create bar charts

In the previous article "Excel chart learning: How to make the chart move like a web page", we learned how to make the Excel chart move like a web page. Today we continue to share the tutorial on how to make Excel dynamic charts. There are even check boxes to select the data that need to be displayed! If anyone uses this chart to give a work report, I guarantee that the boss will look at you twice. Are you sure you don’t want to learn such a high-level and easy-to-learn dynamic chart?

Sep 02, 2022 am 10:52 AM

Excel

4 ways to learn sorting and insert formulas in Excel pivot tables

In the previous article "How to Deal with Common Difficulties in Learning Excel Pivot Tables", we learned how to deal with common pitfalls in Pivot Tables. Today we continue to learn Pivot Tables. Pivot table is one of the very important tools in Excel. It saves us a lot of time. Many times you work overtime, maybe because you don't know how to use it. Today I will share with you the third tutorial on pivot tables. It mainly explains how to sort Excel pivot tables and how to insert excel pivot table formulas. Take a look below!

Sep 01, 2022 am 10:45 AM

Excel