Data Analysis with Excel is a comprehensive tutorial that provides a good insight into the latest and advanced features available in Microsoft Excel. It explains in detail how to perform various data analysis functions using the features available in MS-Excel. The training has plenty of screenshots that explain how to use a particular feature, in a step-by-step manner.

Prerequisites

• The readers of this tutorial are expected to have a good prior understanding of the basic features available in Microsoft Excel

Target Audience

• This training has been designed for all those readers who depend heavily on MS-Excel to prepare charts, tables, and professional reports that involve complex data. It will help all those readers who use MS-Excel regularly to analyze data.

Content

• Introduction
• Data Analysis Process
• Working with Range Names
• Tables
• Cleaning Data with Text Functions.
• Cleaning Data Containing Date Values
• Working with Time Values
• Conditional Formatting
• Sorting, Filtering
• Subtotals with Ranges
• Quick Analysis
• Lookup Functions
• PivotTables
• Data Visualization
• Data Validation
• Financial Analysis
• Working with Multiple Sheets
• Formula Auditing
• inquire
• Step Chart
• Box and Whisker Chart
• Histogram
• Pareto chart
• organization chart

Computer and software technology today has become a primary necessity in the job. In this 21st century, all the companies expect the graduates to be employed already have the basic ability to perform everyday tasks using the technology. In addition, with the increasing competition in the world of work today, the students need to have an additional competence and professional certification to obtain the advantages of the other. Certification to be obtained are usually quite expensive and students must take the extra time to get it. Therefore, to answer all these challenges Ebiz Infotama Interindo as a Microsoft Partner in Indonesia to make a program that was named DAT Program, where DAT Program is a certification program from Microsoft Partner that aims to provide expertise in the field of Microsoft Office because it can not be denied also that in every job and profession using Microsoft Office. By following the DAT program, the graduate student / students not only get a diploma from where they seek knowledge but also get an Competence Certificate whose testimony has been recognized in Indonesia. So that the students / students are expected to actually have the expertise and are ready to apply the latest technology in college and the workplace.

The benefits are as follows:

Instance:

1. Meeting the demands of a better education level by scoring graduates who have the title of  "GRADUATE PLUS",
2. The registration process is simple and easy,
3. No need to make certain capital investments,
4. No need to spend capital for research and development,
5. Educational institutions supported by the Train the Trainer Program,
6. Technical support,
7. This program supporting accreditation,
8. The program DAT has been accredited A from "DISPENDIK"

Student:

1. Student Pack and Curriculum MS Office include MS Word, MS Excel, MS PowerPoint and MS Outlook,
2. Industry Certification: Certification of Ebiz Education Enterprise as the Microsoft Learning Solutions, where the latter will receive a certificate students from Microsoft Learning Solution,
3. Cost of affordable,Cost of affordable,
4. Diploma attendant,
5. Can continue to MOS certificate or BNSP Certificate.

Certificate:

1. Elementary Level
2. Professional Level

Ref: microsoft

Akreditas A:

for detail information education sales