Update July 1, 2020
In an effort to minimize the spread of COVID-19, both campuses of MNTC are closed until August 1. This closure could be extended if health officials deem it necessary.
During this time of teleworking and until August 1, our business hours are:
- Monday - Thursday: 8 a.m. - 5 p.m.; Friday: 8 a.m. - 4:30 p.m.
Excel PivotTables & PivotCharts
ipd114•3 class hrs
Need an easier way to summarizes information in a table or chart from more extensive tables (such as from a database, spreadsheet). This summary might include sums, averages, or other statistics, which the pivot table groups together in a meaningful way. Pivot tables are useful for summarizing raw data stored in a spreadsheet. They allow you to summarize your data in different ways.
Why learn it?
This is much easier to do than you are probably thinking it is. A Pivot Table allows you to analyze more than 1 million rows of data with just a few mouse clicks, show the results in an easy to read table, pivot/change the report layout with the ease of dragging fields around, highlight key information to management and include Charts & Slicers for your presentations or report.
All MNTC instruction and curriculum is provided in English unless specifically stated otherwise.
IPD110 Excel Essentials 2019 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.