0

Microsoft Excel – 12 HOURS

Posted by admin on December 5, 2021 in Blog, Excel, Excel Level 1 - Essentials/Basics, Workforce Development Training |

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.

12 hours of Excel divided into 4 classes at 3-hours each over a 2-week period.

Topic Overview:

  • Create, save, and print a new spreadsheet/workbook
  • Cell Basics

Create a new workbook

  • New, Open, save and print
  • Order of precedence
  • Exercises on
    • Addition
    • Subtraction
    • Multiplication
    • Averages
    • Highest and lowest numbers
  • Adding and deleting rows and columns
  • Make your spreadsheet look professional

Creating a Table

    • Managing Data in an Excel Table
    • Table Styles
    • Deleting a Table

Charts

Working with large spreadsheets

  • Sorting
  • Freeze
  • Split a worksheet

Pivot Tables and Charts

Loan Payments

Vlookup

if Statements

◊   ◊   ◊   ◊   ◊  ◊  ◊  ◊

Live Instruction dates are as follows:

  • Tuesday, February 1, 2021 from 2pm – 5pm
  • Thursday, February 3, 2021 from 2pm – 5pm
  • Tuesday, February 8, 2021 from 2pm – 5pm
  • Thursday, February 10, 2021 from 2pm – 5pm
  •  
  •  
  • call TMCC at 775-829-9010 to reserve your seat today

    this is a very popular class!

    at Truckee Meadows Community College

    5270 Neil Road
    Rm 115

    Reno NV 89502

    Tel: (775) 829-9010

    PLEASE BRING A FLASH DRIVE TO CLASS

    fill out the form below for private instructions or any questions and training requests

    Your Name (required)

    Your Email (required)

    Subject

    Your Message

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.