Home » 2020 » January

Monthly Archives: January 2020

Excel for Beginners

Missed the Fall 2019 class? No problem we have another session coming up in Spring 2020 where we teach you the basics ….

… such as entering text and numbers into spreadsheets … and continue building your skills by learning formatting and formulas.

All tutorials are instructor-led and every student will receive a handout to include screenshots to help guide you through the material presented.

Here is an overview of the topics:

  • Create 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
    • Time permitting Instructor will show you how to create a chart

    Our Excel Essentials I class covering the above topics will start

    January 28 and 30, 2020 from 9 am to 12 pm

    call TMCC (Reno, NV) at 775-829-9010 to reserve your seat today

    or click here to sign up

    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

Excel Series

In this 3-part course, learn the basics of Excel 2016 to enter text and numbers into spreadsheets along with basic formatting and formulas.

In part II, work with large files by freezing panes and splitting the window, use named ranges to make navigation easier, and explore styles and the conditional formatting feature. Learn to create pie, bar, column, XY and other charts in a professional-looking, easy-to-read format. Sort and filter to manage data lists and practice working with formulas and functions.

In level III, work with advanced techniques to make pivot tables and pivot charts, and use intricate formulas and data analysis to make workplace tasks easier. Learn to use various financial functions, grouping skills and how to consolidate worksheets.

at Truckee Meadows Community College

5270 Neil Road
Rm S115

Reno NV 89502

Tel: (775) 829-9010

Website: tmcc.edu/wdce

PLEASE BRING A FLASH DRIVE TO CLASS