Shulou(Shulou.com)11/24 Report--

With the popularity of "put all your eggs in one basket", fraud and fraud prevention have become a hot topic.

Today, Xiaohua will share with you how to prevent fraud when using Excel?

1, unknown files to be careful in the process of using Excel, the key to prevent being deceived is not to open unknown files, especially macro files, otherwise, you may be unwittingly infected with the macro virus.

If any of the following occurs on your computer, congratulations, your computer has been infected with the Macro virus:

❶ Excel automatically pops up a book1.xls as soon as it is opened

Every time ❷ saves, Excel prompts you to include personal information, etc.

❸ automatically adds a hidden worksheet for results when any Excel file is opened

❹ code module includes Knight module, ToDOLE module, pldt module and so on.

The ❺ VBE project window contains k4.xls files, MERALCO.XLS files, and Startup.xls files.

Excel macro viruses usually have the ability to infect every open document and can even pass the virus to other members of the organization in the form of OUTLOOK and so on.

Although they are usually simple to write, they can lower macro security, collect address book information, and endanger the security of user data information.

The following is the Startup.xls virus code, for reference only.

So, how do we deal with the Excel macro virus?

▋ uses antivirus software to protect all kinds of antivirus software on the market have corresponding macro virus detection function, its disadvantage is that they almost "shoot to kill" files infected with macro virus, and even macro files developed by users will be "mistakenly killed", which requires users to make a good data backup or go to the quarantine area to "get people" if necessary.

▋ manually remove macro virus if you inadvertently infect the macro virus and do not want to lose the data in the file, we can also delete startup.xls, results.xls, book1.xls and other files in the Microsoft\ Excel\ XLSTART folder under the path of the system disk (which may be hidden and need to be deleted after cancellation), remove the macro virus manually in VB editing mode and other methods.

▋ enhances macro security in addition, increasing macro security can also play a protective role. We need to check the macro security trust level according to the actual work requirements in "Excel options"-"Trust Center Settings"-"Trust Center Settings"-"Macro Settings". It is generally recommended to check it, but it is not recommended if there are no special circumstances.

.

However, the most important point is not to easily open any unknown macro file. It is better to prevent problems than to mend them.

2. Don't be fooled by appearances such as Excel Macro virus, which is easy to hide. The use of small Excel means to "cheat" is often "difficult to defend against".

These tricks are often only superficial, poor tricks, can not stand scrutiny, but the partners who are not familiar with Excel or do not know Excel are easily fooled.

In fact, you can easily crack these tricks by mastering some simple Excel skills.

For example, some people will fill the formula or format to the unused rows or columns, forming a lot of blank rows or columns that have been used, resulting in scroll bar basic failure, and Excel file is very large, opening and running efficiency are greatly reduced, form users' work efficiency is reduced, they can be described as sinister means to cover up problems that may be exposed to a certain extent.

It is easy to see through this scam, and the solution to the problem is also very simple, just select all invalid rows or columns, right-click to delete the entire row or column, and then save the file.

What's more, sometimes we can't even trust our own eyes.

Willing people will use custom number format, deep hiding, conditional format and other means to confuse the public, please enter the urn.

As shown in the following figure, guess why the same three numbers add up to different results?

This is because the E4 cell uses a custom number format, while the E5 cell is actually a text number, so two simple tricks are enough to confuse the real with the fake.

The E4 cell uses a custom number format as follows:

E5 cells are text numbers and need to be converted to numeric numbers in order to calculate correctly.

To solve this problem, we only need to use the breakdown function to expose the illusion of all numbers.

The above are some fraud precautions during the use of the Excel shared by Xiaohua, including:

❶ does not open unknown files to avoid macro virus infection

❷ 's seemingly large files may be artificial water injection.

The illusion caused by the ❸ digital format also needs to be carefully identified.

Excel as an important tool for many people to work and operate, fraud prevention is particularly important. The scams listed by Xiaohua are only the tip of the iceberg, and friends need to be vigilant all the time.

This article comes from the official account of Wechat: Akiba Excel (ID:excel100), author: Xiaohua

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.