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 11 - Pivot tables
Ways to create a Pivot Table
Skip to main content
File
Ways to create a Pivot Table
Completion requirements
View
Click
Four ways to create a Pivot Table.mp4
link to view the file.
◄ Pivot Table Definition
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
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
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
Creating a Pivot Table ►
Stride
Copyright © 2024 Peritum Agri Institute. All Rights Reserved.