With the huge amount of data that must be handled and analyzed every day, it is imperative that you learn how to use a flexible tool to handle equations and statistics professionally, and Microsoft Excel is the most popular tool for doing so. Training will provide participants with the knowledge and skills they need to comprehend organizational intelligence through the ability to deal with functions, analyzing vast amounts of data, extracting accurate, actionable information, and presenting that to decision makers.
At the end of the training program, the participant should be able to:
1 Define Cell Ranges and Reference Them in Formulas
2 Perform Conditional Calculations
3 Carry Out Logical and Specialized Functions
4 Work with Date and Time Functions
5 Understand and Execute Text Functions
1 Sort and Filter Data
2 Learn the Capabilities of Database Functions
3 Query Data with Database Functions
4 Outline and Subtotal Data
1 Build and Modify Tables
2 Create Formatting Rules
3 Apply Conditional Formatting to Alter Groups of Cells
1 Organize and Represent Data with Charts
2 Modify and Format Charts
3 Search for and Replace Data.
4 Discover and Implement Advanced Chart Features
1 Create a Pivot Table
2 Analyze Pivot Table Data
3 Present Data with Pivot Charts
4 Filter Data Using Timelines and Slicers
Not Available
Names of the training programs that are integrated (enriched) with the training program:
Names of the training programs that after the training program:
Not Available
Add Comment