Learning Outcomes

Introduction to Data Science

Programming Languages

Data Science Methodology

Data Science via Chatbot

Libraries, API’s, Datasets and GitHub

Lesson Summary

This module will introduce you to data science and its applications. You will gain knowledge of data science concepts, methodology as well as programming languages. Learners will be shown how to extract useful data from large chunks of data and evaluate it. You will learn how to create customer response systems and collaborate online for projects.

Data Science Masterclass for Beginners - Course assessment

Discover if data science is the right path for you by learning about its methodology and more in this free course.

Data Science Masterclass for Beginners

Have you ever wondered how businesses use the vast amounts of data they collect and store? This course will introduce you to some of the skills and tools necessary to work with the most valuable resource of today: data. Various topics are covered, including programming languages, data science methodology and collaboration. Take the first steps in getting involved in the vital task of helping organizations make sense of their information.

Data Entry Essentials and Skills

Advanced Data Entry Techniques and Tools

Building Your Data Entry Career

This module will introduce you to data entry and essential tools, data entry in Microsoft Word, and Microsoft Excel. Then you will learn about advanced data entry techniques and tools, data entry best practices and accuracy, and building your data entry career and portfolio.

Data Entry Tools and Techniques - Course Assessment

Learn how to enter data into Microsoft Word and Excel in this free online course that provides data entry training.

Data Entry Tools and Techniques

Before insights can be derived from data analysis, raw information needs to be fed into databases at low transactional levels. Various tools and techniques are used to make this happen. This data entry training course explains how to ensure proper storage and retrieval of essential information using technical, analytical and soft skills. We show you how to quickly input, update and validate data while maintaining accuracy and integrity.

Course Introduction

Viewing and Formatting Data

Basic Formulas in Excel

Referencing Data in Formulas

Data Quality

Removing and Identifying Data

Cleaning and Managing Data

Sort and Concatenation Data

Analyzing Data

This module will begin by helping you examine the basics of Excel. We will also help you find knowledge on the various types of data. This course will provide you with the opportunity to examine the various types of functions in Excel. You will have answers to questions like "How can reference data in Excel?" and "How to filter data in Excel?"

Basics of Data Analysis with Excel - Assessment

Master the fundamental concepts used to handle data and manipulate functions in this free online Excel training course.

Basics of Data Analysis with Excel

Microsoft Excel is a popular program that provides users with the ability to construct spreadsheets. We explore the basic concepts of Excel and explain how to employ various spreadsheet techniques. We show you how to use functions for data analysis. We discuss how to design the perfect formula and keep your data clean when placing it in a spreadsheet. Sign up to become a skilled Excel user capable of using this program to analyze data.

Understanding Data Entry

Preparing for Data Entry

Introduction to Data Entry Tools

Mastering Spreadsheets for Data Entry

Digital Forms and Database Interfaces

Automating and Enhancing Data Entry

Introduction to Optical Character Recognition and AI Tools

Ensuring Accuracy and Consistency

Managing Workflows and Time

Data Security and Confidentiality

Backup and Data Protection Strategies

Mastering Data Entry Tools and Techniques - Assessment

Learn how to improve efficiency, accuracy, and professionalism in data management tasks with this free online course.

Mastering Data Entry Tools and Techniques

Are you ready to transform your data entry skills into a profitable career? This comprehensive data entry course unlocks the secrets to professional accuracy and speed. Master essential spreadsheet techniques, digital forms, and database interfaces while building workflows that save time. This course was reviewed and approved by a qualified subject matter expert, Altin Kika, a data entry specialist. Enroll now and master data entry tools.

Manipulating Records in Tables

Creating Tables

Reports and Controls

Working With Queries

Types of Queries

In this module, you will learn how to navigate existing tables, edit records, sort data, filter records and use the find and replace features in Access. You will be taught the fundamentals of creating new tables and how to set field properties and what look-ups are used for. On top of this, you will learn how to define, create and manage controls, reports and queries.

Working with Forms

Rules for Normalized Tables

Table Design

Types of Relationships

In this module, you will learn how to create and manage forms. You will be taught how to explain Access to experts that are used to working with spreadsheets and codes. You will learn the rules of normalization, how to use primary keys, referential integrity and how the different types of relationships in databases are managed in Microsoft Access.

Excel and Access

Control Structures

Working with Macros

In this module, you will learn how to import excel into Access using the GUI as well as how to organize and structure data after importation. You will be shown how control structures are used for selection and looping, how macros, a simplified programming language are created and how to import Excel into Access using VBA which is also a program.

Microsoft Access Masterclass - Course Assessment

Learn the principles for the creation and proficient use of databases with Microsoft Access in this free online course.

Microsoft Access Masterclass

Databases are an important part of the information landscape and this free online Microsoft Access tutorial will show you how to proficiently leverage data with the use of Microsoft Access. You will learn how to design and build tables, forms, reports, controls and queries that work efficiently, access macros and program control structures in Visual Basic for Applications (VBA) as well as fix Excel data import errors.

MS Excel Interface and File Menu

MS Excel Home and Insert Menus

MS Excel Page Layout and Formulas Menus

This module will provide you with the knowledge to master the basic features of Microsoft Excel. You will learn how to use the MS Excel interface and also understand how to use the main elements within Excel menus such as the File Menu, Home menu, Insert menu, Layout menu, Formulas menu, Data menu, Review menu, and View menu.

MS Excel Data, Review and View Menus

MS Excel Templates, Dates, Numbers and Text

MS Excel Calculations, Page Setup, Printing & File Saving

This module will continue helping you understand how to use Excel main menus. You will learn how to use the Data menu, the Review menu, and View menu. You will also learn how to enter and manipulate data in Excel by learning how to use templates; deal with text, numbers, and calculations; set up pages and configure printing settings.

MS Excel: Manage and Report with Microsoft Excel (Basic) - Course Assessment

Learn how to use Microsoft Excel to manage data and boost office productivity in this free online spreadsheet course.

MS Excel: Manage and Report with Microsoft Excel (Basic)

This Microsoft Excel tutorial from Crafty E-Learning provides the training you need to use this powerful spreadsheet program like a pro. We explain how to manage, analyse and interpret data and statistics efficiently. Knowing how to use Excel is a must-have skill for any modern professional. This course focuses on Excel 2016 but also covers other versions like the 2013, 2019 and 2021 editions. Sign up to improve your data management skills.

Launching, Exploring and Navigating Access

Creating and Testing a New Database

Getting Help in Microsoft Access

Getting Started with Access - Quiz

In this module, Getting Started with Access, students will learn about the basics when starting with Microsoft Access. Students will learn about launching, exploring, and navigating Access. The module will also talk about creating and testing a new database. The module will then talk about getting help in Microsoft Access.

Modifying and Navigating Records

Working with Records

Creating and Configuring Lookups

Working With Table Data - Quiz

In this module, Working with the data table, students will learn about using the data table in Microsoft Access.Students will start by learning about modifying and navigating records. The module will then go over working with records. Students with end the module by creating and configuring lookups.

How to Create and Use a Query

Filtering Out Data in a Query

Working with Calculations in a Query

Querying a Database - Quiz

In this module, Querying a Database, students will learn about using a query in Microsoft Access. Students will start by learning about how to create and use a query. The module will then cover filtering out data in a Query. The module will wraps up with working with calculations in a query

Creating a Query with Single and Multiple Parameters

Creating Action Queries

Working with Unmatched and Duplicate Queries

Creating a Crosstab Query

Creating Advanced Queries - Quiz

In this module, Creating Advanced Queries, students will learn about advanced queries in Microsoft Access. Students will learn about. Creating a query with single and multiple parameters. The module will then talk about working with unmatched and duplicate queries. Students will wrap up the course with creating a crosstab query.

Creating a Report

Adding and Adjusting Report Control

Enhancing the Appearance of a Report

Preparing Reports for Print

Generating Reports - Quiz

In this module, Generating Reports, students will learn about creating reports in Microsoft Access 2013. Students will learn about adding and adjusting report control. The module will then cover enhancing the appearance of a report. Students will then wrap up the course with preparing reports for print.

Exploring the Access Environment

Customizing the Access Environment - Quiz

In this module, Customizing the Access Environment, students will learn about the Access Environment interface in Microsoft Access 2013. Students will learn about exploring the Access Environment and customizing the environment. This this the last thing students will learn before the course assessment.

Diploma in Microsoft Access 2013 Basic Online Training - Assessment

Learn about making databases in Microsoft Access 2013 with this free online course.

Diploma in Microsoft Access 2013 Basic Online Training

This free online course, Microsoft Access 2013 Basic Online Training. Students will learn about working with table data. The course will also cover querying a database. It then shows how to create an advanced queries. Students will then learn about generating reports. The course wraps up with customizing the access environment. So, why wait? Start this course today and learn about Microsoft Access 2013.