Excel Accelerated: Advanced Functions and Formulas

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

Thursday, April 1 2021

from 1pm to 4pm
and 5pm – 8pm

Room 115

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

Excel Accelerated: Intermediate

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.

Building on concepts covered in Excel Essentials, learn how to work with large files by freezing panes and splitting the window, and how to use styles and conditional formatting.

Learn to create pie, bar, column, XY and other charts to present your numeric data in a professional-looking and easy-to-read format. Explore sorting and filtering to manage data lists and practice working with formulas and functions.

  • Manage Large Workbooks
    • Sorting and Filtering
    • Grouping and Subtotals
    • Conditional Formatting
    • Concatenate and Split Text
    • Working with large spreadsheet
      • Freezing panes
      • Split worksheet
      • Copy sheets
      • Selecting sheets
      • Linking worksheets
      • Table of Contents
    • Create a chart (we maybe talking about charts in the beginning class as well)

The Excel Level will be on the following dates:

  • Wednesday, March 31 2021

  • from 1pm to 4pm
    and 5pm – 8pm

at Truckee Meadows Community College

5270 Neil Road
Rm 115

Reno NV 89502

Tel: (775) 829-9010

or click here to signup online

NOTE:  This is an intermediate class.  You will have to have prior knowledge in Excel.

Please bring a flash drive to class

 

Excel Accelerated: Basics

Excel Basics in January 2021 – beginners class

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.

This is Part I for a three-day class to learn Excel from basics to advanced.

This first class covers the basics ….

… such as entering text and numbers into spreadsheets … and continue building your skills by learning formatting and easy 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

    Tuesday, March 30 2021

  • from 1pm to 4pm

    and 5pm – 8pm

    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

Excel Accelerated Series

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.

Please call 829-9010 for the below class.
Registration is still open.
We will start Monday March 29, 2021 at 1pm
REGISTER TODAY for exiting days of learning Excel

In this 3-part course, learn the basics of Excel* 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

*we are using the 2016 version of Excel, however, most of the information that youa re learning here, can be used in previous/older Excel versions. Instructor will point out the differences.

Welcome to the World of “Keeping Track of your Finances” with QuickBooks (Desktop Version)

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.

– You will need this class:

if you are having a hard time keeping track of your income and expense?

– You will need this class:

if you have more months left after you got paid because you do not keep track of your finances

This class is mainly for small to medium business, however, that does not mean that an individual could not benefit from the knowledge and maybe start keeping track of their financial life.

Why this class?

Because, thousands of small companies and nonprofit organizations turn to Quickooks to keep their finances on track. And over the years, Intuit has introduced various editions of the program to satisfy the needs of different types of companies.

Back when milk was simply milk, you either used QuickBooks or you didn’t.

But now, when you can choose milk from soybeans and rice as well as cows, and with five different levels of fat, it’s no surprise that QuickBooks comes in a variety of editions (which, in some cases, are dramatically different from their siblings), as well as six industry-specific editions. From the smallest of sole proprietorship to burgeoning enterprises, one of these editions is likely to meet your needs and budget.

By the way, 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 some of the topics that we will cover:

  • An Introduction to QuickBooks
  • some Bookkeeping/Accounting Terms
  • Setting up your company (or yourself)
  • Chart of Accounts
  • Customers/Clients
  • Sales Tax
  • Vendors
  • Banking

Please  call Truckee Meadows Community College 

for QuickBooks Sessions in 2021

Room 322

call Contact Trainer/Instructor

5290 Neil Road

Reno NV 89502

Tel: (775) 829-9010

Website: tmcc.edu/epic

Please bring a Flash Drive

Computer Basics

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.

Lose that feeling of computer intimidation by learning lingo like monitor, processor, hard drive, RAM, hardware, operating system and software. Get lots of practice using the computer as you explore the world of Windows. Type a short letter on the keyboard using a word processing program and draw a simple picture using an art program. Make practicing the computer fun while surfing the Internet.

September 8 and 10, 2020

from 9am – 12pm

at Truckee Meadows Community College

5270 Neil Road
Rm 115

Reno NV 89502

Tel: (775) 829-9010

Please bring a flash drive to class

Please contact instructor should you have questions whether this class is for you. 

WordPress Blog and Web Design

Sorry, but we (TMCC-EPIC) will have to cancel the following class because of the Corona Virus (COVID-19)

Find out why WordPress powers over  30.2% of all websites while learning how to create your own blog or website.

WordPress is the most user friendly CMS, and as most people building their website with WordPress are not developers, the whole point of the CMS should be to make it as easy as possible to build a clean, good looking website that can scale with your business. ~Google

Start with the basics such as how to install, set up and select a theme without having to learn HTML. Then dive deeper into the software by developing an understanding of customization specifics such as how to use widgets, plugins, the difference between the paid and free versions, along with tips on how to schedule blog and video posts. Finally, increase traffic to your new website by promoting your blog through social media.

… it also powers the websites of some of the worlds biggest brands, including TechCrunch, MTV,Sweden.se, Microsoft, Facebook News and Vogue

We will start with a free WordPress site.  Please be aware that a free site is limited to the changes that you would like to make, so ….

… you will need to have to have a domain name and hosting in order to take full advantage of wordpress for your website … ! I am using Godaddy.com for all my websites.  If you ask them I think they still offer a free month of hosting, however you will have to buy a domain name.

If you need assistance with buying a domain name, please Contact Trainer/Instructor (a small fee may apply)

Some of the Topics we will cover:

  • Narrowing down your topic
  • Writing about multiple topics
  • Deciding how much time to commit
  • Designing your blog (WordPress)
    • Posts and Pages
    • Using drafts
    • Scheduling posts
  • Social Media

Please contact TMCC for the next class

Truckee Meadows Community College

5270 Neil Road

just across from the Sears Auto Center on

sign up in Suite 216

Reno, NV 89502

Call 775-829-9010 to sign up for next session

for private instructions for questions, please go to Contact Trainer/Instructor

Windows 10 Essentials

Learn to get around Windows 10.  What is new, how to update your OS.

Discover the uses of universal apps while learning how to incorporate them across multiple technology platforms. Also, learn to transition from an older operating system to Windows 10 while keeping your files compatible with the new software.

Every Windows update gives you new options to customize Windows 10.  Learn what these options are.

Our next class covering the above topics will be

Call to inquire about the next class 775-829-9010

Truckee Meadows Community College

5270 Neil Road
(just across from the Sears Auto Center )

sign up in Suite 216

Reno, NV 89502

for private instructions, please go to Contact Trainer/Instructor

Please bring a Flash Drive

QuickBooks for Payroll

Save time and money by learning to use this intuitive and useful program to streamline your payroll and paycheck tasks.

Discuss different options through Intuit, how to register for Nevada payroll tax accounts and the basics of manual payroll, such as account setup, tax payment and paycheck creation. 

The QuickBooks Payroll session will be on the following dates:

Call to inquire about the next class 775-829-9010

at Truckee Meadows Community College

5270 Neil Road
Rm TBA

Reno NV 89502

Tel: (775) 829-9010

NOTE:  You will have to have prior knowledge in using QuickBooks

Please bring a flash drive to class

Please contact instructor should you have questions.

Welcome to Microsoft Word

Being comfortable with Word has become a workplace necessity. Increase your efficiency and decrease your frustration by learning how to use tabs, groups, spell check and commands. Play with different formatting choices from bulleted lists and margins to incorporating different fonts and colors in your letter or report. In addition, practice customizing envelopes and creating labels.

Our next class covering the above topics will be

call TMCC at 775-829-9010

Truckee Meadows Community College

5270 Neil Road

just across from the Sears Auto Center on

sign up in Suite 216

Reno, NV 89502

or

for private instructions, please go to Contact Trainer/Instructor :