Working With Advanced Excel
Course Curriculum
Calculating data with advanced formulas
You will learn about using advanced formulas in MS-Excel for calculating data.
Organizing Worksheet and Table data
This module will teach you how to organize worksheet and table data in MS-Excel
Presenting Data Using Charts
This section will introduce you to Data Presentation and how to present your data using charts.
Analysing Data using pivot tables and pivot charts
You will learn about data analysis using Pivot tables and charts in MS-Excel.
Inserting graphic Objects
This module will teach you about inserting graphical objects in MS-Excel.
Customizing and Enhancing workbooks and the Excel environment
You will learn how to customize and enhance workbooks and Excel environment.
Streamlining workflow
This module will guide on how to streamline your workflow in MS-Excel by identifying and prioritizing tasks.
Collaborating with others
You will learn about working in collaboration with others in MS-Excel.
Auditing worksheets
This module will cover everything related to the audit process. You will learn how to audit worksheets in MS-Excel.
Analyzing data
This module will be all about data analysis; you will learn the procedures and steps involved in data analysis.
Working with multiple workbooks
This module will throw light on working with multiple workbooks at a time in MS-Excel.
Importing and Exporting data
You will learn about how to import and export your data in an MS-Excel environment.
Using Excel with the web
This module will guide you to use excel with the web. You can import and export data directly from the web.
Structuring workbooks with XML
This module will cover everything about structuring workbooks, and You will learn how to use XML for structuring your workbooks.
Automating business operations
You can also automate business operations using MS-Excel. This module will cover everything about business operations automation
Manipulating the Excel environment
In the last module, You will learn about Excel environment manipulation for efficient data analysis.
Python With Data Science
This program will help you build foundational skills in data analysis, data visualization, programming, and Relational Database Management Systems (RDBMS).
Learners will learn how to apply basic statistical methods for data analysis using Excel. Including how to visualize data using graphs. Learners will also be introduced to RDBMSs and learn how to use SQL to retrieve or manipulate data. Then, they will learn to program using Python. Python has become a preferred programming language in the world of analytics.
This program will help learners as they progress through their academic journey. It will lay the foundation for an important programming and data analysis skill that will be of immense value in their academic and professional lives.
Course Curriculum
The Program focuses on competency development. It is practice based i.e. learners learn by doing things rather than by watching videos or by attending traditional lectures. Curriculum will cover the following
Data Analytics Using Excel
Learn to analyze numerical and categorized data using MS Excel as a tool. Use Descriptive Statistical techniques to analyze the data. Visually present the analysis using graphs & charts in MS Excel
Analytics using SQL
Learn to represent data in the form of tables in a Relational Database. Create, update, and retrieve data stored in a MySQL (RDBMS) database. Use Structured Query Language (SQL) to perform various operations on the database.
Introduction to Programming using Python
Learn to apply problem-solving techniques to decompose a problem into computational steps. Then translate the steps into a program using the Python language.
Python for Data Science (Using NumPy and Pandas libraries)
Use the NumPy and Pandas libraries in Python to perform data analysis.
Exploratory Data Analysis (EDA)
Introduction to Exploratory Data Analysis
Basics of computer :Ms office
Course Curriculum
- Word processors.
- Spreadsheets.
- Database systems.
- Presentation software.
- E-mail tools.