Stride
Home
My Courses
Learning Pathways
Intro to Learning Paths
Customer Champions
Mastering Management
Supervisory Essentials
The Grain Handler
The HR Advisor
The Professional Secretary
The Relationship Manager
The Retail Specialist
The Successful Salesman
Young Leaders
Corporate
Interested in courses for your business or team?
Support
Getting started
FAQ
Get In Touch
More
Login/Register
Stride
Home
My Courses
Learning Pathways
Intro to Learning Paths
Customer Champions
Mastering Management
Supervisory Essentials
The Grain Handler
The HR Advisor
The Professional Secretary
The Relationship Manager
The Retail Specialist
The Successful Salesman
Young Leaders
Corporate
Interested in courses for your business or team?
Support
Getting started
FAQ
Get In Touch
Login
Sign up!
support@peritumagri.com
×
Login to your account
Don't have an account?
Sign up!
Remember username
Lost password?
Log in
Global searching is not enabled.
E/LMS 716 Excel Advanced
Home
Courses
E/LMS 716
Lesson 4 - Logical Functions
And
Skip to main content
File
And
Completion requirements
View
Click
And.mp4
link to view the file.
◄ Working File: Match
Jump to...
Jump to...
Instructions
Freeze Panes Example 1
Freeze Panes Example 2
Working File: Freeze Panes
Removing Duplicate Values
Working File: Removing Duplicate Values
Match Scenario
Match
Working File: Match
IF_And
Working File: And
Nested IF Scenario
Nested IF
Working File: Nested IF
CountIFS Example 1
CountIFS Scenario 1
CountIFS Scenario 2
Working File: CountIFS
Vlookup Scenario 1
Vlookup Scenario 2
Vlookup Scenario 3
Hlookup Scenario 1
Hlookup Scenario 2
Working File: Lookups
Applying The Table
Total Row
Quick Analysis Formatting
Quick Analysis Pivot Chart
Working File: Table
What is a Slicer
Applying the Slicer
Slicer Setup
Working File: Slicer
Sparklines
Working File: Sparklines
Very Hidden
Working File: Very Hidden
Pivot Table Definition
Ways to create a Pivot Table
Creating a Pivot Table
Calculation Features
Adding a chart to a Pivot Table
Display the Pivot Field List
Defer Layout Update
Working File: Pivot Tables
What Is a Macro
Macro Setup
Record a Macro
Macro Shortcut Key
Running The Macro
Saving a Macro
Edit The Macro With Visual Basic
Working File: Macro
Joining Two or More Cells
Working File: Joining Cells
IFERROR Scenario
IFERROR
Working File: IFError
Validation Scenario
Conditional Validation
Working File: Validation
Random Numbers
Working File: Random Numbers
Conditional Validation Scenario
Step 1
Step 2
Step 3
Working File: Conditional Validation
Flash Fill Example 1
Flash Fill Example 2
Working File: Flash Fill
Mode
Working File: Mode
Instructions
How to upload my assessment.
Name_Surname Excel Final Skills Assessment
Upload your file here
Participant Feedback
IF_And ►
Stride
Copyright © 2024 Peritum Agri Institute. All Rights Reserved.