Become a Successful Data Analyst
Data Analysis For Beginners Using Microsoft Excel and Access 2016
Training Objectives
- Design and manage spreadsheets
- Apply best practices
- Troubleshoot complex models
- Analyze large amounts of data with PivotTables and PivotCharts
- Query data
- Generate and customize charts to suit most purposes
- Create and design Access databases
- Work with Access tables, relationships, keys and constraints
- Manage and design interfaces with Access Forms
- Create basic to advanced reports
Course Details
Course Duration
4 Weekends
Course Price
₦ 40,000.00
Course Level
Beginner-Intermediate
Course Description
Data Analyst is one of the identified 10 jobs that are in-demand in today’s economy and is well positioned to continue to grow in the future, as such this provides huge opportunity to start a new career or grow the existing one in the data analysis and analytics field. This course will focus on Microsoft Access, one of the relational databases and Microsoft Excel which is the most commonly used spreadsheet application. Learning how to use Excel and Access is an investment in both your personal and professional life.
Microsoft Access is a database management system used for the collection of data stored in a computer system database that allows users to enter, access, update and analyze data quickly and easily. Excel makes it easy to evaluate data, monitor financial performance, such as business profit or loss, calculate payments on large purchases, plan a budget, or stay organized with checklists.
Key Features
- Data Validation, Formulas and Functions
- Designing Relational Database and Advanced Queries
- List/Table Essentials & Charting
- Pivot Tables, Protecting & Linking Data
- Data Forms and Reports
Student Reviews about This Course




Enroll & Join 7452 Happy Studentsu200b Today!
Enter description text here.Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.u200b