Skip to main content

Posts

Excel Lab Part 5

  Hands-on Lab 5: Cleaning Data Estimated time needed:  45 minutes In this lab, first you will learn how to deal with inaccurate data, how to remove empty rows, and how to remove duplicated data. Next, you will learn how to change the case of text, how to change date formatting, and how to trim whitespace from data. Finally, you will learn how to use the Flash Fill feature and functions in Excel to help clean data. Software Used in this Lab The instruction videos in this course use the full Excel Desktop version as this has all the available product features, but for the hands-on labs we will be using the free ‘Excel for the web’ version as this is available to everyone. Although you can use the Excel Desktop software if you have access to this version,  it is recommended that you use Excel for the web for the hands-on labs  as the lab instructions specifically refer to this version, and there are some small differences in the interface and available features. Datase...
Recent posts

All about Convolutional Neural Networks (CNNs)

  Introduction Convolutional neural networks (CNNs) emerged from the study of the brain’s visual cortex, and they have been used in image recognition since the 1980s. These studies of the visual cortex inspired the neocognitron, introduced in 1980,4 which gradually evolved into what we now call convolutional neural networks. An important milestone was a 1998 paper by Yann LeCun, Léon Bottou, Yoshua Bengio, and Patrick Haffner, which introduced the famous LeNet-5 architecture, widely used to recognize handwritten check numbers. Artificial Intelligence has been witnessing a monumental growth in bridging the gap between the capabilities of humans and machines. Researchers and enthusiasts alike, work on numerous aspects of the field to make amazing things happen. One of many such areas is the domain of Computer Vision. The agenda for this field is to enable machines to view the world as humans do, perceive it in a similar manner and even use the knowledge for a multitude of tasks such ...

Your most unhappy customers are your greatest source of learning.

  Your most unhappy customers are your greatest source of learning. Far far away, behind the word mountains, far from the countries Vokalia and Consonantia, there live the blind texts. Far far away, behind the word mountains, far from the countries Vokalia and Consonantia, there live the blind texts. Separated they live in Bookmarksgrove right at the coast of the Semantics, a large language ocean. A small river named Duden flows by their place and supplies it with the necessary regelialia. It is a paradisematic country, in which roasted parts of sentences fly into your mouth. The Big Oxmox advised her not to do so, because there were thousands of bad Commas, wild Question Marks and devious Semikoli, but the Little Blind Text didn’t listen. She packed her seven versalia, put her initial into the belt and made herself on the way. Even the all-powerful Pointing has no control about the blind texts it is an almost unorthographic life One day however a small line of blind text by the na...

Question abut advance Excel

1. Question 1 What is the first and most significant part of data quality? 1 / 1 point Accuracy Completeness Relevance Reliability Correct While all the options are traits of data quality, accuracy is the first and most significant aspect to data quality 2. Question 2 Which data quality trait refers to the availability and accessibility of the data? 1 / 1 point Accuracy Reliability Completeness Timeliness Correct Timeliness refers to the availability and accessibility of the selected data 3. Question 3 What is a delimited file? 1 / 1 point file with data fields separated by fixed-widths file with no spaces between data fields file with data fields separated by characters like commas or tabs file with text qualifiers between data fields Correct A delimited file is a file that has data fields separated by characters, the most common of which are comma and tab