Conditional Formatting with Formulas in Excel
ipd113•3 class hrs
So you want to be able to find information based on different criteria like dates for deadlines, at-risk items or budget items? Learn how easy conditional formatting is to use and apply specific formatting to cells that meet certain criteria. It is most often used as color-based formatting to highlight, emphasize, or differentiate among data and information stored in a spreadsheet. You will locate, sort and remove duplicates, create drop-down lists to instantly find and highlight records on any worksheet. You will find text contained in larger text entries, locate and highlight records by date and date ranges, highlight top and bottom ranking records by value and percentage. You will trace values above or below average, apply data bars, color scales and icon sets to your data. Why learn it? Conditional formatting is a fantastic way to quickly visualize data in a spreadsheet. With conditional formatting, you can do things like highlight dates in the next 30 days, flag data entry problems, highlight rows that contain top customers, show duplicates, and more.
All MNTC instruction and curriculum is provided in English unless specifically stated otherwise.
IPD110 Excel 2019 Essentials or basic Excel knowledge. Students who may want to save their work are encouraged to bring a USB flash drive or have access to cloud storage.
It is the policy of the technology center board of education that students who have paid tuition for adult programs be given full or partial refunds under conditions stated in established guidelines.
A 1098-T Tuition Statement provides documentation you may be able to use to apply for education tax credits when you file your tax return. If you decline to provide your Social Security Number, we will not be able to provide you with a 1098-T.
If you would like to receive a 1098-T form, please provide the name filed on your income taxes and social security number using the provided link. Forms can be delivered in person to either campus or mailed to the following address;
Moore Norman Technology Center
Attn: Bursar
PO Box 4701
Norman, OK 73070
If you have questions please use one of the following options to contact our office:
- Phone: (405) 801-5090 or (405) 801-5091 and speak to a bursar representative
- In Person at Franklin Road: Click here for directions & business hours
Penalties
If you fail to furnish your correct Social Security Number (SSN) to the requester, you are subject to a penalty of $50 to the IRS unless your failure is due to reasonable cause and not to willful neglect.
If the requester discloses or uses your Social Security Number (SSN) in violation of federal law, the requester may be subject to civil and criminal penalties.
We proudly offer short-term class discounts for lifelong learners, full-time NPS and MPS employees, as well as valued service members, veterans, and their spouses. Learn about our short-term class discount program.