Learning Outcomes

Data Entry Essentials and Skills

Advanced Data Entry Techniques and Tools

Building Your Data Entry Career

Lesson Summary

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

Controlling Data

IF's Functions

Lookup and Functions

Sorting and Various Functions

Understanding Date Functions

This module helps you understand the functions, features, and calculations that will be used in this course. You will also analyze examples that will help you grasp the processes studied, such as "improving readability." We will help you organize details related to various functions. We will help you answer: What is the Averageif function?

Intermediate Excel 2021 - Course assessment

This free online course is an intermediate Excel 2021 guide that describes the essential functions of this program.

Intermediate Excel 2021

This step-by-step guided course helps you learn essential functions in the program Microsoft Excel 2021. This course is a complete outlet to help you manage data. You will see what it can do for you and examine all its functions, including the use of formulas. We provide information to assist you in creating a spreadsheet that is readable and easy to navigate. We answer questions like ‘what is a function?’ or ‘why use a formula?’.

Introduction to Excel 2019  - Part 1

Creating Workbooks ✓

Saving Workbooks ✓

Navigating Workbooks ✓

Page Setup & Print Options ✓

Working with Rows, Columns and Cells ✓

Moving/re-ordering data ✓

Formulas & Function ✓

Working with Sheets ✓

Microsoft Excel 2019 Beginners - Assessment

Learn Microsoft Excel 2019 and conquer your spreadsheet demons with this free online Excel video  course.

Microsoft Excel 2019 Beginners

This free online Microsoft Excel 2019 course is perfect for those brand new to Excel and who are using Excel 2019 or Excel 365 editions. You'll learn everything from how to create basic formulas in Excel, to how to print the correct part of your spreadsheet! In this course, your expert author gives you a solid grounding, aided by Practice Exercises, in the basics of Excel and guides you to being more confident with spreadsheets.

Sorting Function

Filter And Conditional Formatting

Pivot Tables And What-If Analysis

This module will discuss Excel's sorting, filters, and pivot tables, and you will see how Excel can significantly contribute to effective data organization and analysis. You will learn that the sorting function enables users to arrange data in ascending or descending order based on selected criteria.

Vlookup and Hlookup Functions

Goal Seek And Data Table

Average, Median And Countif Functions

This module will cover the most powerful Microsoft Excel functions like VLOOKUP, HLOOKUP, and Goal Seek. You will learn that they are powerful tools that enhance data analysis and decision-making. You’ll also see that VLOOKUP is a function that enables users to search for a specific value in a vertical column and retrieve information.

Mastering Data Analysis Using Microsoft Excel – Course Assessment

Learn the hot topics of Big Data, Data Analysis, and Microsoft Excel formulas in this free online course.

Mastering Data Analysis Using Microsoft Excel

This course is an invaluable opportunity to gain insight into Data analysis and Microsoft Excel. The knowledge gained will give you the ability to make sense of your company’s data. In addition, you will have the competence to assist your company and managers in making informed decisions based on your data analysis. Discover the different Microsoft Excel formulas and tables that can help you reach your potential.

Introduction to Excel

Other Important Excel Functions

This module will teach you the fundamental and most commonly used Excel functions. You will learn proper syntax writing, functionalities, and how to use functions such as VlookUp, XlookUp, Sum, Average, Find, Concat, logical functions, and more.

Powerful Functions in Excel - Course Assessment

Learn the most important text, numeric, logical and lookup functions in Microsoft Excel in this free online course.

Powerful Functions in Excel

Microsoft Excel is a very popular data processing and organizing tool and this free online Microsoft Excel course will teach you the most useful functions in the program. You will discover the advantages of using Microsoft Excel and become familiar with its interface, how to create pivot tables along with the uses of the pivot table function including examples, as well as other popular features that will have you organizing data in no time.

Introduction to Spreadsheet and Excel Formulas

Microsoft Excel Functions

The IF Function in Microsoft Excel

This module will introduce you to the essential features of Microsoft Excel Formulas and Functions. The content will help you understand the basic parts of Excel, such as spreadsheets, formulas, functions, and error messages. Therefore, by the conclusion of this module, you will master each of these elements.

Advanced Functions I

Advanced Functions II

Advanced Functions III

This module introduces the advanced functions of Microsoft Excel. Altogether, this section will provide a simple approach to advanced tasks like; standard deviation, power functions and many more.

Microsoft Excel Formulas and Functions - Assessment

Learn how Microsoft Excel formulas and functions can make you a spreadsheet expert in this free online course.

Microsoft Excel Formulas and Functions

Microsoft Excel is a powerful tool that can help streamline your business processes and productivity but its many formulas, functions, and chart types to choose from can easily overwhelm you. Whether you are a beginner, intermediate or advanced user, this course offers plenty of shortcuts, tips and tricks to help you master Microsoft Excel by using the best formulas for your projects to increase business productivity.

Introduction to Excel 2021

Launching Excel

Exploring the Interface

The Backstage Area

Useful Keyboard Shortcuts

This module will begin by helping you study an introduction into Excel 2021 covering in fullness information like: Excel 2021 vs Excel for Microsoft 365, and how to launch Excel 2021. You will also study the interface and receive answers to questions like: What is the difference between Excel 2021 and Excel? Why use Excel 2021?

Working with Excel Templates

Working with Workbooks and Worksheets

Saving Workbooks and Worksheets

Entering and Editing Data

Navigating and Selecting Cells, Rows and Columns

This module will help you examine creating your first Excel spreadsheet. Also, you will be able to understand working with Excel templates and analyze working with workbooks and worksheets. Studying this module will help you answer: How would you be able to save workbooks and worksheets? How can you edit and enter data?

Formulas and Functions Explained

Finding the Average with the AVERAGE Function

Absolute vs Relative Referencing

What are Named Ranges?

Formatting Numbers and Cells

This module will begin by helping you study what are the formulas and functions inside Excel 2021, covering in fullness information like: Absolute vs Relative Referencing. You will also study named ranges and receive answers to questions like: What are named ranges? How can you apply formating to numbers and cells?

Excel 2021 for Beginners - Course assessment

This free online course is a basic Excel 2021 tutorial that describes the essential functions and uses of the site.

Excel 2021 for Beginners

This spreadsheet course helps you learn Microsoft Excel 2021, a complete platform to help you organize data. You will see what it can do for you and examine all the features, including the uses of its interface. We provide information to assist you in creating a spreadsheet and using the dashboard. We explain the helpful keyboard shortcuts and answer questions such as: ‘What are the most used formulas in Excel?’ and ‘What is named ranges?’.

Logical Tests and IF Statements

Sum with criteria

Lookups in Excel

Tables and Pivot Tables

Dynamic Arrays

In this module, you will gain the core Excel Skills every accountant or financial professional should know.  The skills include creating IF statements, Summing with criteria, Carrying out lookups, Analysing data with pivot tables, using tables to be more efficient.  You will also learn how to use the Excels new Dynamic Arrays.

Course assessment

Learn the core Microsoft Excel skills every accountant or financial professional needs in this free online course.

Core Excel Skills For Accountants and Financial Professionals

This course provides the fundamental Microsoft Excel skills that every accountant or financial professional requires. We cover important features from logical tests involving ‘IF’ statements to pivot tables and the new dynamic array functions. We teach you the key Excel features used daily in bookkeeping and to give financial presentations. This course provides valuable spreadsheet skills that can take your financial career to the next level..

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.

Introduction to Business Analysis

Merging and Looking Up Data

Making Better Decisions with IF

Preparing Data for Analysis

Microsoft Excel remains one of the best tools for data analysis. This course will focus on the specific functions, and formulas such as VLOOKUP, HLOOKUP, INDEX MATCH, and XLOOKUP that will help to conduct business or data analysis.

Final Assessment

Master Excel’s specific functions and formulae to conduct business analysis with this free online spreadsheet course.

Excel for Business Analysts

This free online spreadsheet course covers some of the most popular and useful functions used in Excel to analyze business and finance. We teach you how to use Excel functions such as ‘vlookup’, ‘hlookup’, ‘xlookup’, ‘index’ and ‘if’ to help you make better business decisions. This course is ideal for those who want to gain practical skills in Microsoft Excel to make business reports more compelling  and meaningful.

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.

Microsoft Excel Functions - Part I

Microsoft Excel Functions - Part II

Microsoft Excel Functions - Part III

In this module, you will be introduced to sine and radians functions, and also how to use standard deviation and average functions. You will further learn about how to use combined functions in Excel, and other important topics. These functions are needed for effective data analysis and management, allowing you to perform advanced calculations.

Microsoft Excel Functions - Part IV

Microsoft Excel Functions - Part V

Microsoft Excel Functions - Part VI

In this module, you will be introduced to count and round functions in Excel, and also how to use log and log10 functions. You will further learn about how to use degrees and arctan functions in Excel, and other important topics. Mastering these functions will enhance your efficiency in using spreadsheet software and make data organization easier.

Simplified Microsoft Excel Functions - Course Assessment

Get the knowledge needed to become a spreadsheet expert with this simplified Microsoft Excel functions online course.

Simplified Microsoft Excel Functions

In this free online course, you will be introduced to the most simplified Microsoft Excel functions that everyone must know for effective Excel usage. The knowledge of this course will enable you to become a spreadsheet expert and handle data analysis activities with ease. This course is best for beginner to advanced Microsoft Excel users, and examples have been provided to improve understanding. So wait no more and start now.

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.

Introduction to Formulas in Excel

Lookup Formulas

Decision Formulas

New Excel Functions

In this module, you will study how to use basic Excel formulas and functions and the process of inserting them correctly into your worksheet. Learn using the VLOOKUP formula to lookup data in a table, SUMIF to perform a conditional calculation IF to sort data according to a given logic, and Index Match to return the position of a value in a list.

Using Excel Named Ranges and Excel Tables

This module explains the strategies of applying different advanced Excel formula tools to build named ranges. You will learn to create an Excel table, use it as an advanced filter and edit that table with different formulas like RANDOM, NOW or INDIRECT.

Introduction to Pivot Tables

Working with Pivot Tables

Pivot Table Tricks

Excel's Data Model

This module explains the practices used to streamline your workflow in Excel using Pivot tables and Pivot charts. You will explore the ways of computing percentages, running totals, and ranking calculations without using a formula. The methods for displaying dynamic views of data using filters, slicers, and Pivot charts are also covered.

Mastering Data Analysis using Microsoft Excel: Formulas & Pivot Tables - Course Assessment

Learn how to develop and apply formulas and perform useful data analysis with this free online Microsoft Excel training.

Mastering Data Analysis using Microsoft Excel: Formulas and Pivot Tables

Did you know that Excel has become a prerequisite for almost all jobs in the analytics and consulting sector? Through this free online Microsoft Excel certification, you will gain the in-demand skills to generate and use lookup, conditional, and advanced Excel formulas and functions to conduct complex calculations, build professional reports as well as perform the data analysis and visualization of Excel tools, pivot tables and pivot charts.