Microsoft Excel Tips and Tricks in Data Analysis

Microsoft Excel Tips and Tricks in 
Data Analysis
https://bigdata-madesimple.com/excel-tips-and-tricks-for-efficient-data-analysis/
https://learn.filtered.com/blog/how-to-understand-organise-and-present-big-data-in-excel

Most data analysts go through the following stages: Data Cleaning, Data Analysis and Data Visualization. These are easy to manage via Microsoft Excel. This post will provide you with just a few tips you can use along the way.Change format of numbers from text to numericSometimes when data is imported from an external source other than Excel, numbers are imported as text. When this happens, Excel will alert you by showing a green tool tip in the top-left corner of the cell. If you click the tool tip you’ll see the following message: ‘Convert to number’ within the tool tip options
A quick method to convert the values to number format is to use Text-to-Columns:Sometimes the data is stored in several csv (Comma Separated Value) files that need to be imported and merged into a single worksheet.
Once you’ve installed the Add-in, follow these steps to use it for importing and merging csv files:.
  • Select the range with the values to be converted.
  • Go to Data > Text to Columns.
  • Select Delimited and click Next.
  • Uncheck all the checkboxes for delimiters (see below) and click Next

Merge data from several csv files into a single folder
  • Go to Data and click on ‘RDBMerge Add-in’.
  • Within the dialog box, click on Browse.
  • Browse to the folder and press OK. The path to the folder will appear in the top part.
  • Select CSV from the Which files dropdown list.
  • Select cells range you want to extract. To import the whole file, select First cell.
  • Click on Merge.

Comments

Post a Comment

Popular posts from this blog

How Big Data Can Boost Weather Forecasting

張岳庭 D0741017 Source:  https://www.wired.com/insights/2013/02/how-big-data-can-boost-weather-forecasting/ Considering the number of variables involved and the complex interactions between these variables, weather forecasting has always been extremely challenging. The significant increase in data collection and processing capabilities has greatly improved the ability of weather forecasters to pinpoint the time and severity of hurricanes, floods, snowstorms and other weather events. Globally, more and more evidence of climate change is prompting governments and scientists to take action to protect people and property from its effects. But to take effective measures, they need to know more about the weather-from everything that will happen tomorrow to what will happen next year. According to the professor of economics and finance , Alan Anderson, PhD , “Example of an application of big data to weather forecasting is IBM’s Deep Thunder. Unlike many weather forecasting systems...
Read more

How Big Data is Changing the Production Industry

Blog#4 : How Big Data is Changing the Production Industry Name : Aileen 蔣慧玲 Student ID : D0726917 Source :   https://www.productionhub.com/blog/post/how-big-data-is-changing-the-production-industry Information technology plays a major role in Hollywood. Producers have to use big data analytics to get the right consumers and communicate with them well. Big data technologies will help filmmakers figure out the best ways to share their ideas and deliver messages, develop movies and content that involve ethical and societal issues. Therefore, information that we can get from the help of big data can help filmmakers make key decisions. Big Data is Changing the Production Game Big data technology can help filmmakers to connect and engage with consumers more directly using social media, mobile devices and traditional advertising outlets. Using this technology, producers can develop promotions that reaches the right consumer at the right time. It is not enough just to mainta...
Read more

Big Data case study: 5 relevant examples from the airline industry

D0740712 Connie  吳霈晴 Website: https://blog.datumize.com/5-relevant-examples-of-a-big-data-case-study-from-the-airline-industry With the summer vacation coming, travel is the one that people love to do during vacation, especially long vacation, going abroad may be the first choice for many travelers. So this makes me think of what is the relationship between big data and airplanes? How will it apply on the airline industry? This article tells about the benefits of big data on airlines, which covers three main advantages. 1.      Smarter maintenance 2.      Safer flights 3.      Improve service The first one includes the fuel of airplane, by analyzing and predicting, the article takes some specific airplane company as an example, giving the real number and how much they save the cost. Second, safety. Like this kind of transportation has a higher risk to take, if have the big data’s help, th...
Read more