Manipulating Data Effectively with Microsoft Excel

These days, any managerial or analyst role requires that you work with data. Excel remains one of the most powerful and easy to use tools when it comes to crunching data. Learning Excel in a proper, structured way not only can help you save time, but also can help you become better at your job and give you time to focus on things and people that matter.

This is an ideal course for users who desires to manage data, sort and filter, analyze data, and learn to automate some common Excel tasks.

In this training you will learn:

• Extract Data into Excel - Microsoft Query, Import/Export Text Files.

• Data Cleansing - Remove Duplicates, Change Case, Removing Spaces and Nonprinting Characters from Text, Merging, Text to Column.

• Data Managing - Advanced Filtering, Extract Specific Columns to Another Worksheet, Setting Up the Criteria Range, Using Wildcards in Criteria, Filter Unique Records, Computed Criteria, Database Functions, Autofilter, Advanced Autofiltering, Filter by Color, Sorting, Custom Sorting, Custom Lists, Sorting Multiple Levels, Subtotal Command, Outline, View.

• Table Formatting - Reconciling table data by matching, Tables, Convert the Table to Range, Table Formulas.

• Advanced Formulas - If/Nested If, And/Or, If + And, If + Or, Count/Counta/Countblank, Countif/Countifs, Sumif/Sumifs, Averageif/Averageifs, Splitting.

• Macro -  Activate the Developer Tab, Set Excel Macro Security, Record a Macro, Stop Recording a Macro, Run a Macro, Delete a Macro, Save a Macro.