Most platforms, programs and applications in the world rely on databases to run seamlessly and so this course is designed to help learners get a better understanding of how to design and implement database concepts.
Apart from learning how to create, format, present, and extract data, learners will also understand how to analyse and validate data from multiple sources and create reports from them to aid decision making. This course will not be specific to any particular database management system, but the skills learnt applies to any of the databases. MS Excel will be used for all practical demonstrations and tasks.
From making simple accounting ledgers to generating pivot tables and dashboards to visualise data, the capabilities of Excel make it by far the most popular among programs and practically indispensable in the office setting. A large proportion of office-based jobs mandate a good understanding of Excel as a prerequisite.
It is used extensively in areas such as data entry, data management, programming, time management, task management, customer relationship management, charting, graphing, statistics, accounting, and financial analysis.
Typical job roles include Administrative Assistants, Office Clerks, Data Entry Staff, Market Analysts, Educators, Support Staff, Financial Analysts, Investment Bankers, Statisticians, Investment Bankers, Research Analysts, Content Managers, Project Coordinators, Office Managers, Senior Managers and Decision Makers among others.
The value of data and its role in the organisation
Data types and formats
Ethical and legal implications applicable to data
Data quality and validation
Storing, organising, manipulating and analysing data in Excel
Importing external data into Excel
Data sorting and formatting in Excel
Formulas and functions in Excel
Formatting and customising charts in Excel
Data analysis techniques in Excel
Report creation and communication in Excel
Pivot tables and power pivots
Data validation techniques in Excel
Building and using interactive dashboards
Project Work and the path ahead
All our skills bootcamps are delivered remotely using MS teams and using one of three course structures:
Online learning delivered remotely through Zoom, Meets, Teams, etc (breakout rooms used for team tasks).
Description for this block. Use this space for describing your block. Any text will do.
|COURSE CODE||COURSE||START DATE||END DATE||LENGTH||DAYS OF WEEK||TIME||LOCATION|
|CXDBADD6||Excel Advanced Database Design||28/02/2022||11/03/2022||2 weeks||Mon-Fri||9.00am-4.00pm||Online|
This course is suitable for learners of all academic backgrounds.
Learners should have basic ICT, access to a PC and the internet as well as access to Microsoft Excel 2019 or higher.
A basic understanding of Excel is required to do this course, but coding or design experience is not essential.