About This Course

Excel is widely used in various activities to bring data together, clean, process and visualize using interactive charts. Excel makes it easy to crunch numbers, and you can streamline data standardization and fix several data issues such as misspelled words, stubborn trailing spaces, unwanted prefixes, inconsistant cases, and nonprinting characters. Additionally, using Power Query (formarly known as Get and Transform Data), you can import or connect to external data, and then combine and/or shape that data the way you want, e.g. remove columns, change data types, or merge tables, etc.

During this training course iMMAP trainer will train you on the following key topics in Excel:

• Data Cleaning and standardize in excel
• Pivot Tables
• Charts and Pivot Charts
• Power Quer