Overview:
Excel is a great tool to record, store, and sort information, especially numerical facts and figures. But the real versatility of this program can be found by using formulas to calculate data. Excel can do a lot of number crunching, even on older computers. In order to make the most of formulas, you need to understand the bits and pieces that are used to create them.
In this course, we will cover all the key concepts to get you started with formulas.
Learning Objectives
In this course you will learn how to:
-
Use formulas in Excel
-
Use functions in Excel
-
Work with names and ranges
-
Work with array formulas
Course Content Outline
Section 1.1: Using Formulas in Excel, Part 1
-
Understanding Relative and Absolute Cell References (Part One)
-
Understanding Relative and Absolute Cell References (Part Two)
-
Understanding Relative and Absolute Cell References (Part Three)
-
Understanding Relative and Absolute Cell References (Part Four)
-
Understanding Relative and Absolute Cell References (Part Five)
-
Understanding Basic Mathematical Operators (Part One)
-
Understanding Basic Mathematical Operators (Part Two)
-
Understanding Basic Mathematical Operators (Part Three)
-
Using Formulas with Multiple Cell References (Part One)
-
Using Formulas with Multiple Cell References (Part Two)
-
Using Formulas with Multiple Cell References (Part Three)
-
Using Formulas with Multiple Cell References (Part Four)
-
Using Formulas with Multiple Cell References (Part Five)
-
Using Formulas with Multiple Cell References (Part Six)
-
Using Formulas with Multiple Cell References (Part Seven)
-
Understanding the Formula Auditing Buttons (Part One)
-
Understanding the Formula Auditing Buttons (Part Two)
-
Understanding the Formula Auditing Buttons (Part Three)
-
Understanding the Formula Auditing Buttons (Part Four)
-
Understanding the Formula Auditing Buttons (Part Five)
-
Understanding the Formula Auditing Buttons (Part Six)
-
Understanding the Formula Auditing Buttons (Part Seven)
-
Understanding the Formula Auditing Buttons (Part Eight)
-
Understanding the Formula Auditing Buttons (Part Nine)
-
Understanding the Formula Auditing Buttons (Part Ten)
-
Understanding the Formula Auditing Buttons (Part Eleven)
-
Understanding the Formula Auditing Buttons (Part Twelve)
-
Understanding the Formula Auditing Buttons (Part Thirteen)
-
Understanding the Formula Auditing Buttons (Part Fourteen)
-
Understanding the Formula Auditing Buttons (Part Fifteen)
-
Understanding the Formula Auditing Buttons (Part Sixteen)
-
Understanding the Formula Auditing Buttons (Part Seventeen)
-
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.2: Using Formulas in Excel, Part 2
-
Fixing Formula Errors (Part One)
-
Fixing Formula Errors (Part Two)
-
Fixing Formula Errors (Part Three)
-
Fixing Formula Errors (Part Four)
-
Modifying Error Checking Options (Part One)
-
Modifying Error Checking Options (Part Two)
-
Displaying and Printing Formulas (Part One)
-
Displaying and Printing Formulas (Part Two)
-
Displaying and Printing Formulas (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)
-
Skill Sharpener
Section 1.3: Exploring Excel Functions
-
What are Functions? (Part One)
-
What are Functions? (Part Two)
-
Finding the Right Functions (Part One)
-
Finding the Right Functions (Part Two)
-
Inserting Functions (Part One)
-
Inserting Functions (Part Two)
-
Inserting Functions (Part Three)
-
Some Useful and Simple Functions
-
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
Section 1.4: Using Functions in Excel
-
Using the IF Function (Part One)
-
Using the IF Function (Part Two)
-
Using the IF Function (Part Three)
-
Working with Nested Functions (Part One)
-
Working with Nested Functions (Part Two)
-
Breaking up Complex Formulas (Part Three)
-
Breaking up Complex Formulas (Part Four)
-
Breaking up Complex Formulas (Part Five)
-
Using Functions and AutoFill to Perform Difficult Calculations (Part One)
-
Using Functions and AutoFill to Perform Difficult Calculations (Part Two)
-
Using Functions and AutoFill to Perform Difficult Calculations (Part Three)
-
Using Functions and AutoFill to Perform Difficult Calculations (Part Four)
-
Using Functions and AutoFill to Perform Difficult Calculations (Part Five)
-
Using Functions and AutoFill to Perform Difficult Calculations (Part Six)
-
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.5: Working with Names and Ranges
-
What are Range Names? (Part One)
-
What are Range Names? (Part Two)
-
What are Range Names? (Part Three)
-
Defining and Using Range Names (Part One)
-
Defining and Using Range Names (Part Two)
-
Defining and Using Range Names (Part Three)
-
Defining and Using Range Names (Part Four)
-
Defining and Using Range Names (Part Five)
-
Defined Names Commands (Part One)
-
Defined Names Commands (Part Two)
-
Defined Names Commands (Part Three)
-
Selecting Nonadjacent Ranges (Part One)
-
Selecting Nonadjacent Ranges (Part Two)
-
Using AutoCalculate (Part One)
-
Using AutoCalculate (Part Two)
-
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.6: Working with Array Formulas
-
What are Array Formulas? (Part One)
-
What are Array Formulas? (Part Two)
-
Defining Basic Array Formulas (Part One)
-
Defining Basic Array Formulas (Part Two)
-
Defining Basic Array Formulas (Part Three)
-
Defining Basic Array Formulas (Part Four)
-
Defining Basic Array Formulas (Part Five)
-
Defining Basic Array Formulas (Part Six)
-
Using Functions within Array Formulas (Part One)
-
Using Functions within Array Formulas (Part Two)
-
Using Functions within Array Formulas (Part Three)
-
Using Functions within Array Formulas (Part Four)
-
Using Functions within Array Formulas (Part Five)
-
Using the IF Function in Array Formulas (Part One)
-
Using the IF Function in Array Formulas (Part Two)
-
Using the IF Function in Array Formulas (Part Three)
-
Using the IF Function in Array Formulas (Part Four)
-
Using the IF Function in Array Formulas (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
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