Data Handling in Excel: Pre-processing, IF Function, Charts and Graphs

DATA
HANDLING

Contents
PART 1............................................................................................................................................3
1. Use of excel of pre-processing the data...................................................................................3
Use of IF function in Excel......................................................................................................4
Charts and Graphs....................................................................................................................5
PART 2............................................................................................................................................6
2.1 Using the audidealership.csv provided in conjunction with Weka give a specific example
of clustering.................................................................................................................................6
2.2 Explain the most common data mining methods that can be used in business with real
world examples..........................................................................................................................10
2.3 Advantages and disadvantages of Weka over excel............................................................13
REFERENCES..............................................................................................................................14

PART 1
1. Use of excel of pre-processing the data
Enterprises can in Microsoft Excel be listed for clients, company managers, home bosses,
data collection, regular results analysis and Microsoft Excel function (Changhong, Intel IP Corp,
2018). The following functions are included in Microsoft Excel:
 ANALYSING AND STORING DATA- Microsoft Excel is a perfect way to manipulate
data and evaluate the system. Information can be written in various rows and columns of
the text. Via maps, charts and graphs, data mining is supported. Information from
different documentation and records is available through Excel. Data are being stored
ordered. It helps one to spend a lot of time in order to fully grasp the exams. The data
processing using the Pivot Table would not be encouraged.
 DATA RECOVERY- It is possible to get it from Windows if the data is impaired. In the
MS Excel package, data is extracted
 MAKING REPORT- MS Excel and MS Word MS document and MS Excel table format
may be submitted to the prose article. MS Excel can obtain these data. These data. MS
Excel can be used to allow simultaneous device distinctions. MS Excel not only monitors
businesses but also encourages staff to document their success reviews on a daily basis.
Teachers will assist students by utilizing graphs, models, methods and estimates.
 RESEARCH- They typically tries levels of accomplishment in the past, but advances
often help us complete our potential research. Why shall we survive for many years in
this manner. Analysis leads to addressing the question of what is and what is not. Users
build possibilities for our potential through different algorithms and historical patterns.
The planning and production was undertaken by organizations according to this research.
 CONDITIONAL FORMATTING- All relevant entities may be classified under
conditional coding. Another illustration may also be a conditional model. This also refers
to meanings identification and replication acknowledgement (Shaer, Kanj and Joshi,
2019).
 Security- MS Excel provides Excel computer protection primarily, allowing consumers to
manage their data quickly. The two MS Excel files are held in an excellent folder with

easy visual programming. In MS Excel, you store your simple details and keep your data
structured to save time. Many people love to protect their records, and MS Excel is really
good to fix this problem. So no one can touch or ruin them.
Use of IF function in Excel
The IF feature or IF declaration in Excel consists of a comma dividing three pieces
• In this case, it is simple to see what points of revenue and income are decreased and on what
date was the purchase by sellers, as well as how the IF feature is done step by phase.
Print and paste the first time in separate sheets tax period, revenue and income.
• Reorganize old details by arranging the quality function sheet for the first time.
Use the 'IF Element' form. • Shape a form code = if (sort of virus: B2>C3),
• Add a cell code to be checked if the requirement is met by the user.
• Pick a comma: • Select "Augment"
• Delete the box; then click Enter if the requirement has not been fulfilled.
When a function reveals B3's significance, then if the importance of B3's is less than the B3's
variable, the B1's parameter will also mean that the IF parameter is more important than B3.'
When this function is seen,
Users should obtain the cell B4 file after you press the Enter key. To see the impact, transfer the
handle from D4 to cell D8400.
If in an application users need to learn well what are H Lookup and V lookup first, they will not
be confused. Whether or not the customers want it is also an important skill. You will consider
anything in detail if you operate for minimal numbers. This would therefore take more longer to
locate everything in the data for the extension of the search.
Lookup Value- The row or base item of the quest. That's the row's basis.
Table series- The required meaning chart. It is difficult to choose from your table what you
want.