Overview:
Excel is capable of doing just about anything involving data calculation. It is a very capable program for managing small databases. The word “database” might seem intimidating, but what you need to understand is that in its pure form, a database is nothing more than a table of data stored in a grid-like structure.
In this course, you will be introduced to tables, a great feature for separating data in a worksheet and the starting point for all databases, large and small.
Learning Objectives
In this course you will learn how to:
-
Work with tables
-
Work with records and fields
-
Work with tables and filters
-
Use Excel as a database
Course Content Outline
Section 1.1: Working with Tables
-
What is a Table? (Part One)
-
What is a Table? (Part Two)
-
Creating Tables (Part One)
-
Creating Tables (Part Two)
-
Creating Tables (Part Three)
-
Creating Tables (Part Four)
-
Creating Tables (Part Five)
-
Modifying Tables (Part One)
-
Modifying Tables (Part Two)
-
Modifying Tables (Part Three)
-
Modifying Tables (Part Four)
-
Using the Table Tools – Design Tab (Part One)
-
Using the Table Tools – Design Tab (Part Two)
-
Using the Table Tools – Design Tab (Part Three)
-
Using the Table Tools – Design Tab (Part Four)
-
Using the Table Tools – Design Tab (Part Five)
-
Using the Table Tools – Design Tab (Part Six)
-
Using the Table Tools – Design Tab (Part Seven)
-
Using the Table Tools – Design Tab (Part Eight)
-
Using the Table Tools – Design Tab (Part Nine)
-
Adding a Total Row (Part One)
-
Adding a Total Row (Part Two)
-
Adding a Total Row (Part Three)
-
Step-By-Step (Part One)
-
Step-By-Step (Part Two)
-
Step-By-Step (Part Three)
-
Step-By-Step (Part Four)
-
Step-By-Step (Part Five)
-
Step-By-Step (Part Six)
-
Step-By-Step (Part Seven)
-
Skill Sharpener
Section 1.2: Working with Records and Fields
-
What are Records and Fields? (Part One)
-
What are Records and Fields? (Part Two)
-
Adding Fields by Inserting Columns (Part One)
-
Adding Fields by Inserting Columns (Part Two)
-
Adding Records by Inserting Rows (Part One)
-
Adding Records by Inserting Rows (Part Two)
-
Quickly Adding Records to a Data Table (Part One)
-
Quickly Adding Records to a Data Table (Part Two)
-
Deleting Records or Fields (Part One)
-
Deleting Records or Fields (Part Two)
-
Cleaning up Duplicate Records (Part One)
-
Cleaning up Duplicate Records (Part Two)
-
Cleaning up Duplicate Records (Part Three)
-
Cleaning up Duplicate Records (Part Four)
-
Cleaning up Duplicate Records (Part Five)
-
Step-By-Step (Part One)
-
Step-By-Step (Part Two)
-
Step-By-Step (Part Three)
-
Step-By-Step (Part Four)
-
Step-By-Step (Part Five)
-
Step-By-Step (Part Six)
-
Skill Sharpener
Section 1.3: Working with Tables and Filters
-
Sorting Data in a Table (Part One)
-
Sorting Data in a Table (Part Two)
-
Sorting Data in a Table (Part Three)
-
Sorting Data in a Table (Part Four)
-
Sorting Data in a Table (Part Five)
-
What is an AutoFilter? (Part One)
-
What is an AutoFilter? (Part Two)
-
What is an AutoFilter? (Part Three)
-
What is an AutoFilter? (Part Four)
-
What is an AutoFilter? (Part Five)
-
Creating a Custom AutoFilter (Part One)
-
Creating a Custom AutoFilter (Part Two)
-
Creating a Custom AutoFilter (Part Three)
-
Creating a Custom AutoFilter (Part Four)
-
Using an Advanced Filter (Part One)
-
Using an Advanced Filter (Part Two)
-
Using an Advanced Filter (Part Three)
-
Using an Advanced Filter (Part Four)
-
Using an Advanced Filter (Part Five)
-
Using an Advanced Filter with Logical Statements (Part One)
-
Using an Advanced Filter with Logical Statements (Part Two)
-
Using an Advanced Filter with Logical Statements (Part Three)
-
Using an Advanced Filter with Logical Statements (Part Four)
-
Copying Filtered Records (Part One)
-
Copying Filtered Records (Part Two)
-
Copying Filtered Records (Part Three)
-
Copying Filtered Records (Part Four)
-
Copying Filtered Records (Part Five)
-
Copying Filtered Records (Part Six)
-
Copying Filtered Records (Part Seven)
-
Step-By-Step (Part One)
-
Step-By-Step (Part Two)
-
Step-By-Step (Part Three)
-
Step-By-Step (Part Four)
-
Step-By-Step (Part Five)
-
Step-By-Step (Part Six)
-
Step-By-Step (Part Seven)
-
Step-By-Step (Part Eight)
-
Step-By-Step (Part Nine)
-
Skill Sharpener
Section 1.4: Using Excel as a Database
-
Filtering with Wildcard Characters (Part One)
-
Filtering with Wildcard Characters (Part Two)
-
Filtering with Wildcard Characters (Part Three)
-
Filtering with Wildcard Characters (Part Four)
-
Validating your Data (Part One)
-
Validating your Data (Part Two)
-
Validating your Data (Part Three)
-
Validating your Data (Part Four)
-
Validating your Data (Part Five)
-
Validating your Data (Part Six)
-
Validating your Data (Part Seven)
-
Validating your Data (Part Eight)
-
Validating your Data (Part Nine)
-
Validating your Data (Part Ten)
-
Data Validation using Lists (Part One)
-
Data Validation using Lists (Part Two)
-
Data Validation using Lists (Part Three)
-
Data Validation using Lists (Part Four)
-
Data Validation using Lists (Part Five)
-
Data Validation using Lists (Part Six)
-
Data Validation using Formulas (Part One)
-
Data Validation using Formulas (Part Two)
-
Data Validation using Formulas (Part Three)
-
Using Database Functions (Part One)
-
Using Database Functions (Part Two)
-
Using Database Functions (Part Three)
-
Using Database Functions (Part Four)
-
Using Database Functions (Part Five)
-
Using Database Functions (Part Six)
-
Using Database Functions (Part Seven)
-
Using Database Functions (Part Eight)
-
Using Database Functions (Part Nine)
-
Using Database Functions (Part Ten)
-
Step-By-Step (Part One)
-
Step-By-Step (Part Two)
-
Step-By-Step (Part Three)
-
Step-By-Step (Part Four)
-
Step-By-Step (Part Five)
-
Step-By-Step (Part Six)
-
Step-By-Step (Part Seven)
-
Step-By-Step (Part Eight)
-
Skill Sharpener
Case Study
Review Questions
How to enroll
Option 1 (ideal for employee training)
To enroll your staff, please send the following to staffelearning@learnsmart.com.ng:
-
Name(s) of staff
-
E-mail address of each staff
-
Name and e-mail address of the primary contact person in your organization
-
Name and e-mail address of the person who will be receiving periodic training report, if different from the person in number (3).
Once we receive the above information, we will send you an invoice for payment to be made. After payment, we will brand a learning portal for your organization, enroll your staff, and send emails with theirunique login information and how to start training.
Option 2
Click on the "Enroll For This Course" button, checkout and make payment with your ATM card. You will receive youruniquelogin information by email and start training.
Option 3
Pay or transfer course fee into any of our bank accounts listed below and notify us through enroll@learnsmart.com.ng. We will register you and instantly email your unique login information for you to start training.
Our Bank Account Information:
Account Name: Paradigm Learning Services
Zenith Bank: Account No: 1013876190
GTBank: Account No: 0159084910
Access Bank: Account No: 0047876850