microsoft excel

Valuable Excel shortcuts you should know

Valuable Excel shortcuts you should know

If you can master the formulas, shortcut keys on Excel will be much faster and more convenient. Let's join WebTech360 to collect for yourself the invaluable Excel shortcut keys in the summary below.

SUBTOTAL Function: Calculates the total value of a filtered list in Excel

SUBTOTAL Function: Calculates the total value of a filtered list in Excel

The sum function when filtering data is very important for Microsoft Excel users. This article will summarize for you how to filter and calculate sum in Excel using Subtotal.

How to Export Airtable to Excel and Google Sheets

How to Export Airtable to Excel and Google Sheets

Airtable lets you create and share relational databases easily. Export your Airtable data to Google Sheets or Excel to enjoy the benefits of advanced charts and data visualization.

Effective ways to use ChatGPT in Excel

Effective ways to use ChatGPT in Excel

Curious about how ChatGPT can enhance your Excel experience? Here are some tips for using ChatGPT in Excel.

8 Ways to Use Excel Beyond Spreadsheets

8 Ways to Use Excel Beyond Spreadsheets

Most people use Excel solely as a tool for organizing data, but its versatility extends far beyond spreadsheets.

The Best Free Family Tree Templates for Microsoft Word and Excel

The Best Free Family Tree Templates for Microsoft Word and Excel

If you don't know how to create a family tree from scratch, these Microsoft Word and Excel templates can help you.

Why are so many people stopping using Google Sheets and going back to Excel?

Why are so many people stopping using Google Sheets and going back to Excel?

For a while, Google Sheets lured people away from Excel. But many people came back after realizing that Google Sheets is far from beating Excel.

How to use the TREND function in Excel

How to use the TREND function in Excel

You can calculate and visualize trends in Excel using the TREND function. Here's how to use the TREND function in Microsoft Excel.

How to Use Excels Regex Function to Power Up Your Searches

How to Use Excels Regex Function to Power Up Your Searches

Regex functions change that. Now you can specify exactly what you need—complex patterns, partial matches, or extracting structured data—without the effort.

How to fix the error of printing blank pages in Microsoft Excel

How to fix the error of printing blank pages in Microsoft Excel

How to fix the error of printing blank pages in Microsoft Excel. Why do some Excel documents not display data or contain blank pages when printed? Below are the reasons

How to pin Word, Excel and PowerPoint files to the corresponding app icon on the Windows 11 taskbar

How to pin Word, Excel and PowerPoint files to the corresponding app icon on the Windows 11 taskbar

How to pin Word, Excel and PowerPoint files to the corresponding app icon on the Windows 11 taskbar, How to pin Office files to the taskbar icon on Windows 11? Invite

How to fix the error of not being able to save Excel files on Windows

How to fix the error of not being able to save Excel files on Windows

How to fix the error of not being able to save an Excel file on Windows. If you can't save the Excel file, don't worry too much. Below are ways to fix the error of not being able to save the above Excel file

How to insert a picture into a cell using VBA in Excel

How to insert a picture into a cell using VBA in Excel

How to insert a picture into a cell using VBA in Excel, You can easily insert pictures into Excel spreadsheets and edit them with macro code. Here's how to insert images

How to synchronize responses on Microsoft Forms with Excel

How to synchronize responses on Microsoft Forms with Excel

How to sync Microsoft Forms responses with Excel, Want to sync Microsoft Forms responses with Excel spreadsheets? Here's how to do it easily

How to change uppercase and lowercase letters in Excel

How to change uppercase and lowercase letters in Excel

To be able to easily change uppercase and lowercase letters in Excel, Microsoft has given us some functions to convert. The following article will provide the functions to support.

IF and IFS functions in Excel: Usage and specific examples

IF and IFS functions in Excel: Usage and specific examples

The IF function in Microsoft Excel is one of the most commonly used logical functions. In the simplest sense, the IF function will return a result based on one or several input comparison data.

Learn Excel - Lesson 6: How to filter unique values ​​and delete duplicate values ​​in Excel

Learn Excel - Lesson 6: How to filter unique values ​​and delete duplicate values ​​in Excel

Filtering unique values ​​and deleting duplicate data is a basic operation that everyone needs to know when using Excel. Join us to learn how to do it in Excel!

How to determine odd and even numbers in Excel

How to determine odd and even numbers in Excel

Determining even and odd numbers is one of the regular jobs of the accounting industry. The following article will guide people to determine odd and even numbers in Excel.

3 ways to fix numeric formatting errors when using Mail Merge in Microsoft Word

3 ways to fix numeric formatting errors when using Mail Merge in Microsoft Word

One of Mail Merge's long-standing annoyances is the inability to correctly format numbers in Excel. Fortunately, we always have a way out. Here are 3 ways to fix number formatting errors in Mail Merge.

Learning Excel - Lesson 11: Importing and exporting text files

Learning Excel - Lesson 11: Importing and exporting text files

There are two simple ways to import data from a text file (.txt or .csv) into Excel. To export data from Excel to a text file, use the Save As command and change the file type from the drop-down menu.

Instructions for using Name Box in Excel

Instructions for using Name Box in Excel

Name Box in Microsoft Excel is an extremely useful feature. You already know all the uses and usage of Name Box yet? Join us to find out!

Instructions to insert checkboxes in Excel

Instructions to insert checkboxes in Excel

Microsoft Excel is a software that helps you track progress and make lists effectively, you can even insert checkboxes into spreadsheets.

How to share and cancel sharing Microsoft Excel files with others

How to share and cancel sharing Microsoft Excel files with others

Thanks to its handy features, Microsoft Excel of Microsoft Office has become one of the most commonly used office tools today. One of the advantages not to be missed by this spreadsheet tool is the ch feature

Page numbering in Excel 2016/2013/2010/2007

Page numbering in Excel 2016/2013/2010/2007

When doing word processing or working on spreadsheets, one of the most important and essential things is page numbering. Not only helps users easily manipulate, but the number of Excel pages also helps us manage and work effectively

How to insert a PDF file into Excel

How to insert a PDF file into Excel

Adding PDF files to Excel will make working with this spreadsheet tool much more efficient and professional.

Instructions for sending emails from Excel spreadsheets using VBA scripts

Instructions for sending emails from Excel spreadsheets using VBA scripts

Using VBA scripts in Excel does not require any programming knowledge. VBA helps you do many advanced tasks such as creating a spreadsheet report containing all PC information, emailing directly from a spreadsheet ...

How to convert time to decimal in Excel

How to convert time to decimal in Excel

If you are not sure how to convert time to decimal numbers in Excel, the following article will guide us to do this with a few simple steps.

Instructions on how to create calendar 2020 in Excel easiest

Instructions on how to create calendar 2020 in Excel easiest

You can create calendars using Microsoft Excel from existing templates or create your own. This article will show you how to make a simple calendar using Excel.

How to get the integer part of a number in Excel

How to get the integer part of a number in Excel

Taking the integer part of a number makes our computation and statistics easier. The following article will guide you to split whole part of a number in Excel.

Learn Excel - Lesson 7: Move & copy cell contents in Excel

Learn Excel - Lesson 7: Move & copy cell contents in Excel

Let's continue learning how to copy or move cell content in Microsoft Excel!

Older Posts >