0

Microsoft Excel: Intermediate

Posted by admin on September 22, 2021 in Blog, Excel, Excel Level 2 - 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:

  • Tuesday, September 21, 2021 from 6pm – 9pm
    • and

      Thursday, September 23, 2021 from 6pm – 9pm

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

 

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.