We covered many of the common data issues that you might encounter when working with data and several strategies to deal with them. Every dataset will have its own challenges that go well beyond what we have covered so far, but by the end of this chapter, you would be able to handle a good number of scenarios. What you can bet on is having data quality issues which will force you to clean your data. As we saw time and time again, Excel has plenty of built-in tools that will ease your pain and make your life a lot easier. In the next chapter, we will continue to focus on how to prepare our data but we will take it to the next level. Advanced uses of formulas and conditional statements are introduced with simple-to-follow examples.
Argentina
Australia
Austria
Belgium
Brazil
Bulgaria
Canada
Chile
Colombia
Cyprus
Czechia
Denmark
Ecuador
Egypt
Estonia
Finland
France
Germany
Great Britain
Greece
Hungary
India
Indonesia
Ireland
Italy
Japan
Latvia
Lithuania
Luxembourg
Malaysia
Malta
Mexico
Netherlands
New Zealand
Norway
Philippines
Poland
Portugal
Romania
Russia
Singapore
Slovakia
Slovenia
South Africa
South Korea
Spain
Sweden
Switzerland
Taiwan
Thailand
Turkey
Ukraine
United States