Stride
Home
More
Login/Register
Stride
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 1 - Freeze Panes
Freeze Panes Example 2
Skip to main content
File
Freeze Panes Example 2
Completion requirements
View
Click
Freeze Panes Example 2.mp4
link to view the file.
◄ Freeze Panes Example 1
Jump to...
Jump to...
Instructions
Freeze Panes Example 1
Working File: Freeze Panes
Removing Duplicate Values
Working File: Removing Duplicate Values
Match Scenario
Match
Working File: Match
And
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
Working File: Freeze Panes ►
Stride
Copyright © 2024 Peritum Agri Institute. All Rights Reserved.