Data analysis tools in Excel, February 2-14, 2017, AUA, Yerevan Armenia
This course had three components 1) inputting information in Microsoft® Excel® in the right format 2) right and logical use of analytics tools such as Pivot Tables, Subtotal function, consolidation tools, and many more, 3) optimizing your decision making while using analytics in Excel®.
In this three-week workshop you will:
- Familiarize yourself with the tools which will help you process and analyze data,
- Learn using the Excel® tools optimize ones calculations and data analysis helping operate quicker and more efficiently
- Automatize analytical processes which help avoid mechanical errors while working with Excel ®
The course includes studying the tools, watching practical examples, application of the learned tools to tasks both in classroom and at home, and further use the electronic materials provided in class.
Prerequisites: Basic knowledge of Microsoft® Excel® is required to take this course.
Enrollment: To enroll in AUA Extension courses, please go through the following steps (see below for the Armenian version):
- Visit im.aua.am.
- Create an account by clicking New User Registration.
- If you are not a new user and already have an AUA account (having previously taken the AUA e-Math Test or applied to AUA), you should log into the account that you had created at that time.
- If you just registered as a new user, you will get an email asking to activate your account.
- Now, for registering to take a course, choose the Extension tab, then Extension Applications, and apply for the course(s) you choose.
- After you register online, your application will be reviewed and you will receive an email acknowledging your application.
- Closer to the course start date, you will receive another email confirming your enrollment, requesting that you make payment before the course start date. The fee can be paid online via credit card or through the EasyPay terminal (located at the entrance to AUA). Alternatively, you may pay the fee via bank transfer to American University of Armenia Fund, account 001-006402-001, HSBC Bank Armenia, indicating your full name (as in the registration) and the course you are paying for.
- The completed application together with the record of payment completes your enrollment.