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 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.