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 715 Excel Intermediate
Home
Courses
E/LMS 715
Lesson 9 - Conditional Format
Working File: Conditional Format
Skip to main content
File
Working File: Conditional Format
Completion requirements
View
Click
Conditional format.xlsx
link to view the file.
◄ Conditional Format Example 3
Jump to...
Jump to...
Instructions
Absolute Referencing
Relative Reference
Working File: Relative and Absolute Referencing
Scenario
Count
CountA
CountBlank
CountIF
Working File: Count
IF Example 1
Working File: IF Example 1
IF Example 2
Working File: IF Example 2
SumIF
Working File: SumIF
Setting The Scenario
Payment
Working File: Payment
Goal Seek Example 1
Goal Seek Example 2
Working File : Goal Seek
One data Table
Working File: One Data Table
Two Data Table
Working File: Two Data Table
Validation of Numbers
Validation on Time
Validation List
Input Message
Stop Alert
Warning Error Alert
Removing a Validation
Working File: Validation
Applying The Filter
Customize Filter
Removing Blank Rows
Removing The Filter
Working File: Autofilter
Conditional Format Example 1
Conditional Format Example 2
Conditional Format Example 3
Chart Scenario
Creating a Chart
Chart Styles
Adding a Data Series
Adding Labels To a Chart
Apply a Filter To a Chart
Scale The Axis
Axis Reverse Order
Working File: Charts
Headers And Footers
Working File: Headers And Footers
Applying Subtotal To a List
Adding a Subtotal
Removing Subtotal
Working File: Subtotals
Linking Cells
Linking Sheets Tabs
Linking Workbooks
Array Links
Paste Link
Working File: Main Database
Working File: Linking
Printing Overview
Gridlines And Column Headers
Page Breaks
Page Setup - Headers And Footers
Page Setup - Margins
Page Setup - Page
Page Setup - Print Area
Page Setup - Rows To Repeat
Print Only The Active Sheets
Working File: Database
Protection Scenario
Method
Setting up The Protection
Applying The Protection
Testing The Protection
Protect Workbook
Saving File With a Password
Opening a File With a Password
Protection: Working File
Control And Tab
Control And Enter
Working File: Control And Enter
Clipboard Example 1
Clipboard Example 2
Working File: Clipboard
Finding And Removing Blanks
Working File: Blanks
Snap Objects To Cell Borders
Working File: Alignment Of Objects
Sort Using a Custom List Criteria Example 1
Sort Using a Custom List Criteria Example 2
Working File: Sorting According To a Custom List
Bullets
Working File: Bullets
Growth Trend
Working File: Growth Trend
Working file to use to answer the questions.
Post-Assessment
Participant Feedback
Chart Scenario ►
Stride
Copyright © 2024 Peritum Agri Institute. All Rights Reserved.