Microsoft Excel: Advanced Functions and Formulas

Posted by admin on October 4, 2021 in Blog, Excel, Excel Level 3 - Advanced |

Truckee Meadows Community College is committed to maintaining a safe learning environment for all students, faculty, and staff. During these unprecedented times, the concept of “community” in the title of our institution takes on special meaning as we all commit to safe practices to ensure a healthy community that protects and addresses the needs of all of us. To this end, we must remain flexible, diligent, and compassionate in our efforts. Students, faculty, and staff are encouraged to remain at home if experiencing any symptoms of ill health. At TMCC, properly worn masks are mandatory in all classrooms, work spaces, and public spaces at all times.

Take your knowledge of Excel to the next level with advanced techniques that include making pivot tables,  use intricate formulas and data analysis to make tasks easier at your workplace.

  • Loans Payments
  • Pivot Table and Chart
  • Data Analysis
    • Loan Payments
  • Lookup Functions
    • VLookup
  • Null function
  • IF Functions
    • if
    • Sumif
    • Countif
    • Averageif
  • Protect your workbook
  • Time permitting other important formulas that might come in handy

Our next class covering the above topics will be

  • Tuesday, June 22 2021 from 09am – 12pm

  • and

    Thursday, June 24 2021 from 9am – 12pm

Truckee Meadows Community College

5270 Neil Road

just across from the Sears Auto Center on

sign up online or in Suite 216

Reno, NV 89502

Please bring Flash Drive

Tags: , , , , , , , , ,

Leave a Reply

Copyright © 2015-2021 Computer and Technology All rights reserved.
This site is using the Desk Mess Mirrored theme, v2.5, from BuyNowShop.com.