Add On Course
ADVANCED DATABASE MANAGEMENT USING MICROSOFT EXCEL
Brochure
Title
ADVANCED DATABASE MANAGEMENT USING MICROSOFT EXCEL
Since 2022-2023, Garhbeta College is offering this specialized training program which is certified the College itself.
Course Duration
30 Hours
Course Overview
This course provides an insight into advanced level database management through Ms Excel typically used in organization to summarize, analyze, explore and present visualizations of data. It helps to use advanced formulas and functions and enables learners to generate advanced excel skills necessary for computing and analyzing data for the purpose of making many policy decisions.
Objective
The course aims to achieve the following objectives:
-
• To impart knowledge on handling huge volume of data, filtering, sorting, aggregating and summarizing those into categories and subcategories.
-
• To develop knowledge focusing on advanced functions, formulas and productivity tools and deriving different statistical result.
-
• To assist in developing spreadsheet and process data using graphs, chart, diagrams, tables etc. to produced results in more sophisticated and timesaving ways.
-
• To impart skill of the learner on working with multiple spreadsheets and manipulation of data using Outline, Autofilter and Pivot Tables.
Learning Outcome
To outrun proficiency in Microsoft Excel and enable the learners to obtain flagship position as data analysts, data scientists, independent professionals and freelancers.
Curriculum for this Add-on Course
➤ Entering, Editing (4 hours):
➤ Working with Data: Marge Cells (4 hours):
➤ Formatting Data (4 hours):
➤ Copying and Pasting within the Same / from Another Worksheet (4 hours):
➤ Data from External Sources (4 hours):
➤ First Tutorial - 1 hour
➤ Filters and Sort (3 hours):
➤ Data Names and Ranges (3 hours):
➤ Manipulating Data (3 hours):
➤ Using Formulae and Functions to Manipulate and Analyze Data (3 hours):
➤ Basic Formulae and Use of Functions (3 hours):
➤ Second Tutorial - 1 hour
➤ Editing a Chart (3 hours):
➤ Using a Chart in a Word Document (3 hours):
➤ Colouring a Chart (3 hours):
➤ Types of Charts, 2D Chart, 3D Chart (5 hours):
➤ Inserting a Chart (5 hours):
➤ Data Analysis Using Charts and Graphs (5 hours):
➤ Third Tutorial - 1 hour
➤ Headers, Inclusion of Text, Numbers & Other Content that Displays at the Top (5 hours):
➤ Using Headers and Footers (5 hours):
➤ Summative Assessment
Assessment / Examination
1. Step 1 – Submission of assignments given by the resource persons
2. Step 2 – Viva-voce conducted by the college
Certification
After passing all the examinations listed above a student will be given a certificate from Garhbeta College.