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

 

iPhone/iPad for 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.

Find out how easy and fun it is to explore the world on your new smartphone. Experience the amazing array of functions and applications available and how to update your Apple iPhone Operating Systems.

Setup WiFi and email addresses.  Learn how to add contacts and more.

Bring your iPhone to class. 

Please make sure your iPhone is fully charged.

Our next class starts

2/19, 2/26, 3/5 and 3/12 
 4 sessions from 10am to 12pm 

Room 315

Truckee Meadows Community College
(just across from the Sears Auto Center )

5270 Neil Road

sign up in Suite 216

Reno, NV 89502

or call 775-829-9010

or

for private instructions, please go to Contact Trainer/Instructor

 Note to iPad users:  the only difference is that you can not make a phone call!

So, please join us in the iPhone 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.

Learn more about your iPhone

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

You took the ‘iPhone for Beginners’ class or have experience using your phone?

Enhance your knowledge by adding contacts to your address book, set up and use your email, and send and reply to text messages. Share photos, organize photo galleries and download and listen to your favorite music.

And … bring your questions if you already know about or would like to review one or more about the above mentioned topics.

Bring your iPhone/iPad to class with any questions you have about it.

Our next class covering the above topics will be

on 3/19, 3/26, 4/2 and 4/9

from 10am – 12pm

Rm 315

Truckee Meadows Community College

5270 Neil Road

just across from the Sears Auto Center

sign up in Suite 216 or call 775-829-9010

Reno, NV 89502

for private instructions, please go to Contact Trainer/Instructor

 Note to iPad users:  the only difference is that you can not make a phone call!

So, please join us in the iPhone class

Form 1099-MISC vs Form 1099-NEC

How are they Different?

For the tax year 2020, the IRS introduced new forms. Here is an example of 2 of the forms: 1099-MISC and 1099-NEC

Form 1099-MISC

Form 1099-MISC reports the total amount of payments a person receives from a single person or company during the tax year. The IRS requires any person or business to report certain types of payments on a 1099-MISC Form and to the IRS. The type of payments the IRS requires to be reported on this form are:

Form 1099-MISC used to be most commonly used for reporting earnings of independent contractors and consultants, both types of employment where the person employed is not an employee of the company.

  • Rent
  • Royalties
  • Prizes
  • Awards and substitute payments in lieu of dividends

This is also known as nonemployee compensation.

Starting in the 2020 tax year all nonemployee compensation will be reported on a new form, Form 1099-NEC.

Form 1099-NEC

Form 1099-NEC is a form dedicated to only nonemployee compensation, also known as self-employment income. This is the income that is received when someone is employed by an employer as an independent contractor versus an employee. Basically, Form 1099-NEC is an entire form dedicated to Box 7 on Form 1099-MISC. Subsequently, for tax year 2020, Box 7 has been removed from Form 1099-MISC. Essentially, Form 1099-NEC serves a similar purpose as Form W-2 does for employees. That purpose is to report the total amount of payments a person receives from a single person or business during the tax year.

Why did the IRS create Form 1099-NEC?

There are two main reasons why it made sense for the IRS to designate a form specifically for nonemployee compensation.

  1. More and more people are working as independent contractors making it make more sense to have a tax form dedicated specifically to this income.
  2. Previously, when nonemployee compensation was reported on Form 1099-MISC, it had a different deadline date than the form itself. Therefore, it didn’t make sense to use one form for payments that have two different deadline dates with the IRS.

QuickBooks: Please Observe January Tax Due Dates

New 2020 Filing DateFormFiscal Year Filers
January 15, 2021Form 941 for monthly payroll filers)
January 25, 2021Form 940 (Electronic and Mail)January 25, 2021
January 31, 2021Form W-2 (Electronic and Mail). W-3January 31st, 2021
January 31, 2021Form 941 for 4th Qtr 2020 January 31st, 2021
January 31, 2021Form 1099-Misc w/Box 7, Non-Employee CompensationJanuary 31st, 2021

Form 940, Employer’s Annual Federal Unemployment (FUTA) Tax Return

due 1/25/21 if you either owe, or if your Federal Unemployment taxes were less than $500 for all of 2020.

February 1 is the deadline for employers to issue and file wage statements

Since January 31, 2021 falls on a Sunday, please make sure that you file your paperwork electronically or mail by Feb 1 , 2021: Form 941 (4th Qtr 2020), W2 and W3

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

Tax Year 2020: Changes to IRS Form 1040

The IRS recently released a draft of Form 1040, U.S. Individual Income Tax Return. This article provides a look at some of the most significant changes proposed for tax year 2020 (returns filed in 2021).

read more …..