Course Duration
2 Weekends
Course Price
₦ 30,000.00
Course Level
Beginner-Intermediate
Course Overview
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.
What You Will Learn
- Sort and filter more extensive data and to calculate their subtotals.
- Derive new data by calculating them through formulas and functions.
- Query data and create basic to advanced reports
- Analyze large amounts of data with PivotTables and PivotCharts
- 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
Course Requirements
- Microsoft Excel 2016 desktop version for Windows installed your laptop
- Basic knowledge of any computer application
