1. Find and Replace: Knowing how to find and replace data in Excel will help you quickly get the information you look for and save you tons of time. In this chapter, we will introduce how to find or replace data, including special objects such as pictures, buttons etc. check more…
2. Data Sort: Sorting is one of the important skills in data analysis letting you quickly achieve the goal you work for. There are many different ways sorting your data such as value, color, background. In this chapter, we will introduce all these different data sorting methods, check more…
3. Data Filter: Filtering data is one of the skills that are similar to data sorting. Data filter will display the data you want, while data sorting will display all the data in a certain order. In this chapter, we will introduce filtering data with different rules such as selecting tops, larger or smaller a value, data between two values etc. check more…
4. Conditional Formatting: Conditional formatting will easily spot the trends and patterns with many different rules and help you visually identify the important data pieces, even in multiple columns and rows. It is very efficient identifying data by combining with data sorting or data filtering. In this chapter, we will introduce different formatting rules and make quicky find your data pieces, check more…
5. Fill Flash: Instead of typing the data manually, data fill and flash fill will automatically fill the rest cells with the existing data pattern and save you plenty of time. In this chapter, we will introduce how to use data fill and how to combine or separate data using flash fill, check more…
6. How to Insert: There are scenarios we need to have a picture, shape or SmartArt to make our work look better. In this chapter, we will introduce how to insert pictures, shapes and SmartArts that we cannot type directly from the keyboard in the same way as a number or text, check more…
7. VLOOKUP Function: VLOOKUP function is one of the most useful Excel lookup and reference functions. The function allows users to quickly look for a value in the leftmost column of a table, and then returns a value in the same row from the column you specified. In this chapter, we will introduce how to use vlookup match two tables, how to create a search box, and approximate search etc, check more…